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.