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

Storage Inspector is a Firefox extension that makes it easy to view any sqlite database files in the current profile. This includes the anti-phishing and search engine...

Developer Comments:

There are quite a few polish issues that need to be addressed before this version is ready for the masses. If you notice problems, please view the readme.txt file first and tell me if there are other issues.

You can set the storageinspector.openmode pref to 2 if you want the extension to open in a new tab instead of its own window.

I have primarily tested the extension in Firefox 2b1 but would still like feedback on how it runs in 3a1.

If you dont like something, please post here with a constructive statement telling me what you would like.

CGI::Wiki::Kwiki is an instant wiki built on CGI::Wiki.

A simple-to-use front-end to CGI::Wiki. It can be used for several purposes: to migrate from a CGI::Kwiki wiki (its original purpose), to provide a quickly set up wiki that can later be extended to use more of CGI::Wikis capabilities, and so on. It uses the Template Toolkit to allow quick and easy customisation of your wikis look without you needing to dive into the code.

INSTALLATION

The distribution ships with and installs a script called cgi-wiki-kwiki-install. Create an empty directory somewhere that your web server can see, and run the script. It will set up a SQLite database, install the default templates into the current directory, and create a cgi script to run the wiki. You now have a wiki - edit wiki.cgi to change any of the default options, and youre done.

MORE DETAILS

wiki.cgi will look something like this:

#!/usr/bin/perl -w
use strict;
use warnings;
use CGI;
use CGI::Wiki::Kwiki;

my %config = (
db_type => SQLite,
db_name => /home/wiki/data/node.db,
formatters => {
default => CGI::Wiki::Formatter::Default,
},
);

my %vars = CGI::Vars();
eval {
CGI::Wiki::Kwiki->new(%config)->run(%vars);
};

if ($@) {
print "Content-type: text/plainnn";
print "There was a problem with CGI::Wiki::Kwiki:nn--n";
print "$@";
print "n--n";
print STDERR $@;
}

In the following directions, we use "webserver" to mean the user that your webserver executes CGI scripts as. Often this is actually you yourself; sometimes it is "www-data" or "apache". If you dont know, ask your ISP.
In the script above and in the following, replace /home/wiki/data/node.db with a filename in a directory that you will be able to make readable and writeable by the webserver. SQLite requires access to both the file (for writing data) and the directory it resides in (for creating a lockfile).

Callweaver project is a community driven software PBX project. The most important differences between Callweaver and Asterisk are built-in STUN support, the use of SpanDSP for better codecs and full T.38 fax over IP support, Sqlite instead of Berkeley DB, universal jitterbuffer, POSIX timers to avoid Zaptel timing dependencies, greater speed, more efficient dialplan execution, and greater stability.
Enhancements:
- This is hopefully the last release candidate before the 1.2 release.
- There are many bugfixes and improvements.

Simple PHP Hit Counter is a simple hit counter written in PHP and using SQLite as a database. SiPHiCo project can be included in a page like an image, and the hits will be counted as the graphic is created.

After that, the IP will be blocked for further counts (10 minutes by default). Administration (creation of counters, etc.) is done via a web frontend, which is password protected. Theres also a log, a small statistics page and a calendar that shows the hits per day.

GENU is a Content Management System which uses a database server (MySQL, PostgreSQL, or SQLite). The project uses a template system and supports multiple languages.
It features BBCode and HTML tag support, a bulletin board, a comment system with reply and editing abilities, an administration interface, headlines generation, polls, a search engine, smilies support, "submit" and "send" news functions, unlimited news organized into unlimited categories, and user management.
Enhancements:
- new search system, also included in the posts
- new template named blumar
- HTML corrections
- more verifications when editing the categories