Free sqlite software for linux

KTagebuch is a diary application. It has word processor-like functions and has a plugin to save the mood for every entry.
The file is a SQLite database and its content can also accessed with the sqlite3 commandline utility for example to export certain entries. It is now also easier to backup or encrypt the entries because it is now just a single file.
Main features:
- Word processor like functions
- A toolbar to easily access the entries
- Entries are searchable
- Mood Plugin
Enhancements:
- Version 0.73 crashed if there were no entries to import.

PyGogear is a tool for using the Philips GoGear MP3 players under Linux. The GoGear Philips HDD0xx series of MP3 players can be mounted with the usb-storage module, but merely copying MP3 files onto it is not enough, since the player needs to read information about the tracks from a Sqlite database file, usually named MyDb.
This program reads the ID3v1 tags from the MP3 files placed on the player and inserts the most important ones in the database.
Written in Python. Beta development stage. HIGHLY experimental.
Please read the README file included for a careful usage and more info.
Enhancements:
- Support for Python 2.3 was added.
- Some bugs in reporting missing modules were fixed.
- Output formatting was made nicer.

SQLitepp is a C/C++/Python wrapper to sqlite library for database management. It implements an object oriented way to manipulate the database in every supported language.

SQLitepp supports selfupdatable queries and a straight SQL code query system without using strange things for querying the database, letting you manipulate it directly in SQL but also exposing simple object oriented methods to manipulate the result of the queries and updating them.

Python EXAMPLE:

db = SQLDatabase("database.db")
q = db.query("Tablename", "SELECT Name,Id FROM %t")
if len(q):
tuple1 = q[0]
tuple1["Name"] = "Foobar"
tuple1.commit()
del db

C++ EXAMPLE:

SQLDatabase db("database.db");
SQLQuery *q = db.query("Tablename", "SELECT Name,Id FROM %t");
if(q->numberOfTuples()) {
SQLRow *tuple1 = q->getRow(0);
tuple1->set("Name", "Foobar");
tuple1->commit();
}
delete q;

C EXAMPLE:

void *db = new_SQLDatabase("database.db");
void *q = SQLDatabase_query(db, "Tablename", "SELECT Name,Id FROM %t");
if(SQLQuery_numberOfTuples(q)) {
void *tuple1 = SQLQuery_getRow(q, 0);
SQLRow_set(tuple1, "Name", "Foobar");
SQLRow_commit(tuple1);
}
delete_SQLQuery(q);
delete_SQLDatabase(db);

DatabaseScripts is a collection of scripts for general manipulation of the amarok collection database. Currently, DatabaseScripts has two scripts in the bundle.

Backup Collection:

database will be copied to a directory. This will work for SQLite or MySQL database backends.

Optimise Database:

This script will remove all entries in the database which do not exist in the filesystem.

Money Manager Ex is a cross-platform, easy-to-use personal finance software.
Main features:
- Intuitive. Simple, Fast, Clean
- Maintain checking, credit card, savings, stock investment accounts
- Budgeting
- Maintain and Track Fixed Assets with depreciation
- Reminders for recurring Bills and Deposits
- Simple one click reporting
- Cash Flow Forecasting
- Does not require an install. Can run from a USB key.
- International language support (Available in 17 languages)
- Import data from any CSV format, QIF [ Microsoft Money ]
- Printing, Exporting to HTML, CSV
- Non-Proprietary SQLite Database

Contact Book is a simple contact book manager.

Simple Contact that could be compared to Mac OS Xs simply address book application. I plan on making the initial release with very basic functionality but it will certainly grow from there.

Although it is in a deb it does net check dependancies so make sure you have mono, GTK# (2.4), and sqlite installed to use it.

Why you might be interested:

- Simple Address Book so you dont have to use evolution (this was my main reason for starting this project)
- Easy to use (not pop up dialog boxes)

Monodiary project is a simple an effective way to work with an user diary.

Monodiary use xml to store the information, organized by dates, In the future,
implementing the NoteManagers interface methods, the information can be stored over other format or database, like mysql, postgresql, sqlite, ...

The apps configuration is stored using gconf.