Re: Strategy to construct a Stack
Posted: Wed Dec 19, 2018 7:34 pm
SQLite is no more multi user than flat files, LSON, or stack files; the developer would need to hand craft record locking with each.
But that's not hard to do, and can be reasonably efficient depending on the particulars of the data and how it's used.
Using an inherently multi user DB like MySQL takes care of that part for you, so if you're going to use SQL you might as well use one designed for multi user scenarios.
But if you're looking to avoid introducing more moving parts into the system, there are many other ways to manage storage for multi user systems.
We know the number of records is small. How large is each record? And how many fields? And does the system require relationality?
But that's not hard to do, and can be reasonably efficient depending on the particulars of the data and how it's used.
Using an inherently multi user DB like MySQL takes care of that part for you, so if you're going to use SQL you might as well use one designed for multi user scenarios.
But if you're looking to avoid introducing more moving parts into the system, there are many other ways to manage storage for multi user systems.
We know the number of records is small. How large is each record? And how many fields? And does the system require relationality?