Provide mathematical, string and aggregate functions for SQL queries
using the SQLite loadable extensions mechanism.
Math functions:
acos, asin, atan, atn2, atan2, acosh, asinh, atanh, difference,
degrees, radians, cos, sin, tan, cot, cosh, sinh, tanh, coth,
exp, log, log10, power, sign, sqrt, square, ceil, floor, pi
String functions:
replicate, charindex, leftstr, rightstr, ltrim, rtrim, trim,
replace, reverse, proper, padl, padr, padc, strfilter
Aggregate functions:
stdev, variance, mode, median, lower_quartile, upper_quartile
Tablelog is a contributed PostgreSQL module that uses a trigger to log
any INSERTs, UPDATEs and DELETEs on a specific table into another table.
The second part of tablelog is able to restore the state of the original
table or of a specific row for any time in the past.
The Zild Database Library implements a small and fast database API
with the following features: C database library - easy to use API
- connect to multiple database systems - zero runtime configuration,
connect using URL scheme - Thread safe Connection Pooling.
Alembic is a new database migrations tool, written by the author of
SQLAlchemy. A migrations tool offers the following functionality:
- Can emit ALTER statements to a database in order to change the structure of
tables and other constructs
- Provides a system whereby "migration scripts" may be constructed; each
script indicates a particular series of steps that can "upgrade" a target
database to a new version, and optionally a series of steps that can
"downgrade" similarly, doing the same steps in reverse.
- Allows the scripts to execute in some sequential manner.
R.V. Guha's rdfDB. Intended to be a simple, scalable, open-source
database for RDF. Written in C and based on top of the Sleepycat
Berkeley Database, it supports interrogation via TCP/IP sockets,
meaning integration is possible with any programming language.
rdfDB uses a high level SQLish query language. The data is modelled as
a directed labelled graph (RDF).
The goals of this project are to build a database that is capable of:
1. Supporting a graph oriented API via a textual query language ala
SQL.
2. Load/Reload an RDF file from a url into the database
3. Scalable to millions of nodes and triples.
4. Provide support for RDF Schemas.
5. Provide support for some basic forms of inferencing.
6. Provide both C and Perl access to the database.
7. The Perl philosophy applies : Simple things should be simple and
complex things should be possible.
Speed tables is a high-performance memory-resident database, currently oriented
towards Tcl. Speed tables provides an interface for defining tables containing
zero or more rows, with each row containing one or more fields. The speed table
compiler reads the table definition and generates C code to create and manage
corresponding structures, generating a custom C language Tcl extension to
create, access and manipulate those tables and building a native code package
in a shared library that is loadable on demand via Tcl's "package require"
mechanism.
For those either needing a dummy PostgreSQL database full of real
facts and data, or those who make frequent use of the CIA's World Fact
Book, this is the port for you: wfb2sql converts the WFB into SQL
inserts. Act now and get your copy of the WFB for free now! The
WFB is a public domain document that may disappear as fast as you do
after the black helicopters lock in on your location!!!!
Anamnesis is a clipboard manager. It stores all clipboard history
and offers an easy interface to do a full-text search on the items
of its history.
Autocutsel synchronizes the two copy/paste buffers mainly used by X
applications. It unifies "clipboards" between VNC servers and Windows.
The 'cutsel' binary performs the synchronization whenever it is run.
The 'autocutsel' binary performs the synchronization continuously. I
suggest running it from ~/.vnc/xstartup by adding a line like this at
the top:
exec autocutsel &
This is a character map. It is developed using the GNUstep development
environment (www.gnustep.org) and is meant to contribute to GNUstep's
promise towards a desktop environment.
Charmap offers font selection, allowing one to easily see all the glyphs
which a particular font offers.
LICENSE: GPL2 or later