Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Jailer, a unique open-source database tool

github.com

Post reply on HN
Print view View original

21–30 of 30 posts

Re: Jailer, a unique open-source database tool

#21

Post by SOLAR_FIELDS »

jailertool2 wrote: post #4
_xnmw wrote: post #2

The browsing-through-relationships features looks very, very, cool. One-click "see related rows" would save me a ton of time every day, as I use TablePlus, where I often find myself manually copying foreign keys as I switch between related tables. Anyone know of any other apps that do this, as this is Windows only?

I'm glad you like it. It is not only available for Windows, but also for macOS/linux and others. (It is a Java application)

Is this supposed to be a generic drop in replacement for cross platform admin tools like Dbgate or Dbeaver? Or is it more of a specialized tool to do a specific thing?

Re: Jailer, a unique open-source database tool

#22

Post by mmsimanga »

babayega2 wrote: post #14

It 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

I just took a quick look at condenser application you linked. Only supports Postgresql and MySQL. This is often the case with none Java tools. They tend to support a select few number of databases. With tools that support JDBC you will be able to connect to most databases. That is often my challenge as someone who works in BI.

Re: Jailer, a unique open-source database tool

#23

Post by mmsimanga »

_xnmw wrote: post #2

The browsing-through-relationships features looks very, very, cool. One-click "see related rows" would save me a ton of time every day, as I use TablePlus, where I often find myself manually copying foreign keys as I switch between related tables. Anyone know of any other apps that do this, as this is Windows only?

+1. I work with data from different applications dumped into one database. Analytics. Often you cannot enforce foreign key relations and you need to define these relationships. Jailer allows you to define these relationships and then you can explore the data by following you defined relationships. This is so useful when working in analytics. I have never actually used jailer to subset but to explore data and to demo data to users. You can quickly find a piece of data by filtering on the field and then retrieve related rows in other tables. This is way faster than writing the SQL out.

Thank you to the author(s). Great underated tool that takes a bit of effort to understand.

Re: Jailer, a unique open-source database tool

#24

Post by jailertool2 »

exceptione wrote: post #20
jailertool2 wrote: post #17

Earlier quoted context omitted.

"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.

It operates on database dumps. That alone is absurd. Database dumps are not public interfaces. And they are really not suitable for mass data processing.

You have a DBMS available, but all you ask from it is a dump of all data in a format that can only be used as an archive or transfer format. And yet you think you can process this data reasonably?

Re: Jailer, a unique open-source database tool

#26

Post by exceptione »

jailertool2 wrote: post #24
exceptione wrote: post #20

Earlier quoted context omitted.

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.

It operates on database dumps. That alone is absurd. Database dumps are not public interfaces. And they are really not suitable for mass data processing. You have a DBMS available, but all you ask from it is a dump of all data in a format that can only be used as an archive or transfer format. And yet you think you can process this data reasonably?

> would you expect to be congratulated on your unusually high IQ?

I guess your "you" is not directed at me, as I basically wondered the same.

Replibyte seems like to use a highly unpractical way as I explained, but I meant to ask wether you only found the implementation to be bad, or that you also found it lacking in other terms.

Re: Jailer, a unique open-source database tool

#27

Post by pbowyer »

jailertool2 wrote: post #4
_xnmw wrote: post #2

The browsing-through-relationships features looks very, very, cool. One-click "see related rows" would save me a ton of time every day, as I use TablePlus, where I often find myself manually copying foreign keys as I switch between related tables. Anyone know of any other apps that do this, as this is Windows only?

I'm glad you like it. It is not only available for Windows, but also for macOS/linux and others. (It is a Java application)

Not being familiar with Java apps, can any reader tell me the best way to run this on macOS? From the CLI?

Re: Jailer, a unique open-source database tool

#28

Post by alflervag »

We’ve used this tool to subset a decent sized database (~1500 tables, mostly 5th normal form) with success. The UI is pretty good for exploring the database and getting a configuration up and running.

The resulting configuration is in plain text which makes it very easy to commit to source control and even batch edit.

Extracting data can be done on the command line without running the UI and is thus well suited for pipelines.

We had a few questions and the author was very friendly and helped us understand how to solve our issues.

Big +1 from me.

Re: Jailer, a unique open-source database tool

#30

Post by systems »

giancarlostoro wrote: post #19

For 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,…

you should check azure data studio, they have a plugin for few databases other then ms sql server

  * Postgresql
  * MySQL
  * Oracle
And maybe more
Post reply on HN