The goal of dzo is to treat application database objects the same way the application's source code is treated, with respect to development, revision control, and deployment. Dzo uses a text file that contains native create statements for all database objects and compares them against the actual database-schema. As a result, dzo creates the SQL statements needed to update the database schema (or you can let dzo execute the SQL statements directly). If your application lives in a Tomcat or Java EE application server, dzo has a servlet that controls the deployment process, inspects and executes the necessary database changes, and finally deploys the application. Dzo currently works with HSQLDB, MySQL, Oracle, PostgreSQL, and SQL Server (more to come).
Pyrseas provides a framework and utilities to upgrade and maintain a relational database. It currently includes the dbtoyaml utility to create a YAML description of a PostgreSQL database's tables, and the yamltodb utility to generate SQL statements to modify a database to match an input YAML specification. It also aims to develop data administration tools to supplement an agile database development process.
AsyncFP is a Scala project with composable actors that interoperate both synchronously and asynchronously. The current focus is on providing a kit for creating high-performance custom NoSQL databases. The small datastore currently under development is a crash-proof in-memory database supporting multiple queries or single update. Updates write to a backing disk file.
SynApp2 is a development tool that generates database-backed Web applications by processing your MySQL or Oracle schema definition and producing the Web pages used to manage your data. It does more than an admin tool or file manager by considering table relations as a cohesive whole that drives the generation of a complete application that smoothly integrates your entire database design, complete with PDF reports. It is open, compact, efficient, and compatible with the tools and technologies you’re using now.
The Easysoft ODBC-Access Driver is an ODBC driver that supports both the MDB (Access 2000–2003 and Office Access 2007) and ACCDB (Office Access 2007 and later) database formats. It provides read-write access to Access databases for Linux/Unix applications. You do not need to change where your database file is located, as it supports shared locations such as a Windows or Samba share. It uses Access’ locking file mechanism and prevents users from opening a database if another user has the database opened for exclusive access, again mirroring the Access front-end’s behavior for seamless integration. It supports encrypted/encoded .mdb files, which is an Access security feature that protects Access data from unauthorized viewing.
ObjectiveSync is a thin JDBC object persistence library. If features querying done in SQL, centralized object marshaling and unmarshaling where each object should know how to sync itself and its descendants, a single syntax for inserting and updating, Ruby-like objectivized JDBC fetching with exception handling, user-definable deep fetching and updating (almost Hibernate-like), batch API to avoid round-trips when submitting multiple queries, stats collection, and more.