Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

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

by sundialsvc4 (Abbot)
on Jul 23, 2019 at 01:30 UTC ( #11103182=note: print w/replies, xml ) Need Help??


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

The question as posted is whether or not SQLite is good enough to handle large amounts of data.   The superficial answer is of course Yes.   But, quite some time ago now, we moved away from "desktop database" topologies that were based on shared files an offshoot from files that existed only on a single non-shared computer and adopted the client/server model instead.   Since every computer you'll actually encounter fully supports multiprogramming ... as earlier systems did not ... it is now a trivial matter to support a client/server capable database on your own computer.   The advantage of this being that the topology requires no changes to become multi-user:   "it already is."

SQLite just might be the penultimate advancement (IMHO) of "a filesystem-based database."   It really is a remarkable, best-of-breed tool for its appointed, narrow, niche.   But its technically-necessary design introduces issues that you might come to regret if your use-case grows in such a way that this requirement might very reasonably be expected to do.   Hence my recommendation to instead use a local, but multi-user capable, daemon.   Best to get off on the right foot, no matter what programming language/tool you are using.

  • 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 bliako (Vicar) on Jul 23, 2019 at 10:38 UTC

    Fair points. The defining advantage of SQLite, for me, is that it does not require all the CREATE USER, GRANT PRIVILEGES and then debugging the localhost VS 127.0.0.1 and tens of other small problems (talking about MySQL here which is my main experience) arising when users try to install your application to different OS and with different privileges. SQLite can be run with default user and no networking which requires zero admin rights. I think?

Re^2: is Sqlite db good enough to handle large data.
by Anonymous Monk on Jul 23, 2019 at 09:48 UTC

    Thank you for this.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (5)
As of 2019-12-14 12:32 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?