Hi everyone,
How to use cloud based or mysql database for sambapos instead of using local DB, so that I can connect terminals from multiple locations.
Thanks.
SambaPOS is not compatible with mySQL only Microsoft SQL (MSSQL).
localDB is a single user instance of MSSQL.
MSSQL Express can be used easily for multi terminal locally.
Multisite setup on single DB has been tested but is not ideal due to amount of requests samba makes to DB, it is programmed and optimized for local MSSQL DB and also multi site off single DB goes against licence conditions of licence per site as far as im aware as licence is per DB.
emre is planning a multisite system which I think is next on the roadmap once the API is complete. I expect this is because the plan is to use the API to create a site to HO link keeping the databases local with a uplink to a central instance however this is just my guess - nothing official has been announced.
3 Likes