Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

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

by sundialsvc4 (Abbot)
on Jul 22, 2019 at 17:21 UTC ( #11103155=note: print w/replies, xml ) Need Help??


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

Listen to the good counsel that has been given to you, and instead set up a local MySQL server running on your local machine – IP-address 127.0.0.1.   While the SQLite server technology is battle-tested, and certainly capable of handling any amount of data you may care to throw at it, it is a product of its designed-for time and place and therefore is not standard.   Whereas, it is easy enough to see that your application is likely to expand to become multi-user, and that you will at that time discover that you have made various design decisions that will be expensive to change.   SQLite is a terrific solution for its very narrow niche, but its niche is very narrow – narrower than yours.

Running MySQL as a service (daemon) on the local machine is an easy and cost-free investment in future proofing, will not cost you a dime, and will make no difference to the user.   I have plenty of personal experience deploying solutions based on both technologies, and feel that SQLite is not the best long-term solution for your use-case as described.

  • Comment on Re^2: is Sqlite db good enough to handle large data.

Replies are listed 'Best First'.
Re^3: is Sqlite db good enough to handle large data.
by holli (Monsignor) on Jul 22, 2019 at 17:37 UTC
    * Popcorn! *


    holli

    You can lead your users to water, but alas, you cannot drown them.
Re^3: is Sqlite db good enough to handle large data.
by Anonymous Monk on Jul 22, 2019 at 21:47 UTC
    How you got any of this from statements posted is beyond belief, but you've proven again that you can not be taken at your word.
Re^3: is Sqlite db good enough to handle large data.
by karlgoethebier (Monsignor) on Jul 23, 2019 at 11:22 UTC
    "...I have plenty of personal experience..."

    No. You don't. As it often has been proven here. Now go back in your garden cellar where ever it is.

    «The Crux of the Biscuit is the Apostrophe»

    perl -MCrypt::CBC -E 'say Crypt::CBC->new(-key=>'kgb',-cipher=>"Blowfish")->decrypt_hex($ENV{KARL});'Help

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (5)
As of 2019-12-05 18:05 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Strict and warnings: which comes first?



    Results (151 votes). Check out past polls.

    Notices?