Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

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

by erix (Parson)
on Jul 22, 2019 at 20:33 UTC ( #11103166=note: print w/replies, xml ) Need Help??


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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://11103166]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (7)
As of 2019-11-18 11:58 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Strict and warnings: which comes first?



    Results (90 votes). Check out past polls.

    Notices?