Free sqlite 3.4.2 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

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.

libASSA is an OO C++ UNIX networking library based on some of the design patterns such as Configurator, Reactor, Acceptor, and Connector collectively known as Adaptive Communication Patterns described in various papers published by Dr. D. C. Schmidt.
libASSA library happily co-exists with other frameworks such as GUI toolkits and various CORBA implementations.
Enhancements:
- The networking layer has been ported to wing32 environment.
- There are minor bugfixes and interface improvements.

VSQLite++ is a portable SQLite wrapper library for C++.
Supported Compilers
- GCC and G++ 4.x (maybe 3.4.x too, but it wasnt tested until now)
- Visual C++ 8/2005 (Visual C++ 7.1/2003 wasnt tested, maybe will be added later)

LiteMan is a simple GUI database manager for the SQLite embeded database engine version 3. It is written in C++ using the Qt toolkit, and is free software under the terms of the GNU GPL license.
LiteMan is meant to be used a quick tool to build database files for dynamic websites and application file formats, but can be used as a generic database application (though a low-level one).
Main features:
- Create and view any SQLite3 database file
- Create, delete and alter new and existing tables
- Create and delete database views
- Run quaries by either direct SQL code or by a dialog
- Export your tables and views to a SQL dump file
Known Issues (and missing features)
- Table field comments are not stored.
- The only way to alter a table is to rename it. Anything other requires re-creating the table.
- There are no means to alter a view.

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);

php-sqlite3 project is a PHP extension that lets you access SQLite3 databases within your scripts.
PHP 4 and PHP 5 have already built-in support for this RDBM, but this is limited to the 2.x releases. This extension adds support for SQLite 3.x release.
Please note that this project is still alpha-quality. Please test and report if it works for you and how it can be enhanced.
Current (or planned) features include:
In-memory databases support
UTF-16 encoding
User-level SQL functions
PEAR::DB driver class
Enhancements:
- fix BEGIN...END/ROLLBACK statments queries (thanks to John Morrissey!)
- better support for BLOB columns (thanks to Michal Srajer!)

KnowledgeTree is a feature-rich document management system featuring knowledge management, document version control, hierarchical document management, support for common file formats (MS Word, MS Excel, PDF, TXT, HTML), extensible meta data, creation of custom document types, application managed document links that guarantees consistent data and eliminates emailing documents, easy publication of documents, subscription agents, archiving according to expiry date, expiry time period, or utilisation for enhanced speed, and much more.
KnowledgeTree is free software released under the GPL license.
Main features:
- Fully web-based
- Includes document version control
- Search within common file formats (MS Word, MS Excel, PDF, TXT, HTML)
- Entry and search of user-defined metadata fields
- Subscription agents provide notification of changes to documents or to document directories
- Archives by expiry date, expiry time period, or by document usage, ensures fast searching
- Document-specific discussion forums
- Configurable browsing of information in the repository by folder, by category, or by document type
- Customizable dashboard allows you to view subscriptions, pending documents, checked-out documents, and quick links
- Displays configurable metadata when browsing
- Supports bulk uploads of multiple files to a folder
- Translations available for most of the user interface
Enhancements:
- This is a bugfix release that mainly addresses some webservices and XSS issues as well as several smaller issues related to i18n and issues created by the XSS fixes.