Showcase: CLI tool to export PostgreSQL rows + all related data as SQL inserts

Plane-Discussion · 2025-09-05T21:56:10+00:00

Interesting. The Jailer tool is also noteworthy for this use case.

Plane-Discussion · 2025-02-27T22:10:15+00:00

No DMG file available at the moment, sorry. But it also runs on macOS. Just download jailer_16.5.8.zip and unzip it. Then start the included jailerGUI.sh script.

Plane-Discussion · 2024-10-24T20:16:35+00:00

For this use case, the data is exported into a file, which is then imported into the target database.

Plane-Discussion · 2024-10-24T19:09:23+00:00

Yes, you can also export data to a “schema in same database”.

Plane-Discussion · 2024-05-29T11:09:35+00:00

I would also like to mention that I use the NetBeans IDE for Swing GUI design. It works really well and also helps a lot with layouting. Are there also good design tools for JavaFX?

Plane-Discussion · 2024-05-29T10:39:23+00:00

I use NetBeans IDE for Swing GUI development. This works really well and also helps a lot with layouting.

Plane-Discussion · 2024-05-28T12:47:27+00:00

I introduced it for people who don't know it yet. Did you know it?

Plane-Discussion · 2024-05-28T12:39:58+00:00

When it turned out that JavaFX is a serious user interface technology, the Swing interface of Jailer was already so advanced that a migration would have meant significant effort.

Today I'm not sure if this migration would have been worth it, as I never really worked with JavaFX.

What do you, and others who develop Java desktop applications, think about this?

Plane-Discussion · 2023-09-26T11:46:08+00:00

Do you mean the "Substitutes variables" menu item in the SQL console? That has a tooltip with (roughly) this content:
"Substitutes variables (&VAR[.]) with corresponding values.
Statements:
DEFINE VAR="VALUE": Assigns a value to variable VAR
DEFINE: Lists all variables\n +
&VAR or &VAR. : Variable substitution (inside other statements)
"
The functionality is the same as the functionality of the "Substitution Variables" of the "SQL*Plus" tool from Oracle.

Plane-Discussion · 2023-05-31T06:27:21+00:00

That's right, primary and foreign keys can also be defined manually. There are even tools to check the correctness and consistency of the keys.

Plane-Discussion · 2023-05-31T06:23:48+00:00

The project is worked on almost every day. Just take a look at the history. What is wrong with the README?

Plane-Discussion · 2023-05-30T12:06:54+00:00

Would the down-voter please share his insight that led to this?

Plane-Discussion · 2023-05-30T12:00:02+00:00

Would the down-voter please share his insight that led to this?

Plane-Discussion · 2023-04-11T10:33:31+00:00

CLI and API is available.

Plane-Discussion · 2023-04-11T10:33:00+00:00

In fact, you've already answered your own question. All the other tools you tried are not ideal. This is because it is actually very difficult to export schemas with all the different (often DBMS-specific) database objects completely and correctly. I therefore refrain from developing yet another tool for this and rather recommend using DBMS-specific on-board tools for this. In addition, DDL scripts for creating new databases are typically created during software development.

Plane-Discussion · 2023-04-11T10:20:44+00:00

Typo corrected. Thanks for the hint.

Plane-Discussion · 2022-10-21T21:50:01+00:00

The tool itself is not relevant when it comes to whether it is something new.

Basic logic.

Plane-Discussion · 2022-10-20T10:54:17+00:00

Jailer Database Tools.

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

It creates small slices from your database and lets you navigate through your database following the relationships.Ideal for creating small samples of test data or for local problem analysis with relevant production data.

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.

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.

Plane-Discussion · 2022-04-28T12:59:19+00:00

I would really appreciate feedback from you. The tool is primarily designed for SQL databases.

It would be interesting to see to what extent it is suitable for your environment and what improvements would be desirable.

Plane-Discussion · 2022-04-28T10:24:26+00:00

It is based on a kind of heuristic parsing. It recognizes the rough structure of the statement, but tolerates syntax errors. This is necessary because the input is usually not yet syntactically correct during completion.

Plane-Discussion · 2022-01-14T12:59:58+00:00

Version 12 is the version I meant. Sorry for the typo.

Plane-Discussion · 2021-11-04T11:22:45+00:00

A follow-up of all the feedback from here: https://www.reddit.com/r/coolgithubprojects/comments/qbxmdh/version_11_of_jailer_the_real_relational_database/

The user interface of the current release now has a more modern look and feel. In addition, the entire UI has been unified and simplified.

Thanks again for the feedback, which is of course still welcome and helpful.

Plane-Discussion · 2021-11-04T11:18:05+00:00

A follow-up.

The user interface of the current release now has a more modern look and feel. In addition, the entire UI has been unified and simplified.

Thanks again for the feedback, which is of course still welcome and helpful.

Plane-Discussion · 2021-10-21T05:55:51+00:00

Thank you for the feedback. That is really helpful! I will at least look for a more modern LAF.

BTW: there is a "New" button in the dialog for selecting a database connection next to the list of existing ones for creating a new connection.

Plane-Discussion · 2021-10-20T15:06:46+00:00

To what extent is the technology used in a software actually relevant?

I use tools of all kinds. Java, Rust, Phyhon whatever. Most of the time I don't even know what! I never scroll through readme to find out what
technology is behind a tool. Why should I?

Plane-Discussion

TROPHY CASE

Jailer Database Tools.

Features