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 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 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 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 @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).
[1] https://news.ycombinator.com/item?id=29939890
[2] https://news.ycombinator.com/item?id=27808653
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)
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.
I've used it once for collecting some testdata from a huge database and thiz worked really well.
You should always document this stuff.
I happened to glean the author's intent, but it's a real ambiguity.
E.g if I had some tables with string UUID foreign keys, would it suggest them?