Hacker News Reader

Comment by OJFord | Hacker News Reader

I don't think it is whatever it's written in, because I can't imagine what it would mean? Unless there's a DBMS implementation called simply 'SQL' that I'm not aware of? (Or if Mongo calls its query language 'MongoDB'?)

Seems like '.. to (My|Postgre)SQL' would be a better fit?

View on HN

SQLite is a portable DBMS library that exposes a SQL language interface that is built and runs under every OS and language under the sun, for the most part. It is probably the single-most distributed library on the planet (in aggregate). And likely one of the most used libraries (top 10) on just about every given OS and platform/language.

Mongita is only useful for Python developers.

I like sqlite and agree with your it should run everywhere to be compared.

I question that it is the most distributed library on the planet. Is there something backing that up? It would be cool but very shocking.

> I question that it is the most distributed library on the planet. Is there something backing that up? It would be cool but very shocking.

I recall seeing that claim made ~2 years ago, with data to back it up. I think many people forget that it is shipped (or statically compiled into an application that is shipped) on every android device (handset, TVs, etc), every Linux installation, every Windows installation and every OSX installation.

I do not know of any other library that has that penetration. I don't know about iOS.

I can't say it's the most, but it does get used a lot. Chromium and descendants, Firefox, bunch of chat apps (Telegram, WeChat), and so on. You probably have multiple copies per machine.

The SQLite people are quite proud of their ubiquity: https://sqlite.org/mostdeployed.html

I guess the idea relates to "a SQL database" - might be technically incorrect, but with Mongo it's sort of embedded in NoSQL - that also originally meant "no SQL [language]", but has turned to mean "no SQL and not a classical RDBMS with databases, tables and columns, rows, views, procedures..."

Reply on news.ycombinator.com