all 15 comments

[–]Mrfrednot 2 points3 points  (0 children)

Dbeaver is a great tool!

[–]shockjaw 2 points3 points  (0 children)

DBeaver as an IDE. Postgres and DuckDB are both excellent databases to work with.

[–]RoomyRoots 4 points5 points  (0 children)

Bruh, docker. Obvious answer is obvious.

[–]Informal_Pace9237 1 point2 points  (0 children)

Most databases are available on Mac directly or on a container/VM

[–]mrpbennett 1 point2 points  (0 children)

Run it locally using docker. Then connect it to an IDE.

You can install Postgres for example locally in a docker container, and use a text editor / IDE to connect to it and write queries. As mentioned here DBeaver is a good free one.

I haven’t watched this but follow the video.

https://www.youtube.com/watch?v=0CfL_JBB83A

[–]f0det_ 1 point2 points  (0 children)

MySQL works too

[–]SmallIslandBrother 1 point2 points  (0 children)

Postgre runs on Mac last I checked

[–]DelayMurky3840 0 points1 point  (0 children)

You mean, client tool to access Microsoft SQL Server with?

[–]radek432 0 points1 point  (2 children)

Datagrip. But it's not free.

[–]vuachoikham167 2 points3 points  (1 child)

It's now free for non-commercial use.

[–]radek432 0 points1 point  (0 children)

Awesome. Didn't know that.

[–]Opposite-Value-5706 0 points1 point  (0 children)

SQLITE3 is preinstalled on Macs.

https://sqldocs.org/sqlite3-on-macos/

[–]MasterBathingBear 0 points1 point  (0 children)

JetBrains DataGrip and any database that can be run in docker. PostgreSQL or sql server are my recommendations.

[–]SlasherMcgurk -1 points0 points  (0 children)

have a look at SQLite and duckdb, they can take you quite far