News for hackers. Stuff that matters.
Re:Size isn't everything for the modest creator of SQLite (2... by smadge on Sunday February 07, 2016 @04:52AM (#11052352)
Hacker news is too often obsessed with get rich quick schemes, and devising new ways to rip people off. It's nice to hear a story about people who just wants to write good, useful software, and release it to the public domain.
[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by sehugg on Sunday February 07, 2016 @12:43AM (#11051804)
So how many SQLite databases are in use? "We don't have a good way of counting it," he says, "but we're guessing it's the most widely deployed SQL database in the world."

This article came out before the original iPhone was released -- it certainly is by now, probably by an order of magnitude.

[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by skeeterbug on Sunday February 07, 2016 @02:02AM (#11051998)
Chrome uses it for local storage too right?
[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by infogulch on Sunday February 07, 2016 @02:31AM (#11052069)
And Firefox. There are probably more instances of SQLite in use than humans on the planet.
[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by abtinf on Sunday February 07, 2016 @03:57AM (#11052237)
Just "an order of magnitude"? I suspect you are off by an order of magnitude. If you count each deployed instance of each product using it, it's probably the most popular by close to 10 orders of magnitude.

Edit: phones are just the start. Numerous embedded products use it - the kind that ship in such large quantities that a couple pennies per device become significant sums of money. And even in the phone case, every app is using a separate database.

[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by adrianN on Sunday February 07, 2016 @04:17AM (#11052280)
10 orders of magnitude is a lot. Are you really saying there are ten billion times more SQLlite databases than the next most popular SQL?
[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by masklinn on Sunday February 07, 2016 @04:41AM (#11052329)
That's probably excessive by a lot, but every modern smartphone has at least one sqlite bundled (possibly more, some software will bundle their own in case the system changes its version), OSX bundles it (and Apple Mail uses it for some stuff), Chrome and Firefox bundle it, …
[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by throwawaymsft on Sunday February 07, 2016 @05:38PM (#11055293)
Off by "an (one) order of magnitude", i.e. off by 2 orders of magnitude.
[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by dang on Saturday February 06, 2016 @11:52PM (#11051676)
We should have a bonus for finding great old articles that never were posted to HN before.

There was another one earlier today: https://news.ycombinator.com/item?id=11048637.

[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by bootload on Sunday February 07, 2016 @01:11AM (#11051891)
yeah I'll take a look, @dang the web rusts a lot so a lot of old stuff might be archived [0] there.

[0] Internet Archive https://archive.org/

[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by greglindahl on Sunday February 07, 2016 @02:37PM (#11054395)
For the future, HN's software could call the Wayback Machine's "save page now" API on all front-page links.
[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by dang on Sunday February 07, 2016 @04:40PM (#11055004)
Definitely willing to do that. Lord knows we do it enough by hand already.
[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by dalke on Friday February 05, 2016 @07:46PM (#11045889)
A nice interview, though from 2007. One thing has changed a smidgeon: "he has a self-imposed limit on the size of his product: 250KB. And he's stuck to both aims". The FAQ on sqlite.org says "With all features enabled, the library size can be less than 500KiB ... If optional features are omitted, the size of the SQLite library can be reduced below 300KiB." Close though!
[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by nly on Friday February 05, 2016 @08:05PM (#11045956)
Also out of date. The 3.10.2 shared library is over 1 MiB on my system.
[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by dalke on Friday February 05, 2016 @10:19PM (#11046386)
Compiling with -Os brings it down to 800 KB.

  % gcc -c sqlite3.c
  % ls -l sqlite3.o
  -rw-r--r--  1 dalke  admin  1270372 Feb  6 04:11 sqlite3.o
  % gcc -c sqlite3.c -Os
  % ls -l sqlite3.o
  -rw-r--r--  1 dalke  admin  805044 Feb  6 04:12 sqlite3.o

  % clang -c sqlite3.c
  % ls -l sqlite3.o
  -rw-r--r--  1 dalke  admin  1248704 Feb  6 04:15 sqlite3.o
  % clang -c -Os sqlite3.c
  % ls -l sqlite3.o
  -rw-r--r--  1 dalke  admin  796888 Feb  6 04:16 sqlite3.o
778 KiB is still some 50% larger than 500.
[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by SQLite on Friday February 05, 2016 @10:50PM (#11046467)
Using "gcc -Os -m32 -c sqlite3.c; size sqlite3.o" I get 443,264 bytes using the latest SQLite source on Ubuntu.

The "size" command gives a more accurate measurement of what actually ends up in a compiled and stripped binary. "ls -l" includes symbolic and linking info that gets stripped from the finished binary.

[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by obelisk_ on Sunday February 07, 2016 @04:49AM (#11052343)
Are you the author of SQLite or did you just name your account so for other reasons?
[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by lorenzhs on Sunday February 07, 2016 @05:40AM (#11052446)
From their comment history it seems like the GP really is SQLite's author, Richard Hipp. Cool!
[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by SQLite on Sunday February 07, 2016 @06:10AM (#11052516)
Yes, I am.
[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by orvr on Sunday February 07, 2016 @07:01AM (#11052590)
May I ask you about the current state of sqlite4?
[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by dalke on Friday February 05, 2016 @11:35PM (#11046567)
Thanks for the pointer to 'size'. I so rarely compile code these days. FWIW, on my Mac with 3100200, clang -Os -m32 is 495,508 bytes while gcc is 507,378.
[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by jevinskie on Sunday February 07, 2016 @03:30AM (#11052180)
Clang also has -Oz for even more aggressive size optimizations. I find that it is identical codegen to -Os half the time and shows some nice size reductions the other half of the time.
[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by coliveira on Friday February 05, 2016 @10:22PM (#11046391)
This might have to do with 64 bit platforms. I would test this on a 32 bit binary.
[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by matt_wulfeck on Sunday February 07, 2016 @11:30AM (#11053394)
> The author disclaims copyright to this source code. In place of a legal notice, here is a blessing: may you do good and not evil. May you find forgiveness for yourself and forgive others. May you share freely, never taking more than you give.

Wow! That is the most enlightened disclaimer I've ever read.

[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by ksec on Sunday February 07, 2016 @01:34AM (#11051933)
what happened to SQLite 4?
[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by maaku on Sunday February 07, 2016 @03:33AM (#11052185)
This is from 2007.
[ Parent | on HN ]