News for hackers. Stuff that matters.
Re:TablePlus – Modern, Native Tool for Database Management by jackschultz on Saturday April 18, 2020 @12:03PM (#22908599)
Don't know if the person who posted this has an affiliation, I do not, but I'm a huge fan of TablePlus so feel it's still worth it for me to comment about this.

It offers so many features that seem so natural. Quick editability which in some cases saves a ton of time. Tabs for different tables, plain text editing for queries with highlighting for ease of reading. There are other database interactors, that do the same thing, but really for me, I've found the UI/UX looks and feels so much better than others, and as a user, that really is a huge part of it.

As for the licensing price, I started by trying it out in the free, two tab version. I then stepped back and thought about how for me, the benefit it gave me was well worth $60.

Again, I have nothing to do with them, but for how nice it's been for me, I feel it deserves a shoutout.

Re:TablePlus – Modern, Native Tool for Database Management by jacurtis on Saturday April 18, 2020 @12:17PM (#22908711)
I've been using TablePlus for a long time now as well. I don't have any affiliation but started with their mac app. It was easily the best DB GUI out there. I like that you can use the same GUI for PostgreSQL, MYSQL, Redis, MongoDB, and SQLite (there are even more than this, but these are the ones I use).

It is awesome to have one very powerful and well-maintained program for all my database needs. I can get proficient at one tool and use it for everything. In addition, I can pay 1 licensing fee and get access to a powerful tool for working with all of these databases, instead of needing a separate tool for each one (which was the case in the past).

The pricing model is EXTREMELY FAIR in my opinion. First of all, it is free to use in its entirety forever, with only a small handful of limitations. New devs will easily be satisfied with the free version. You can upgrade to support them and to remove the few limitations in the free version for just $60. This is well worth any developer's time as it accounts for only an hour or two of their wages most likely. I also like that it is a perpetual license, so you don't need to "subscribe" if you don't want to. You do need to renew if you want newer versions, as the $60 license only covers 1 year of updates. But i think that this is a great balance between being fair (it is perpetual at the version + 12mos that you bought it at), while also incentivizing and allowing to support further development. Finally offering a generous free version supports newbies and the dev community.

Lastly I need to point out an often-overlooked reason to consider TablePlus. They offer tools on every platform (Mac, Windows, Linux). And MOST IMPORTANTLY, this isn't an electron application. Each version is maintained by a seperate team (from my understanding) within their business and it is built on the native language and frameworks for that platform.

About 1.5-2 years ago I started a discussion on their forum about bringing a version to Linux (at the time it was only Windows and Mac). The forum post quickly started gaining momentum from other Linux users who discussed how there is quite literally NO good DB GUI on Linux (other than the CLI). Let alone something as easy to use and powerful as TablePlus. The team eventually committed to a Linux version, and after a year of development updates I was invited to the beta and had been using it ever since.

This team really is great and I highly recommend trying their tool for free and upgrading to the paid version if you find it useful, which I think any developer will.

Re:TablePlus – Modern, Native Tool for Database Management by elamje on Saturday April 18, 2020 @05:32PM (#22911273)
That sounds impressive, if not unbelievable, they have 2 employees listed on their LinkedIn, and only 3 listed on their website. Maybe they are using offshore developers for a lot of the heavy lifting, but I honestly don’t see how they could have native apps for 3 platforms that have this much functionality with that many employees. Anyone else have insight?
Re:TablePlus – Modern, Native Tool for Database Management by nicoburns on Saturday April 18, 2020 @07:15PM (#22911923)
Why not? Two full time developers is plenty if you don't have the overhead of management processes, and everyone has a unified vision. Sublime Text was a one-man show until relatively recently. It's a single cross-platform codebase, but he built the cross-platform abstraction layer himself! Presumably this has the underlying database logic in some kind of shared library.
Re:TablePlus – Modern, Native Tool for Database Management by 40four on Saturday April 18, 2020 @08:54PM (#22912489)
The 3 native code bases are impressive. Early on it was very Mac centric, the Windows client used to lag way behind in features. The last time I checked, Windows had all the features I expected from the Mac version.

The new Linux client might be a good example of where the Windows client was a year/ year and a half ago. It works, but lacking a lot still. I’m confident they will continue to iterate and get it up to speed soon.

Big fan of Table Plus here. I like the ease of use and the clean UI. It’s everything you need, and nothing you don’t. Very smooth workflow.

Re:TablePlus – Modern, Native Tool for Database Management by wdb on Monday April 20, 2020 @03:07PM (#22927203)
In the end you only need to implement UI layer when the business logic is separated out. Not that the business logic on the different platforms can't be tricky but I think most time is spend on the native UI implementation. That's how I would go about it.

I am glad it's not Elektron. I am also using TablePlus and enjoying it a lot!

Re:TablePlus – Modern, Native Tool for Database Management by aembleton on Saturday April 18, 2020 @06:27PM (#22911644)
What does it give me that DBeaver doesn't? I use DBeaver daily for work but would consider paying for a better tool if I can see what is better about it.
Re:TablePlus – Modern, Native Tool for Database Management by aembleton on Saturday April 18, 2020 @06:48PM (#22911761)
I've just found the Linux alpha release (build 52) [1], and so I've installed it. This is just alpha and probably missing features, one being that it doesn't seem possible to connect to Oracle. MySQL was available so I tried connecting to a local instance of that that DBeaver connects to and it failed to connect.

There are some UI glitches, but it is alpha software. I do like the simple UI; DBeaver does feel very busy in comparison. I'll keep updating as it progresses through alpha and see how it improves.

1. https://tableplus.com/blog/2019/10/tableplus-linux-installat...

Re:TablePlus – Modern, Native Tool for Database Management by 40four on Saturday April 18, 2020 @09:08PM (#22912579)
DBeaver is my go to free option as well, but I am a big Table Plus fan as well.

The thing I think it gives you is a smooth, frictionless workflow. The UI is simple & uncluttered. Everything you need for the most common tasks is easy to find.

Re:TablePlus – Modern, Native Tool for Database Management by craigkilgo on Sunday April 19, 2020 @08:54AM (#22915579)
Totally agree. When I'm on Mac, I go with Sequel Pro, but on Linux DBeaver is unfortunately the best. It's not bad, its just way too cluttered. I am liking the direction Table Plus Linux is going.
Re:TablePlus – Modern, Native Tool for Database Management by 40four on Monday April 20, 2020 @04:51PM (#22928394)
DBeaver UI is definitely too busy, but I found that when I figured out where everything is, it's pretty nice. I bailed on Sequel Pro for Table Plus recently on my Mac because I needed to work on a version 8.x DB.

I bet the Linux TablePlus will be up to speed in features by the end of the year.

Re:TablePlus – Modern, Native Tool for Database Management by OOPMan on Sunday April 19, 2020 @10:46AM (#22916239)
No good DB UI on Linux?

You never heard of DataGrip then?

Re:TablePlus – Modern, Native Tool for Database Management by ohmaigad on Saturday April 18, 2020 @09:36PM (#22912729)
I have been testing the free version and there are a few things which i find annoying:

1. Importing large SQL files into DB is slow, SequelPro seems to be much faster;

2. No option to add/delete connection when you choose "Show connections";

3. Maybe it is a free limitation but almost every time i want to open a table it wants to create a new tab;

4. It doesn't want to reconnect to the server (even when cmd +r) if it lost connection - must close and open server again;

5. I have noticed that 2 different databases which are exact copies (structurally) have different column order so doing simple cmd + c in one DB and then cmd + v will mess up the data as the column order is different.

Re:TablePlus – Modern, Native Tool for Database Management by elbear on Sunday April 19, 2020 @02:20AM (#22913961)
I noticed their issue tracker is on GitHub: https://github.com/TablePlus/TablePlus

In case they're not watching this thread, I think they would appreciate your feedback.

Re:TablePlus – Modern, Native Tool for Database Management by aarbor989 on Monday April 20, 2020 @12:21AM (#22921068)
Back about a year and a half ago I was having some issues with the fuzzy search being laggy and submitted a feature request. The dev responded and had a beta for me to try out within a day or two. Overall it’s a great product. Definitely one of the best db clients out there. Only reason I stopped using recently is because my team got an all access IDEA license so I switched over to datagrip
Re:TablePlus – Modern, Native Tool for Database Management by te_chris on Saturday April 18, 2020 @12:04PM (#22908609)
Best thing about the editing is the staging mode, allowing you to preview a few changes then flush them at once.
Re:TablePlus – Modern, Native Tool for Database Management by sys_64738 on Saturday April 18, 2020 @12:38PM (#22908867)
It's a really nice app. The best of the bunch on the Mac IMO.