Jonathan Kamens 86 47Mar 16

It should not be this hard to run SQL queries on some data

I had to push my way through 13 barriers to success to do this seemingly simple thing.

https://blog.kamens.us/2026/03/15/it-should-not-be-this-hard-to-run-sql-queries-on-some-data/
#TechIsShitDispatch #LibreOffice #PostgreSQL #pgAdmin #HSQLDB

It should not be this hard to run SQL queries on some data

I had to push my way through 13 barriers to success to do this seemingly simple thing.

Something better to do
Show threadMatt Zagaja
@jik try TablePlus https://tableplus.com. Much better than any other DB GUI I’ve used especially for Postgres.
TablePlus | Modern, Native Tool for Database Management.

Modern, native client with intuitive GUI tools to create, access, query & edit multiple relational databases: MySQL, PostgreSQL, SQLite, Microsoft SQL Server, Amazon Redshift, MariaDB, CockroachDB, Vertica, Cassandra, and Redis.

Mar 16 at 12:15pmIvory for iOS
Show threadJonathan Kamens 86 47Mar 16
@mzagaja nice, but was trying to solve this with open source
Show threadMatt ZagajaMar 16
@jik fair enough. if you want to futz with CLI my OSS go to is dump to CSV and use CSVkit (or the Rust equivalent XSV, though less features). Would love if more OSS folks were as passionate about GUI as they were about TUI but think it’s a function of the habitat they (we?) all work in most of time.