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.
RedBeanPHP is a zero-config, easy-to-use object database for PHP and an ORM tool. It works very simply. Just create bean objects and throw them at RedBean. RedBean will analyze your objects and infer a readable, comfortable data scheme from it and create all required tables and columns on the fly. RedBean is not schemaless, it makes neat tables and columns for you, but on the fly without any configuration.
HTSQL a high-level query language and Web service gateway for relational databases. It comes with source code and is royalty free for any use with open source database systems such as MySQL, PostgreSQL, SQLite, etc. Licenses for using HTSQL in conjunction with proprietary databases such as Microsoft SQL and Oracle can be purchased.
DBeaver is a universal database manager and SQL Client. It supports MySQL, PostgreSQL, Oracle, DB2, MSSQL, Sybase, Mimer, HSQLDB, SQLite, Derby, and any database that has a JDBC driver. It is a GUI program that allows you to view the structure of a database, execute SQL queries and scripts, browse and export table data, handle BLOB/CLOB values, modify database meta objects, etc. It has a native UI (provided by the Eclipse SWT library), great performance, and relatively low memory consumption.