Jailer

Database Subsetting and Relational Data Browsing Tool.
Alternatives To Jailer
Project NameStarsDownloadsRepos Using ThisPackages Using ThisMost Recent CommitTotal ReleasesLatest ReleaseOpen IssuesLicenseLanguage
Mongo Go Driver7,4343,58417 hours ago307September 06, 20227apache-2.0Go
The Official Golang driver for MongoDB
Jepsen6,174
665 days ago39June 07, 201955Clojure
A framework for distributed systems verification, with fault injection
Gpdb5,773
17 hours ago387apache-2.0C
Greenplum Database - Massively Parallel PostgreSQL for Analytics. An open-source massively parallel data platform for analytics, machine learning and AI.
Go Sqlmock5,217991a month ago21June 28, 202070otherGo
Sql mock driver for golang to test database interactions
Toydb4,894
3 months ago7apache-2.0Rust
Distributed SQL database in Rust, written as a learning project
Dockertest3,4962327238 days ago87May 25, 202218apache-2.0Go
Write better integration tests! Dockertest helps you boot up ephermal docker images for your Go tests with minimal work.
Test_db3,405
3 months ago2Shell
A sample MySQL database with an integrated test suite, used to test your applications and database servers
Nodejs Integration Tests Best Practices2,906
a month ago42JavaScript
✅ Beyond the basics of Node.js testing. Including a super-comprehensive best practices list and an example app (April 2022)
Aresdb2,329
3 years ago21apache-2.0Go
A GPU-powered real-time analytics storage and query engine.
Marten2,309315614 days ago185September 04, 202280mitC#
.NET Transactional Document DB and Event Store on PostgreSQL
Alternatives To Jailer
Select To Compare


Alternative Project Comparisons
Readme

Jailer Database Tool

Jailer is a tool for database subsetting and relational data browsing.

  • The Subsetter creates small slices from your database (consistent and referentially intact) as SQL (topologically sorted), DbUnit records or XML.

    Ideal for creating small samples of test data or for local problem analysis with relevant production data.

  • The Data Browser lets you navigate through your database following the relationships (foreign key-based or user-defined) between tables.

https://user-images.githubusercontent.com/861721/142761281-299bddc4-eea7-4f26-8c24-54fccb31b152.mp4

More Videos

Features

  • 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.
  • A demo database is included with which you can get a first impression without any configuration effort.

Supported Databases

Thanks to the JDBC technology used, any DMBS is in principle supported. For best results, specific additional support features are useful, however. These are available for:

  • PostgreSQL
  • Oracle
  • MySQL
  • MariaDB
  • Microsoft SQL Server
  • IBM Db2
  • SQLite
  • Sybase
  • Amazon Redshift
  • Firebird
  • Informix Dynamic Server
  • H2
  • Exasol

News

  • 2023-02-03 Thanks to deep analysis of statements, the SQL console can now relate the result of queries to the source tables and display them accordingly. In addition, this technique also allows filter conditions to be dynamically added to arbitrary SQL queries.
  • 2022-01-01 Comprehensive redesign and modernization of the entire user interface. New Look & Feel FlatLaf.
  • 2021-02-04 Cycles in parent-child relationships will be detected and broken. Thus, such data can be exported by deferring the insertion of nullable foreign keys.
  • 2020-02-04 The Jailer engine is published in Maven repository. https://mvnrepository.com/artifact/io.github.wisser/jailer-engine
  • 2019-02-01 The new "Model Migration Tool" allows you to easily find and edit the newly added associations if the data model has been extended after the last change to this extraction model.
  • 2018-04-26 The new feature "Analyze SQL" analyzes SQL statements and proposes association definitions. This allows to reverse-engineer the data model based on existing SQL queries.
  • 2018-03-06 SQL Console with code completion, syntax highlighting and database metadata visualization.
  • 2017-05-10 New API provides programmatic access to the data export and import functionality. https://wisser.github.io/Jailer/api.html
  • 2017-03-30 Improved filter management. Templates allows you to define rules for assigning filters to columns. Filters on primary key columns will automatically be propagated to the corresponding foreign key columns. https://wisser.github.io/Jailer/filters.html
  • 2015-12-04 Data can now also be exported directly to a schema of the same database. This ensures optimal performance.
  • 2015-10-23 Rows can alternatively be collected in a separate embedded database. This allows exporting data from read-only databases.
  • 2014-07-20 Implemented the "Subset by Example" feature: Use the Data Browser to collect all the rows to be extracted and let Jailer create a model for that subset. https://wisser.github.io/Jailer/subset-by-example.html
  • 2014-04-15 A Data Browser has been introduced. Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.

Installation

Use the installation file "Jailer-database-tools-n.n.n.msi" (for Windows) or "jailer-database-tools_n.n.n-x64.deb" (for Linux).

Unless you want to use your own Java installation. Then unzip the file "jailer_n.n.n.zip". See also https://wisser.github.io/Jailer/faq.html#multiuser

To start the tool from the unpacked zip:

  • On windows platform execute "Jailer.exe". You can also start "jailerGUI.bat".
  • On Unix/Linux platform execute the script "jailerGUI.sh" or use "java -jar jailer.jar"

Building

Clone the git repository:

  • git clone https://github.com/Wisser/Jailer.git

To build the tool you can just use ant: ( https://ant.apache.org )

  • cd Jailer
  • ant

Contact

Contributors

Code Contributors

This project exists thanks to all the people who contribute.

Financial Contributors

Become a financial contributor and help us sustain our community. [Contribute]

Individuals

Organizations

Support this project with your organization. Your logo will show up here with a link to your website. [Contribute]

Popular Database Projects
Popular Testing Projects
Popular Data Storage Categories
Related Searches

Get A Weekly Email With Trending Projects For These Categories
No Spam. Unsubscribe easily at any time.
Java
Database
Testing
Mysql
Postgresql
Sql
Gui
Oracle
Jdbc
Sql Server
Mssql
Redshift
Db2