SQLite is likely used more than all other database engines combined
1–10 of 82 posts
Re: SQLite is likely used more than all other database engines combined
#2[dead]
Re: SQLite is likely used more than all other database engines combined
#3In the past, I've used it as a file format for an online application. Users often wanted to download bits and bobs of data from the app, not to view it or edit it on their desktop, but more as backups or to share a particular configuration
Previously we'd used a json+zip pair, but the lack of enforced schema became a problem. Switching over to a gzipped sqlite db with a "custom" file extension worked incredibly well
Re: SQLite is likely used more than all other database engines combined
#4Most likely, indeed.
Re: SQLite is likely used more than all other database engines combined
#5Once that is said, does OSS move forward? Not an inch, good luck getting any change upstream
Re: SQLite is likely used more than all other database engines combined
#6i find it ironic one of the most gatekeepy, closed, walled garden companies in the history of the planet, Bloomberg, is a sponsor of one of the most free most open piece of software ever.
Re: SQLite is likely used more than all other database engines combined
#7In terms of installations, sure.
In terms of total data, probably not.
In terms of important data, 100% not. Important data needs guarantees, and its privacy is second to its longevity.
Server side and centralized beats client side decentralized for all but sensitive consumer data.
Re: SQLite is likely used more than all other database engines combined
#8i find it ironic one of the most gatekeepy, closed, walled garden companies in the history of the planet, Bloomberg, is a sponsor of one of the most free most open piece of software ever.
Bloomberg sells pacakaged public information, they rely on commonwealth and transparent regulation disclosures, they are agents of such transparency.
They gatekeep their product sure, but you need to do that if you want to sell it.
Re: SQLite is likely used more than all other database engines combined
#9Once that is said, does OSS move forward? Not an inch, good luck getting any change upstream
It's still OSS, you're allowed to fork and maintain Sqlite if you don't like the upstream merge requirements.
Re: SQLite is likely used more than all other database engines combined
#10I’m curious, is the prevalence of SQLite similar to how PHP is widely used because it’s behind many WordPress sites?