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.
StelsXML is a JDBC type 4 driver that allows you to perform SQL queries and other JDBC operations on XML files. It allows you to easily access data contained in XML documents using the standard SQL syntax and XPath expressions. The driver is completely platform-independent. It supports most keywords of ANSI SQL'92, XPath expressions for defining tables and columns, inner and outer table joins, aggregate, numeric, string, conversion, and user-defined SQL functions.
SYMPLiK XTRACT4J is a stand-alone, pure Java program that can create XML files from one or more dependent or independent SQL queries. A post-processing hook can be applied to this XML file, e.g. using Oracle BI Publisher RTF template to create professional PDF report with embedded barcodes. It was originally designed as a drop-in replacement for Oracle Report, with highly configurable and easy-to-use features.
lib4d_sql is a C library that provides the required functions (connect, prepare, execute, etc.) for writing an SQL client for 4D databases. It uses the public 4D SQL protocol, which is supported by 4D products since version 11. It is already used by the PDO_4D Open Source project, and it might be used to provide others drivers for JDBC, ADO, or ActiveRecord.
BlackRay is a relational database system designed to offer performance features commonly associated with search engines. It offers SQL support and sophisticated operational and management features. Load-balancing and operational stability by means of N+1 redundance are included. BlackRay is called a "Data Engine" since it combines traditional, relational database features and SQL with the power and flexibility of search engines. It is a true hybrid, offering transaction support, data-versioned snapshots, and sophisticated function-based indices. Wildcards, phonetic, and fuzzy logic searches are supported, as well. BlackRay supports a subset of the SQL92 standard and provides JDBC/ODBC/native driver options via the PostgreSQL protocol, in addition to an API based query option. The project is released under the GPLv2, with some drivers available under BSD-style licenses. Commercial support contracts are available as well.
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.
The Generic Repository (grepo) is a framework for Java which allows you to access (database) repositories in a generic and consistent manner. Using grepo, it is generally no longer required to provide all the boilerplate code which is necessary in order to access (database) repositories from Java. All you have to do is write appropriate database code (queries, procedures, functions, etc.), an appropriately annotated Java interface, and very little Spring configuration.