This was posted just yesterday by a user "jailertool". Did you make a new username just to repost?
Jailer, a unique open-source database tool
11–20 of 30 posts
Re: Jailer, a unique open-source database tool
#12Any support for remote server connections via SSH? My RDBMS instance is not exposed publicly, and is only accessible over SSH.
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
Re: Jailer, a unique open-source database tool
#13Any support for remote server connections via SSH? My RDBMS instance is not exposed publicly, and is only accessible over SSH.
Can you do SSH tunneling? That would be transparent to any other tooling.
Re: Jailer, a unique open-source database tool
#14It took them time. I had asked the same problem few months ago [0]. I needed a tool to subset a huge PostgreSQL db. The choices where Condenser [1] and this Jailer. Since I'm not a Java guy, I was struggling to know how to properly run this Jailer. I'm glad they released a .deb format. But I ended up using Condenser.
[0]: https://news.ycombinator.com/item?id=35975606 [1]: https://github.com/TonicAI/condenser
Re: Jailer, a unique open-source database tool
#15It took them time. I had asked the same problem few months ago [0]. I needed a tool to subset a huge PostgreSQL db. The choices where Condenser [1] and this Jailer. Since I'm not a Java guy, I was struggling to know how to properly run this Jailer. I'm glad they released a .deb format. But I ended up using Condenser. [0]: https://news.ycombinator.com/item?id=35975606 [1]: https://github.com/TonicAI/condenser
May I ask why you decided to use a condenser?
Re: Jailer, a unique open-source database tool
#16Replibyte also does this and supports anonymization: https://www.replibyte.com/docs/introduction
You might want to combine a subsetting tool with an anonymizing tool like this one:
Re: Jailer, a unique open-source database tool
#17Replibyte also does this and supports anonymization: https://www.replibyte.com/docs/introduction You might want to combine a subsetting tool with an anonymizing tool like this one: https://datanymizer.github.io/docs/
"Replibyte" is a toy. This thing operates seriously on database dumps - a text file full of "insert" statements (what DBMS often generates like this, but no guarantee)
Re: Jailer, a unique open-source database tool
#18It took them time. I had asked the same problem few months ago [0]. I needed a tool to subset a huge PostgreSQL db. The choices where Condenser [1] and this Jailer. Since I'm not a Java guy, I was struggling to know how to properly run this Jailer. I'm glad they released a .deb format. But I ended up using Condenser. [0]: https://news.ycombinator.com/item?id=35975606 [1]: https://github.com/TonicAI/condenser
Java is a huge plus over Python for me, namely type checking and ease of deployment.
I don't know either jailer or condenser, but I know that jailer@java has an unreasonable better change to have less bugs then condenser@python. Like you already noticed, condenser produces errors during run time.
Re: Jailer, a unique open-source database tool
#19For those wondering: Seems to be coded in Java and supports a decent number of SQL databases:
PostgreSQL
Oracle
MySQL
MariaDB
Mirosoft SQL Server
IBM Db2
SQLite
Sybase
Amazon Redshift
Firebird
Informix Dynamic Server
H2
Exasol
My only "negative feedback" since I dont have time to test it out so far is the name of the tool. Jailer does not imply database management to me. When I think of jailer I think of containers, I guess databases can be seen as container types.
Personally I have a JetBrains license so I usually just opt to use DataGrip (Which I have some minor gripes against) most of the time. Although a lot of the time I use HeidiSQL for MySQL / MariaDB since I got too used to it.
I will have to see if I have time to try this tool next.
Re: Jailer, a unique open-source database tool
#20Replibyte also does this and supports anonymization: https://www.replibyte.com/docs/introduction You might want to combine a subsetting tool with an anonymizing tool like this one: https://datanymizer.github.io/docs/
"Replibyte" is a toy. This thing operates seriously on database dumps - a text file full of "insert" statements (what DBMS often generates like this, but no guarantee)
Do you mean it is a toy because it only works on database dumps or..? I can imagine that querying, filtering and traversing relations will be harder with only a textual dump.