[HN Gopher] TablePlus - Modern, Native Tool for Database Management
       ___________________________________________________________________
        
       TablePlus - Modern, Native Tool for Database Management
        
       Author : bottle2
       Score  : 343 points
       Date   : 2020-04-18 15:06 UTC (7 hours ago)
        
 (HTM) web link (tableplus.com)
 (TXT) w3m dump (tableplus.com)
        
       | [deleted]
        
       | MrOxiMoron wrote:
       | I love TablePlus. Definitely worth it's money for me.
        
       | jonnycomputer wrote:
       | 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 wrote:
         | Postico
        
         | amartya916 wrote:
         | 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 wrote:
         | DBVisualizer
        
       | ganomi wrote:
       | Free alternative i have been using for some years now:
       | 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...
        
         | welly wrote:
         | I've been using mysql workbench for a few years now. Is free,
         | works well, is cross platform and open source.
        
         | anhthang wrote:
         | I like SequelPro. The UI much simpler, powerful, but it's
         | inactivated, nobody working on it to update for new macOS :(
        
           | casperb wrote:
           | I loved it and would pay for it. But after 3 months of
           | restarting it a couple of times a day since the 2018 Mac
           | update, I switched to TablePlus.
           | 
           | I still miss SequelPro, as its search and export features
           | where way better then TablePlus' way.
        
           | datasage wrote:
           | Nightly builds have some fixes, but it does seem to be mostly
           | abandoned.
        
           | HatchedLake721 wrote:
           | Which is a big shame. I'm happy to $$$ pay for Sequel Pro,
           | but it's been abandoned for 1-2 years now?
        
         | mercer wrote:
         | I quite like Postico (Mac-only though)
         | 
         | https://eggerapps.at/postico/
        
           | will_raw wrote:
           | Using Postico for long time, great so far and is also
           | cheaper.
        
           | thibaut_barrere wrote:
           | It's Mac-only, but also Postgres-only! TablePlus has wider
           | datastores support.
        
         | piggybox wrote:
         | I'm using it on daily basis but it's not a smooth experience.
         | I'm not sure if it's just me that very time I switch to a new
         | database in dbeaver and start running a different query ...
         | more often than not it's just stuck there for more than half
         | min and eventually told me it's not connected to the new
         | database yet so I had to refresh the connection. For all the
         | SQL tools I've used, dbeaver takes the the longest to realize
         | it's actually not connected to a db. It's not fun.
        
         | wenc wrote:
         | DBeaver is great for MySQL databases. HeidiSQL is another good
         | one for MySQL databases.
         | 
         | pgAdmin is not good.
        
         | tbrock wrote:
         | 1990s Java swing clunky UI... would rather use CLI IMHO.
        
           | sjbr wrote:
           | it's not swing, it's SWT that is why it has the native look
        
             | ken wrote:
             | It may be a reliable and useful application, but it
             | definitely does not have anything close to a "native look".
        
           | pyr0hu wrote:
           | That literally the name of the animal
        
       | planetjones wrote:
       | 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 wrote:
         | +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 wrote:
         | > _Advanced cryptography algorithms for SSL /SSH connections._
         | 
         | as a feature limited to the enterprise version sounds kind of
         | scary.
        
         | bgorman wrote:
         | I have also been a dbeaver user, but DBeaver 7 has been really
         | unstable for me and has caused me to look for alternatives.
        
         | thecrumb wrote:
         | 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 wrote:
         | 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 wrote:
           | 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 wrote:
         | 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.
        
       | Cenk wrote:
       | Previous discussion (333 points):
       | https://news.ycombinator.com/item?id=16339004
        
         | dang wrote:
         | That was 2018.
         | 
         | Also 2019: https://news.ycombinator.com/item?id=19160808
         | 
         | And another 2018: https://news.ycombinator.com/item?id=18004727
        
       | [deleted]
        
       | dvfjsdhgfv wrote:
       | 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 wrote:
         | 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 wrote:
         | 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 wrote:
           | 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.
        
       | whoisjuan wrote:
       | 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 wrote:
       | Anyone know what this is built in/with? C++ & GTK?
        
         | sys_64738 wrote:
         | It's a native GUI on the Mac.
        
         | megavolcano wrote:
         | from the website:
         | 
         | > TablePlus is a native application. We are using Swift,
         | Objective-C, C/C++, Perl for OSX, C# for Windows.
        
       | wenc wrote:
       | 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 wrote:
         | 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 wrote:
           | > 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.
        
             | oefrha wrote:
             | Never mind, I read your comment wrong.
        
               | wenc wrote:
               | No worries, I appreciate it.
        
           | yashap wrote:
           | I think you've missed wenc's point - they aren't arguing for
           | a CLI, they're arguing for a UI specialized to a single
           | RDBMS, vs one trying to convert many RDBMSs.
        
           | kyleee wrote:
           | If you've used SSMS extensively you'll know it's tailored to
           | SQL server like a glove. You'd definitely be leaving
           | usability on the table going with a generic DB client. The
           | person you've responded to even mentioned that of course you
           | can do all things via CLI, but SSMS builds powerful GUI layer
           | on top of that
        
             | Nullabillity wrote:
             | > If you've used SSMS extensively you'll know it's tailored
             | to SQL server like a glove.
             | 
             | Sure, assuming that MSSQL is a foot.
        
         | aik wrote:
         | How do you deal with the complete lack of searching for
         | tables/SPs/functions in SSMS? There are a number of 3rd party
         | extensions but they all seem slow and still just jump you to
         | the entity in the explorer.
         | 
         | The speed of searching for anything in DataGrip is just so
         | beautiful and amazing for productivity. A big downside is we
         | have run into situations where a SP is cached and is an old
         | version and DataGrip doesn't notify me that's the case.
        
           | greggyb wrote:
           | GUI search is awful, but it does exist. Right clicking on an
           | object type node (e.g. 'Tables' or 'Procedures' in the object
           | explorer) and selecting the 'Filter' option gives you a
           | limited search feature for objects in that node.
           | 
           | It is clumsy and painful, and I will most often just query
           | the sys schema to search for objects, but GUI search is
           | there.
        
           | wenc wrote:
           | > How do you deal with the complete lack of searching for
           | tables/SPs/functions in SSMS?
           | 
           | That is a weakness of SSMS, and I've no good answers.
           | 
           | For stuff like SQL formatting though, the free ApexSQL
           | Refactor [1] has been a godsend for me. I write a lot of
           | complex analytic queries and having the ability to tidy up
           | statements as I'm writing the query is amazing.
           | 
           | [1] https://www.apexsql.com/sql-tools-refactor.aspx
        
       | blobster wrote:
       | 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.
        
       | Nevada-Smith wrote:
       | 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.
        
         | ricardobeat wrote:
         | 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.
        
         | rubber_duck wrote:
         | Should probably mention it doesn't work on Windows 95 either.
        
           | adventured wrote:
           | 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-
           | window...
        
       | azranoman wrote:
       | what is iq option? how to use
       | 
       | https://coinmarket01.blogspot.com/2020/04/what-is-iq-option-...
        
       | sinnet11 wrote:
       | "Supports a whole set of relational databases"
       | 
       | Includes MongoDB in the list.
        
         | megavolcano wrote:
         | and redis lol
        
       | z3t4 wrote:
       | Thats one scary select statement in the screenshot.
        
       | pencilcode wrote:
       | I use sqlpro and just tried this, thinking that maybe table plus
       | is better, their history feature is much better imho.
        
       | rkwz wrote:
       | 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.
        
       | ryanmarsh wrote:
       | No mention of DynamoDB or Cosmos. Why can't these DB's get some
       | love from tool vendors?
        
         | kkrbalam wrote:
         | dbeaver supports dynamoDB, and it is an awesome product free of
         | cost.
        
         | ufmace wrote:
         | 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.
        
       | btcnews wrote:
       | Killer news Bitcoin vs Ethereum
       | 
       | https://coinmarket01.blogspot.com/2020/04/bitcoin-vs-ethereu...
        
       | pvtmert wrote:
       | 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.
        
       | computerman1337 wrote:
       | 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 wrote:
         | Hmm, I'm in the same situation: how reliable is the company
         | behind it, can I trust their expertise?..
        
       | jackschultz wrote:
       | 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.
        
         | jacurtis wrote:
         | 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.
        
           | elamje wrote:
           | 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?
        
           | aembleton wrote:
           | 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.
        
             | aembleton wrote:
             | 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...
        
         | te_chris wrote:
         | Best thing about the editing is the staging mode, allowing you
         | to preview a few changes then flush them at once.
        
         | sys_64738 wrote:
         | It's a really nice app. The best of the bunch on the Mac IMO.
        
       | geniium wrote:
       | Looks nice. Is there any plan to support Apache CouchDB ?
        
       | exabrial wrote:
       | For those of you who miss SequelPro before it was abandoned, this
       | is a worthy successor. I bought licenses for my whole team.
        
         | jdpedrie wrote:
         | Indeed. I just went searching for a SequelPro replacement
         | yesterday and found Table Plus. Tried it for an hour and bought
         | a license.
        
       | sergiotapia wrote:
       | 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.
        
       | dotmanish wrote:
       | 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.
        
       | crazygringo wrote:
       | Curious if anyone knows how it stacks up against Sequel Pro?
       | 
       | (At least if you only need to work with MySQL, obviously?)
        
         | thibaut_barrere wrote:
         | 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).
        
       | jasonpbecker wrote:
       | 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).
        
       | megavolcano wrote:
       | 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
        
       | alexashka wrote:
       | 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]
        
       | seemslegit wrote:
       | When/Why should someone pick it over dbeaver ?
        
       | S3raph wrote:
       | is this similar to DBeaver?
        
       | memco wrote:
       | 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.
        
       | Roritharr wrote:
       | 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 wrote:
         | 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.
        
       | petilon wrote:
       | Looks like almost the same feature set as SQLPal:
       | http://www.pebblereports.com/sqlpal/
       | 
       | However, SQLPal only supports Oracle.
        
       | Thristle wrote:
       | 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 wrote:
       | 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).
        
       | caseyf7 wrote:
       | Postico is a nice Mac alternative but is focused on Postgres DBs
       | like Redshift.
        
         | augstein wrote:
         | 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/
        
         | jops wrote:
         | I've been using Postico for years. High quality software.
        
       | wackget wrote:
       | 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 wrote:
         | 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.
        
       | hackerm0nkey wrote:
       | > 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 wrote:
         | TablePlus for 2 Macs with 12 months of updates: $99
         | 
         | SetApp subscription for 2 Macs (includes TablePlus): $108/year
        
           | tasqyn wrote:
           | does SetApp show ads? what is the difference between business
           | and personal pricing? they seem to be the same.
        
             | hackerm0nkey wrote:
             | Yeah, I am getting the same impression that the personal
             | might have ads? not sure.
             | 
             | I am trying it now and the trial version doesn't show me
             | ads, at least not yet -\\_(tsu)_/-
        
               | halostatue wrote:
               | No ads in Setapp.
        
           | hackerm0nkey wrote:
           | Interesting, didn't know about SetApp before, thanks.
           | 
           | I wonder how they manage around DRM rights with the
           | individual app publisher?
        
       | HHad3 wrote:
       | 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.
        
         | thibaut_barrere wrote:
         | 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 wrote:
           | 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.
        
         | reaperducer wrote:
         | It's worse on the iOS version. It's a $3.99/month subscription.
         | 
         | No thanks. I don't rent software.
        
         | nerdbaggy wrote:
         | If you have 2 computers just buy 2 licenses?
        
           | Kudos wrote:
           | I don't condone pirating software, but this is the kind of
           | licensing that makes me understand it to a degree.
        
             | jolmg wrote:
             | 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 wrote:
               | It's not proportional to number of users, either. Zero
               | marginal costs mean pricing is always at least a little
               | arbitrary.
        
               | Nullabillity wrote:
               | Yup. I'm starting to think that Kickstarter (and similar
               | group-buys) is the only way to fund software that
               | actually makes sense.
        
               | jolmg wrote:
               | > 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."
        
         | Kudos wrote:
         | I asked them about that a year ago and they weren't interested
         | in changing the model then.
        
           | heyoni wrote:
           | 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.
        
         | nerdbaggy wrote:
         | What is your opinion on a license that is for unlimited
         | computers but can only be used by 1 computer at a time?
        
           | alexdumitru wrote:
           | That would be much better for me.
        
             | oefrha wrote:
             | If you're a fan of always-online DRM. You must be a
             | first...
        
               | nerdbaggy wrote:
               | 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 wrote:
               | Okay, that's a much smaller concern.
        
         | ramraj07 wrote:
         | 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.
        
         | oefrha wrote:
         | 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/
         | 
         | [2] https://setapp.com/news/setapp-launches-extra-seats
        
           | jfim wrote:
           | 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.
        
         | johne20 wrote:
         | 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.
        
         | surfsvammel wrote:
         | I totally agree. I have a license but would have liked to use
         | it also on my workstation, not only my laptop.
        
         | annoyingnoob wrote:
         | 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.
        
         | DevX101 wrote:
         | 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.
        
           | heyoni wrote:
           | No it's not. I have a desktop and 2 laptops. My desktop has 3
           | OSes, Mac windows and Linux. Why the hell would I buy this,
           | and then have to think really hard about which one I'll use
           | with it?
           | 
           | I probably feel too strongly about this. Last week I setup a
           | nytimes cooking subscription and then immediately canceled it
           | when I realize I had to leave it on auto pay or else it
           | wouldn't work.
        
             | dahdum wrote:
             | Just having a desktop and a laptop is enough to kill this
             | product for me, I'm not paying twice when it's only me
             | using it. It shows disrespect for the user, or at least
             | ignorance.
             | 
             | No other paid software I use does that. Sketchup, Sublime,
             | Jetbrains, and Office for instance.
        
           | ineedtosleep wrote:
           | 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 wrote:
             | > My one subscription to a Jetbrains product covers all of
             | them
             | 
             | And also includes their database tool, DataGrip.
        
               | zo1 wrote:
               | > _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.
        
           | zarkov99 wrote:
           | I have a laptop, a home computer, a work computer and I have
           | all my tools on all of them. I bet that is more the norm than
           | not. The license should be associated with the person not the
           | device.
        
       | nojvek wrote:
       | 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?"
        
       ___________________________________________________________________
       (page generated 2020-04-18 23:00 UTC)