SymmetricDS provides file and database synchronization with support for multi-master replication, filtered synchronization, and transformation across the network in a heterogeneous environment. It supports multiple subscribers with one-direction or bi-directional, asynchronous data replication. It uses Web and database technologies to replicate data as a scheduled or near-realtime operation. The software has been designed to scale for a large number of nodes, work across low-bandwidth connections, and withstand periods of network outage. It works with most operating systems, file systems, and databases, including Oracle, MySQL, MariaDB, PostgreSQL, MS SQL Server (including Azure), IBM DB2, H2, HSQLDB, Derby, Firebird, Interbase, Informix, Greenplum, SQLite (including Android), Sybase ASE, and Sybase ASA (SQL Anywhere) databases.
Vibur DBCP is a new, concurrent JDBC connection pool based on Java dynamic proxies. It is fast, has concise source code, and supports a fairness parameter, statement caching, SQL query logging, and many other features. Various configuration examples (with Spring, Hibernate, etc.) are provided.
MyJSQLView provides an easy-to-use Java based GUI frontend for viewing, adding, editing, or deleting data in the HSQL, MSAccess, MySQL, Oracle, PostgreSQL, and SQLite databases. A query tool allows the building of complex SQL statements. The application allows easy sorting, searching, and import/export of table data. A plug-in framework allows inclusion of tools to profile and plot data for analysis.
LMDB is an ultra-fast, ultra-compact key-value data store developed by Symas for the OpenLDAP Project. It uses memory-mapped files, so it has the read performance of a pure in-memory database while still offering the persistence of standard disk-based databases, and is only limited to the size of the virtual address space (it is not limited to the size of physical RAM).
SchemaCrawler is a Java API which makes working with database metadata as easy as working with ordinary Java objects. It is also a database schema discovery and comprehension and schema documentation tool. You can search for database schema objects using regular expressions, output the schema and data in a readable text format, and find potential design issues with lint . The output is designed to be diff-ed against other database schemas. SchemaCrawler supports almost any database which has a JDBC driver, but for convenience is bundled with drivers for some commonly-used RDBMS systems. SchemaCrawler works with any operating system which supports Java.
The Logfile Navigator, lnav for short, is a curses-based tool for viewing and analyzing log files. The value added by lnav over text viewers or editors is that it takes advantage of any semantic information that can be gleaned from the log file, such as timestamps and log levels. Using this extra semantic information, lnav can do things like interleaving messages from different files, generate histograms of messages over time, and provide hotkeys for navigating through the file. These features are meant to allow the user to quickly and efficiently focus on problems.
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 from every used index in the plan, SQL abbreviations, and much more.