Is it possible to keep only one Database for both web and desktop applications?
- by B4NZ41
I'm experiencing a trouble with my business model, let me explain better.
I'm developing a software for 1 year and few months, it's for the food industry, more exactly a software to: Delivery, Take Way, Table Reservation, POS, Accounts Payable and Receivable, Prints(receipt), Kitchen Monitors Orders, Customers Orders Control and Fiscal Area.
Well, I had separated the software mainly in two areas, one is web area and the other is desktop area (Used by Admins only) and local installed.
1 - Web Area (Basically do the follow:)
Show Catalog with the products
Customers Make Orders
Customers Pay for the Orders
etc ... as mentioned above
2 - Desktop Area
Manage Orders
Manage Customers
Manage Suppliers
Manage Accounts Payable and Receivable
etc ... as mentioned above
The web area is hosted in an online web server (scripts and database are online). The Desktop area is hosted locally in a Linux machine with a local database and local scripts files.
My question is:
Is it possible to keep only one Database for both applications? If YES, please what is the best approach?
Follow my technical specification environment
Database: Actually I have two databases working and I would love to keep only one.
Operating System: Linux (Kernel 2.6.X and above) or Windows (XP and above)
For the Web Area
Apache, PHP, Python, Java Script, Shell Script and MySQL.
For the Desktop Area:
PHP-GTK2, Apache, PHP, MySQL and Shell Script.