I'm so fucking sick of the lack of great modern open source DB tooling.

MySQL Workbench can go suck a big fat herpes-ridden cock, it's horrible.

Dbeaver is a clunky 90's tool, which charges two Netflixes (yes, that is a valid $/month monetary unit) just to connect to a NoSQL DB.

Datagrip is nice, but has the same outrageously expensive pricing. I paid for it, and couldn't use it for my local docker DB during my holiday because it couldn't connect to the license server. Fuck you, Jetbrains. Your software is nice, but your DRM makes me hate you.

And then ERD software... It's either some hard-to-use afterthought piece of crap bundled with the DB IDE, some generic diagramming tool which makes DB-specific work needlessly unergonomic, or some vendor-locked online tool.

Fuck this shit, I'm making my own DB admin tool. With blackjack. And hookers. 😡

Primarily IntelliJ IDEs.

I'm using IDEA for Rust & Kotlin, PHPStorm, Datagrip (DB), and sometimes PyCharm CE.

IDEs can feel a bit dirty with how heavy they are, and the lack of customization/control. But at the end of the day there's just nothing that can measure up against IntelliJ's inspections, integrations and project indexing.

My ideal product would be one universal IntelliJ IDE, but combined with the openness of VSCode/Atom, having everything transparently configurable through stylesheets and scripts.

As an editor though.... I use Vim for LaTeX, Markdown, plain text and Haskell code... but not so much for other programming languages.

Vim was my first editor when I moved from C64 to PC development 25 years ago, and while you get used to balancing keybind vimgolfing with being actually productive, i've always found maintaining plugins and profiles too cumbersome -- the reality is that Vim is an awesome TEXT editor, but it's really awful as a CODE editor out of the box.

When you want to try out a new programming language, you don't want to have to mess around with your Vimrc and Vundle and YCM for half a day just so you can comfortably write "Hello World" in Rust or Elixir... you just want to click one install button, press F10 to compile and see if it flies.

Oh, and I use Xed a lot for quickly editing files... because it's the default GUI editor on Mint desktops, and it's quite good at being a basic notepad.

endor's first magical adventures with PostgreSQL

"Alright, got the docker image up and running, and I'm connected to the db, both from console and from Datagrip! Cool, let's get started with the tutorial!"
*cue montage of me using Datagrip to create my first schema, then the first table, then insert a bunch of data to try things out*

"Cool, now let's see if I can view my data from the console"
db1-# select * from my_schema.table1
db1-# [nothing]

"*Ahem*, I said:"
db1-# select * from my_schema.table1
db1-# [nothing]

db1-# select * from my_schema.table1
db1-# [cricket noises]

"Wut, why can't I see the data that I inserted? Wtf is going on?"

*30 minutes later*
"Alright, I have no idea what's going on, so let's try inserting the data from console and see if Datagrip can see it"

db1-# insert into my_schema.table1(id, name, field2, field3) values (1, 'Mike', null, 123), (2, 'Jake', 0, 456);
ERROR: syntax error at or near "SELECT"
LINE 2: SELECT
^

"Wait, what?"

db1-# insert into my_schema.table1(id, name, field2, field3) values (1, 'Mike', null, 123), (2, 'Jake', 0, 456);
INSERT 0 2

"Wtf? Haaang on... "

db1-# select * from my_schema.table1;
id | name | field2 | field3
----+------+--------+--------
1 | Mike | | 123
2 | Jake | 0 | 456
1 | Mike | | 123
2 | Jake | 0 | 456
(4 rows)

*eye twitches*

Thank you Jetbrains for all your products, but specially DataGrip...OFMG

I might be pushing my 4 years old macbook pro too hard with 2 IDEs, 1 instance of datagrip, and tons of open browser tabs, all on 4gb of RAM..

WTF intellij DataGrip is way too good. Why didnt anyone tell me this software exists?? I was using the oracle and pgadmin by now. Life could have been so much fking easier if i knew this existed

Fuck DataGrip, and it's an unintuitive interface, which asshole came up with the idea to remove the import menu option in favour of a drag and drop bullshit, and while I am at it fuck your documentation that is never accurate. You are a tool to speed up my work not create more tasks dummy!

What Database client do you use? I'm currently using Sequel Pro. Right now I'm comparing TablePlus and DataGrip.

DataGrip - not user friendly and complicated to use but powerful
TablePlus

Goland, intellij, webstorm, PyCharm, Datagrip....
I love jetbrains❤

Intellij / vim

I primarily use intellij(-based ides) or vim.

Jetbrains is doing an awesome job with the intellij platform.
If its GoLand, IDEA, Pycharm, Webstorm, Rider or DataGrip.
Once you have indexed your project it works flawless. The autocomplete is EXTREME fast and very good. You got quick actions, refactoring and barely need to use your mouse.

Everything works fine. And if there is something missing there is an plugin for it. And if there even doesnt exist a plugin already, you can code one!

The price is relatively high, but its worth every damn cent!

For light editing and ansible stuff i primarily use vim.
Its good to go and i am pretty sure i am using not even 1 percent of the features. Although i am learning new stuff about it every day.

Its cool if i just want to code distraction free and dont want to leave my sweet $HOME. Yeah i am a linux & bash fetishist, although sometimes its driving me crazy.

Editor? VSCode
IDE? Anything from JetBrains: PhpStorm, DataGrip, Android Studio, occasionally PyCharm and IntelliJ IDEA

Time for a new laptop, bored with current. Taking community suggestions. May donate current laptop to some poor dev soul in need; has been a trustworthy machine.

I do some of a lot on any given day: c#, PHP, node and typically run vs 2017, phpstorm, datagrip, sql management, webstorm, plus slack, office, etc.

I have terrible browser tab management skills and prefer electron apps over web apps. Am a vm junkie, constantly spinning up linux distros to see something.

Do light gaming when the mood strikes, Spotify or Netflix always on.

Suggest away.

favourite/recommended database IDEs/tools? I'm looking to put more time into a hobby project using mysqlite. I only got datagrip, mysql workbench and DB Browser for SQLite on my list so far

Just installed and started playing with DataGrip.

It feels pretty solid with the little bit of Postgres I have been using it for.

I would expect nothing less from JetBrains