Re:The Design Of SQLite4
by jqm on Sunday May 25, 2014 @04:27PM
(#7797458)
I love sqlite and find it extremely useful.
I just wish they could figure the multi-user issues out (maybe it's not practical...probably not, I don't know how it works internally). But, if they could do this it would be truly awesome!
[ Parent
| on HN ]
Re:The Design Of SQLite4
by ghshephard on Monday May 26, 2014 @05:05AM
(#7799144)
From: http://www.sqlite.org/whentouse.html
SQLite is not designed to replace Oracle. It is designed to replace fopen().
Easy: Put a server process in front of it and route access to the DB through that. :P
Doesn't that just defeat the purpose? At that point you're probably much better off just using postgressql (or similar).
It might be a neat solution if you already have a server process for other tasks anyway and the data access needs are quite simple.
That's what I'm thinking. Probably less trouble just to set up postgres at that point and not deal with unexpected troubles and complications.
But I hadn't thought of putting a server process in front of sqlite so thanks for the tip. It might come in handy at some point.
would someone care to explain why they down voted that comment?
It was a joke! Hence the ":P".