SQLite is the 900lb gorilla in the room of in-process databases. It is in every mozilla install, android device, iOS device. It's the default database for Adobe AIR apps. Skype. Symbian. McAffee. It is widely used by pretty much everyone except Microsoft. It's fast (in my tests it was about 2x faster than SQL CE 4 straight out of the box, although I recently made some perf changes to my code in the way it calls SQLite that make it about 10x faster than SQL CE 4, but I don't know much about tuning SQL CE perf). From my tests ESE from Microsoft is the only in-process database technology of comparable speed. But ESE doesn't have a SQL interface, full text search etc like SQLite does. SQLite has some weird notions about types, but it still manages to be very fast. Their approach to software reliability is quite interesting > 600x more test code and scripts than actual SQLite code.
Joseph On Sun, Dec 5, 2010 at 1:05 PM, Mark Ryall <mark.ry...@gmail.com> wrote: > sqlite is amazingly ubiquitous these days. > > Most mozilla (or mozilla based) projects use sqlite for any relational > storage (including html5 databases) - firefox, songbird, thunderbird, etc. - > as did google gears. Other miscellaneous applications seem to favour it > these days - calibre ebook manager, delicious monster etc. > > It is really easy to get started with, has plenty of tools available and > works on all platforms. > > On Sun, Dec 5, 2010 at 12:52 PM, Nic Roche <nicro...@hotmail.com> wrote: > >> Hi Greg, >> >> You may be aware of this, but there is a simple GUI tool at >> http://sqlitebrowser.sourceforge.net/ >> >> Also SQLite is the default db on the Android platform... >> >> Regards, >> Nic >> >> ------------------------------ >> From: g...@mira.net >> To: ozdotnet@ozdotnet.com >> Subject: In praise of SQLite >> Date: Sun, 5 Dec 2010 11:13:01 +1100 >> >> >> A couple of years ago I asked in here what people recommended for an >> “RDB lite” with little to no installation footprint. Some people recommended >> SQLite, but for some reasons I can’t remember I rejected it as unsuitable. >> I’ve been running with SQL CE since then simply because it was from >> Microsoft, it was free, well documented and it had a familiar style. CE does >> have an installation footprint, which is small, but still a nuisance >> sometimes. >> >> >> >> I just revisited SQLite <http://www.sqlite.org/index.html> and ran a few >> tests with a VS2010 solution and the ADO.NET >> provider<http://sqlite.phxsoftware.com/>. >> Hey, I’m impressed ... it just works. The ADO .NET code follows the familiar >> coding style (connection, command, adapter, etc). The raw SQLite uses a >> plain C API which is indigestible for .NET developers, so the provider is >> the miraculous part that makes things easy for us. Best of all, there is >> zero installation footprint, you just reference the DLL. The SQLite VS2010 >> designer is working but incomplete, so I look forward to seeing it expanded. >> I’m pretty sure I’m going to abandon CE in future projects and use SQLite >> instead. >> >> >> >> Cheers, >> >> Greg >> > > -- w: http://jcooney.net t: @josephcooney
