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).
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.
sqlmap is a penetration testing tool that automates the process of detecting and exploiting SQL injection flaws and taking over of database servers. It comes with a detection engine, many niche features, and a broad range of switches including database fingerprinting, data fetching from the database, and accessing the underlying file system and executing commands on the operating system via out-of-band connections.
Orabbix is a plugin designed to work with Zabbix Enterprise Monitor to provide multi-tiered monitoring and performance and availability reporting and measurement for Oracle Databases, along with server performance metrics. It provides an effective mechanism to acquire data from numerous Oracle instances, and in turn provides this information for monitoring and performance metrics to your Zabbix server. You can then utilise the reporting capabilities of Zabbix for all data collected, and provide analysis such as graphs and service level agreement metrics for stakeholders. The current distribution contains a set of pre-defined templates that incorporate alerting and graphing capabilities from initial deployment. However, these can be fine tuned to suit your needs and data/monitoring requirements.
BoneCP is a Java JDBC connection pool implementation that is tuned for high performance by minimizing lock contention to give greater throughput for your applications. It currently beats all known connection pools, including C3P0 and DBCP, as shown on the benchmark section on the site.
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.
Dominion v8 is a PHP universal database abstraction layer to develop rapid portable and compatible applications connecting to any freeware or commercial databases. You no longer need to write proprietary SQL sentences, but can use portable objects that give you the power to change the database engine without rewriting a single line of code.
SymmetricDS Pro is software for data replication, change data capture, and data transformation in a heterogeneous enterprise environment. Performance and scalability allow it to replicate thousands of databases asynchronously in near real time. With flexible configuration and powerful scripting and programming interfaces, it can be extended to meet a range of requirements. Based on the popular open source version of SymmetricDS, the Pro edition enhances the experience with a click-through installer, Web management console, and production support.