In selecting SQLite you are giving up the flexibility for simplicity. We don't know your application as well as you do. Your job as a software engineer highly qualified to design a product worth buying, and capable of keeping your clients happy, is to research what the various alternatives can provide, and to make the decision based on the total suitability of the solution you choose. Someone already provided links to SQLite's documentation, which I've read in depth a few times in the past 90 days. I know that the documentation spells out pretty clearly what constitute reasonable use cases and what constitute blockers. Now find discussions on PostgreSQL, MySQL, and other alternatives so that you can make the informed decision.

At this point we've strayed pretty far off of the original question; whether or not SQLite can handle big data. We've identified that's not really the question to be asking. And none of this is specific to Perl. Interesting to Perl developers, sure. But it seems like you really want the answer to be yes. It would be irresponsible of us to green light a decision that should be made with a lot more details than would be appropriate to raise here in this forum.

You have read https://www.sqlite.org/whentouse.html, right? Digital Ocean has a lot of great information in its support documents. Check out this one: SQLite vs MySQL vs PostgreSQL: A comparison of relational database management systems.


Dave

In reply to Re^5: is Sqlite db good enough to handle large data. by davido
in thread is Sqlite db good enough to handle large data. by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.