News for hackers. Stuff that matters.
Re:Jailer – Data Browsing by aargh_aargh on Wednesday May 18, 2022 @07:06AM (#31421293)
Re:Jailer – Data Browsing by dang on Wednesday May 18, 2022 @02:14PM (#31425883)
Thanks! Macroexpanded:

Jailer: A tool for database subsetting, schema and data browsing - https://news.ycombinator.com/item?id=29939890 - Jan 2022 (14 comments)

Jailer: A truly relational database client - https://news.ycombinator.com/item?id=27811752 - July 2021 (2 comments)

Jailer: A truly relational database client - https://news.ycombinator.com/item?id=27808653 - July 2021 (17 comments)

Re:Jailer – Data Browsing by dang on Wednesday May 18, 2022 @02:43PM (#31426212)
Please don't use multiple accounts to promote your stuff on HN and definitely don't do voting rings. This is in both https://news.ycombinator.com/newsguidelines.html and https://news.ycombinator.com/newsfaq.html.

Note these from https://news.ycombinator.com/newsguidelines.html:

Please don't use HN primarily for promotion. It's ok to post your own stuff occasionally, but the primary use of the site should be for curiosity.

Don't solicit upvotes, comments, or submissions. Users should vote and comment when they run across something they personally find interesting—not for promotion.

Re:Jailer – Data Browsing by brookritz on Wednesday May 18, 2022 @08:25AM (#31421895)
Jailer is a great tool for navigating your database. You can basically click through tables by following foreign keys. You can just start somewhere on record and it shows you which records relate to the selected one and you can explore the data further. The GUI is really easycto use.

I've used it once for collecting some testdata from a huge database and thiz worked really well.

Re:Jailer – Data Browsing by FloayYerBoat on Wednesday May 18, 2022 @08:38AM (#31422008)
What databases does it support? What OS's? Documentation is anemic.
Re:Jailer – Data Browsing by nerVios on Wednesday May 18, 2022 @08:53AM (#31422123)
It's a Java application, so it's actually OS independent. Moreover, it is almost DMBS-independent thanks to JDBC technology. Why would you need to document that?
Re:Jailer – Data Browsing by junon on Wednesday May 18, 2022 @09:49AM (#31422740)
Java doesn't immediately mean OS independent for what it's worth. Quite close, though.

You should always document this stuff.

Re:Jailer – Data Browsing by easywood on Wednesday May 18, 2022 @10:45AM (#31423429)
I also wondered what databases this tools supported. Java or JDBC is not mentioned in a place I could find. A shame, really. I understand developers prefer development over documentation, but this is underselling it a bit.
Re:Jailer – Data Browsing by fipar on Wednesday May 18, 2022 @07:04AM (#31421277)
This looks interesting, but I don’t think the title uses the word Relational in the same sense that the Relational Model does. From the title, I was hoping to see a database with a relational (I.e., not SQL) language.
Re:Jailer – Data Browsing by samatman on Wednesday May 18, 2022 @11:08AM (#31423755)
It's an ambiguous parse, I read "A (truly relational) (database tool)" and you read "A (truly relational database) tool".

I happened to glean the author's intent, but it's a real ambiguity.

Re:Jailer – Data Browsing by exabrial on Wednesday May 18, 2022 @09:43AM (#31422658)
This is pretty danged cool. Downloaded, run the startup script and it fired right up. The moving arrow vis is a little corny, but the rest of what it's getting across is really neat. I doubt I'll replace SequelAce / TablePro with this tool, but when I'm trying to explain the schema to some newer users I will definitely break this out.
Re:Jailer – Data Browsing by justsomeuser on Wednesday May 18, 2022 @10:42AM (#31423393)
Does it pick up implicitly defined relationships?

E.g if I had some tables with string UUID foreign keys, would it suggest them?

Re:Jailer – Data Browsing by aredoubleyou on Wednesday May 18, 2022 @11:40AM (#31424130)
Yes, It detects foreign key based relationships automatically.
Re:Jailer – Data Browsing by justsomeuser on Wednesday May 18, 2022 @01:34PM (#31425427)
But without reading the SQL schema, based on table values only (E.g. there is no FK relationship in the schema, but the same UUID exists in two tables).