Clojurians Log v2

DataGrip integrated into IntelliJ IDEA Ultimate. There's also https://database-client.com/ for VSCode. And a standalone https://www.dbvis.com/ that I used to use at some point.

I think I also used https://dbeaver.io/ in the past, but can't recall any specifics.

Thanks! dbvis looks nice, the only problem is that I have to install it manually.

OK, let me install database client and other vscode extensions and see how they goes, thanks!

Not sure what you mean by "install manually". :) Everything has to be installed, one way or another. Or "installed" - by just extracting a .tar.gz archive or something like that.

Yeah, you're right, everything has to be installed somehow. By "install manually", I mean I need to download it from the website and then "install" it. Ideally I can install it from the system repo with just one command in the terminal.

I like Azure Data Studio as well, if you happen to be a VSCode user it has the same UI/UX

Thanks, Ben! I don't use vscode as my editor, but I think I can use it as my sql client for the moment 😛

Yeah I don't use VSCode either (except for JS) but I like it as a lightweight visual tool for database manipulation

It is an Electron app tho so if you aren't running a well-supported Linux distro there may be dragons

Well, I misunderstood and thought it's a vscode plugin, no wonder I only found "Azure Data Studio Debug" in the extension search. Now I got it, it's a standalone app.

Ah sorry yeah I should've been more specific, tis a standalone app indeed

FWIW, I think you should first check out any possible options that are available right in your main IDE. It makes working with DB much, much smoother.

Totally! I will look into what Emacs offers here, and it may takes some effort I assume. So currently I just falled back to use the plain old command line. It's a bit old school, but it just works 🙂

Although I have MySQL Shell for VS Code installed, I generally just run SQL via next.jdbc from RCFs, and tap> them into Portal (inside VS Code) to look at data and table structure.

So, essentially, I use the REPL 🙂 with Portal as the UI.

I tried something similar but gave up - there's way too much that ends up not being available or very hard to get.

Donut's dbxray is a nice library to turn DB schemas into pure data -- I generally have that on my classpath but don't use it often (but it is helpful sometimes).

It's good for names, types, and a very narrow set of constraints, but that's about it. Anything more "deeper" into the DB - you gotta use much more advanced DB tools. Generic constraints, complex indices, triggers, views, and so on.

I'm not doing any heavy DB work, but when I need to take a peek at a DB, I often use the Clojure REPL like @seancorfield, and if I want to poke around via a DB UI, I use https://dbeaver.io/. I'm not sure how great DBeaver is compared to other tools, but it is what I stumbled on and seems to work well enough for me.

Well, Emacs' built-in sql package sounds nice, I'm using it right now! I can write my sql statements in a .sql file and send them by line/paragraph/buffer over to the SQL "REPL", cool!

https://arjanvandergaag.nl/blog/using-emacs-as-a-database-client.html

That's the wrong link

https://john.shaffe.rs/honeysql/

The one I posted is linked in the HoneySQL docs, it's the only one I've ever been aware of

https://cljdoc.org/d/com.github.seancorfield/honeysql/2.6.1243/doc/getting-started @seancorfield The playground site mentioned in the above link doesn't work any more. The one in the github readme page does.

Maybe I can create a small pr to fix this.

https://github.com/seancorfield/honeysql/pull/559

Thank you! Apparently, two instances of that link got fixed but I missed two others.

Sometimes it jut happens 😃