Jailer – Data Browsing | Hacker News Reader

Jailer – Data Browsing

wisser.github.io

117 pointsnerVios14 comments

Past comments:

[1] https://news.ycombinator.com/item?id=29939890

[2] https://news.ycombinator.com/item?id=27808653

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)

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.

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.

What databases does it support? What OS's? Documentation is anemic.

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?

Java doesn't immediately mean OS independent for what it's worth. Quite close, though.

You should always document this stuff.

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.

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.

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.

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.

Does it pick up implicitly defined relationships?

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

Yes, It detects foreign key based relationships automatically.

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

Reply on news.ycombinator.com