HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL
heidisql.com
heidisql.com
I still experience bugs from time to time. But it's improving.
The repo doesn't show releases, but the heidisql.com site has nightly builds done directly from the master branch.
Can vouch for it, one of the best experiences with enterprise modelling tools.
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.
[0]https://www.sql-workbench.eu/manual/dbexplorer.html#table-se...
[1] https://www.dbvis.com/features/software-screenshots/
[2] https://www.dbvis.com/images/features/screens/chart3.png
Jetbrains Datagrip is popular too, more intelligent but less DBs than DBeaver: https://www.jetbrains.com/datagrip/
If you want a web-based tool, especially for Postgres, then OmniDB is a good choice: https://www.omnidb.org/en/
DBeaver has support for many databases through JDBC.
First saw it here.
[0]http://squirrel-sql.sourceforge.net/ [1]https://www.sql-workbench.eu/
https://www.valentina-db.com/en/
it work well. Even work with Sql Server on osx!
create function...
"""
declare some string "'"this string"'" int
"""
end;
The cross-database client didn't support or comprehend $$ escaping, so the people who wrote everything had no choice but the write with loads of quotes everywhere. I didn't realize this, so I passed some code back to them and they couldn't run it at all.
The client-specific programs are all optimized to the RDMS you are using, so I never was able get on board with these products.
Plus, I can update single column field from the query result by double clicking it.
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.
HeidiSQL is hands down the best SQL client I've used.
https://www.mysql.com/products/workbench/
But in 90% of cases, I do find that the cli sql client for your DB of choice is sufficient.
I've used both, and they're both good.
Of course, it only disallows the downloads via clicking the link. Easily circumventable.
I'm only here for a serious discussion.
Recently tried workbench after a year or 2 again; was enjoying some new features, but the lack of OSX dark theme support is hurting usability, some parts of UI and or texts are simply unreadable. I hope they sort that soon. Workbench is not one of many that supports connections over ssh native, which is nice as i hope non of the folks here run interfacing databases :). The performance analyses tab is quite neat, saves me a lot of manual query logging and plowing through that to find bad queries.
After having trouble with workbench, Using PHPStorm I was able to export a whole database to a file per table in one go and both TSV/CSV are supported. I found my resultant CSV files to be reliably escaped.
a) truncation of data b) removal of line breaks c) not escaping enclosing values, ex. " as "" d) using \n or other values in place of actual line breaks or tabs e) using \N for NULL values (which isn't too bad, but it would be nice to be able to configure this) f) in general not complying with https://tools.ietf.org/html/rfc4180
You're right, there is no standard that I'm aware of, though the answer to those first two questions could well be a proxy for a de facto standard in practice.