Transition from standalone to multiuser with SQLite
Posted: Sun Jul 17, 2016 11:27 am
Hi,
I have developed a Livecode application (Windows and Mac) that currently runs standalone using SQLite. I need to progress this to a multi-user system with the database hosted on either the internet/intranet/local network using our app and also the web.
In order to do this I need to have the database hosted in a networked location. I was thinking of using MySQL, however it is problematic given that composite keys that contain text fields need to be represented with MD5 checksums or equivalent - because MySQL doesn't support composite keys the same as SQLite when they contain large text strings. Or I can go for SQLite first up and then transition if the database gets bigger.
I need some advice on this. Not sure how to set up SQLite on a server and access it over the web. Having the database as a shared file is the solution for a local network, but not for something web based (unless I am missing something).
Any advice appreciated.
Cheers
Greg
I have developed a Livecode application (Windows and Mac) that currently runs standalone using SQLite. I need to progress this to a multi-user system with the database hosted on either the internet/intranet/local network using our app and also the web.
In order to do this I need to have the database hosted in a networked location. I was thinking of using MySQL, however it is problematic given that composite keys that contain text fields need to be represented with MD5 checksums or equivalent - because MySQL doesn't support composite keys the same as SQLite when they contain large text strings. Or I can go for SQLite first up and then transition if the database gets bigger.
I need some advice on this. Not sure how to set up SQLite on a server and access it over the web. Having the database as a shared file is the solution for a local network, but not for something web based (unless I am missing something).
Any advice appreciated.
Cheers
Greg