Jailer - Database Subsetting and Browsing Tool

  •        638

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

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.

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.

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.

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.


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.

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.

CloudBeaver - Cloud Database Manager

  •    Java

CloudBeaver is a free and open source web-based database management tool. It currently supports multiple databases: MariaDB, PestgreSQL, SQLite, Firebird, MySQL. It allows to manipulate with data like in a regular spreadsheet. It has complete features of all database management tools like Execute SQL queries, Navigate and observe database structure: schemas, tables, views indexes, View properties of database objects etc.

RedisDesktopManager - Cross-platform GUI management tool for Redis

  •    C++

Redis Desktop Manager (aka RDM) — is a fast Redis database management application. It works with Amazon ElastiCache, Microsoft Azure Redis Cache and Redis Labs. It provides basic operations like View keys as a tree, CRUD keys, Execute commands via shell, List connected clients, Pub/Sub channels and Slow log commands, Import data from RDB files, Copy data between databases and lot more.

Mongo Express - Web-based MongoDB admin interface, written with Node.js and express

  •    Javascript

mongo-express is a web-based MongoDB admin interface written with Node.js, Express and Bootstrap3. It has support to work with multiple database, GridFS support, Replication etc.

FlameRobin - Database Administration Tool for Firebird

  •    C++

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

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.

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.





We have large collection of open source products. Follow the tags from Tag Cloud >>


Open source products are scattered around the web. Please provide information about the open source projects you own / you use. Add Projects.