Ditto. Tab issue in prod release, Not nightly. I love the app but it’s made me look for diff options. I close tabs all day, it’s a big bug in my head that should’ve forced an update. Otherwise monster fan.
I have the exact same issue with MySQL Workbench. Since upgrading to Mojave, lots of Workbench is just unstable. Probably crashes 6-8 times a day. I spend most of time in CLI now since it doesn't crash. It has helped me understand the SQL much better since I have to bang it out rather than just "confirming" what the UI decided to do for me.
Me too. I like their “commit” feature and that it shows you every action you perform with a query and you can commit or remove each one before allying changes
I looked into Table Plus when I found that Sequel Pro crashes more than NASCAR on a Sunday. But it’s pricing model doesn’t work for the way I work. I’m just one person, but use multiple computers simultaneously, making per-computer licensing prohibitive.
Obviously phpMyAdmin is a tire fire.
I’m still looking for a good macOS-native client similar to Sequel Pro. Bonus points if it has a usable iPad version.
> I’m just one person, but use multiple computers simultaneously, making per-computer licensing prohibitive.
Ouch, that is a bit pricey for one person with multiple computers, especially if the annual upgrade fee is also per computer. It makes me wonder if the licensing is tied to the motherboard / MAC address too, which is a pain when repairs happen.
On the other hand, I'm really glad to see a developer charging a sustainable price for their product.
which is a pain when repairs happen => TablePlus has a license manager where you can remove your old device, manage your license.
The TablePlus license is the onetime purchase, if you don't need any new feature, you don't need to renew it anyway.
I use it on multiple computers - jsut not at the same time.
"If you want to use TablePlus on multiple devices you need to add more seats to your license. The number of seats is the number of devices you can log in to at the same time"
https://tableplus.io/order/extend-seats
So I took that to mean that I can have it on multiple machines, I just can't use them at the same time - which is fine, I can use my laptop or desktop depending on where I am.
I like TablePlus, but at $59/yr a license is ridiculous. Luckily the feature set isn't that much greater with a license, just minor annoyance on tabs which I've developed a habit of closing a tab as soon as I don't need it.
This is a perpetual (lifetime) license not yearly. You only need to pay if you want to upgrade. The price is not $59/year, the price is $29 to extend one year free of updates.
I think without the tab limitation, you can be happier, more productive and earn more than $29/year.
Second this. I moved away from SequelPro about a year ago once the app started to crash occasionally. TablePlus isn't as feature rich but it's fast, uncluttered and pretty stable.
It hasn't been updated in a very long time. Constant crashes on Mojave. I have transitioned away to TablePlus and DataGrip. Too bad because it was a very good tool for quick edits.
FWIW I had the same reaction, then upgraded due to the Mojave crashes and discovered that the nightly doesn't update that often and is stable. It's been fine for months.
Yeah the crashes in Mojave were driving me crazy. Then to my surprise I tried the test build here and its way more stable and even has multiple filters, a feature I've been wanting for years. https://sequelpro.com/test-builds
Love DataGrip...was a big Sequel Pro fan until I started on a project with PostgreSQL and found DataGrip. Haven’t looked back. (I’m now using DataGrip for MySQL as well.)
sadly neither postico nor tableplus can connect using an ssh certificate. this is becoming a big drawback in organisations switching to ssh certs instead of keys.
Are you sure it's not actively being fixed? I see active development on GitHub with many commits. Have you reported the issue on GitHub as the website suggests?
It was fixed several months ago, apparently, but the fix still hasn't been released outside of a test build yet. There have been multiple issues opened (and closed as duplicates) but this[0] seems to be the original.
I had a lot of trouble with Mojave and the crashing you are reporting is annoying. I’ve been using their test builds the past couple months with zero problems though.
In my experience, it's specifically every time you try to disconnect from a server. (I have connections set up for dev and production for a small project, and I try to keep the production connection open only when I need it...but if I open it, I need to keep it open or it crashes the whole app.)
I'm afraid SequelPro may be coming to a dead end without a real active development (night lies occur but no stable release in years without latest MySQL support.)
As others have mentioned, it has not received much love recently from the developer. My guess is that it is due to the pricing model and accepting donations. I have donated $200 back in 2014 but I did not see many supporters back then and none now. There is no incentive for the developer to keep maintaining and enhancing the product. Everyone who used this tool in the past and liked itshould consider supporting it if not with money then with their time and knowledge on github.
Can they not just turn into subscription model for something like $10/mo or even $5/mo and get things done instead of floating with nightlies?
I'm sure people cry and scream for going paid but seeing this disappear with lack of recent MySQL version support and likely never support any other DB looks pretty sad too.
Great product. Switched from MySQL workbench and it was amazing. Haven’t upgraded to Mojave though. Apple hasn’t been the same since they switched to one year OS release cycles.
Mojave was a really painless upgrade for me compared to previous upgrades.
MacOS High Sierra was the worst upgrade for me. The APFS update borked my laptop and they dropped support for the integrated raid card from my 2010 Mac Pro.
Yep, just wanted to add that I haven't seen any of the crashes with Sequel Pro that others have mentioned. But I'm still on High Sierra with HFS+ file system though.
(Though I've since bought a Windows laptop & I haven't found a Sequel Pro equivalent for Windows yet.)
I had this problem as well, but I just tested one of the Test builds as suggested above, and the problem disappeared. So I highly recommend trying that :).
It's a paid and rather expensive product but I've used Navicat happily for something like ten years.
The latest release was a rewrite and they're still sorting out problems but every incremental update brings it closer to how great the previous version was.
I used to love Navicat and have a copy but the UI was so unbearably slow, the only thing I use it for is user permissions. Maybe it's only on OS X, but the app was completely unusable compared to something like SQL Pro and I realized I was only using it because I had paid for it and it should have been not only usable but better. It really isn't. The UI slowness is so bad, the team that maintains it should be ashamed of themselves, especially for charging money. It's a native app after all! They can't even blame electron or whatever fw of the day for this, afaik.
I loved Sequel Pro and was disappointed when I switched companies and couldn't use it with Postgres. Plug: it's one of the reasons why I built PopSQL (https://popsql.io)
Out of curiosity, why did you build PopSQL from scratch? How many hours would you estimate it would take to generalize Sequel Pro to support PostgreSQL? The license even allows proprietary forks.
Would it be possible to have versioned downloads of this? I like pinning package versions so latest download doesn't cut it since it breaks the hashes.
Projects like these should be celebrated through donations and this project makes it easy. When’s the last time you’ve seen freeware developer tool for macOS that’s not from a corporation with money to spare?
I personally can’t think of anything beyond iTerm (utility), Homebrew (utility), ...aaand that's where my list ends.
I don't think that freeware is really a part of the Apple Developer ecosystem. Most of the MacOS exclusive software I use on a daily basis costs $20-$30, a price I'm more than willing to pay for software like Pixelmator, DaisyDisk and Alfred that is significantly more polished (and Mac-ish) then the average piece of open-source software just due to the resources available to them.
I think that's just because the software landscape matured in general. More people use apps, more developer make a real business out of it instead of tinkering in their free time. A few years ago people around me would look at me weirdly for paying for apps for a phone. Now it's normal that you pay for some apps and subscriptions on a monthly basis.
most of the things i use for development on windows/linux are open source by comparison whereas buying a macbook led me to spend 200 bucks on utilities. definitely feels like an apple tax
I disagree with this strongly. While it is the case in some instances, on macOS you often have to pay for the most basic of utilities, quality of life improvements, stuff like better window snapping and unarchivers etc. Things that are no worse on Linux. You even have to pay for a decent file manager on macOS and it usually still doesn't come close to Dolphin, which is a pure joy to use on Linux, while still being free software.
I think it's more to do with the (lack of) ideology when it comes to macOS developers, as in, they don't feel strongly about advancing free software etc. even if they grew up on it, they see software development as a job like any other, to make money from and nothing more. Am not saying it's an illegitimate view, but dressing it otherwise is I think not accurate.
This is exaggeration. You're overselling linux but underselling macOS. It's not terrific in every aspect (window snapping being one) but you don't have to pay for every basic utilities on mac. Finder is reasonable. Preview supports a lot of file formats and even allows PDF stitching (few platforms support this out of the box). Keka is a free unarchiver for macOS. Karabiner is a free tool for remapping keyboard keys. Homebrew. iTerm. IINA. Compared to Windows, macOS support a lot more out of the box.
> You even have to pay for a decent file manager on macOS and it usually still doesn't come close to Dolphin, which is a pure joy to use on Linux,
You're conflating expectations. A vast majority of people are using the file manager for basic stuff. Not everyone needs a feature packed one for day to day operations. If they need one, Commander One is free.
> (lack of) ideology when it comes to macOS developers, as in, they don't feel strongly about advancing free software etc.
This is cynical. I see plenty of developers on mac or developing for mac using it to contribute to open source projects. Just because it's not translating into free and open source consumer-facing projects on macOS does not imply that devs do not care about open source. In fact most of the important projects put instructions for developing on and for macOS first.
From what I've seen, people on macOS are mostly paying for software like BetterTouchTool, Alfred, Keyboard Maestro, Hazel, Carbon Copy Cloner, Ulysses. Software which extends the core OS in a set of ways fitting a myriad set of needs - not for basic stuff. Few of these have convenient or easy to use alternatives on other platforms. People are paying for options, convenience and polish.
> You're overselling linux but underselling macOS.
I use both platforms daily and while I agree that macOS has more 'polish' in terms of being more uniform, I don't think am overselling that there are many tools on Linux for which I have to pay on macOS to get similar capabilities.
> You're conflating expectations. A vast majority of people are using the file manager for basic stuff.
Right and there are many basic file managers for Linux too, but there are also advanced ones that you don't have to pay for, which was my point.
> Finder is reasonable.
Agree to disagree.
> I see plenty of developers on mac or developing for mac using it to contribute to open source projects. Just because it's not translating into free and open source consumer-facing projects on macOS does not imply that devs do not care about open source.
Perhaps I worded this poorly, but I meant macOS developers as in Swift/ObjC/Cocoa, not developers in general who happen to be using a Mac. So yes, I meant those developing customer-facing software specific to the platform, not say webdevs on a Mac. There's many open-source libraries sure, but that's because of convenience. When it comes to customer-facing apps, it is nowhere near Linux level and given the many more devs on the platform that speaks for something.
> From what I've seen, people on macOS are mostly paying for software like BetterTouchTool, Alfred, Keyboard Maestro, Hazel, Carbon Copy Cloner, Ulysses.
Right, and my point is that on Linux utilities akin to BetterSnapTool, Alfred, Keyboard Maestro tend to be free software and not particularly worse in terms of polish.
I see some convenience value in a tool like Ulysses, even if Org-mode could be used to achieve similar results, I don't see the value in utilities like BetterSnapTool and PDF Expert, since there's no extra polish that's not available on Linux as free software.
LauchBar created in 1996 for NeXT pre-dates both QuickSliver and Mac OS X. LaunchBar was one of the first utilities I installed on the OS X beta and originated the use of cmd-space as the launcher shortcut
If you're talking strictly developer tools, I have GitUp and Hex Fiend in my Dock right now. If you stray out further into productivity tools, I have Hammerspoon, Jumpcut, Karabiner-Elements off the top of my head; on the command-line side MacPorts brings me many cross-platform tools.
I was going to mention macports. As an aside, I still don't understand why folks suddenly decided homebrew was "it", when macports already does the job so we'll.
I don't see many MacOS-specific developer tools in general. Command line tools are portable, at least between Unices, and often even beyond that. Going back to the MPW...
Nowadays even IDEs aren't platform-specific anymore, more often than not.
I'm way more inclined to use something on a daily basis that I pay for to be honest as this means I have some kind of influence on how long the project will be around that I incorporate in my workflow. At least a little bit more than if I use a free product.
I don't mind paying for quality software and I think a lot macOS users feel the same way.
To be fair, you can usually donate to free software as well, it's just that people seem to be less inclined to do so vs straight up paying for a proprietary one, sadly.
macvim and macports come to mind.
But I guess the "developer tools" space is pretty restricted anyway, most of it is editors and command line stuff (compilers, interpreters etc) which is often free in this era.
I have used iina myself. I was very fond of smplayer in linux and windows and iina is very similar in a lot of ways. I like to drag forward with keyboard shortcut and iina/mpv does that well. VLC makes a screeching sound with each drag. And per file position reminder is fabulous for breaks in watching a media.
Unfortunately the last pre 1.0 was giving error from Cylance on libuchardet.0.dylib. Anyone has any idea on that?
Fork is a great Git GUI with a very "Mac-like" interface (also available for Windows): https://git-fork.com
I use it for some git operations when I would be slower on the command line, and I can highly recommend it. The UI is very polished! Bonus: I can open it from the command line with a simple "fork" command.
I haven't really used any of the other clients long enough to give you a solid answer.
For me, Fork just works, I can scroll through the commits easily, file trees are available as a tab for each commit. The UI is very easy to use and discoverable, that's why I like it.
You should also give Sublime Merge a go. I'm mostly a CLI git user, but Sublime Merge is so lightweight (and intuitive to someone who knows git), it's had me using it quite a bit.
That's just a subset of what I saw scanning my /Applications, and I don't specifically look out for replacing existing software with free (whether freedom or beer) applications.
Adium is basically abandoned and cyberduck has always been a clusterfuck by virtue of being a Java app. As such the UX is terrible. If I'd paid for either I'd want my money back.
Mac's third party app lineup is just so much better than Windows in my opinion, I don't care what OS to use but not going to leave Mac because of them.
Windows culture of free but mediocre or good but bloated and expensive never really hits the right spot.
Honestly, I really enjoyed using Sequel Pro but I __had__ to switch to DBeaver because it constantly kept crashing for me. Maybe I'll have to give it another shot.
I had used Navicat for years on my old iMac, but when I got my new MacBook Pro as my secondary development machine and went to get another licence for it, I was shocked at the current pricing. I am certain I only paid about $50 for a licence years back. When I downloaded the latest version it was something like 25x the price!!
Don't get me wrong - Navicat is a great MySQL/MariaDB client, but I wasn't going to stretch to that price. I hunted around and found Sequel Pro, which meets my needs to a 't' and probably has a slicker interface.
Naturally being native does not sort out everything if not coded properly.
The difference being that native solutions have better tooling to handle such cases, one just needs to actually learn how to use them.
In a future where Worklets and WebComponents with virtual tables are a standard browser feature, similar approaches can be done in the browser as well.
Sequel Pro is one of the few reasons why I used to be really, really envious about Mac users, as a Linux user (now I don't work with MySQL anymore).
I've never seen any SQL GUI even come close.
Me and my colleagues have benefitted greatly from Sequel Pro over the years. Recent Mojave complaints aside it's been close to perfect. It's eye opening to think we have paid nothing. Maybe companies should look into implementing 1% turnover to OSS. I'm guessing having bi-annual company votes about how to distribute the funding, and communicating this in the recruitment process might offset some/all of the cost.
169 comments
[ 2.9 ms ] story [ 208 ms ] threadBasically every top result mentions this. It's not a secret. :)
That coupled with a lack of other RDBMS support has forced me to transition to other tools like DataGrip.
edit: oh I derped there. I didn't follow the link before I commented and once I did I noticed they're subscription based :\",
Obviously phpMyAdmin is a tire fire.
I’m still looking for a good macOS-native client similar to Sequel Pro. Bonus points if it has a usable iPad version.
Ouch, that is a bit pricey for one person with multiple computers, especially if the annual upgrade fee is also per computer. It makes me wonder if the licensing is tied to the motherboard / MAC address too, which is a pain when repairs happen.
On the other hand, I'm really glad to see a developer charging a sustainable price for their product.
"If you want to use TablePlus on multiple devices you need to add more seats to your license. The number of seats is the number of devices you can log in to at the same time" https://tableplus.io/order/extend-seats
So I took that to mean that I can have it on multiple machines, I just can't use them at the same time - which is fine, I can use my laptop or desktop depending on where I am.
And I'm guessing it was more than DBeaver became popular and everyone felt like it was worth getting some free traffic to help boost sales.
please note that i am talking about SSH certificate, not SSL certificate. https://ef.gy/hardening-ssh
[0] https://github.com/sequelpro/sequelpro/issues/3116
https://sequelpro.com/test-builds
Will try the test build.
TablePlus has been great.
With that recent addition, it's been able to completely replace Sequel Pro and Postico for Postgres management
https://github.com/sequelpro/sequelpro/issues/3037#issuecomm...
Some of what I can do in there feels like magic.
I'm sure people cry and scream for going paid but seeing this disappear with lack of recent MySQL version support and likely never support any other DB looks pretty sad too.
MacOS High Sierra was the worst upgrade for me. The APFS update borked my laptop and they dropped support for the integrated raid card from my 2010 Mac Pro.
(Though I've since bought a Windows laptop & I haven't found a Sequel Pro equivalent for Windows yet.)
The latest release was a rewrite and they're still sorting out problems but every incremental update brings it closer to how great the previous version was.
I personally can’t think of anything beyond iTerm (utility), Homebrew (utility), ...aaand that's where my list ends.
Quicksilver, while at the time a terrible mess in terms of the code is basically the forefather of all these launchers.
Apple also removed a lot of the MacOS APIs that allowed you to mod system components (e.g. input managers) around the same time.
If you didn’t care about user experience (or didn’t think it was better) and just wanted to save money, why would you ever get a Mac anyway?
I think it's more to do with the (lack of) ideology when it comes to macOS developers, as in, they don't feel strongly about advancing free software etc. even if they grew up on it, they see software development as a job like any other, to make money from and nothing more. Am not saying it's an illegitimate view, but dressing it otherwise is I think not accurate.
> You even have to pay for a decent file manager on macOS and it usually still doesn't come close to Dolphin, which is a pure joy to use on Linux,
You're conflating expectations. A vast majority of people are using the file manager for basic stuff. Not everyone needs a feature packed one for day to day operations. If they need one, Commander One is free.
> (lack of) ideology when it comes to macOS developers, as in, they don't feel strongly about advancing free software etc.
This is cynical. I see plenty of developers on mac or developing for mac using it to contribute to open source projects. Just because it's not translating into free and open source consumer-facing projects on macOS does not imply that devs do not care about open source. In fact most of the important projects put instructions for developing on and for macOS first.
From what I've seen, people on macOS are mostly paying for software like BetterTouchTool, Alfred, Keyboard Maestro, Hazel, Carbon Copy Cloner, Ulysses. Software which extends the core OS in a set of ways fitting a myriad set of needs - not for basic stuff. Few of these have convenient or easy to use alternatives on other platforms. People are paying for options, convenience and polish.
I use both platforms daily and while I agree that macOS has more 'polish' in terms of being more uniform, I don't think am overselling that there are many tools on Linux for which I have to pay on macOS to get similar capabilities.
> You're conflating expectations. A vast majority of people are using the file manager for basic stuff.
Right and there are many basic file managers for Linux too, but there are also advanced ones that you don't have to pay for, which was my point.
> Finder is reasonable.
Agree to disagree.
> I see plenty of developers on mac or developing for mac using it to contribute to open source projects. Just because it's not translating into free and open source consumer-facing projects on macOS does not imply that devs do not care about open source.
Perhaps I worded this poorly, but I meant macOS developers as in Swift/ObjC/Cocoa, not developers in general who happen to be using a Mac. So yes, I meant those developing customer-facing software specific to the platform, not say webdevs on a Mac. There's many open-source libraries sure, but that's because of convenience. When it comes to customer-facing apps, it is nowhere near Linux level and given the many more devs on the platform that speaks for something.
> From what I've seen, people on macOS are mostly paying for software like BetterTouchTool, Alfred, Keyboard Maestro, Hazel, Carbon Copy Cloner, Ulysses.
Right, and my point is that on Linux utilities akin to BetterSnapTool, Alfred, Keyboard Maestro tend to be free software and not particularly worse in terms of polish.
I see some convenience value in a tool like Ulysses, even if Org-mode could be used to achieve similar results, I don't see the value in utilities like BetterSnapTool and PDF Expert, since there's no extra polish that's not available on Linux as free software.
I just like that Sequel Pro isn't electron based like so many dev tools are these days.
Nowadays even IDEs aren't platform-specific anymore, more often than not.
I don't mind paying for quality software and I think a lot macOS users feel the same way.
[1] https://iina.io/
Unfortunately the last pre 1.0 was giving error from Cylance on libuchardet.0.dylib. Anyone has any idea on that?
I use it for some git operations when I would be slower on the command line, and I can highly recommend it. The UI is very polished! Bonus: I can open it from the command line with a simple "fork" command.
For me, Fork just works, I can scroll through the commits easily, file trees are available as a tab for each commit. The UI is very easy to use and discoverable, that's why I like it.
That's just a subset of what I saw scanning my /Applications, and I don't specifically look out for replacing existing software with free (whether freedom or beer) applications.
Neither of these are freeware?
Windows culture of free but mediocre or good but bloated and expensive never really hits the right spot.
I had used Navicat for years on my old iMac, but when I got my new MacBook Pro as my secondary development machine and went to get another licence for it, I was shocked at the current pricing. I am certain I only paid about $50 for a licence years back. When I downloaded the latest version it was something like 25x the price!!
Don't get me wrong - Navicat is a great MySQL/MariaDB client, but I wasn't going to stretch to that price. I hunted around and found Sequel Pro, which meets my needs to a 't' and probably has a slicker interface.
A table view, a tree view, few buttons, some dialogs.
I have no love for Electron. Still remember Active Desktop, MSHTML, XUL and Symbian Web Runtime.
As someone that does both native and Web fullstack, the place for Web technologies is on the browser, with approaches like PWAs.
The difference being that native solutions have better tooling to handle such cases, one just needs to actually learn how to use them.
In a future where Worklets and WebComponents with virtual tables are a standard browser feature, similar approaches can be done in the browser as well.
https://github.com/ohwgiles/sequeljoe
Still, it's light years behind Sequel Pro in terms of features/completeness/quality and probably always will be :)