Free sqlite software for linux

Cloud Wiki is a wiki engine written in Python and backed by Sqlite, providing user authentication, powerful command line administration facilities, and a concise, efficient Web interface.
Implemented by Scott Dunlop, Cloud Wiki provides a simple, fast environment that limits itself to features necessary for providing user-editable content quickly and easy to learn.
Cloud Wiki is now an official Sourceforge project. The latest releases of Cloud Wiki should be downloaded from our project file releases to ease congestion on KMN. Cloud Wikis DARCS repository is also now hosted on Sourceforge.
Main features:
- Flexible user authentication system. See An Argument Against Anonymous Wikis for an explanation why Cloud Wiki supports user authentication.
- Implementation of C2 Wikis fundamental Wiki Principles
- Extremely fast SQLite database used for node storage, caching generated content html, content changes and dependency information.
- Long running web server process, instead of a slow loading CGI. Designed to run well behind a reverse proxy.
- Minimalist markup language designed with an emphasis on having just enough features to be useful, but not so many that new users are intimidated. All linking is done with brace-enclosed free links, for example.
- Modular user authentication system.
- Powerful command line node and server manipulation tools for easy administration.
- An interface to view change/replacements to a node in the past three days.
- Added Nodes gateway to list all nodes added to the wiki in the past three days.
- Changed Nodes gateway to list all nodes changed on the wiki in the past three days.
- Generated content is automatically valid, strict XHTML 1.0.
- Wikis may be exported to static HTML files; our Sourceforge website is produced this way from our test wiki.

XAMPP project is a very easy to install Apache distribution for Linux, Solaris, and Windows.
Many people know from their own experience that its not easy to install an Apache web server and it gets harder if you want to add MySQL, PHP and Perl.
XAMPP is an easy to install Apache distribution containing MySQL, PHP and Perl. XAMPP is really very easy to install and to use - just download, extract and start.
Main features:
- Apache 2.2.4
- MySQL 5.0.45
- PHP 4.4.7
- PHP 5.2.3
- Perl 5.8.7
- ProFTPD 1.3.0a
- phpMyAdmin 2.10.3
- OpenSSL 0.9.8e
- GD 2.0.1
- Freetype 2.1.7
- libjpeg 6b
- libpng 1.2.12
- gdbm 1.8.0
- zlib 1.2.3
- expat 1.95.2
- Sablotron 1.0
- libxml 2.6.11
- libxslt 1.1.8
- Ming 0.3
- Webalizer 2.01
- pdf class 009e
- ncurses 5.8
- mod_perl 2.0.2
- FreeTDS 0.63
- gettext 0.11.5
- IMAP C-Client 2004e
- OpenLDAP (client) 2.3.11
- mhash library 0.8.18
- mcrypt library 2.5.7
- cURL 7.13.1
- SQLite 2.8.17 (for PHP4 + PHP5)
- SQLite 3.3.17 (for PHP5 PDO SQLite)
- phpSQLiteAdmin 0.2
- libapreq 2.07
- eAccelerator 0.9.5.1
- FPDF 1.53
Enhancements:
- Fixed problem with start script on 64-bit systems.

SQLite::VirtualTable is a Perl module that can create SQLite Virtual Table extensions in Perl.

SYNOPSIS

on Perl:
package MyVirtualTable;
use base SQLite::VirtualTable;

sub CREATE {
...
and then from your preferred SQLite application or language, as for instance, the sqlite3 shell:
$ sqlite3
sqlite> .load perlvtab.so
sqlite> CREATE VIRTUAL TABLE foo USING perl ("MyVirtualTable", foo, bar, ...);
sqlite> SELECT * FROM foo WHERE col1 AND col1 > 34;
...

Virtual tables are a new feature in SQLite (currently still only available from the development version on CVS) that allows you to create tables using custom backends to access (read and change) their contents instead of being stored in the database file.

The SQLite::VirtualTable module allows you to create these backends in Perl embbeding a perl interpreter as a SQLite extension.
Note that extensions written using this module can be used from any SQLite application and programming language (C, Java, PHP, Perl, etc.).

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

DBConsole is a GPLd database shell written in Python. The project currently supports SQLite, PostgreSQL and MySQL.

DBConsole is dedicated to the nice people behind Python DBAPI-2.

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.

WizSQLiteAdmin is a PHP script to manage SQLite databases.

If you use SQLite databases you can manage their contents with WizSQLiteAdmin: its very simple to use and avoid you to perform a lot of action.

SQLite is a simply but powerful database embedded into PHP5. See here for more information about it!

This application got the 2nd prize at 2nd PHP Programming Marathon at dotgeek.org