SQLCipher provides fully transparent encryption of SQLite databases. SQLCipher is a specialized build of the SQLite database that performs transparent and on-the-fly encryption. Using SQLCipher, an application uses the standard SQLite API to manipulate tables using SQL. Behind the scenes, the library silently manages security, making sure that data pages are encrypted and decrypted as they are written to and read from storage. SQLCipher relies on the peer-reviewed OpenSSL library for several encryption requirements, including the AES-256 algorithm, pseudo random number generation, and PBKDF2 key derivation.
GCstar is an application that can be used to manage collections of different types. Users can enter all the items they own, along with associated information and later perform searches using filtering criteria. A plugin system allows some information to be downloaded automatically from Internet sites. Collections can be exported to many formats, including HTML, XML, CSV, or Tellico file format, or imported from Ant Movie Catalog or Tellico, among others. It currently manages collections of movies, video games, books, music, numismatic, wines, board games, and lets users define their own types of collections.
PySQL aims to be a full replacement for sqlplus (and much more). It has features such as history, completion, and line editing. It has high level functions (searching for tables, indexes, count, explain plan, list of sessions, etc.), proper output for screen and files (CSV ready for inclusion in spreadsheets), support for user-defined SQL, background queries, graphical output for the schema data model, object dependencies, a PL/SQL package function call tree, and much more.
SMDB is a small, portable database library that exports an API similar that of GDBM and allows for the simple storage and retrieval of key/data couples. The library is totally system independent due to the use of externally supplied interface pointers. File locking is left to the caller, allowing single instance users to not pay the the price (in terms of performance and portability) of the locking framework. It supports transactions, multiple tables inside the same DB file, and is less than half the size of GDBM.
KeyAccess is a light-weight object-relational mapping (ORM) tool for Java, using existing databases as the starting point to generate a domain model. Its main goal is to reduce and sometimes eliminate manual updating between your domain object model and the underlying databases, while still being able to use arbitrarily complex SQL queries. In addition, KeyAccess doesn’t mandate a special architecture or framework – it will work in any application using JDBC.
The OpenDBX libraries provide a unified and consistent API for software developers to different database management systems. The C and C++ libraries aim to implement access to the native database interfaces efficiently via a thin abstraction layer. They consist of a basic set of functions that are part of all vendor database libraries and can be extended by additional function blocks. Currently, Firebird/Interbase, MS SQL Server, MySQL, ODBC, Oracle, PostgreSQL, SQLite 2 and 3, and Sybase ASE are supported.