Is there a gui client that can do both "normal" databases (like postgres and oracle) and Hive or Presto?
If you add the hive jdbc fat jar, Datagrip can talk to Hive server 2
HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
61–70 of 94 posts
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#62So what's the best x-platform SQL client these days?
Can only say 10000 good things about DataGrip
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#63One of my favorite features of HeidiSQL is its "Find text in database", see https://www.heidisql.com/forum.php?t=1006 It'll search through all text fields of all tables of whichever database you specify for a given string, and displays a nice per-table summary for each matching record. I haven't found anything like this in any other DB client.
SQL Workbench/J has this feature[0]. I often use this feature when someone asks me questions about a report and I don't have a clue which tables that data comes from. Just search the database.
[0]https://www.sql-workbench.eu/manual/dbexplorer.html#table-se...
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#64So many people sleeping on DB Visualizer. It’s been around forever, can connect to anything with a JDBC driver, has a ton of features, and is updated frequently. My favorite is the ability to quickly full text search any query I’ve ever run.
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#65This has been around a long time. I used to use it when working with DBs in awkward places, like RDP accessed Windows servers. Since it doesn't require an install, it was handy to just put it on a shared local folder and run it from there on the remote server.
Never had any real complaints but it wasn't anything I'd used for regular work. I tend to prefer using the DB plugins in IntelliJ IDEA Ultimate or, if they aren't great, then something specific to the DB at the time.
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#66For working with MySQL on Mac, I really enjoy Sequel Pro [1]. Full native (and kinda old-skool, if you dig that kinda thing) Mac experience/design. Works fast. Is free. [1] https://sequelpro.com
I use Sequel Pro almost daily, pretty damn good, and you can't complain about the price :)
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#67One of my favorite features of HeidiSQL is its "Find text in database", see https://www.heidisql.com/forum.php?t=1006 It'll search through all text fields of all tables of whichever database you specify for a given string, and displays a nice per-table summary for each matching record. I haven't found anything like this in any other DB client.
There's an extension for SQL Server Management Studio that does it (MSSQL) as well. I don't think it's really recommended for prod DBs though.
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#68Oh! This is still a thing? Cool! I lost track of it when I switched over to Linux.
Re: HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
#69For working with MySQL on Mac, I really enjoy Sequel Pro [1]. Full native (and kinda old-skool, if you dig that kinda thing) Mac experience/design. Works fast. Is free. [1] https://sequelpro.com
I use Sequel Pro almost daily, pretty damn good, and you can't complain about the price :)
I used the regular Sequel Pro for years but just recently switched to the nightly version, which usually it's stable and has more updates. I recommend the switch to nightly. They share the same DB configurations you have created, so no need to worry that you have to import/export.