StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>SQLite is a very good option. It is just a single file, and fast. No configuration, transactions are atomic, supports terabyte-sized databases. There are language-bindings for Ada, C#, Lisp, Fortran, Java, Lua, PHP, Perl, Python, Ruby, Tcl, etc...</p> <p>It has good GUI admin options:</p> <ol> <li><a href="http://www.softpedia.com/get/Internet/Servers/Database-Utils/SQLite-Admin.shtml" rel="nofollow noreferrer">SQLite Admin</a> for Windows</li> <li><a href="http://sqlitebrowser.sourceforge.net/" rel="nofollow noreferrer">SQLite Browser</a> for Linux, Mac, and Windows <a href="http://sqlitebrowser.sourceforge.net/screenshots.html" rel="nofollow noreferrer">screenshots</a></li> <li>Even a <a href="https://addons.mozilla.org/en-US/firefox/addon/5817" rel="nofollow noreferrer">Firefox plugin</a> for viewing/editing data</li> <li>Many more</li> </ol> <p>It is used in industry:</p> <ol> <li>It's the base database the Firefox uses internally for bookmarks and history. It can also be used by plugins for them to store internal data. <a href="https://developer.mozilla.org/en/Storage" rel="nofollow noreferrer">link</a></li> <li>The iPhone also uses it internally to store data, and can be used by apps themselves for their own data storage. Here is a series of tutorials on using it within your own apps. <a href="http://www.mobileorchard.com/iphone-sqlite-tutorials-and-libraries/" rel="nofollow noreferrer">link</a></li> <li>Adobe uses it as the file format for Lightroom. Apple uses it for Mail and Aperture. Skype uses it in their clients for Mac and Windows. Lastly, it seems to be an integral part of Symbian, Nokia's phone OS. <a href="http://www.sqlite.org/cvstrac/wiki?p=BigNameUsers" rel="nofollow noreferrer">users page</a></li> </ol>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload