Sequel Pro – Open source macOS native MySQL GUI client
sequelpro.com
sequelpro.com
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.
please note that i am talking about SSH certificate, not SSL certificate. https://ef.gy/hardening-ssh
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.
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.
Now I’m using TablePlus which is a great paid client ($50 I think) and I love it.
I really hope in the new era, we can have paid open source tools with some bounties for important bug fixes and UX improvements.
That seems to be a very sustainable way to develop great software.
Seconded.
I inherited an old MySQL/Java system and SequelPro was invaluable to understanding how it worked and keeping it running. At least until I added a view to the schema, the export/import facility was also very effective at taking and restoring snapshots of the database state. I could connect it to production, pull down an exported SQL script and then restore exactly that state to another environment. (Including local.)
(And given that it ran in OSX, it also had a plausible subset of Emacs keybidings too. :-) )
Do you know how TablePlus clients compare on Windows and Mac? Been wondering since they're both built natively instead of using cross platform development like Electron.
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.
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.
Such a great client!!!
After trying a few like MySQL Workbench and Navicat, I landed on Querious and haven't looked back since. It's not free in either sense of the word but well worth the ~$50 USD license IMO.
Interface-wise I found it to be easier/more familiar to switch to from Sequel Pro, as compared to some of the alternatives mentioned above - more on the light and nimble side, less on the heavy interface enterprisey-feeling side if that makes sense.
It's Mac native, performant, and very stable. Some very basic features that felt like a big upgrade from Sequel Pro:
- Arbitrary WHERE clause support in the data view, so you don't need to switch to a full manual query as soon as you need slightly more complex conditions
- Multiple query tabs - I used to spawn multiple Sequel Pro instances because this was so hard to live without. There's also good management of query history and saved queries.
- Robust and performant import/export tools
No affiliation with the developer, just wanted to give a shout-out to a high quality piece of software that I've really appreciated using.
It’s a wonderful Mac app. I love the interface. And yes the WHERE clause in the view is amazing.
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 :\
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.
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.)
I've mainly used it from a "let's go in and see what's going on in the database" perspective, and it's been great for that.
I wish I had the same thing for Oracle and sql server.
It crashes on Mojave, but only when closing it so it's more an annoyance than a problem (and the fix is in the works).
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.
This is how you brand something.
https://github.com/ohwgiles/sequeljoe
Still, it's light years behind Sequel Pro in terms of features/completeness/quality and probably always will be :)
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.