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.
once:radix is an integrated development environment (IDE) that operates entirely within a Web browser. once:radix supports two methods of connecting to the server. Most interest is focused on its Rich Internet Application (RIA) environment. This comes with a suite of five RIAs that perform specific roles: logging on or off, context-sensitive help, database administration, IDE, and client. In addition, the once:secureserver (oSS) can respond to commands from session-managed external Web servers.
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.
nf1db is an in memory database engine with SQL and JDBC interfaces. It supports transactions, commands from the SQL-2003 standard, all major data types, a number of functions, default and null values, auto-increments, constraints, primary and foreign keys, set operations, implicit and explicit joins, nested SELECT statements, quantity limits in SELECT statements, and much more.
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.