squawk VS beekeeper-studio

that is definitely the goal, both a formatter and a linter. we want to add something like squawk directly to the language server, so you get eslint-like dx. with the ast and the database schema in the data model, you can basically add any rule you like.

[0] https://github.com/sbdchd/squawk/tree/master

> I wish there were ways to enforce this on the db so you never accidentally grabbed a table lock during these operations.

You can use a linter for PostgreSQL migrations https://squawkhq.com/

We've had good success with https://github.com/sbdchd/squawk to lint migrations. It tells you if a query is going to lock your table (as long as it's written in SQL, not some ORM DSL)

If we access a client like PgAdmin or Beekeeper, or accessing its container via bash and checking via CLI, we can see that the table was created successfully:

This tool doesn't let you run SQL queries or create tables. SchemaSpy describes and visualizes an already-created database.

To work directly with SQL, I recommend https://www.beekeeperstudio.io/ or https://dbgate.org/

I use the free “community” edition daily: https://github.com/beekeeper-studio/beekeeper-studio/release...

postgres has some cool tools these days. postico if you are on macos or my personal fav lately has been https://www.beekeeperstudio.io/

Beekeeper Studio is a modern (aesthetic) and lightweight SQL client that supports MySQL, Postgres, SQLite, SQL Server, etc. It is available on Linux, Mac and Windows.

I'm trying to renew my certificate for Beekeeper Studio, 3 years ago it was a simple download, but now it costs 3x the price and they want to ship me a physical device with the private key on it.

`cask "beekeeper-studio"` [link][oss] for anything database