20 ms·
Sequel Pro – Open source macOS native MySQL GUI client
- pensatoio 8y agohttps://www.google.com/search?q=best+sql+client+for+mac https://www.google.com/search?q=best+sql+client+for+mac Basically every top result mentions this. It's not a secret. :)
- chrisseaton 8y agoNobody said it was a secret?
- sfcguyus 8y agoFinally, a tutorial on how to use Google. I've always been looking for one.
- mtnGoat 8y agoI have an up to date version running on an up to date macbook pro and it crashes every time I close a tab. Pretty annoying.
- CaliforniaKarl 8y agoHmmmmm, I'm curious, are you seeing the issue described at https://github.com/sequelpro/sequelpro/issues/3325 https://github.com/sequelpro/sequelpro/issues/3325 ?
- gouggoug 8y agoI do to. The latest Beta build does not have this issue though.
- digitalboss 8y agoDitto. 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.
- aphpdev 8y agoFYI, doesn't play nice with exporting/importing virtual columns. Had to switch to MySqlWorkBench.
- skunkworker 8y agoIs this project still alive? they haven't had an official release since 2016 though the commit history shows some recent but unreleased work. That coupled with a lack of other RDBMS support has forced me to transition to other tools like DataGrip.
- reaperducer 8y agoI liked the DataGrip tour, but I don’t believe in subscribing to software. Any other recommendations?
- krrrh 8y agoTablePlus.
- manigandham 8y agoJetbrains give you a perpetual license. The subscription is for updates.
- wishinghand 8y agoSomeone else in the comments said that Sequel Pro inspired them to make a Postgres compatible clone. edit: oh I derped there. I didn't follow the link before I commented and once I did I noticed they're subscription based :\
- jmagaro88 8y agoGreat app even though it crashes every time I close a window on Mojave.
- dylan604 8y agoI 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.
- tomaskafka 8y agoUse the test builds: https://news.ycombinator.com/item?id=18937589 https://news.ycombinator.com/item?id=18937589
- barkerja 8y agoI'm personally a big fan of TablePlus: https://tableplus.io https://tableplus.io
- usaphp 8y agoMe 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
- reaperducer 8y agoI 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.
- SyneRyder 8y ago> 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.
- Reedx 8y agoInteresting... did something happen today that there are 3 posts for db clients at the top of HN?
- threeseed 8y agoIt's a SQL client miracle ! 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.
- DonHopkins 8y agoDoesn't everybody always up and downvote stories just so related ones are next to each other? It sure seems like it.
- h1d 8y agoI thought you can't downvote a story but just ignore it.
- angott 8y agoIt 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.
- exabrial 8y agoUse the nightly
- zapzupnz 8y agoThe last thing I want to use when dealing with data is a nightly. Yes, I have backups; those are for rainy days, not my own recklessness.
- fluxsauce 8y agoFWIW 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.
- tomschlick 8y agoSame here. They really need to put out a release for it so people can auto update.
- larryzoumas 8y agoYeah 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 https://sequelpro.com/test-builds
- h1d 8y agoWhat is the reason for them from releasing a stable for years? Feels like it's dead without uncovering GitHub activities.
- yani 8y agoAs 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.
- h1d 8y agoCan 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.
- gdemers 8y ago:love:
- enahs-sf 8y agoGreat 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.
- yani 8y agoExactly my thought
- cenal 8y agoMojave 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.
- SyneRyder 8y agoYep, 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.)
- u02sgb 8y agoNot sure if it's feature equivalent but HeidiSQL was pretty good on Windows
- daveFNbuck 8y agoSequel Pro crashes when you close a tab in Mojave.
- M4v3R 8y agoI 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 :).
- 8y ago
- gdemers 8y agoGreat tool, would be nice to have INSERT / UPDATE table sql script generator.
- donatj 8y agoIt'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.
- mnm1 8y agoI 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.
- rahilsondhi 8y agoI 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 https://popsql.io)
- disiplus 8y agosequel Pro is better then pgadmin for me, but pgadmin is very usable
- Milner08 8y agoSequel Pro doesn't support PG though... Unless I have missed something? If you can tell me how to use it with PG I will be very happy :P
- vortico 8y agoOut 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.
- etu 8y agoWould 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.
- alpb 8y agoProjects 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.
- JimmyAustin 8y agoI 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.
- rjzzleep 8y agoIt used to be though. I think the freeware culture slowly moved away at 10.5 or so. Maybe that was accelerated by the app store release in 10.6. 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.
- dewey 8y agoI 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.
- kkarakk 8y agomost 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
- hammerton 8y agoHonestly, 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.
- cyberferret 8y agoThis is a nice client. 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.
- juddlyon 8y agoSeriously grateful for the app, I’ve used it (and maybe taken it for granted) for years. Does what it says on the tin.
- darkstar_16 8y ago3 SQL GUI tools (Sequel Pro, Dbeaver, HeidiSQL) on the front page at the same time. Has this happened before?
- pjmlp 8y agoAnd none of them Electron based!
- kowdermeister 8y agoYou know, Electron is perfect for these use cases: A table view, a tree view, few buttons, some dialogs.
- pjmlp 8y agoUntil you try to actually use more than demo data and need to resort to tricks to sort out unresponsive rendering. 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.
- jimmy1 8y agoSequel Pro's query dialog grinds to a screeching halt on my 2018 model MBP when there is more than 1500 lines of text in the box.
- pjmlp 8y agoNaturally 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.
- NietTim 8y ago
- rcarmo 8y agoThis looks amazing, and I wish I had something similar for Postgres (which is what I use for my own projects). Kudos!
- creativityhurts 8y agoCheck out Postico https://eggerapps.at/postico/ https://eggerapps.at/postico/
- deleted 8y ago[deleted]
- kowdermeister 8y agoIs this DB GUI day on HN? :) 3 clients on the front page is amusing.
- dasanman 8y agoThis is a great tool, I use it every day
- wink 8y agoSequel 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.
- amiga-workbench 8y agoI put up with mySQL workbench, its java based, clunky and unstable but very well featured.
- ogtifs 8y agoAfter a brief period working with macOS, I missed Sequel Pro when moving back to Linux. In the end I wrote Sequel Joe: https://github.com/ohwgiles/sequeljoe https://github.com/ohwgiles/sequeljoe Still, it's light years behind Sequel Pro in terms of features/completeness/quality and probably always will be :)
- zpe 8y agoMe 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.
- uberswe 8y agoIt's a great program and I have used it for years. I highly recommend it to everyone and the developers have done a great job. Currently it has a small bug which can be bit annoying where it crashes when opening and closing connections.
- anhthang 8y agoIt's my favorite MySQL/MariaDB GUI. I have to build by myself to use with the latest commit for a long time.
- pikzel 8y agoIt's ok. I mean, it's great that you put in all this time to give it away for free, but this is not where open source shines. This is lightyears behind professional SQL clients like SQL Server Management Studio (SSMS) - even compared to what SSMS was 10 years ago!
- dagaci 8y agoCan't comment on Sequel Pro yet, but even SSMS is in need of improvement.
- dna_polymerase 8y agoSequel Pro is the single app that makes me come back to OSX every now and then to work with my databases. This app for Linux would be so great. The official Oracle MySQL application for Linux is so unstable, it's mostly unusable for large databases. Never experienced such problems with Sequel.
- gerardnll 8y agoI thought they had released the new version... :( crashes on mojave are usual... I know they have fixed them in new builds, but I'm waiting for a stable release. Such a great client!!!
- nkkollaw 8y agoSequel Pro is by far the best SQL client I've ever used. It's really sad that it's available only for Mac. It's the only app I miss after having moved to Linux.
- wiradikusuma 8y agoThis is my favorite DB tool, but unfortunately it doesn't support MySQL 8 — https://github.com/sequelpro/sequelpro/issues/2699 https://github.com/sequelpro/sequelpro/issues/2699
- haydenkshaw 8y agoI ran into the same issue here too. They've fixed it in their nightly builds which I've found pretty useable: https://sequelpro.com/test-builds https://sequelpro.com/test-builds
- antoniotajuelo 8y agoGreat tool I have been using for many years!
- sameera_sy 8y agoGreat GUI for the DB! Far better than softwares like MySQL Workbench! It's simple and people totally like it!
- dep_b 8y agoIt has the best application icon ever. Just everything is right about it.
- whywhywhywhy 8y agoSo glad they haven't changed it, beautiful execution and the humor of it has made it instantly memorable even for a product that has a completely generic (but clear) name, googling "sql pancake icon" even gets you to the product. This is how you brand something.
- Pezmc 8y agoThank you for reminding me to appreciate this tool I've been using for years, just donated!
- pweezy 8y agoI used and loved Sequel Pro for years, but interface limitations and crashes finally set me off looking for a replacement after some stressful production debugging sessions. 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.
- h1d 8y agoI tried it years ago but is this still being developed actively?
- apple4ever 8y agoYes it is. They just released an update as recently as December.
- apple4ever 8y agoI was looking to see if anybody mentioned Querious. It’s a wonderful Mac app. I love the interface. And yes the WHERE clause in the view is amazing.
- mavfly 8y agoIt is nice it is true. But some time ago SequelPro was crashed on my Mac. Since then I moved to TablePluse. It is much more convinent for me. Contain everyting what I need and I can use for manage another types of database (Redis, Postgres, Mongo..). I highly recomend TablePlus.
- fragebogen 8y agoIs it open source as well?
- mavfly 8y agoUnfortunately not. But it is worth the price. You can try with free version but it is limited.
- jmull 8y agoThis is a really nicely done client. 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).
- eikeland 8y agoWhich crashes every time you close a tab... Otherwise it's an awesome mysql client.
- risfriend 8y agoHave been using this one for years. A rare for a mac only app being leaps better than non-mac apps for similar use.
- mproud 8y agoHasn’t been updated in forever, has me very concerned.
- nojvek 8y agoSequelPro is amazing and I used it for many many years. 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.
- mschaef 8y ago> SequelPro is amazing and I used it for many many years. 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. :-) )
- wtroughton 8y agoI love SequelPro but I've been thinking about switching to TablePlus from SequelPro for quite some time since SequelPro isn't available on Windows / Linux. 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.
- freakynit 8y agoBeen using this for years now. Im hooked to it. That simplicity and functionality. Wow!!! Way better than than MySQL Workbench for most of the daily needs.
- nvahalik 8y agoI used Sequel Pro for years but just recently switched to Querious.