Finally, many database vendors at one time or another have packaged and rebranded SQLite as their “mobile” edition (read: MongoDB and Couchbase). Second, it’s bundled with a lot of open-source developer kits, most notably Android. First, it’s an open-source offering that’s been around for over two decades, so it is widely known. So why has it remained so popular? Practically speaking, it has largely been the only game in town. Everyone in the SQLite community knows that SQLite is painfully slow. Okay, so SQLite’s pokiness is not really news. Zen Core and SQLite are both free, and you can run this test for yourself.
We made an apples-to-apples comparison, running both on a Raspberry Pi 3, a small ARM-based single-board computer that you can buy from Amazon for under $50. Okay, for indexed deletes, it was three orders of magnitude faster. Putting aside the challenges posed by the shared and distributed data requirements – we’ll touch on those in the next installment – let’s just examine SQLite’s limitations in the area of local data processing, starting with one of the most important, performance.Įighteen months ago, we ran performance tests of Actian Zen - our Zero-DBA Embedded Nano-footprint database- against the latest SQLite distribution and found Zen to be faster by two orders of magnitude, depending on the operation being run. Modern Edge data management demands an ability to process and analyze data locally, to share it peer-to-peer, to move data between gateways, other intelligent machines, and even back into the Cloud – and SQLite was never built to meet those demands. But while local and embedded data management is necessary – indeed critical – for modern Edge data management systems, as implemented in SQLite, it is insufficient. Here’s the thing: If you’re a mobile or IoT developer, or if you’re extending out from the Cloud to the Edge with distributed applications and data, local embedded data management is a critical capability, and that’s where SQLite stood out for years. The first looked at the advantages that SQLite offers over both flat files and the heavier lift of an enterprise-grade SQL databases – and it does offer distinct advantages over both.
#Sqlite limitations series
Earlier this month, I kicked off a series of blogs about SQLite.
0 kommentar(er)
