What combination of language-DBMS to choose for the development of POS-Inventory systems for MacOS and iOS?

Question

Database

I own a small Apple store.
Due to the legal situation, I do not need to maintain any mandatory accounting, other than the usual management accounting of sales and purchases.
There is a great desire to develop a Purchase-Warehouse-Sales application for ourselves, so that it has a local database (it works without an Internet connection), but is synchronized with other local databases located on other devices (mostly Mac OS and iOS).
I have nano programming experience and some experience with SQL and development under Oracle APEX.
I would like to hear advice on which language to choose and the DBMS (like SQLite is the most attractive) for the simplest and fastest development of such a system.
Thank you!

Answer 1

Have a look at FileMaker , maybe it will work. It is a relational DBMS, it has a client/server for Mac and Windows, plus clients for iPhone/iPad. Clients can work directly with the server or store the database locally; it is assumed that you write the synchronization then manually. Among the shortcomings - this DBMS was originally developed for end users, it can be difficult for a programmer with it :) Let's say that SQL is not there. Well, not free.

Answer 2

Clarification:
Now we use MoySklad, but the lack of work without a network kills + too many unnecessary features and too few necessary for us.

Answer 3

Thanks for the advice.
I, personally, see something like Php + MySQL, but only to work locally and with synchronization (yes, even with dropbox).
As I understand it, for MacOS and iOS, yes, with a local database, this combination will be Obj-C + SQLite.
It makes no sense to write TK, all the functionality easily falls into several Google Sheet tables, but gSheet simply does not have the possibility of flexible access control and the ability to work locally.

Answer 4

By the way, if someone reads the same topic, with nano-experience :), then if the local database is not critical, then I highly recommend the free Oracle APEX + Oracle DB XE, it’s quite possible for a person with hands to develop a corporate application in a few months, practically no knowledge in this area.

Answer 5

Tell me, please, is it possible to make an on-demand replica from the SQLite database, so that when you change something in one database, it will be displayed in another and on another device?