Sqlite – Most Deployed Database in the World

https://www.sqlite.org/mostdeployed.html

by gitgud • 8 years ago

148 45 8 years ago

sudeepj2• 8 years ago

https://www.sqlite.org/testing.html

The testing each release goes through is quite impressive. I bet more time is spent on testing (or writing tests) than actually developing the features.

fuddle• 8 years ago

"the project has 711 times as much test code and test scripts" than source code. That's a really impressive feat.

monocasa2• 8 years ago

Huh, at that point it'd probably make more sense to formally verify it. For sel4 last time I checked the ratio was 25/1 proof code/verified code.

simonw• 8 years ago

I also like this page of the docs: "SQLite as an application file format": https://www.sqlite.org/appfileformat.html

hardwaresofton• 8 years ago

Also on my list of favorites: https://www.sqlite.org/whentouse.html

Back when I worked at a large semi conductor company they used GDSII[0] and Calibre[1] files along with internal formats and I always wondered why they wouldn't just use SQLite. SQLite is even threadsafe[2].

[0] https://en.wikipedia.org/wiki/GDSII

[1] https://www.mentor.com/products/ic_nanometer_design/verifica...

[2] https://www.sqlite.org/threadsafe.html

mistrial9• 8 years ago

also see GeoPackage https://en.wikipedia.org/wiki/GeoPackage

simonebrunozzi• 8 years ago

Most = highest number of installations. I bet the winner for largest amount of data managed could be another one (Oracle? MySQL?)

fl0wenol• 8 years ago

It might still be SQLite in that case. The largest data management systems are proprietary (i.e. Google's ever-evolving data layer)

jayonsoftware• 8 years ago

"Every Windows10 machine" , did not know that, where is it located ?

tantalor• 8 years ago

It's built into UWP

https://docs.microsoft.com/en-us/windows/uwp/data-access/sql...

SQLite• 8 years ago

c:\WINDOWS\System32\winsqlite3.dll

xkcd-sucks• 8 years ago

I would contribute towards a Wall St Journal full page ad "SQLite: Most widely used DB in the world" with little misleading graphs comparing to Oracle and DB2

qwerty4561274• 8 years ago

Indeed it would be interesting to also see comparison by the volume of data stored and the number of requests processed.

darkpuma• 8 years ago

Trying to make Larry Ellison blow a fuse?

kakwa_• 8 years ago

He has reasons to, given that Oracle owns BerkeleyDB which used to dominate the embedded DB use case in the past, being often replaced by sqlite.

virtualwhys3• 8 years ago

SQLite is likely used more than all other database engines combined. Billions and billions of copies of SQLite exist in the wild. SQLite is found in:
Every Firefox, Chrome, and Safari web browser

Where is SQLite in Firefox? It would be wonderful to use SQL in the browser, on the server, in mobile devices (everywhere!), but alas I suspect SQLite can be "found" in Firefox as the underlying storage engine on top of which IndexedDB is built.

Dammit Mozilla, set SQLite free!

hnaccy• 8 years ago

That was Web SQL.

https://hacks.mozilla.org/2010/06/beyond-html5-database-apis...

virtualwhys3• 8 years ago

That was Web SQL

and very much still is in Chrome and Safari, nearly 10 years after WebSQL was "deprecated". Firefox removed WebSQL, replacing it with IndexedDB, a simple k -> v store.

Cross platform SQL everywhere? Not with Firefox still in the mix.

bch• 8 years ago

https://support.mozilla.org/en-US/kb/profiles-where-firefox-...

https://addons.mozilla.org/en-US/firefox/addon/sqlite-manage...

quietbritishjim• 8 years ago

I believe that quotation is just saying that Firefox uses SQLite to store some of its internal state, not that it has an API to interact with general SQLite databases.

virtualwhys3• 8 years ago

not that it has an API to interact with general SQLite databases

Well, it did, but they removed it, and in fact spearheaded the movement to deprecate WebSQL circa 2010...when Firefox had significant marketshare. Chrome and Safari still, 10 years later, ship with WebSQL support, which makes it pretty clear which side of the fence they're on.

baldfat• 8 years ago

I love sqlite. It is far to under used. It scales incredibly well and if you out grow you can easily move it into a different dB system.

wenc• 8 years ago

There is a way that it does not. It is flexibly typed so you can insert a string into an integer column. This is by design.

This also means you’ll run into trouble when you try to move it to most SQL databases which are strongly typed.

solarkraft• 8 years ago

This is by design.

Oh god, why?

thisgoodlife• 8 years ago

No. In reality, it's incredibly hard to migrate any database to another database. Even if you have high test coverage, there can be some corner cases bite you later. Hack, simply a version upgrade can have all kinds of problems.

n-gate• 8 years ago

Isnt it Microsoft windows registry?

mkl• 8 years ago

No, even if you count that as a database, it isn't the most deployed. Look at the list in the article. SQLite is on every Android device and Windows 10 device, and many/most personal computers with other operating systems (including earlier Windows versions). There are more Android devices in use than Windows ones: https://www.computerworld.com/article/2919104/windows-pcs/wh...

misterkolaz• 8 years ago

Most of android apps use it as well ;)

qwerty4561274• 8 years ago

This makes me wonder why there are no alternative implementations of it (i.e. I felt like I would appreciate a .Net-native implementation many times).

hawkice• 8 years ago

It's written in C, you should be able to FFI into it from anywhere. The API is reasonably small, too.

qwerty4561274• 8 years ago

I know it's written in C. And it usually takes hours of shamanic dances to make it work in a Visual Studio WinForms app (while performance is rarely important for these projects).

jasode2• 8 years ago

A C# native port[0] of Sqlite was attempted in 2009 and eventually abandoned in 2012. It was a lot of work and the developer didn't get 100% of the verification tests to pass.

To be fair to the programmer, he said the C-to-C# translation was mostly a self-learning exercise rather than a serious attempt at creating a production-quality library.

I think the obvious answer is that there's no market demand for a C# native version of SQLite. People just use the C# ADO.NET wrapper that calls the "unsafe" C compiled DLL[1]. Using that method, it's easier to stay up-to-date with the canonical C source code that has the latest bug fixes and new features. If you look at high frequency of updates in the release history[2], you can see that constantly porting the new C code to C# to maintain feature parity would be a tremendous amount of work.

Also, if you create a C to C# port, it means using the C Language style API such as "sqlite3_open()" instead of the more natural C# paradigm of ADO.NET "new SQLiteConnection(@"Data Source=x")". Somebody would than have to write another ADO.NET wrapper to specifically interface with the C# port of SQLite.

[0] https://code.google.com/archive/p/csharp-sqlite/

[1] https://system.data.sqlite.org/index.html/doc/trunk/www/down...

[2] https://www.sqlite.org/changes.html

qwerty4561274• 8 years ago

Also, if you create a C to C# port, it means using the C Language style API

Is this really necessary? Is it impossible to just write a .Net-native library with whatever an API that would just open an SQLite file and run SQL queries against it? As for me that's all I ever needed of it.

ksec• 8 years ago

I wonder why there aren't more DB like bedrock which builds on top of SQLite.

https://github.com/Expensify/Bedrock

stickupkid• 8 years ago

LXD has a distributed cluster system built upon SQLite[1], that's based on the raft consensus protocol.

1. https://github.com/CanonicalLtd/go-dqlite/

InGodsName2• 8 years ago

I don't think Sqlite will maintain this position for long.

Apps are moving to LSM based storage engines.

RocksDB or Badger are the future.

Now, you just need to make embedded DB with Sqlite API using rocksdb/badger and sell it as direct competitor to Sqlite.

It will be a dropin replacement for Sqlite, written in a safer (hacker hype) language.

For more Omph, use Rust as a language for this and create libaries using FFI for python/ruby/node/c#

pdimitar• 8 years ago

and sell it as direct competitor to Sqlite

Pretty sure selling it won't work. For many, a convenient mini-storage is an afterthought during a product development and it doesn't warrant a cost.

InGodsName2• 8 years ago

Selling as in marketing it to same crowd.

Sqlite – Most Deployed Database in the World

Related Stories