Re: sqlite database
On Sun, 01 Jul 2018 22:21:11 +0200
deloptes <deloptes@gmail.com> wrote:
> Cousin Stanley wrote:
>
> > As an alternative to client-server database managers,
> > such as mysql, mariadb, postgresql, etc. ,
> > the sqlite embedded database manager is very useful ....
>
> Not sure what thread you write to, but can you do concurrent
> reads/writes to sqlite3 DB?
>
> I think it is not possible as the process that writes, locks the
> file, so just keep in mind that there are severe limitations in the
> use of sqlite3 databases. Correct me if I am wrong
>
And the single file is vulnerable to network issues. Basically the same
limitations as MS Access when used as a single-file database. Sqlite is
the right answer for most single-user non-network applications, but
not for anything more demanding. Horses for courses, as ever.
--
Joe
Reply to: