Jailer

Clicky: - GitHub: https://github.com/Wisser/Jailer - Official Docs: https://wisser.github.io/Jailer/

It's interesting to hear your perspective thanks. FYI there is no need to save before shutdown. I stole notepad++s excellent idea of autosaving regularly. Edit: Actually your description reminded me of jailer: https://github.com/Wisser/Jailer Does that do what you want?

I also found DBeaver to be a huge improvement over tools I used earlier. Recently I discovered Jailer which makes it very easy to navigate complex relational structures: https://github.com/Wisser/Jailer

If you have any problems with this tool, you can contact the developers. Either here (preferred): https://github.com/Wisser/Jailer/issues or here (no registration necessary): https://sourceforge.net/p/jailer/_list/tickets

Jailer[0] might be worth a look. From the project's website[1]: Jailer is a tool for database subsetting, schema and 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. [0] https://github.com/Wisser/Jailer [1] https://wisser.github.io/Jailer/

This is my passion project. The subsetter is certainly something for specialists, but the data browser is unique and very useful for many. https://github.com/Wisser/Jailer Feedback and ideas for improvement are very welcome.

This is my passion project. The subsetter is certainly something for specialists, but the data browser is unique and very useful for many. https://github.com/Wisser/Jailer Feedback and ideas for improvement are very welcome.

I have a very huge Postgres database that I need to clone locally (like 0.01 if its data) and do some tests. I have tried to use Jailer [0] (complicated to use. Like after installing it with the dpkg command, how do we launch it?) or Condenser [1] (intuitive but producing errors). Is there any other open source program to produce a small subset of the data available in a PostgreSQL? Like I like the fact that in Condenser you only tell the config file that you want 1% of the initial data and it does. [0]: https://github.com/Wisser/Jailer [1]: https://github.com/TonicAI/condenser

Jailer is a tool for database subsetting and relational data browsing. https://github.com/Wisser/Jailer 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 yo

I suspect you're looking for https://github.com/Wisser/Jailer . (I'd seen it before as well, couldn't remember the name immediately, and googled for `sql database subset relation export tool` to find it again.)