Caché Monitor is an SQL development tool for InterSystems database Caché. It features an advanced SQL query editor with SQL syntax highlighting, SQL code completion with context sensitive information about database objects (also known as Intellisense), an SQL history buffer for executed SQL commands, SQL code formatting, parallel queries, graphical SQL execution plan with index and selectivity information, SQL abbreviations, and much more. Database diagrams graphically show the structure of the database.
mysql-diff is a commandline database structure comparator. It compares the structure of two databases. It currently works with MySQL. A database can be specified as an SQL script or as an URL to a running database. So the tool can compare two scripts, two live databases, or a database and a script. The tool outputs SQL DDL script that can be used to convert one schema to another.
Awake SQL is a virtual JDBC Driver and a framework that enables remote JDBC access through HTTP. It allows Android and Java desktop app developers to use regular JDBC calls to access remote SQL databases in the cloud. It implements the main data types including blobs/clobs, and supports transactions. Security has been taken into account from the design stage: server-side configuration lets admins specify strong authentication and security rules in order to protect the databases.
SqliteJdbcNG is a JDBC driver for SQLite. The overall goal of this project is to start a fresh implementation that leverages newly available technologies in the Java world. For example, any SQLite driver for any language must integrate with the native SQLite library. All of the current Java implementations rely on a custom JNI library to call out to the SQLite library. This extra layer can easily create a headache for the development and deployment of the driver, since it needs to be built for a variety of operating systems. Fortunately, there are technologies like Bridj and JNA that can be used to call native code directly from Java. By leaving the majority of the headaches of integrating with the native library to the Bridj project, more time can be spent on making a high quality driver that is more compliant with the JDBC4 spec.
StelsCSV is a JDBC driver that allows performing SQL statements and other JDBC operations upon text files (comma separated, tab-separated, fixed length, etc.). Using this driver, users can easily create a simple database consisting of plain text files. The driver can be used for writing data importing programs and migration tools. It supports most keywords of ANSI SQL92, table joins, INSERT, UPDATE, and DELETE statements, data types, aggregate, converting, string, and user-defined SQL functions.
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.
Midao JDBC simplifies development with Java JDBC. It is flexible, customizable, and simple/intuitive to use, and provides a lot of functionality: transactions, working with metadata, type handling, profiling, input/output processing/converting, pooled datasource libraries support, cached/lazy query execution, named parameters, multiple vendor support out of the box, custom exception handling, and overrides. With a single jar, it supports both JDBC 3.0 (Java 5) and JDBC 4.0 (Java 6). Midao JDBC is well tested. Not only does it have around 700 unit and functional tests, but it's also tested with the latest drivers of Derby, MySQL (MariaDB), PostgreSQL, Microsoft SQL, and Oracle. Midao is a data-centric project. Its goal is to shield Java developer from nuances of vendor implementation and standard boilerplate code. Midao JDBC is the first library released under it.