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

sixbs is a library capable of writing and reading beans to and from XML using their public properties. sixbs is especially suited for writing configuration data or sending data over the network.

Contrary to normal Java serialization it is readable (i.e., you can easily edit it with your favourite text editor), and it is independent from class versions.

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)

sqlitewrapped is a C++ wrapper for the Sqlite database C application programming interface.
The code works for linux/unix, as well as win32. This library supports version 3 of the sqlite database. From version 1.2 the connection pool can be made threadsafe.
Examples:
#include < stdio.h>
#include < stdlib.h>
#include < sqlite3.h>
#include < string>
#include "Database.h"
#include "Query.h"
int main()
{
Database db( "database_file.db" );
Query q(db);
q.execute("delete from user");
q.execute("insert into user values(1,First Person)");
q.execute("insert into user values(2,Another Person)");
q.get_result("select num,name from user");
while (q.fetch_row())
{
long num = q.getval();
std::string name = q.getstr();
printf("User#%ld: %sn", num, name.c_str() );
}
q.free_result();
}
Enhancements:
- This release adds methods to access values in the result set by column name.

phpSQLiteAdm is an application to provide Web based management and administration for SQLite databases.
phpSQLiteAdm project is meant to be similar to phpMyAdmin. It provides functionality to view data, to add and drop tables, views, and indexes, to export data, to add and delete rows, and to query the database.
Enhancements:
- This is the initial release.
- Code cleanup and bugfixes were done.

gqlplus is a drop-in replacement for sqlplus, an Oracle SQL client, for UNIX and UNIX-like platforms.
The difference between gqlplus and sqlplus is command-line editing and history, plus table-name and column-name completion. As you know if you have used sqlplus, it is notoriously difficult to correct typing errors and other mistakes in your SQL statements.
sqlplus does give you ability to use external editor to edit a statement, but only the last statement you typed. gqlplus solves this problem by providing the familiar command-line editing and history as in tcsh or bash shells, and table/column-name completion, while otherwise retaining compatibility with sqlplus.
Thus, no user training is needed - simply use gqlplus instead of sqlplus. In addition, configuration/installation is trivial: gqlplus is a single binary compiled executable (written in C), so all you need to do is download it and put it anywhere in your PATH. After that, youll be ready to use it.
There are a number of other sqlplus front-end programs which include this functionality. They, however, require some user training, and may not be as easy to install (requiring particular version of Perl, and/or particular set of Perl modules, and/or configuration files).
In contrast, the design goal of gqlplus was to remain as close as possible to sqlplus, with the addition of command-line editing and table and column name completion. The command-line editing will be familiar to UNIX users since it works as in command-line shells. Additionally, there are no installation issues since the program is a single binary executable.
Enhancements:
- A SIGSEGV that occurred when using SQLPATH was fixed.
- An ACCEPT command was implemented.
- The DYLD_LIBRARY_PATH environment variable (the Mac OS X version of LD_LIBRARY_PATH) was added along with an NLS_DATE_FORMAT environment variable.
- A -p command-line switch that displays a progress report and elapsed time information was added.
- SIGTERM is now used to kill sqlplus.
- ORACLE_PATH was added to the environment.

libusb is a library to provide userspace access to USB devices. libusb project supports Linux 2.6/2.4/2.2, FreeBSD/OpenBSD/NetBSD, and Darwin/MacOS X.
Operating System support
- Linux
- FreeBSD
- NetBSD
- OpenBSD
- Darwin
- MacOS X
Building:
It should be as simple as running these two commands:
./configure
make