Jailer - Database Subsetting and Browsing Tool

  •        423

Database Subsetting and Browsing Tool. Exports consistent, referentially intact row-sets from relational databases (JDBC). Removes data w/o violating integrity. Generates DbUnit datasets, hierarchically structured XML and topologically sorted SQL-DML.

  • Exports consistent and referentially intact row-sets from your productive database and imports the data into your development and test environment.
  • Improves database performance by removing and archiving obsolete data without violating integrity.
  • Generates topologically sorted SQL-DML, hierarchically structured XML and DbUnit datasets.
  • Data Browsing. Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.
  • SQL Console with code completion, syntax highlighting and database metadata visualization.

http://jailer.sourceforge.net
https://sourceforge.net/projects/jailer/
https://github.com/Wisser/Jailer

Tags
Implementation
License
Platform

   




Related Projects

MySQL-Front - A GUI front end for the MySQL and MariaDB database servers

  •    Pascal

MySQL-Front is a Windows front end program for the MySQL database server. The database structure and data can be handled via dialogs or SQL commands. Import and Export in standard file formats is supported. The database server can be connected directly or via HTTP tunneling.

pgAdmin - Administration and development platform for PostgreSQL

  •    C

pgAdmin is the most popular and feature rich administration and development platform for PostgreSQL. It is designed to answer the needs of all users, from writing simple SQL queries to developing complex databases. The graphical interface supports all PostgreSQL features and makes administration easy. The application also includes a syntax highlighting SQL editor, a server-side code editor, an SQL/batch/shell job scheduling agent, support for the Slony-I replication engine and much more.

Chive - MySQL Data Management tool

  •    PHP

Chive is a free, open source, web-based database management tool, designed to bring joy to web developers - with easy administration and super fast UI. It supports Repeated administration of your SQL queries by saving and re-execute them, Analyze and Optimize your queries with Profiling and lot more.

MySQL Workbench - Visual database design tool for MySQL

  •    C++

MySQL Workbench is a visual database design tool. The tool is specifically for designing MySQL database. MySQL Workbench provides DBAs and developers an integrated tools for Database Design & Modeling, Query browser, Database Administration.

PHPMyAdmin

  •    PHP

phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.


Sequel Pro - MySQL Database management for Mac

  •    PHP

Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL databases. It gives you direct access to your MySQL databases on local and remote server. It supports Full table management including indexes and MySQL Views.

Infobright - The Database for Analytics

  •    C++

Infobright combines a columnar database with our Knowledge Grid architecture to deliver a self-managing, self-tuning database optimized for analytics. Infobright eliminates the need to create indexes, partition data, or do any manual tuning to achieve fast response for queries and reports.

YourSqlDba

  •    

T-Sql Database script that automate database maintenance using SQL Agent an DB Mail. Performs optimizations (index, statistics), integritry check, databases backups (complete and tx logs).

iSQL-Viewer - JDBC compliant database front end

  •    Java

iSQL-Viewer is JDBC compliant database front end. It implements across multiple platforms features of the JDBC API. It does everything through a single interface. iSQL-Viewer works with most database platforms, including PostgreSQL, MySQL, Oracle, and Informix.

DBeaver - Universal SQL Manager and SQL Client

  •    Java

DBeaver is a multi-platform database tool for developers, SQL programmers, database administrators and analysts. It supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, Teradata, MongoDB, Cassandra, Redis, etc. Its feature include metadata editor, SQL editor, rich data editor, ERD, data export/import/migration, SQL execution plans, etc.

SIDU admin GUI : MySQL PostgreSQL SQLite

  •    

SIDU is a FREE database web GUI written in PHP. Handy and powerful for MySQL + PostgreSQL + SQLite + CUBRID. SIDU is simple and easy DB tool to use! SIDU has all features you need for database admin and web development. It's a great DB admin tool! No installation need. Best database front-end web based tools, cross platform looking no further

HyperSQL - Java Database

  •    Java

HyperSQL supports the widest range of SQL Standard features seen in any open source database engine. It offers a small, fast database engine which offers in-memory and disk-based tables and supports embedded and server modes. It is a relational database engine written in Java, with a JDBC driver, conforming to ANSI SQL:2008. It alsi supports transaction isolation, multiversion concurrency and ACID, Java stored procedures, Scalability and lot more.

VFront - User front-end for MySQL and PostgreSQL

  •    PHP

VFront is a open source front-end for MySQL or PostgreSQL databases. VFront is for non-expert users capable to work safely on data using an intuitive graphic interface. It exports data modules, statistics and report management based on xml, xsl and xsl-fo protocols.

FlameRobin - Database Administration Tool for Firebird

  •    C++

FlameRobin is lightweight cross platform database administration tool for Firebird RDBMS.

MapD - The MapD Core database

  •    C++

MapD Core is an in-memory, column store, SQL relational database that was designed from the ground up to run on GPUs. MapD Core is the foundational element of a larger data exploration platform that emphasizes speed at scale. By taking advantage of the parallel processing power of the hardware, MapD Core can query billions of rows in milliseconds. Furthermore, by using the graphics pipelines of GPUs, MapD Core can render graphics directly from the server.

LibreOffice - The Document foundation

  •    C

LibreOffice is the free power-packed Open Source personal productivity suite for Windows, Macintosh and Linux. LibreOffice is the perfect choice for home users, businesses, government and other organizations. It's native file format is the ISO standardized ODF (Open Document Format), but LibreOffice can open and save Microsoft Word, PowerPoint and Excel files, as well as many other formats, bringing you the widest-available compatibility with other products.

Liquibase - Source control for your Database

  •    Java

Liquibase is a database-independent library for tracking, managing and applying database schema changes. It s main functionality includes Database refactoring, Update database to current version, Versioned approach to maintain schema, Database diff report, Rollback database changes to particular date/time and lot more.

MySQL Control Center

  •    C++

MySQL Control Center is an excellent GUI front end for MySQL database creation and administration. It allows multiple concurrent MySQL server connections, MDI (or not under Linux), stored login credentials, point and click dump file imports and more.

phpMoAdmin - MongoDB administration tool for PHP

  •    PHP

phpMoAdmin is a MongoDB administration tool for PHP. It helps to create, drop and repair database and indexes. It provides support to view and search on data, Provides stats on database uptime and memory, Import/export data in JSON format.

Xoops - Web content management system in PHP

  •    PHP

XOOPS is an acronym of eXtensible Object Oriented Portal System. XOOPS is a web application platform written in PHP for the MySQL database. Its object orientation makes it an ideal tool for developing small or large community websites, intra company and corporate portals, weblogs and much more.