Developping for the translation industry RSS 2.0



 Monday, 20 October 2008

Today’s portable app is not a simple application but a full featured database engine: SQLite. SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

From SQLite Website:

SQLite does not need to be "installed" before it is used. There is no "setup" procedure. There is no server process that needs to be started, stopped, or configured. There is no need for an administrator to create a new database instance or assign access permissions to users. SQLite uses no configuration files. Nothing needs to be done to tell the system that SQLite is running. No actions are required to recover after a system crash or power failure. There is nothing to troubleshoot.

SQLite just works.

 

For those who didn’t heard the SQLite name before and have some doubts on the stability and performance of this engine, don’t fear.  This is probably the most widely deployed database engine as of today. Here are some stats on where SQLite is currently used:

  • 125 million copies of Mozilla Firefox [1]. Firefox 3 uses Sqlite for bookmarks and history.
  • 20 million Mac computers, each of which contains multiple copies of SQLite
  • 20 million websites run PHP which has SQLite built in. [2] We have no way of estimating what fraction of those sites actively use SQLite, but we think it is a significant fraction.
  • 300 million downloads of the Skype client software and 100 million registered users [3]. All recent versions of the Skype client use SQLite internally.
  • 20 million Symbian smartphones shipped in Q3 2007 [4] Newer versions of the SymbianOS have SQLite built in. It is unclear exactly how many Symbian phones actually contain SQLite, so we will use a single quarter's sales as a lower bound.
  • 10 million AOL subscribers use SQLite in the AOL email client that comes bundled with their subscription.
  • 10 million Solaris 10 installations, all of which require SQLite in order to boot.
  • Millions and millions of copies of McAfee anti-virus software all use SQLite internally.
  • Millions of iPhones use SQLite
  • Millions and millions of other cellphones from manufactures other than Symbian and Apple use SQLite. This has not been publicly acknowledged by the manufactures but it is known to the SQLite developers.
  • There are perhaps millions of additional deployments of SQLite that the SQLite developers do not know about.

 

Other Portable software posts:

Portable software – Part 1 (Developer tools)

Portable software – Part 2 (Graphic tools)

 

Other posts:

Chuck Norris Programming facts

Monday, 20 October 2008 09:18:02 (Eastern Standard Time, UTC-05:00)  #    Comments [0] -
Portable Software | SQL | Tools

Navigation
Advertisement
About the author/Disclaimer

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

© Copyright 2017
Stanislas Biron
Sign In
Statistics
Total Posts: 135
This Year: 0
This Month: 0
This Week: 0
Comments: 1
All Content © 2017, Stanislas Biron