A software engineer trying to build stuff and helping people in open source. I like beers, sunny beaches and JavaScript but I also fiddle around with a lot of other languages and tools.
Recently discovered Beekeeper Studio, it is Open Source and free. Based on Electron and Vue.js it is cross-platform which is super nice. On top, it works with most SQL dialects. Personally, I mostly use PostgreSQL in my personal projects so this is just perfect and so much better than pgAdmin.
For work, I use Datagrip since the license is provided. The most used feature there is probably the copy rows as CSV, JSON, or similar. That is the deal breaker there. Hoping Beekeeper introduces this feature as well.
I uninstalled it immediately coz the tables were not being shown. I commented on one of the posts of Beekeeper on Twitter but got no response. What a horrible experience from both software and its twitter. twitter.com/beekeeperdata/status/1...
Would love too add mongo support, but I'm not a current mongo user, and feels like it deserves some real work to figure out how to display mongo data in a way that works well.
So probably not for a little while I guess? If you have ideas on what results should look like for mongo data please take screenshots and make an issue! It will help me a lot when I build the feature.
Tech Lead/Team Lead. Senior WebDev.
Intermediate Grade on Computer Systems-
High Grade on Web Application Development-
MBA (+Marketing+HHRR).
Studied a bit of law, economics and design
Location
Spain
Education
Higher Level Education Certificate on Web Application Development
I love Workbench too, for PostgreSQL I do not really use a GUI. But then again a typical Django/Laravel/Rails etc admin is a GUI and I have made plenty of those.
Currently I am building a GUI for databases that does not need/mention SQL and builds all queries for you behind the scene. Here is the product and its source on GitHub.
Sequel pro and beekeeperstudio both are good. Sequel Pro has now a days some crashing as it is not very actively maintained but still one of the best guis I know. Beekeeperstudio is relatively new but they have a good pace and bring up new features quite quick.
For SQLite, I remembered it was SQLiteStudio, but it seems that the website has updated. (I also remembered that it was never first results on Google...)
I also remembered that DBeaver did its job well, for multiple kinds of RDBMS, based on JDBC.
Since I use MongoDB Atlas, I rarely use Compass, (but I need it sometimes, especially outside Atlas).
I love people and everything good. And I want to positively influence people and be influenced by positive people. I am in love with software development using .NET Technologies.
B.A. in Economics!
Breaking things apart to see how they work!
Passionate about linear algebra, probability, statistics.
Big fun of Python and Mathematica.
Datagrip from JetBrains is by far the best IDE for databases. It can't be compared with a other tools available in the market... Datagrip, then 5 empty places, then any other tool.
A Senior Developer working mostly with PHP and JavaScript, with a bit of Python thrown in for good measure, all on Linux. My tooling is simple, it's GitLab and JetBrains where possible.
Recently discovered Beekeeper Studio, it is Open Source and free. Based on Electron and Vue.js it is cross-platform which is super nice. On top, it works with most SQL dialects. Personally, I mostly use PostgreSQL in my personal projects so this is just perfect and so much better than pgAdmin.
For work, I use Datagrip since the license is provided. The most used feature there is probably the copy rows as CSV, JSON, or similar. That is the deal breaker there. Hoping Beekeeper introduces this feature as well.
👋 Beekeeper Studio creator here. We have download table as CSV/JSON, but not copy rows. Like that idea. I'll add it to the feature requests :-)
I uninstalled it immediately coz the tables were not being shown. I commented on one of the posts of Beekeeper on Twitter but got no response. What a horrible experience from both software and its twitter. twitter.com/beekeeperdata/status/1...
Don't disclose issues through twitter, please.
Wow ! Congratulations. An amazing tool. I didn’t know it, so I will install and checkit
Beekeeper studio is my favorite one!!!
Please consider add MongoDB support
Also... Way don't add hacktoberfest lable to the issues? 🔥🔥🔥
Would love too add mongo support, but I'm not a current mongo user, and feels like it deserves some real work to figure out how to display mongo data in a way that works well.
So probably not for a little while I guess? If you have ideas on what results should look like for mongo data please take screenshots and make an issue! It will help me a lot when I build the feature.
Datagrip would be my Choice for SQL if had a license. It tried it once and it really works well.
I wouldn't mention the Electron part if you want to drive people in, not out. Electron apps are cancer.
But back to the topic, I vote DataGrip as well.
For MySQL, PostgreSQL and Oracle I use DBeaver =)
me too
I love DBeaver and that it can generate entity relationship diagrams.
+1 for DBeaver.
Their cloud/web version is awesome.
I like Datagrip from Jetbrain for any kind of DB engine
I love Workbench too, for PostgreSQL I do not really use a GUI. But then again a typical Django/Laravel/Rails etc admin is a GUI and I have made plenty of those.
Currently I am building a GUI for databases that does not need/mention SQL and builds all queries for you behind the scene. Here is the product and its source on GitHub.
Sequel pro and beekeeperstudio both are good. Sequel Pro has now a days some crashing as it is not very actively maintained but still one of the best guis I know. Beekeeperstudio is relatively new but they have a good pace and bring up new features quite quick.
There is a fork of Sequel Pro which is actively maintained: github.com/Sequel-Ace/Sequel-Ace
Beekeeper and DBGate
Thanks for the insight, zakaria 👍💯✨
For SQLite, I remembered it was SQLiteStudio, but it seems that the website has updated. (I also remembered that it was never first results on Google...)
I also remembered that DBeaver did its job well, for multiple kinds of RDBMS, based on JDBC.
Since I use MongoDB Atlas, I rarely use Compass, (but I need it sometimes, especially outside Atlas).
I use Atlas too, but find Compass to be way faster and more intuitive, those are the main reasons I use it 👍
I like Navicat if I don't have to pay for it and TablePlus if I do. Both work with whatever DBMS you are looking to use it with.
For me, Sequel Pro and good old phpMyAdmin
Hope you're using the nightly build of Sequel Pro. If not you should consider switching to Sequel Ace.
Perks:
Just the plain build haven't seen Sequel Ace, but let me give it a try
Oh, good days with phpMyAdmin 😉 Got the job done still 👍👌
100% it's maybe something I'm just used to, but it works
For MongoDB I use NoSQLBooster. What I appreciate is:
;)
For MySQL, PostgreSQL, SQLite , MS SQL and MongoDB you can try DbGate. I am DbGate creator
Thnaks for sharing this tool 😉👍
Personally I love DataGrip from JetBrains.
I prefer dbForge Studio for MySQL. It is an ultimate IDE for MySQL and MariaDB database development, management, and administration.
Thanks for insight 🙏❤
Heidi SQL
Compass for MongoDB and Valentina Studio for postgresql.
I need to pick up a great GUI for PostgreSQL, added to the list 😉 Thanks! 👌
MySQL Workbench and DBeaver.
For PostgreSQL I use Admin.
For MySQL the Workbench.
Datagrip would be in there but at the moment I got no license.
dbdiagram.io for database design and Tableplus to connect to almost any database engine.
IntelliJ ultimate all the way
Compass for Mongodb 👍
Love it too, great tool 👍👌
Querious for MySQL, and TablePlus for SQLite. TablePlus supports other databases (including MySQL), but for some reason I just use it for SQLite.
nosqlbooster for mongo.
was using navicat before that.
I use Sequel Pro and Postico 🤟
beekeeperstudio.io/ this is my favourite
Inise robo3t for mongodb.
Mysql workbench for mysql. But reading comments I didnt know Beekeeper. So i will install it
Azure Data Studio.
JavaFX, Java swing, MySQL
DataGrip is better db tool
I'm using workbench mostly to db design, and Sequel Pro for operations.
For work connecting to MS SQL I use Azure Data Studio.
Otherwise I mainly use CLI tools.
DrawERD with mysql & postgresql support
Datagrip from JetBrains is by far the best IDE for databases. It can't be compared with a other tools available in the market... Datagrip, then 5 empty places, then any other tool.
MongoDB Compass
HeidiSQL(window), Sequel Ace(Mac) for MySQL, NoSQL Booster for MongoDB
DataGrip by JetBrains. It lets me work with several database types in one easy tool. Fewer things to update, and fewer shortcuts to remember
I mainly use TablePlus with PostgreSQL.
I like it because it is native, fast and beautiful.
Mongo -> Robo 3T
Redis -> Redis Desktop Manager
MySQL/Postgres -> DBeaver or Sequel Pro (depending on complexity of what I need to do).
I like mongodb, it's cool
Dbeaver for mysql and postgress
Toad for oracle
MYSQL Workbench & HeidiSQL are my favorites.
When the Database is very simple i use HeideSQL, otherwise i use HeidiSQL
I like DBeaver but v7.2 have a problems with oracle connection.