Re: is Sqlite db good enough to handle large data.

in reply to is Sqlite db good enough to handle large data.

SQLite is wonderful, even for not-so-small data, as long as it is readonly / write-rarely.

The SQLite people say (from whentouse.html):

" SQLite is not directly comparable to client/server SQL database engines such as MySQL or PostgreSQL. SQLite does not compete with client/server databases. SQLite competes with fopen(). "

If your "desktop application for retailers" just reads/writes to the local computer, one user at a time, SQLite might be all right.
If it reads/writes, by possibly many users concurrently, to some central database SQLite is probably not so good. Then I'd use PostgreSQL.
2019.07.23 - (edited slightly)
Comment on Re: is Sqlite db good enough to handle large data.

Replies are listed 'Best First'.
Re^2: is Sqlite db good enough to handle large data. by Anonymous Monk on Jul 23, 2019 at 09:49 UTC
Thank you for this information. I am going with SQLite as it fits the bill for me.	[reply]

In Section Seekers of Perl Wisdom