17 ms·

TablePlus – Modern, Native Tool for Database Management

562 points by bottle2 6y ago

deleted 6y ago
[deleted]
HHad3 6y ago
The application looks and feels nice, but the per-device pricing/licensing model seems severely outdated to me. I will not make a purchase unless named licenses, which enable me to use the application on all devices and operating systems I use (with reasonable limits if DRM is needed for some reason), are available.
- nerdbaggy 6y ago
  If you have 2 computers just buy 2 licenses?
  - Kudos 6y ago
    I don't condone pirating software, but this is the kind of licensing that makes me understand it to a degree.
    - jolmg 6y ago
      Right, it's not like their cost of production is proportional to the number of computers the software is used in. It's like trying to buy a vacuum cleaner and being charged per room you plan to use it in.
      - satyrnein 6y ago
        It's not proportional to number of users, either. Zero marginal costs mean pricing is always at least a little arbitrary.
        jolmg 6y ago
        > pricing is always at least a little arbitrary. Whatever both buyer and seller agree on. I think in general buyers can agree that, by the nature of software and the existence of the internet, if people share their bought software like they would any other object, then the seller risks not being able to make any profit at all. Since sharing software is copying software, there's no equivalent of "returning" what was borrowed. It's a compromise most buyers can understand. However, charging per machine of the same user seems to cross the line, no? Sellers are pushing, and I think it's valid here for buyers to push back. EDIT: Could we have the courtesy of including explanatory replies with downvotes? Simply downvoting seems like the equivalent of replying, "No. Shut up."
        Nullabillity 6y ago
        Yup. I'm starting to think that Kickstarter (and similar group-buys) is the only way to fund software that actually makes sense.
- Kudos 6y ago
  I asked them about that a year ago and they weren't interested in changing the model then.
  - heyoni 6y ago
    Go with data grip then. I’m pretty sure it can be installed on every machine. At least that’s what I do, and I see no reason to switch other than their lack of official support for non-relational databases. It’s otherwise solid software.
- surfsvammel 6y ago
  I totally agree. I have a license but would have liked to use it also on my workstation, not only my laptop.
- annoyingnoob 6y ago
  I tend to agree. I'm not sure about all devices but a license being install-able on somewhere between 2 to 5 devices seems reasonable. I'll be a paying customer but I need a little flexibility. I use more than one computer and some other devices - I don't need an SQL tool on all of them but definitely on more than one.
- oefrha 6y ago
  You can also get TablePlus though a Setapp[1] subscription. (Unfortunately Setapp is also licensed on a per device basis, but you get 2 Macs out of box and you could buy extra seats at $5/mo/seat.[2] I think named licenses are hard to offer because a lot of people abuse them by sharing with coworkers and friends.) Having used TablePlus for a couple months with both Postgres and SQLite, I only have positive things to say. [1] https://setapp.com/ https://setapp.com/ [2] https://setapp.com/news/setapp-launches-extra-seats https://setapp.com/news/setapp-launches-extra-seats
  - jfim 6y ago
    For Mac apps, one can simply bind the license to the user's name, with some allowance for edit distance (and a few automated name changes), which can solve the casual license sharing. Adding a "Licensed to John Smith" message during load time also helps with this.
- DevX101 6y ago
  This is an odd hill to die on. I'd bet 90%+ of engineers have a single computer they code from at home (even if you have multiple computers) and another at work. It's perfectly fair to pay for a separate license for each of those use cases. I'd prefer this to some $10/month SAAS model.
  - ineedtosleep 6y ago
    Disagreed. I have a MBP, a Linux desktop and a Thinkpad running both Linux and Windows. My one subscription to a Jetbrains product covers all of them provided I don't run the program at the same time across multiple machines. Believing that most engineers only have one computer IMO seems out of touch with reality.
    - brandonmenc 6y ago
      > My one subscription to a Jetbrains product covers all of them And also includes their database tool, DataGrip.
      - zo1 6y ago
        > And also includes their database tool, DataGrip. Which is awesome by itself. I use it regularly and only have minor issues with some of it's behavior, but the experience is worlds-ahead than what I've encountered previously at that price point.
      - Aeolun 6y ago
        DataGrip is quickly becoming unusable to me due to it’s inability to show me a tables/field encoding. I really have no clue how anyone thought that was an unnecessary feature.
        therealdrag0 6y ago
        Can you elaborate on what that is? I haven’t ran I to that before.
- thibaut_barrere 6y ago
  I do not find that model outdated at all. Actually a good bunch of apps I use have that model (e.g. Alfred App, Ableton Live...). Also, TablePlus seems to be selling well (at least from what I see around me), so I am not personally of the opinion that they should change their model!
  - fredoliveira 6y ago
    I'm confused. I have licenses for both Alfred and Ableton, and both of them run on all my devices just fine. Ableton in particular allows a limited number of authorizations, but handles my laptop and desktop.
- nerdbaggy 6y ago
  What is your opinion on a license that is for unlimited computers but can only be used by 1 computer at a time?
  - alexdumitru 6y ago
    That would be much better for me.
    - oefrha 6y ago
      If you’re a fan of always-online DRM. You must be a first...
      - nerdbaggy 6y ago
        A lot of them just are on the local network. Like Jetbrains software will throw a license error if both are on the same internal network, but will be fine if they are on separate networks.
        oefrha 6y ago
        Okay, that’s a much smaller concern.
- ramraj07 6y ago
  I moved my entire team to this program because of how simple (and reasonably hard to screw up) it is. It's also incidentally one of the cheapest non-buggy tools you can use to access redshift. Even if you buy multiple licenses it's cheaper than navicat et al. Also to note that their free version is still _very_ usable, I survived on that itself for many months spending hours in the tool.
- reaperducer 6y ago
  It's worse on the iOS version. It's a $3.99/month subscription. No thanks. I don't rent software.
- johne20 6y ago
  I am totally fine with the license model. I have been using TablePlus for over 2 years. When I first tried it I had a few questions/issues and the developer responded immediately and made changes based on feedback. (the email thread is 42 msgs :)). I have been using it daily for pg, mysql, occasionally for redis and sqllite, it works great and gets continuous improvements. I wish this company all the best, great product, great support.
- stephenr 6y ago
  I have a single license for TablePlus right now. I do have another machine, but it's effectively a "spare" / "travel" machine, so I don't use it a lot. If I happen to need TP next time I'm using that machine, the cost of adding another seat to the license is offset by some fraction of an hours billable work, and lasts for a year. What's always missing from these type of discussions is the consideration that just maybe, offering it as per-seat rather than per-person is why the price is what it is. Would you prefer it it was per-person but cost $99 for a licence, with a year of updates? Sure, that gives you the warm fuzzy feeling, and benefits anyone with > 2 machines, but it doubles the price for those who only need one seat under the current scheme. I'm lucky enough to be paid pretty well for my skills and experience, and I (or technically my company) can maintain some software and release it as open source. But I'm also very aware that high quality fully native developer tools are quite few and far between, and the number that are also cross platform is miniscule. There is significant competition from things built using "cross platform runtimes" (Electron, Java). So when one comes along that is as good as this, they could charge twice what they do and I'd pay happily - but not everyone can justify/afford that much on developer tools.
- skinnymuch 6y ago
  Like some others have said. Getting it via Setapp is great. The prices aren’t far from one another and Setapp offers other apps. Setapp has the device limitation too, but since it’s basically the same price, add a few more seats if needed. Setapp lets you use apps on as many devices as you want. But like streaming services these days, you can only have apps through Setapp actively running based on the seats you have. Though if you have say 2-3 seats for Setapp. And launch Setapp and some apps on a 4th comp. whichever comp has to get off Setapp to give space, you can usually keep apps open. Just can’t re-open them until a seat space is available again. M
deleted 6y ago
[deleted]
Cenk 6y ago
Previous discussion (333 points): https://news.ycombinator.com/item?id=16339004 https://news.ycombinator.com/item?id=16339004
- dang 6y ago
  That was 2018. Also 2019: https://news.ycombinator.com/item?id=19160808 https://news.ycombinator.com/item?id=19160808 And another 2018: https://news.ycombinator.com/item?id=18004727 https://news.ycombinator.com/item?id=18004727
dvfjsdhgfv 6y ago
I love the licensing model. No crappy "pay us for the privilege of using the software every month and year" like Adobe does. Just plain perpetual licence like Affinity. We need more projects like that.
- Kudos 6y ago
  Except it's licensed per computer and not per seat. I'm not sure what they're trying to achieve with it. I have two personal devices, not to mention dual booting Linux some of the time.
- cwhiz 6y ago
  Perpetual license but not perpetual updates. And you have to pay per device instead of per seat. I think the pricing is low enough to overcome these annoyances but I’d rather pay double and not have to be concerned with buying another license when I dual boot another OS.
  - jacurtis 6y ago
    I do agree, that it would be nice to pay per seat, not per computer. I develop on Mac 95% of the time, so I own a license on Mac, but on Windows I just use the free version because I don't use it on Windows enough to justify paying for it on that device, despite the fact I am a paying customer. This is an annoyance for me. However, I rarely run into any of the free-version limitations on Windows since I am usually just logging in quickly to check on something on Windows and not doing anything major. If I need to do some hardcore work I pull it up on my mac, which has a better dev environment. But it is extremely annoying the few times when I do go to open several tabs on WIndows and remember that despite being a paying customer, I can not use these paid features because I am using it on the wrong platform. I don't have a problem with the perpetual license that doesn't include perpetual updates. To me, if you are using the tool that often, you can support the team that builds something that you most likely make money off using. One year of updates for TablePlus is nearly equivalent to a month of updates from Adobe. At $60 a year we are talking about $5 a month. Which is very little to most developers, who purchase $6 coffees and $15 salads without batting an eye. But I would like to see a per-seat option. Especially because I most likely wouldn't/couldn't use two different computers at the same time, it seems fair to let me install it on a few OS's if I desire.
rkwz 6y ago
I've been using it for the past year and it's my go to app for managing PG databases. As much as I love SQL, TablePlus makes certain actions like inserts/updates/import really convenient especially when you're working with dev databases.
jackschultz 6y ago
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.
- te_chris 6y ago
  Best thing about the editing is the staging mode, allowing you to preview a few changes then flush them at once.
- jacurtis 6y ago
  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.
alexashka 6y ago
These products all do more or less the same thing. If Valentina Studio free version supports your DBs of choice, I've found it to suit my needs perfectly well - Postgres user here. Oh, did I mention it's free? These products should have a mandatory feature comparison chart to their competition - it'd speed up the inevitable decline of mediocre competition that relies on gaming google search results for its survival. I back in the day had to download and suffer through half a dozen DB clients that do the same thing slightly differently.
- deleted 6y ago
  [deleted]
Thristle 6y ago
I like tableplus a lot and used it mainly as a redis GUI (we have a querious license at work so i use that for sql). I did encounter some wierd things around version 290 it seems that when you use a filter (which is called "advanced filter" not sure why) on a mac everything works but the same filtering action was blocked for the free version on my windows machine. some versions later it was also blocked on my mac but i cant seem to find any way to filter redis keys at all. other than that i really like everything else
timothevs 6y ago
Has anyone compared this to Navicat? Our non profit has a non commercial license for Navicat Premium, and I just love the product (despite more than a few quirks).
ganomi 6y ago
Free alternative i have been using for some years now: https://dbeaver.io/ https://dbeaver.io/ The community edition is updated more often than i would like and sometimes features break but bugs get fixed quickly and they add usefull stuff all the time. Dont know what i would do if i was stuck with pgAdmin...
- wenc 6y ago
  DBeaver is great for MySQL databases. HeidiSQL is another good one for MySQL databases. pgAdmin is not good.
- tbrock 6y ago
  1990s Java swing clunky UI... would rather use CLI IMHO.
  - pyr0hu 6y ago
    That literally the name of the animal
  - sjbr 6y ago
    it's not swing, it's SWT that is why it has the native look
    - ken 6y ago
      It may be a reliable and useful application, but it definitely does not have anything close to a "native look".
- anhthang 6y ago
  I like SequelPro. The UI much simpler, powerful, but it's inactivated, nobody working on it to update for new macOS :(
  - HatchedLake721 6y ago
    Which is a big shame. I'm happy to $$$ pay for Sequel Pro, but it's been abandoned for 1-2 years now?
planetjones 6y ago
Been using the open source dbeaver for a while now. On the whole very impressed with it, so worth a look as a free alternative.
- supernintendo 6y ago
  +1 for DBeaver. It doesn’t have a pretty UI like TablePlus but it’s FOSS, cross platform and has all of the same features (maybe more).
- detaro 6y ago
  > Advanced cryptography algorithms for SSL/SSH connections. as a feature limited to the enterprise version sounds kind of scary.
- thecrumb 6y ago
  I looked at TablePlus but the formatter was horrible. DBeaver internal formatter is decent and if I want more I can use an external tool.
- wackget 6y ago
  Does the code completion/autocomplete in dbeaver support "fuzzy typing" like in Sublime Text? For example, if you have a table called "catalog_product_flat", would the autocomplete suggest that table when you typed "catprfl"?
  - zmmmmm 6y ago
    Just tried that and it did autocomplete, for example 'dal' to 'django_admin_log'. It did not auto-suggest it while typing, but when I pressed control-space it expanded it.
- zmmmmm 6y ago
  Agreed. The only thing it probably doesn't satisfy here is lightweight (being built on Eclipse). But actually one of the things that keeps me with it is that being built on Eclipse I can use a whole bunch of Eclipse plugins that have have from that environment and they work great.
whoisjuan 6y ago
TablePlus is awesome! I got it through Setapp and it completely any need I had for SequelPro which I feel got shittier in the last couple of years (no new features and it feels super laggy nowadays).
tbrock 6y ago
Anyone know what this is built in/with? C++ & GTK?
- sys_64738 6y ago
  It's a native GUI on the Mac.
- megavolcano 6y ago
  from the website: > TablePlus is a native application. We are using Swift, Objective-C, C/C++, Perl for OSX, C# for Windows.
- armadsen 6y ago
  I can confirm with a very little spelunking that the Mac app is a real native AppKit/Cocoa app. It appears to mostly be written in Swift, but also uses a fair amount of Objective-C. They've said publicly that the Windows version is written in C# and C/C++. Not sure what they did for Linux...
wenc 6y ago
I work with SQL Server. I really like general multi-db GUI tools like this, but also wonder if one is giving up a lot of power. SQL Server's free native tool is SSMS (SQL Server Management Studio), which is one of the most powerful SQL clients I've ever used. (despite my carryover reservations with MS products from the 1980s-90s, SQL Server is indisputably an innovative and solid piece of technology -- MS did something right with their database group). One can interact syntactically with the database via pure SQL, but SSMS lets you access the deep corners of the database quickly via a GUI (SQL is a great query language, but many admin/ops tasks are much more easily done via a GUI -- writing SQL every time you want make a simple change is tedious plus nobody remembers the syntax for infrequently used features). Some of the features I use regularly: row/column/covering index creation, linked servers, user management, live query plans, create/alter script generation from existing objects (stored proc, view, index, table, etc.). I've never seen these features exposed in any third party SQL GUI client. Postgres has a bunch of very powerful features too, and I've never seen these exposed in GUI tools. Jetbrains' DataGrip comes the closest, but because it needs to support lowest common denominator features across databases, it doesn't expose deep features either. I wonder if folks are giving up deep feature discovery by using an generic GUI SQL client. Exception: Oracle SQL Developer. It's native to Oracle but is quite unpleasant to use.
- oefrha 6y ago
  Edit: read the parent wrong, but leaving my comment here so it doesn’t look like backtracking some offensive content. > wonder if one is giving up a lot of power. That’s an irrational concern. GUI tools also come with SQL consoles where you can do anything that’s possible in the CLI. With the added benefit of results being presented in a nicer way.
  - wenc 6y ago
    > That’s an irrational concern. Is it though? So for SQL Server, you can't really see the live query plan (real-time plan + statistics while the query is running) without the GUI. You cannot see the Activity Monitor without the GUI. There are elements that cannot be accessed via pure SQL. 3rd party GUIs generally don't support these features.
azranoman 6y ago
what is iq option? how to use https://coinmarket01.blogspot.com/2020/04/what-is-iq-option-how-to-use.html https://coinmarket01.blogspot.com/2020/04/what-is-iq-option-...
sergiotapia 6y ago
Been using this for a 8 months now, I really enjoy it. It's polished, and has a format sql query feature that is useful for that final step once you have your query down to what you want it. Very nice stuff.
memco 6y ago
I like TablePlus and have bought licenses for my work computers. It’s got a lot features, but is still rough around the edges in some spots: Mongo is technically supported but the viewing and editing experience isn’t great for nested object. The SSH support seems wonky: I can’t get it to work with my ssh config which uses proxyjunp to connect. I have to setup the tunnel using -L in my terminal and use the local port in TP. I know it’s supposed to be able to use the proxy jump configs but it has just never worked for me.
- mekster 6y ago
  I have a jump host and it works by reading ~/.ssh/config and works fine. You might want to report it on GitHub as they seemed quite responsive the last time I reported an issue.
petilon 6y ago
Looks like almost the same feature set as SQLPal: http://www.pebblereports.com/sqlpal/ http://www.pebblereports.com/sqlpal/ However, SQLPal only supports Oracle.
MrOxiMoron 6y ago
I love TablePlus. Definitely worth it's money for me.
jonnycomputer 6y ago
I have been looking for a native app alternative to pgAdmin ever since they changed it over to a browser based application. I will have to check this out. Actually, if people have suggestions, I'll listen!
- gerry_shaw 6y ago
  Postico
- amartya916 6y ago
  I have used both Postico and Tableplus extensively, and if you are sure that you are going to be working with Postgres only, its the better, more Mac-like app. However, both are a serious upgrade over PgAdmin :)
- listenallyall 6y ago
  DBVisualizer
- yyx 6y ago
  Valentina Studio
btcnews 6y ago
Killer news Bitcoin vs Ethereum https://coinmarket01.blogspot.com/2020/04/bitcoin-vs-ethereum.html?m=1 https://coinmarket01.blogspot.com/2020/04/bitcoin-vs-ethereu...
jasonpbecker 6y ago
I’ve been using this as a part of my Setapp subscription and loving it. It’s the only tool that has replaced DBeaver (which is still more powerful, but I hate the interface).
sinnet11 6y ago
"Supports a whole set of relational databases" Includes MongoDB in the list.
- megavolcano 6y ago
  and redis lol
ryanmarsh 6y ago
No mention of DynamoDB or Cosmos. Why can’t these DB’s get some love from tool vendors?
- ufmace 6y ago
  I use both TablePlus and DynamoDB at work. I don't see any reason to bother trying to put DynamoDB support into TablePlus. DynamoDB is great at its one killer feature of supporting arbitrarily huge tables without you having to worry about any details. For everything else, it's just kind of adequate, considering the constraint of needing to support multi-Terabyte tables. It lacks a huge number of features that all RDBMSes have that would admittedly be impossible or not make sense on huge tables. Thus, it doesn't make much sense to try to access it from a RDBMS GUI. The AWS Console provides all of the GUI that really makes sense for it, plus the CLI tools and API.
- kkrbalam 6y ago
  dbeaver supports dynamoDB, and it is an awesome product free of cost.
computerman1337 6y ago
How does this compare to Datagrip / IntelliJ IDEA for databases in terms of functionality? I’ve been using IntelliJ for relational databases and I am very pleased with it.
- 0x49d1 6y ago
  Hmm, I'm in the same situation: how reliable is the company behind it, can I trust their expertise?..
- mekster 6y ago
  It is far easier to work than DataGrip. I used DataGrip after SequelPro stopped updating to support MySQL 8 and apparently it's feature rich but got annoyed how it's bloated and takes half a minute to launch. I still prefer SequelPro for it's layout and UI but finally dropped it in favor of TablePlus as now it seems close enough to that usability. Also of note is that the author is really responsive and friendly on GitHub who corrected some minor UI issues pretty quickly when I reported.
geniium 6y ago
Looks nice. Is there any plan to support Apache CouchDB ?
caseyf7 6y ago
Postico is a nice Mac alternative but is focused on Postgres DBs like Redshift.
- jops 6y ago
  I've been using Postico for years. High quality software.
- augstein 6y ago
  Been using it since its first stable release, absolutely reliable and easy to work with. Version 2, which should be released soon, is even nicer. https://eggerapps.at/postico/ https://eggerapps.at/postico/
  - elAhmo 6y ago
    Version 2 is lovely, I have been using it in beta and it seems quite stable, looking forward to the final release.
hackerm0nkey 6y ago
> After 1 year, you can continue using TablePlus without any limitations but you can't upgrade to the latest version. If you want to upgrade, you must renew the license, the renewal fee is much cheaper than buying a new one. This sort of put me off. Personally I am fine with a single user perpetual license for my use case. But as they are claiming it being a young project and likely to have more bugs than your average mature product. Why do you expect me to renew my license to get your updates ? doesn't seem fair. > TablePlus is a young project, we fix bugs and add new features every day, then put them together in a new update released at the end of week/month. That week/month could fall a year after the date of my initial purchase :(
- eugeniub 6y ago
  TablePlus for 2 Macs with 12 months of updates: $99 SetApp subscription for 2 Macs (includes TablePlus): $108/year
  - hackerm0nkey 6y ago
    Interesting, didn't know about SetApp before, thanks. I wonder how they manage around DRM rights with the individual app publisher?
    - filmgirlcw 6y ago
      They make agreements with the publishers and SetApp delivers the app updates (usually the same day as the regular app updates are released). SetApp lets you have a certain number of “active” machines. My account (which I got whenever it launched) let’s me have 5 machines but the standard plan might be 2, I’m unsure. Any annual upgrade terms don’t apply, your access is predicated on having a SetApp subscription. So for an app like Ulysses, I don’t have to pay the annual IAP or subscription (the Ulysses subscription extends to iOS too fwiw although other apps like Screens still have their own separate iOS apps, which makes sense). I actually discovered TablesPlus thorough SetApp and liked it enough to buy the Windows version for the times I use Windows. There are a number of apps in SetApp I’ve already paid for, but talking to a friend who is a SetApp author, if I install the SetApp version, that actually helps him get paid more so when I do have overlap, I install the SetApp version. (My friend makes decent money off of SetApp which made me feel a lot better about the whole thing and feel comfortable it wasn’t predatory towards indie app makers).
z3t4 6y ago
Thats one scary select statement in the screenshot.
crazygringo 6y ago
Curious if anyone knows how it stacks up against Sequel Pro? (At least if you only need to work with MySQL, obviously?)
- thibaut_barrere 6y ago
  Well, it is maintained! My understanding is that SequelPro hasn't seen any release since 2016 (at least based on https://github.com/sequelpro/sequelpro/releases https://github.com/sequelpro/sequelpro/releases).
S3raph 6y ago
is this similar to DBeaver?
pvtmert 6y ago
I saw TablePlus first time again in HN, (circa 2016) since then it is go-to tool for databases. Many DB connection UI's (except MySQL Workbench and Sequel Pro I think) requires some kind of purchase. Besides My company uses Sequel Pro it always had either crashed or having slow import/export speeds etc. Even TablePlus can import/export between engines using CSV files, which is IMHO awesome option to have.
- mekster 6y ago
  SequelPro served me for years and I loved it but since it no longer is being actively maintained (I know about nightlies but it's buggy with constant crashes and such, so it doesn't count.) to support MySQL 8, I'm glad TablePlus mostly caught up on the usability to SequelPro for me to have a unified tool for all DB needs.
nojvek 6y ago
I like how TablePlus makes a yearly post. It is relevant for HN users and will deliver them nice sales but I wonder what is the policy for pasting same urls. In product hunt I see same products arriving again with version #2 e.t.c I know VSCode and Typescript announce their new versions here too. May be the official policy is "it doesn't matter, unless too spammy?"
deleted 6y ago
[deleted]
pencilcode 6y ago
I use sqlpro and just tried this, thinking that maybe table plus is better, their history feature is much better imho.
blobster 6y ago
I love it because it's the only Mac app that allows you to connect to a remote Mysql server via ssh and Unix socket at the same time.
seemslegit 6y ago
When/Why should someone pick it over dbeaver ?
Roritharr 6y ago
After testing this for 30 minutes it made me actually Donate money to the HeidiSQL project, as it fits my workflow MUCH better. It has a couple of annoying bugs but it's feature set develops in general much more along my actual needs. The Redis implementation of TablePlus is rather worthless to me compared to what Redis Desktop Manager does as it doesn't sensibly group keys, it doesn't give me much information about the relevant redis metrics (memory usage especially). Over in the MySQL side of things of TablePlus I like the way it structures its filters and the way I can actually copy a column of values in sensible formats, but besides these two features i'm much happier with HeidiSQL, so that's where I put my money.
- kevmo314 6y ago
  Have you gotten HeidiSQL to work well with PostgresQL? I really like it back when I used MySQL, but it's absolutely rife with bugs in its PostgresQL adapter with constant crashes and invalid queries being generated. It's so bad that it makes me wonder if I just have something misconfigured instead of it being an application bug.
  - Roritharr 6y ago
    I only use the PostgreSQL adapter only for a very simple database, so I can't comment on it.
exabrial 6y ago
For those of you who miss SequelPro before it was abandoned, this is a worthy successor. I bought licenses for my whole team.
- jdpedrie 6y ago
  Indeed. I just went searching for a SequelPro replacement yesterday and found Table Plus. Tried it for an hour and bought a license.
wackget 6y ago
Does the code completion/autocomplete in this program support "fuzzy typing" like in Sublime Text? For example, if you have a table called "catalog_product_flat", would this program's autocomplete suggest that table when you typed "catprfl"? That's one feature I find is missing from every single DBA program out there except for DataGrip, which I don't like because it's overkill.
- nickforall 6y ago
  Yeah, it tries to do that but is not always very good at it. For example with aliases in join and subqueries it struggles sometimes and it doesn't show up.
Nevada-Smith 6y ago
This program won't install on Windows 7 because it requires .NET Framework version 4.8, which won't install on Windows 7, because Micro$oft doesn't support it any longer. Given this, you'd think TablePlus would explicitly mention this before putting Windows 7 users through this unnecessary waste of time.
- rubber_duck 6y ago
  Should probably mention it doesn't work on Windows 95 either.
  - adventured 6y ago
    Windows 7 end of life began in January 2020. Around a quarter of all PCs are still running it. Remind me again what the EOL for Windows 95 was. "Even today, millions of PCs are still running Windows 7, and the operating system still runs on a massive 26 percent of all PCs according to data from Netmarketshare." https://www.theverge.com/2020/1/14/21065122/microsoft-windows-7-end-of-support-lifecycle-millions-pcs https://www.theverge.com/2020/1/14/21065122/microsoft-window...
    - rubber_duck 6y ago
      That's EOL, it's been deprecated since 2015, if you're a developer using it and can't see why people can't bother supporting it I don't know what to say other than should we support XP since random PCs in China still run it ?
      - paulryanrogers 6y ago
        Windows 7 is still widely deployed in western markets which TablePlus appears geared toward. So it's a reasonable call-out IMO.
- ricardobeat 6y ago
  Why would they support a dead OS? Windows 7 is months past end-of-life, receiving no security patches and hence unsafe to use. And by the way they actually explicit mention it on the homepage - it says .NET 4.8 right under the download button.
dotmanish 6y ago
Coincidentally, I discovered TablePlus in Setapp today while searching for a macOS MySQL client. Has been a smooth experience in the first few hours, and a better looking interface that other clients that I have tried in the past. As another comment mentions, support for Linux is a big plus - we need better GUIs in there.
megavolcano 6y ago
gave it a trial install, and one thing I noticed right away is that memory usage shoots up and responsiveness slows to a crawl when working with medium-ish tables (hundreds of thousands of rows) if you happen to run a select and forget to limit your query, it slows to a crawl datagrip paginates results in batches of 500 by default, which helps with not accidentally making the interface implode on itself
paulryanrogers 6y ago
These GUIs are great though I find no substitute for learning the CLIs. With a CLI one can work on remote systems and quickly automate one off tasks.
- _el 6y ago
  Ditto. I'm one of the few at my company who uses the CLI. It's so much quicker and intuitive for me.
tumidpandora 6y ago
DBeaver is hands down the best client for any and all databases, plus it’s free.
dikaio 6y ago
Use it, love it. All it needs is a Data Modeler and it would be complete.
deleted 6y ago
[deleted]
soheil 6y ago
Sequel Pro's pros: - Sequel Pro's UI is much simpler - it's been around for over a decade - Sequel Pro can import/export large DBs much quicker - works on OSX - less bloated by not having to support 10+ different db types Genuine question: when did Redis become a relation db?
- s_dev 6y ago
  Table Plus works on macOS. I disagree about the UI. Table Plus when connecting to a DB will mark the offending parameter red to let you know what credential isn't right e.g. host/port/key I've found this very helpful. Sequel Pro is free which you didn't mention and Table Plus has a fee.
russianbandit 6y ago
Anyone know if they plan to support Presto?
mikl 6y ago
I’ve been using TablePlus for a while, its nice to have because it supports all the databases I use with no fuss, replaced a bunch of separate apps for Redis/PostgreSQL/MySQL/Cassandra. Also comes as part of the deal if you have a Setapp subscription (https://setapp.com/ https://setapp.com/ ) (And just to be clear, I’m not affilated with either company.)
SeriousM 6y ago
I like the fact that it has a reasonable price without the subscription bullshit. Like linkpad, pay money and own the product without having to pay for every single month. That's how software should be sold, like the good old days.
978e4721a 6y ago
Where's Linux version? Does editor has vi bindings? People should stop building database IDE without vi bindings.
978e4721a 6y ago
Hands up if you use cli and format SQL with python-sql-format/README.md at master · longgb246/python-sql-format https://github.com/longgb246/python-sql-format/blob/master/README.md https://github.com/longgb246/python-sql-format/blob/master/R...
lpil 6y ago
Just gave it a test with WSL2 on Windows, doesn't seem to work with that setup. A shame
- ewenjo 6y ago
  Just tried the same, worked fine for me.

562 points by bottle2 6y ago

deleted 6y ago

[deleted]

The application looks and feels nice, but the per-device pricing/licensing model seems severely outdated to me. I will not make a purchase unless named licenses, which enable me to use the application on all devices and operating systems I use (with reasonable limits if DRM is needed for some reason), are available.

nerdbaggy 6y ago
If you have 2 computers just buy 2 licenses?
- Kudos 6y ago
  I don't condone pirating software, but this is the kind of licensing that makes me understand it to a degree.
  - jolmg 6y ago
    Right, it's not like their cost of production is proportional to the number of computers the software is used in. It's like trying to buy a vacuum cleaner and being charged per room you plan to use it in.
    - satyrnein 6y ago
      It's not proportional to number of users, either. Zero marginal costs mean pricing is always at least a little arbitrary.
      - jolmg 6y ago
        > pricing is always at least a little arbitrary. Whatever both buyer and seller agree on. I think in general buyers can agree that, by the nature of software and the existence of the internet, if people share their bought software like they would any other object, then the seller risks not being able to make any profit at all. Since sharing software is copying software, there's no equivalent of "returning" what was borrowed. It's a compromise most buyers can understand. However, charging per machine of the same user seems to cross the line, no? Sellers are pushing, and I think it's valid here for buyers to push back. EDIT: Could we have the courtesy of including explanatory replies with downvotes? Simply downvoting seems like the equivalent of replying, "No. Shut up."
      - Nullabillity 6y ago
        Yup. I'm starting to think that Kickstarter (and similar group-buys) is the only way to fund software that actually makes sense.
Kudos 6y ago
I asked them about that a year ago and they weren't interested in changing the model then.
- heyoni 6y ago
  Go with data grip then. I’m pretty sure it can be installed on every machine. At least that’s what I do, and I see no reason to switch other than their lack of official support for non-relational databases. It’s otherwise solid software.
surfsvammel 6y ago
I totally agree. I have a license but would have liked to use it also on my workstation, not only my laptop.
annoyingnoob 6y ago
I tend to agree. I'm not sure about all devices but a license being install-able on somewhere between 2 to 5 devices seems reasonable. I'll be a paying customer but I need a little flexibility. I use more than one computer and some other devices - I don't need an SQL tool on all of them but definitely on more than one.
oefrha 6y ago
You can also get TablePlus though a Setapp[1] subscription. (Unfortunately Setapp is also licensed on a per device basis, but you get 2 Macs out of box and you could buy extra seats at $5/mo/seat.[2] I think named licenses are hard to offer because a lot of people abuse them by sharing with coworkers and friends.) Having used TablePlus for a couple months with both Postgres and SQLite, I only have positive things to say. [1] https://setapp.com/ https://setapp.com/ [2] https://setapp.com/news/setapp-launches-extra-seats https://setapp.com/news/setapp-launches-extra-seats
- jfim 6y ago
  For Mac apps, one can simply bind the license to the user's name, with some allowance for edit distance (and a few automated name changes), which can solve the casual license sharing. Adding a "Licensed to John Smith" message during load time also helps with this.
DevX101 6y ago
This is an odd hill to die on. I'd bet 90%+ of engineers have a single computer they code from at home (even if you have multiple computers) and another at work. It's perfectly fair to pay for a separate license for each of those use cases. I'd prefer this to some $10/month SAAS model.
- ineedtosleep 6y ago
  Disagreed. I have a MBP, a Linux desktop and a Thinkpad running both Linux and Windows. My one subscription to a Jetbrains product covers all of them provided I don't run the program at the same time across multiple machines. Believing that most engineers only have one computer IMO seems out of touch with reality.
  - brandonmenc 6y ago
    > My one subscription to a Jetbrains product covers all of them And also includes their database tool, DataGrip.
    - zo1 6y ago
      > And also includes their database tool, DataGrip. Which is awesome by itself. I use it regularly and only have minor issues with some of it's behavior, but the experience is worlds-ahead than what I've encountered previously at that price point.
    - Aeolun 6y ago
      DataGrip is quickly becoming unusable to me due to it’s inability to show me a tables/field encoding. I really have no clue how anyone thought that was an unnecessary feature.
      - therealdrag0 6y ago
        Can you elaborate on what that is? I haven’t ran I to that before.
thibaut_barrere 6y ago
I do not find that model outdated at all. Actually a good bunch of apps I use have that model (e.g. Alfred App, Ableton Live...). Also, TablePlus seems to be selling well (at least from what I see around me), so I am not personally of the opinion that they should change their model!
- fredoliveira 6y ago
  I'm confused. I have licenses for both Alfred and Ableton, and both of them run on all my devices just fine. Ableton in particular allows a limited number of authorizations, but handles my laptop and desktop.
nerdbaggy 6y ago
What is your opinion on a license that is for unlimited computers but can only be used by 1 computer at a time?
- alexdumitru 6y ago
  That would be much better for me.
  - oefrha 6y ago
    If you’re a fan of always-online DRM. You must be a first...
    - nerdbaggy 6y ago
      A lot of them just are on the local network. Like Jetbrains software will throw a license error if both are on the same internal network, but will be fine if they are on separate networks.
      - oefrha 6y ago
        Okay, that’s a much smaller concern.
ramraj07 6y ago
I moved my entire team to this program because of how simple (and reasonably hard to screw up) it is. It's also incidentally one of the cheapest non-buggy tools you can use to access redshift. Even if you buy multiple licenses it's cheaper than navicat et al. Also to note that their free version is still _very_ usable, I survived on that itself for many months spending hours in the tool.
reaperducer 6y ago
It's worse on the iOS version. It's a $3.99/month subscription. No thanks. I don't rent software.
johne20 6y ago
I am totally fine with the license model. I have been using TablePlus for over 2 years. When I first tried it I had a few questions/issues and the developer responded immediately and made changes based on feedback. (the email thread is 42 msgs :)). I have been using it daily for pg, mysql, occasionally for redis and sqllite, it works great and gets continuous improvements. I wish this company all the best, great product, great support.
stephenr 6y ago
I have a single license for TablePlus right now. I do have another machine, but it's effectively a "spare" / "travel" machine, so I don't use it a lot. If I happen to need TP next time I'm using that machine, the cost of adding another seat to the license is offset by some fraction of an hours billable work, and lasts for a year. What's always missing from these type of discussions is the consideration that just maybe, offering it as per-seat rather than per-person is why the price is what it is. Would you prefer it it was per-person but cost $99 for a licence, with a year of updates? Sure, that gives you the warm fuzzy feeling, and benefits anyone with > 2 machines, but it doubles the price for those who only need one seat under the current scheme. I'm lucky enough to be paid pretty well for my skills and experience, and I (or technically my company) can maintain some software and release it as open source. But I'm also very aware that high quality fully native developer tools are quite few and far between, and the number that are also cross platform is miniscule. There is significant competition from things built using "cross platform runtimes" (Electron, Java). So when one comes along that is as good as this, they could charge twice what they do and I'd pay happily - but not everyone can justify/afford that much on developer tools.
skinnymuch 6y ago
Like some others have said. Getting it via Setapp is great. The prices aren’t far from one another and Setapp offers other apps. Setapp has the device limitation too, but since it’s basically the same price, add a few more seats if needed. Setapp lets you use apps on as many devices as you want. But like streaming services these days, you can only have apps through Setapp actively running based on the seats you have. Though if you have say 2-3 seats for Setapp. And launch Setapp and some apps on a 4th comp. whichever comp has to get off Setapp to give space, you can usually keep apps open. Just can’t re-open them until a seat space is available again. M

deleted 6y ago

[deleted]

Cenk 6y ago

Previous discussion (333 points): https://news.ycombinator.com/item?id=16339004 https://news.ycombinator.com/item?id=16339004

dang 6y ago
That was 2018. Also 2019: https://news.ycombinator.com/item?id=19160808 https://news.ycombinator.com/item?id=19160808 And another 2018: https://news.ycombinator.com/item?id=18004727 https://news.ycombinator.com/item?id=18004727

dvfjsdhgfv 6y ago

I love the licensing model. No crappy "pay us for the privilege of using the software every month and year" like Adobe does. Just plain perpetual licence like Affinity. We need more projects like that.

Kudos 6y ago
Except it's licensed per computer and not per seat. I'm not sure what they're trying to achieve with it. I have two personal devices, not to mention dual booting Linux some of the time.
cwhiz 6y ago
Perpetual license but not perpetual updates. And you have to pay per device instead of per seat. I think the pricing is low enough to overcome these annoyances but I’d rather pay double and not have to be concerned with buying another license when I dual boot another OS.
- jacurtis 6y ago
  I do agree, that it would be nice to pay per seat, not per computer. I develop on Mac 95% of the time, so I own a license on Mac, but on Windows I just use the free version because I don't use it on Windows enough to justify paying for it on that device, despite the fact I am a paying customer. This is an annoyance for me. However, I rarely run into any of the free-version limitations on Windows since I am usually just logging in quickly to check on something on Windows and not doing anything major. If I need to do some hardcore work I pull it up on my mac, which has a better dev environment. But it is extremely annoying the few times when I do go to open several tabs on WIndows and remember that despite being a paying customer, I can not use these paid features because I am using it on the wrong platform. I don't have a problem with the perpetual license that doesn't include perpetual updates. To me, if you are using the tool that often, you can support the team that builds something that you most likely make money off using. One year of updates for TablePlus is nearly equivalent to a month of updates from Adobe. At $60 a year we are talking about $5 a month. Which is very little to most developers, who purchase $6 coffees and $15 salads without batting an eye. But I would like to see a per-seat option. Especially because I most likely wouldn't/couldn't use two different computers at the same time, it seems fair to let me install it on a few OS's if I desire.

rkwz 6y ago

I've been using it for the past year and it's my go to app for managing PG databases. As much as I love SQL, TablePlus makes certain actions like inserts/updates/import really convenient especially when you're working with dev databases.

jackschultz 6y ago

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.

te_chris 6y ago
Best thing about the editing is the staging mode, allowing you to preview a few changes then flush them at once.
jacurtis 6y ago
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.

alexashka 6y ago

These products all do more or less the same thing. If Valentina Studio free version supports your DBs of choice, I've found it to suit my needs perfectly well - Postgres user here. Oh, did I mention it's free? These products should have a mandatory feature comparison chart to their competition - it'd speed up the inevitable decline of mediocre competition that relies on gaming google search results for its survival. I back in the day had to download and suffer through half a dozen DB clients that do the same thing slightly differently.

deleted 6y ago
[deleted]

Thristle 6y ago

I like tableplus a lot and used it mainly as a redis GUI (we have a querious license at work so i use that for sql). I did encounter some wierd things around version 290 it seems that when you use a filter (which is called "advanced filter" not sure why) on a mac everything works but the same filtering action was blocked for the free version on my windows machine. some versions later it was also blocked on my mac but i cant seem to find any way to filter redis keys at all. other than that i really like everything else

timothevs 6y ago

Has anyone compared this to Navicat? Our non profit has a non commercial license for Navicat Premium, and I just love the product (despite more than a few quirks).

ganomi 6y ago

Free alternative i have been using for some years now: https://dbeaver.io/ https://dbeaver.io/ The community edition is updated more often than i would like and sometimes features break but bugs get fixed quickly and they add usefull stuff all the time. Dont know what i would do if i was stuck with pgAdmin...

wenc 6y ago
DBeaver is great for MySQL databases. HeidiSQL is another good one for MySQL databases. pgAdmin is not good.
tbrock 6y ago
1990s Java swing clunky UI... would rather use CLI IMHO.
- pyr0hu 6y ago
  That literally the name of the animal
- sjbr 6y ago
  it's not swing, it's SWT that is why it has the native look
  - ken 6y ago
    It may be a reliable and useful application, but it definitely does not have anything close to a "native look".
anhthang 6y ago
I like SequelPro. The UI much simpler, powerful, but it's inactivated, nobody working on it to update for new macOS :(
- HatchedLake721 6y ago
  Which is a big shame. I'm happy to $$$ pay for Sequel Pro, but it's been abandoned for 1-2 years now?

planetjones 6y ago

Been using the open source dbeaver for a while now. On the whole very impressed with it, so worth a look as a free alternative.

supernintendo 6y ago
+1 for DBeaver. It doesn’t have a pretty UI like TablePlus but it’s FOSS, cross platform and has all of the same features (maybe more).
detaro 6y ago
> Advanced cryptography algorithms for SSL/SSH connections. as a feature limited to the enterprise version sounds kind of scary.
thecrumb 6y ago
I looked at TablePlus but the formatter was horrible. DBeaver internal formatter is decent and if I want more I can use an external tool.
wackget 6y ago
Does the code completion/autocomplete in dbeaver support "fuzzy typing" like in Sublime Text? For example, if you have a table called "catalog_product_flat", would the autocomplete suggest that table when you typed "catprfl"?
- zmmmmm 6y ago
  Just tried that and it did autocomplete, for example 'dal' to 'django_admin_log'. It did not auto-suggest it while typing, but when I pressed control-space it expanded it.
zmmmmm 6y ago
Agreed. The only thing it probably doesn't satisfy here is lightweight (being built on Eclipse). But actually one of the things that keeps me with it is that being built on Eclipse I can use a whole bunch of Eclipse plugins that have have from that environment and they work great.

whoisjuan 6y ago

TablePlus is awesome! I got it through Setapp and it completely any need I had for SequelPro which I feel got shittier in the last couple of years (no new features and it feels super laggy nowadays).

tbrock 6y ago

Anyone know what this is built in/with? C++ & GTK?

sys_64738 6y ago
It's a native GUI on the Mac.
megavolcano 6y ago
from the website: > TablePlus is a native application. We are using Swift, Objective-C, C/C++, Perl for OSX, C# for Windows.
armadsen 6y ago
I can confirm with a very little spelunking that the Mac app is a real native AppKit/Cocoa app. It appears to mostly be written in Swift, but also uses a fair amount of Objective-C. They've said publicly that the Windows version is written in C# and C/C++. Not sure what they did for Linux...

wenc 6y ago

I work with SQL Server. I really like general multi-db GUI tools like this, but also wonder if one is giving up a lot of power. SQL Server's free native tool is SSMS (SQL Server Management Studio), which is one of the most powerful SQL clients I've ever used. (despite my carryover reservations with MS products from the 1980s-90s, SQL Server is indisputably an innovative and solid piece of technology -- MS did something right with their database group). One can interact syntactically with the database via pure SQL, but SSMS lets you access the deep corners of the database quickly via a GUI (SQL is a great query language, but many admin/ops tasks are much more easily done via a GUI -- writing SQL every time you want make a simple change is tedious plus nobody remembers the syntax for infrequently used features). Some of the features I use regularly: row/column/covering index creation, linked servers, user management, live query plans, create/alter script generation from existing objects (stored proc, view, index, table, etc.). I've never seen these features exposed in any third party SQL GUI client. Postgres has a bunch of very powerful features too, and I've never seen these exposed in GUI tools. Jetbrains' DataGrip comes the closest, but because it needs to support lowest common denominator features across databases, it doesn't expose deep features either. I wonder if folks are giving up deep feature discovery by using an generic GUI SQL client. Exception: Oracle SQL Developer. It's native to Oracle but is quite unpleasant to use.

oefrha 6y ago
Edit: read the parent wrong, but leaving my comment here so it doesn’t look like backtracking some offensive content. > wonder if one is giving up a lot of power. That’s an irrational concern. GUI tools also come with SQL consoles where you can do anything that’s possible in the CLI. With the added benefit of results being presented in a nicer way.
- wenc 6y ago
  > That’s an irrational concern. Is it though? So for SQL Server, you can't really see the live query plan (real-time plan + statistics while the query is running) without the GUI. You cannot see the Activity Monitor without the GUI. There are elements that cannot be accessed via pure SQL. 3rd party GUIs generally don't support these features.

azranoman 6y ago

what is iq option? how to use https://coinmarket01.blogspot.com/2020/04/what-is-iq-option-how-to-use.html https://coinmarket01.blogspot.com/2020/04/what-is-iq-option-...

sergiotapia 6y ago

Been using this for a 8 months now, I really enjoy it. It's polished, and has a format sql query feature that is useful for that final step once you have your query down to what you want it. Very nice stuff.

memco 6y ago

I like TablePlus and have bought licenses for my work computers. It’s got a lot features, but is still rough around the edges in some spots: Mongo is technically supported but the viewing and editing experience isn’t great for nested object. The SSH support seems wonky: I can’t get it to work with my ssh config which uses proxyjunp to connect. I have to setup the tunnel using -L in my terminal and use the local port in TP. I know it’s supposed to be able to use the proxy jump configs but it has just never worked for me.

mekster 6y ago
I have a jump host and it works by reading ~/.ssh/config and works fine. You might want to report it on GitHub as they seemed quite responsive the last time I reported an issue.

petilon 6y ago

Looks like almost the same feature set as SQLPal: http://www.pebblereports.com/sqlpal/ http://www.pebblereports.com/sqlpal/ However, SQLPal only supports Oracle.

MrOxiMoron 6y ago

I love TablePlus. Definitely worth it's money for me.

jonnycomputer 6y ago

I have been looking for a native app alternative to pgAdmin ever since they changed it over to a browser based application. I will have to check this out. Actually, if people have suggestions, I'll listen!

gerry_shaw 6y ago
Postico
amartya916 6y ago
I have used both Postico and Tableplus extensively, and if you are sure that you are going to be working with Postgres only, its the better, more Mac-like app. However, both are a serious upgrade over PgAdmin :)
listenallyall 6y ago
DBVisualizer
yyx 6y ago
Valentina Studio

btcnews 6y ago

Killer news Bitcoin vs Ethereum https://coinmarket01.blogspot.com/2020/04/bitcoin-vs-ethereum.html?m=1 https://coinmarket01.blogspot.com/2020/04/bitcoin-vs-ethereu...

jasonpbecker 6y ago

I’ve been using this as a part of my Setapp subscription and loving it. It’s the only tool that has replaced DBeaver (which is still more powerful, but I hate the interface).

sinnet11 6y ago

"Supports a whole set of relational databases" Includes MongoDB in the list.

megavolcano 6y ago
and redis lol

ryanmarsh 6y ago

No mention of DynamoDB or Cosmos. Why can’t these DB’s get some love from tool vendors?

ufmace 6y ago
I use both TablePlus and DynamoDB at work. I don't see any reason to bother trying to put DynamoDB support into TablePlus. DynamoDB is great at its one killer feature of supporting arbitrarily huge tables without you having to worry about any details. For everything else, it's just kind of adequate, considering the constraint of needing to support multi-Terabyte tables. It lacks a huge number of features that all RDBMSes have that would admittedly be impossible or not make sense on huge tables. Thus, it doesn't make much sense to try to access it from a RDBMS GUI. The AWS Console provides all of the GUI that really makes sense for it, plus the CLI tools and API.
kkrbalam 6y ago
dbeaver supports dynamoDB, and it is an awesome product free of cost.

computerman1337 6y ago

How does this compare to Datagrip / IntelliJ IDEA for databases in terms of functionality? I’ve been using IntelliJ for relational databases and I am very pleased with it.

0x49d1 6y ago
Hmm, I'm in the same situation: how reliable is the company behind it, can I trust their expertise?..
mekster 6y ago
It is far easier to work than DataGrip. I used DataGrip after SequelPro stopped updating to support MySQL 8 and apparently it's feature rich but got annoyed how it's bloated and takes half a minute to launch. I still prefer SequelPro for it's layout and UI but finally dropped it in favor of TablePlus as now it seems close enough to that usability. Also of note is that the author is really responsive and friendly on GitHub who corrected some minor UI issues pretty quickly when I reported.

geniium 6y ago

Looks nice. Is there any plan to support Apache CouchDB ?

caseyf7 6y ago

Postico is a nice Mac alternative but is focused on Postgres DBs like Redshift.

jops 6y ago
I've been using Postico for years. High quality software.
augstein 6y ago
Been using it since its first stable release, absolutely reliable and easy to work with. Version 2, which should be released soon, is even nicer. https://eggerapps.at/postico/ https://eggerapps.at/postico/
- elAhmo 6y ago
  Version 2 is lovely, I have been using it in beta and it seems quite stable, looking forward to the final release.

hackerm0nkey 6y ago

> After 1 year, you can continue using TablePlus without any limitations but you can't upgrade to the latest version. If you want to upgrade, you must renew the license, the renewal fee is much cheaper than buying a new one. This sort of put me off. Personally I am fine with a single user perpetual license for my use case. But as they are claiming it being a young project and likely to have more bugs than your average mature product. Why do you expect me to renew my license to get your updates ? doesn't seem fair. > TablePlus is a young project, we fix bugs and add new features every day, then put them together in a new update released at the end of week/month. That week/month could fall a year after the date of my initial purchase :(

eugeniub 6y ago
TablePlus for 2 Macs with 12 months of updates: $99 SetApp subscription for 2 Macs (includes TablePlus): $108/year
- hackerm0nkey 6y ago
  Interesting, didn't know about SetApp before, thanks. I wonder how they manage around DRM rights with the individual app publisher?
  - filmgirlcw 6y ago
    They make agreements with the publishers and SetApp delivers the app updates (usually the same day as the regular app updates are released). SetApp lets you have a certain number of “active” machines. My account (which I got whenever it launched) let’s me have 5 machines but the standard plan might be 2, I’m unsure. Any annual upgrade terms don’t apply, your access is predicated on having a SetApp subscription. So for an app like Ulysses, I don’t have to pay the annual IAP or subscription (the Ulysses subscription extends to iOS too fwiw although other apps like Screens still have their own separate iOS apps, which makes sense). I actually discovered TablesPlus thorough SetApp and liked it enough to buy the Windows version for the times I use Windows. There are a number of apps in SetApp I’ve already paid for, but talking to a friend who is a SetApp author, if I install the SetApp version, that actually helps him get paid more so when I do have overlap, I install the SetApp version. (My friend makes decent money off of SetApp which made me feel a lot better about the whole thing and feel comfortable it wasn’t predatory towards indie app makers).

z3t4 6y ago

Thats one scary select statement in the screenshot.

crazygringo 6y ago

Curious if anyone knows how it stacks up against Sequel Pro? (At least if you only need to work with MySQL, obviously?)

thibaut_barrere 6y ago
Well, it is maintained! My understanding is that SequelPro hasn't seen any release since 2016 (at least based on https://github.com/sequelpro/sequelpro/releases https://github.com/sequelpro/sequelpro/releases).

S3raph 6y ago

is this similar to DBeaver?

pvtmert 6y ago

I saw TablePlus first time again in HN, (circa 2016) since then it is go-to tool for databases. Many DB connection UI's (except MySQL Workbench and Sequel Pro I think) requires some kind of purchase. Besides My company uses Sequel Pro it always had either crashed or having slow import/export speeds etc. Even TablePlus can import/export between engines using CSV files, which is IMHO awesome option to have.

mekster 6y ago
SequelPro served me for years and I loved it but since it no longer is being actively maintained (I know about nightlies but it's buggy with constant crashes and such, so it doesn't count.) to support MySQL 8, I'm glad TablePlus mostly caught up on the usability to SequelPro for me to have a unified tool for all DB needs.

nojvek 6y ago

I like how TablePlus makes a yearly post. It is relevant for HN users and will deliver them nice sales but I wonder what is the policy for pasting same urls. In product hunt I see same products arriving again with version #2 e.t.c I know VSCode and Typescript announce their new versions here too. May be the official policy is "it doesn't matter, unless too spammy?"

deleted 6y ago

[deleted]

pencilcode 6y ago

I use sqlpro and just tried this, thinking that maybe table plus is better, their history feature is much better imho.

blobster 6y ago

I love it because it's the only Mac app that allows you to connect to a remote Mysql server via ssh and Unix socket at the same time.

seemslegit 6y ago

When/Why should someone pick it over dbeaver ?

Roritharr 6y ago

After testing this for 30 minutes it made me actually Donate money to the HeidiSQL project, as it fits my workflow MUCH better. It has a couple of annoying bugs but it's feature set develops in general much more along my actual needs. The Redis implementation of TablePlus is rather worthless to me compared to what Redis Desktop Manager does as it doesn't sensibly group keys, it doesn't give me much information about the relevant redis metrics (memory usage especially). Over in the MySQL side of things of TablePlus I like the way it structures its filters and the way I can actually copy a column of values in sensible formats, but besides these two features i'm much happier with HeidiSQL, so that's where I put my money.

kevmo314 6y ago
Have you gotten HeidiSQL to work well with PostgresQL? I really like it back when I used MySQL, but it's absolutely rife with bugs in its PostgresQL adapter with constant crashes and invalid queries being generated. It's so bad that it makes me wonder if I just have something misconfigured instead of it being an application bug.
- Roritharr 6y ago
  I only use the PostgreSQL adapter only for a very simple database, so I can't comment on it.

exabrial 6y ago

For those of you who miss SequelPro before it was abandoned, this is a worthy successor. I bought licenses for my whole team.

jdpedrie 6y ago
Indeed. I just went searching for a SequelPro replacement yesterday and found Table Plus. Tried it for an hour and bought a license.

wackget 6y ago

Does the code completion/autocomplete in this program support "fuzzy typing" like in Sublime Text? For example, if you have a table called "catalog_product_flat", would this program's autocomplete suggest that table when you typed "catprfl"? That's one feature I find is missing from every single DBA program out there except for DataGrip, which I don't like because it's overkill.

nickforall 6y ago
Yeah, it tries to do that but is not always very good at it. For example with aliases in join and subqueries it struggles sometimes and it doesn't show up.

Nevada-Smith 6y ago

This program won't install on Windows 7 because it requires .NET Framework version 4.8, which won't install on Windows 7, because Micro$oft doesn't support it any longer. Given this, you'd think TablePlus would explicitly mention this before putting Windows 7 users through this unnecessary waste of time.

rubber_duck 6y ago
Should probably mention it doesn't work on Windows 95 either.
- adventured 6y ago
  Windows 7 end of life began in January 2020. Around a quarter of all PCs are still running it. Remind me again what the EOL for Windows 95 was. "Even today, millions of PCs are still running Windows 7, and the operating system still runs on a massive 26 percent of all PCs according to data from Netmarketshare." https://www.theverge.com/2020/1/14/21065122/microsoft-windows-7-end-of-support-lifecycle-millions-pcs https://www.theverge.com/2020/1/14/21065122/microsoft-window...
  - rubber_duck 6y ago
    That's EOL, it's been deprecated since 2015, if you're a developer using it and can't see why people can't bother supporting it I don't know what to say other than should we support XP since random PCs in China still run it ?
    - paulryanrogers 6y ago
      Windows 7 is still widely deployed in western markets which TablePlus appears geared toward. So it's a reasonable call-out IMO.
ricardobeat 6y ago
Why would they support a dead OS? Windows 7 is months past end-of-life, receiving no security patches and hence unsafe to use. And by the way they actually explicit mention it on the homepage - it says .NET 4.8 right under the download button.

dotmanish 6y ago

Coincidentally, I discovered TablePlus in Setapp today while searching for a macOS MySQL client. Has been a smooth experience in the first few hours, and a better looking interface that other clients that I have tried in the past. As another comment mentions, support for Linux is a big plus - we need better GUIs in there.

megavolcano 6y ago

gave it a trial install, and one thing I noticed right away is that memory usage shoots up and responsiveness slows to a crawl when working with medium-ish tables (hundreds of thousands of rows) if you happen to run a select and forget to limit your query, it slows to a crawl datagrip paginates results in batches of 500 by default, which helps with not accidentally making the interface implode on itself

paulryanrogers 6y ago

These GUIs are great though I find no substitute for learning the CLIs. With a CLI one can work on remote systems and quickly automate one off tasks.

_el 6y ago
Ditto. I'm one of the few at my company who uses the CLI. It's so much quicker and intuitive for me.

tumidpandora 6y ago

DBeaver is hands down the best client for any and all databases, plus it’s free.

dikaio 6y ago

Use it, love it. All it needs is a Data Modeler and it would be complete.

deleted 6y ago

[deleted]

soheil 6y ago

Sequel Pro's pros: - Sequel Pro's UI is much simpler - it's been around for over a decade - Sequel Pro can import/export large DBs much quicker - works on OSX - less bloated by not having to support 10+ different db types Genuine question: when did Redis become a relation db?

s_dev 6y ago
Table Plus works on macOS. I disagree about the UI. Table Plus when connecting to a DB will mark the offending parameter red to let you know what credential isn't right e.g. host/port/key I've found this very helpful. Sequel Pro is free which you didn't mention and Table Plus has a fee.

russianbandit 6y ago

Anyone know if they plan to support Presto?

mikl 6y ago

I’ve been using TablePlus for a while, its nice to have because it supports all the databases I use with no fuss, replaced a bunch of separate apps for Redis/PostgreSQL/MySQL/Cassandra. Also comes as part of the deal if you have a Setapp subscription (https://setapp.com/ https://setapp.com/ ) (And just to be clear, I’m not affilated with either company.)

SeriousM 6y ago

I like the fact that it has a reasonable price without the subscription bullshit. Like linkpad, pay money and own the product without having to pay for every single month. That's how software should be sold, like the good old days.

978e4721a 6y ago

Where's Linux version? Does editor has vi bindings? People should stop building database IDE without vi bindings.

978e4721a 6y ago

Hands up if you use cli and format SQL with python-sql-format/README.md at master · longgb246/python-sql-format https://github.com/longgb246/python-sql-format/blob/master/README.md https://github.com/longgb246/python-sql-format/blob/master/R...

lpil 6y ago

Just gave it a test with WSL2 on Windows, doesn't seem to work with that setup. A shame

ewenjo 6y ago
Just tried the same, worked fine for me.