Re:We’re pretty happy with SQLite and not urgently intereste...
by zyx321 on Tuesday June 21, 2016 @09:19AM
(#11945357)
That might work, as long as you don't ever need to read the data you've just written (logging?).
Otherwise you'll end up serving stale data that might be several minutes out of date.
Say you have an MVC web app, could you have asynchronous calls to a thread performing the actual DB writes? From your app's perspective, concurrent writes would be placed into a queue that performs them serially.
Are there any functional issues to this approach? Thanks in advance for your thoughts or info.