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

Show HN: TablePlus – A macOS client for relational databases

medium.com

Post reply on HN
Print view View original

141–150 of 161 posts

Re: Show HN: TablePlus – A macOS client for relational databases

#142

Post by mmariani »

hungerstrike wrote: post #111
ble52 wrote: post #38

Love it! Please don't bother with people who don't care about proper native experience. I've been waiting for a tool like that for sooooo long and I'm really happy to see it. I love when developers use the platform to its full extent instead fighting with it (like Electron and all rest of cross-platform approaches) And for those whining about "macOS-only" - take a look at Tower, a Git client that was initially macOS-…

I'm happy with what I already have on Windows. I've never seen a better client than SQL Server Management Studio or SQL Server Data Tools and this tool doesn't look like it even comes close. Honestly, I've never seen a native macOS app that I thought was any good though. That's why I typically just use them to compile my stuff for iOS. If I have to use some program on a Mac, I hope it's got a somewhat familiar interf…

You could’ve taken about the same time to make a feature request in a nice way. Maybe you should quit the hungerstrike and eat a banana or something, you’re getting a little cranky.

Re: Show HN: TablePlus – A macOS client for relational databases

#143

Post by no_gravity »

rabidrat wrote: post #127
no_gravity wrote: post #82

I would like to stay in the terminal even when working on a DB. But I never found a decent terminal based DB client with a GUI (TUI?). So I am writing my own at the moment. A terminal based database editor. It's a bit like vim for databases. If you too are interested in such a thing, let me know.

Have you seen VisiData[0]? It supports Postgres and sqlite at the moment (read-only). Do you want more than simple editing of fields and deleting of rows? [0] http://visidata.org

Interesting. I will try it out. It seems somewhat heavy though with 191 files. Probably because it supports way more then what I need.

I have already implemented most of the functionality I need in a single file with just 395 lines of code.

Re: Show HN: TablePlus – A macOS client for relational databases

#144

Post by avdempsey »

This looks pretty sweet so far. I love having multiple panes, multiple tabs, and good shortcuts. When you click on a row it also appears in a vertical orientation in the sidebar on the right, that's a nice touch.

Today, I use mysql in the terminal most of the time. The main reason I've been using the terminal instead of SequelPro is my terminal has the scrollback available from my previous queries. This is great for comparing results, printing out a few table schemas to help write a query, and acting as kind of a log of my thought process. Terminal has a lot of other disadvantages, but I've accumulated a lot of tricks to mitigate them.

A nice implementation of tabs and panes could chip-away at that advantage, definitely, so this app is exciting. One limitation in the current implementation is it looks like table views need to take up the whole tab. It would be nice to have a table view in one pane, and a query editor in the next.

The app has a nice query history sidebar. In addition to the query, it has the timestamp; my terminal doesn't have that. Could this concept be expanded to include query results? My first instinct was also to try dragging and dropping one of the queries from my history into the desired pane. That didn't work, but its behavior of adding it to the pane where the cursor was last works well.

All in all, I think this will definitely find a regular place in my tool set; thank you for making something cool!

Re: Show HN: TablePlus – A macOS client for relational databases

#145

Post by Cyberdog »

I'll buy that this is a true native macOS app, but why does it seem to be trying so hard not to be? Why does everything have a flat white background, and why is the list of data not a standard Cocoa list view? It's still a bit too visually disruptive for my taste.

Re: Show HN: TablePlus – A macOS client for relational databases

#147

Post by rabidrat »

no_gravity wrote: post #143
rabidrat wrote: post #127

Earlier quoted context omitted.

Have you seen VisiData[0]? It supports Postgres and sqlite at the moment (read-only). Do you want more than simple editing of fields and deleting of rows? [0] http://visidata.org

Interesting. I will try it out. It seems somewhat heavy though with 191 files. Probably because it supports way more then what I need. I have already implemented most of the functionality I need in a single file with just 395 lines of code.

It has no dependencies other than Python3. Most of those files are documentation, tests, etc. But, everyone has their own taste when it comes to proper sizing for their tools.

Re: Show HN: TablePlus – A macOS client for relational databases

#148

Post by dancek »

turtlebits wrote: post #128
dancek wrote: post #122

I've been using DataGrip by JetBrains for a while now. I have no qualms with it, but the price would be an issue if I didn't have the full JetBrains pack already from my employer. What is the killer feature of TablePlus? Should I try it even though I'm happy with DataGrip? Or is it just as good for a lower price? https://www.jetbrains.com/datagrip/

DataGrip has one of the worst UI's (if not the worst) I've ever used. If you create a new database (not using Datagrip), it won't show up in until you go manually enable it to be shown. I ran into so many issues wondering why my created databases didn't show up. (while spamming the refresh button in the toolbar). And ended up spending extra time to verify that they were there Eventually figured out the setting is hid…

Is that the reason you consider it one of the worst UI's you've ever used? To be fair, the UI does tell you that it's showing e.g. "5 of 6" databases next to the connection name. If you click on that text, you get the same Manage Shown Schemas dialog.
Post reply on HN