Free sqlite 3.3.x c api. software for linux

SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine.
Main features:
- Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures.
- Zero-configuration - no setup or administration needed.
- Implements most of SQL92. (Features not supported)
- A complete database is stored in a single disk file.
- Database files can be freely shared between machines with different byte orders.
- Supports databases up to 2 terabytes (241 bytes) in size.
- Sizes of strings and BLOBs limited only by available memory.
- Small code footprint: less than 30K lines of C code, less than 250KB code space (gcc on 486)
- Faster than popular client/server database engines for most common operations.
- Simple, easy to use API.
- TCL bindings included. Bindings for many other languages available separately.
- Well-commented source code with over 95% test coverage.
- Self-contained: no external dependencies.
- Sources are in the public domain. Use for any purpose.
The SQLite distribution comes with a standalone command-line access program (sqlite) that can be used to administer an SQLite database and which serves as an example of how to use the SQLite library.
Create A New Database:
- At a shell or DOS prompt, enter: "sqlite3 test.db". This will create a new database named "test.db". (You can use a different name if you like.)
- Enter SQL commands at the prompt to create and populate the new database.
Write Programs That Use SQLite
Below is a simple TCL program that demonstrates how to use the TCL interface to SQLite. The program executes the SQL statements given as the second argument on the database defined by the first argument. The commands to watch for are the sqlite3 command on line 7 which opens an SQLite database and creates a new TCL command named "db" to access that database, the invocation of the db command on line 8 to execute SQL commands against the database, and the closing of the database connection on the last line of the script.
#!/usr/bin/tclsh
if {$argc!=2} {
puts stderr "Usage: %s DATABASE SQL-STATEMENT"
exit 1
}
load /usr/lib/tclsqlite3.so Sqlite3
sqlite3 db [lindex $argv 0]
db eval [lindex $argv 1] x {
foreach v $x(*) {
puts "$v = $x($v)"
}
puts ""
}
db close

Google Data Objective-C Client provides a framework and source code that make it easy to access data through Google Data APIs.
The Google data APIs provide a simple protocol for reading and writing data on the web. Many Google services provide a Google data API.
Each of the following Google services provides a Google data API:
- Base
- Blogger
- Calendar
- Spreadsheets
- Picasa Web Albums
- Notebook
Additional services with Google data APIs that are not yet supported by the Objective-C Client Library:
- Code Search
- Google Apps Provisioning

Qcat is a simple media catalog. It can import data from WhereIsIt. The project is still in pre-alpha stage, so there are no sources available.

Compile:

1. download the source
2.untar it - tar -xzvf qcat-0.5-src.tar.gz
3. cd qcat-dist-0.5
4. here is the tricky part.

Perhaps you use QT 3.3.x. So to compile you have export QT_DIR and PATH for QT4.

Check where is installed QT4. For example if QT4 is in /opt/qt4 type these commands:

export QT_DIR=/opt/qt4
export PATH=/opt/qt4/bin:$PATH

5. run qmake
6. make
7. If all is ok, the result shall be an executable file in qcat-dist-0.5/bin named qcat
8. run it and enjoy.

Installation:

Ive not written any install target, script or so on, so you can just copy "qcat" file somewhere in you path. The install script/target is is in my TODO list.

Some instructions:

This program use SQlite for db backend. During its first run it will create file in ~/.config/QCat in which it will store the configuration. Also it will create your first catalog in your home directory. It will be named defaultCatalog.qcat.

If you want to make shortcut for your CD/DVD drive, go to Tools - Manage Drives. There you can add alias for this drive or any other folder. If you chose that this is optical drive, you have to specify its drive node in /dev/ so the program can read CD/DVD label and mount/unmount the media in it.

In Tools - Manage Icons you can change some of the default icons. They are stored in DB.

Import menu - here you can try to import WhereIsIt xml file. Please notify that if you have groups defined in WhereIsIt file, the hierarchy will be lost. (WherIsIt do not export it), so you have to arrange your disks again. You can use Drag and Drop. At this point only Disk Groups and Disks can be moved.

Saving - there is no need to save your changes, They are committed instantly. Shame on me. I havent write transactions yet.

Locking the catalog - Select catalog properties and click Lock icon. Please note that the passwords are kept in plain text. Shame on me again, so you can just avoid password protection and wait for some new version.

Feel free to explorer. It is almost certain there are plenty of bugs.

pysqlite is a Python DB-API 2.0 interface for the SQLite embedded relational database engine.
Enhancements:
- pysqlite is now 2.5 times faster for DML statements.
- This pays off especially for bulk-loading data.
- pysqlite now recognizes if the database engine has done an implicit ROLLBACK and acts accordingly.
- Using custom mapping and sequence types in parameters works now.

libviper is an API for quickly developing console, curses-based interfaces with mouse support (GPM). Its a good alternative to the panels library.

The API preserves many of the familiar ncurses monikers. The project also provides, basic, GTK-like window signal handling.

SQLiteJDBC is a JDBC driver for SQLite which is written as a Java JNI layer over the SQLite 3.3.x API.

SQLiteJDBC supports the most commonly used features of JDBC that can be efficiently implemented on top of SQLite. Only a single native JNI library is required, and SQLite is compiled in.

Binaries are provided for Linux, Mac OS X, and Windows.