AboutWelcome to Free Software Daily (FSD). FSD is a hub for news and articles by and for the free and open source community. FSD is a community driven site where members of the community submit and vote for the stories that they think are important and interesting to them. Click the "About" link to read more...
Last weeks I've been looking (again) whether or not it was possible to create a working sqlite back end for Akonadi. The last time I tried was around august last year and by then sqlite just wasn't able to meet the multi-threading requirements that Akonadi has for its database back ends. A couple of sqlite releases later things seem to have changed.
In my last article I wrote about accessing a PostgreSQL database in C/C++. In this article, I'm going to discuss performing the same functions in C against an SQLite database. Unlike Postgresql and the supporting libraries, SQLite creates completely self-contained databases that aren't dependant upon a client-server architecture.
ITTIA, a global supplier of embedded lightweight relational database software, demonstrates its database benchmark leadership to application developers of embedded systems and devices, with exceptional results. On an ARM device, ITTIA DB SQL surpasses SQLite, an open source database, in three critical areas: insert, select, and update.
If you think about learning how to create dynamic database-driven web sites, the simplest way is to start with PHP and SQLite. Ubuntu is a wonderful Linux distribution that makes installation of this software extremely easy.
Adobe has announced that it is sponsoring the SQLite public domain database engine project by joining Mozilla and Symbian on the SQLite consortium. The news is interesting in that it balances Google’s recent sponsorship of efforts to support Photoshop on Linux, while it also raises an interesting question about Microsoft’s attempt to define commercial open source.
Firefox insists on doing huge amounts of I/O when closing, as well as act slow when using the awesomebar, try the following (close down Firefox completely first):
for f in ~/.mozilla/firefox/*/*.sqlite; do sqlite3 $f ‘VACUUM;’; done
It’s harmless, no data will be lost: it compacts your SQLite databases. Noticable gains for me.
Fossil is a new version control system based on sqlite (and in fact authored by sqlite's author). While the world doesn't really need another source control system, Fossil has some very interesting, if not downright compelling, unique features.
Version 11g Release 2, which is to become available at the end of the month, will provide Oracle's embedded Berkeley DB database with an SQL interface that offers the same functionality as free SQLite