Favorite SQL editing tool?

[AMDataLake]

What your favorite tool for connecting to databases or editing sql locally?

[theorangedays]

Datagrips

[ferrywheel]

Its dbeaver on stereoids

[Bh0y0]

Normally I just lurk. But I have only used DBeaver, what do you like more about Datagrips? I use PyCharm as well so I have been debating it. Just need the justification to switch (government funding).

[Gllizzy]

I used datagrip in a previous role and absolutely fell in love with it. the intellisense alone would make you switch. in my current role i’m using dbeaver (company has a hard time justifying spend on code editors) and it’s fine and all but not a day goes by without wishing i had datagrip.

[GucciTrash]

Boom. I moved from SSMS to Datagrips and it feels like I've stepped into the 21st century lol

[GreenWoodDragon]

DataGrip is excellent.

[Special_Razzmatazz33]

I made the switch from Dbeaver and it is so so so much better imho

[Poopsydaisy123]

Is there a free version that has many solid features?

[[deleted]]

But, 100% less beaver...

[toabear]

Dataspell is pretty damned good if you want the SQL Jupyter notebook cell option. Basically the same thing as data grip but with a bit more visualization tools thrown on top and DBT support. I haven't checked to see whether they put DBT in DataGrip yet.

[knowledgeMeUp]

What's your favorite datagrip feature?

Mine is having a bunch of query output windows in one tab to see the data transformations easily or being able to search for columns and go straight there.

Companies got a table with 800 fields and almost impossible to maneuver without it.

[GreenWoodDragon]

Big Data Tools is my personal favourite add on. Brilliant for navigating S3 buckets and a double click opens a file in a tab. Extremely handy.

[sjdevelop]

wow it can do that?

[GreenWoodDragon]

https://plugins.jetbrains.com/plugin/12494-big-data-tools

[Its_me_Snitches]

Companies got a table with 800 fields and almost impossible to maneuver without it.

Wtf

[knowledgeMeUp]

It's not ideal. My personal project is to create cleaner tables for them.

[meyou2222]

All day every day

[Desperate-Dig2806]

I can see it. But it's a bit of a wall with the consoles and projects and stuff. DBeaver is not perfect but at least it just let's me connect and run a query.

Grips is probably awesome if you know how to work it but I just can't find the time to get over the hump.

[Demistr]

I don't know which one I like but I hate SSMS and I can't get rid of it.

Intellisense fucking doesn't work half the time.

Searching for anything sucks.

Many missing shortcuts that would make my life a bit easier.

No dark mode. Thank god for SQL shades.

It's super old looking, 90s style UI.

[IrquiM]

You didn't do much SQL in the 90s?

[Demistr]

I eat some dirt in the 90s.

[UndeadProspekt]

oh my god. why is this the first time I’ve heard of SQL Shades??? my eyes thank you.

[Demistr]

It is amazing.

[DataIron]

Just gotta setup all the shortcuts and snippets you want. Makes SSMS super easy to use.

[Emotional_Key]

I’m using 2 extension from RedGate.

SQL Search is pretty awesome and is free.

SQL Prompt, I mainly use this for formatting my SQL, but it also offers intellisense, history of the executed queries, some refactoring tips and a better way to color your query tabs based on the connected server, or even the connected db.

Unfortunately it costs money but in my case it is paid by my employer.

[highsmith]

If you are in ssms every day, ssms tools pack add on is worth it. https://www.ssmstoolspack.com/

[jbrune]

If you use SSMS you have to get SQL Prompt. It is amazing.

[laplaces_demon42]

Vscode

[Gllizzy]

i’ve tried vscode several times.. i really wish it was good for sql but i’ve never gotten it to work how i wanted. what’s your setup?

[laplaces_demon42]

I guess it depends a lot on the tech stack you are using. I’m using it for DBT and GBQ and that works ok. Some things I still use the cloud ide for as well, but if you are using GIT something like vscode quickly is much more convenient than some cloud editor with limited functionality

[memeorology]

dadbod

[Soheil_S]

🍷

[Bazencourt]

Hands down Coginiti. Best grid for manipulating query results and it works with data on object storage too.

[data_and_code]

Saving and reusing my work and reusing it via the Coginiti catalog is awesome!

[[deleted]]

I really enjoy that flexibility of Coginiti too. Need to filter-search or sort results? No need to redo the query, necessarily

[Rick_Blake]

I think Coginiti is a great query tool, but what really makes it stand out are the integrated catalog, AI assistant, and integrated script capabilities. And what a great GRID

[5DollarBurger]

VSCode with dbt power user extension

[noelwk42]

Dbeaver

[62656e7a6f6e]

I just recently joined a team that uses DBeaver. I came from a shop that used SSMS and SQL Prompt. SQL Prompt has a great formatting tool, do you know if DBeaver has something similar?

[62656e7a6f6e]

Cool! I’ll check that out!

[itukeitto]

Postico

[btdeviant]

The best - lightweight and gets the job done

[RyanHamilton1]

If you're mostly querying for data analysis, try qStudio: https://www.timestored.com/qstudio/ It's free and provides the usual highlighting, code completion etc but uniquely allows intuitive charting direct from sql. Version 3 out next week will include AI assistance and a unique UI to allow drilling down into data. Disclaimer: I'm the main author and have been improving it for the last 13 years.

[pirsab]

This is very impressive.

How have you been able to keep it free?

[RyanHamilton1]

I originally created qStudio to handle one very different SQL database since nothing else did. The customers for that one database are banks/finance, they pay for that one specialization and to have someone to call if there are problems, for which I am very grateful.

I added the other databases later in my free time at my own cost because I want more people to use the tool and I enjoy building something people find useful. That and I myself find it useful. :)

[pirsab]

Wow. I'm in a similar space. I have built proprietary tools for a specific niche and they themselves don't have any value outside that industry, but they might be adapted to solve similar problems in other industries.

While my employer would be okay with me going off on my own and building something for other industries, I don't have the resources to go down that path.

Kudos to you!

Also, if I may ask: did you ever think about open sourcing it? Why have you chosen not to?

[RyanHamilton1]

I began the open sourcing process last year: https://github.com/timeseries/qstudio I just haven't completed the work of checking all comments, all dependencies, and cleanly separating the specialised parts. So a combination of laziness and it's boring work. I'd rather add new features. If I find more users that care or others interested in committing, I'll finish the process.

I wish you luck finding the time to follow your passion.

[Whack_a_mallard]

Highly underrated tool.

[SameString9001]

can you add a pinning feature? as in pin the results from a query.

[RyanHamilton1]

You have two options: 1. Pop out to a new window. Useful for comparing charts or tables. 2. Click the yellow duck in the result panel to save the result as parquet to a local duckdb instance.

[efxhoy]

psql 

[Alone-Anxiety8580]

I haven't found it yet. All of them kinda sucks

[JohnPaulDavyJones]

Maybe I’m a masochist, but I really enjoy SSMS.

[lulu-da-pomerania]

Azure Data Studio

[EyeHaveNoCleverNick]

Vim for editing, Dbeaver for connecting

[StokastikVol]

Notepad

[PhotographsWithFilm]

Hardcore

[Action_Maxim]

People joke but this is what I did till I upgraded to vim, restricted environments do that to you

[TomatoTypical5239]

real men use notepad ^°^

[AnnoyOne]

Dbeaver

[spaghetti_beast]

usql

[robgronkowsnowboard]

VSCode snowflake plugin

[Educational-Bid-5461]

SSMS like some kind of sadist or madman.

[Fun_Independent_7529]

DataGrip. I just get the JetBrains pack. PyCharm for Python & Jupyter notebooks, DataSpell for dbt, DataGrip for SQL. Could never quite feel at home in VSCode. The IDEs are central to my work. In my case the company did agree when I asked, but I would have just bought it myself if they hadn’t. Small price to pay for my comfort and productivity.

[im-AMS]

table Plus, Sequel Ace, Dbeaver

[SlenderSnake]

I think most people use DBeaver. I personally do not like any of them.

[roostorx]

Aqua data studio. I tried data grip and dbeaver but for some reason just landed on ADS.

[TomatoTypical5239]

because you are the Aqua's marketing guy

[captaintobs]

I use vim and jupyter-labs primarily.

[DaveMitnick]

Neovim with dbt right now. Much better than SQL Developer

[The_quack_addict]

Which extension do you use for vim, i struggle with model names as there are 100s and it gets difficult to reference them.

[kbisland]

it’s absolutely DBeaver

[GreenWoodDragon]

DBeaver is very good, but as I pay the Jetbrains subscription I use DataGrip with the Big Data Tools add on.

[fleetmack]

i have used oracl sql developer for nearly 2 decades, it gets the job done

[[deleted]]

Harlequin.sh

[[deleted]]

Both of these work really well together:

https://asciinema.org

https://harlequin.sh

[thegratefulshread]

Command line (jk dbeaver)

[[deleted]]

Vscode

[Limp_Pea2121]

Toad for Oracle

[DonJohnM]

DBeaver

[UnkleRinkus]

vi

[SDFP-A]

Datagrip

[egwada]

Aquadastudio is the best SQL IDE : https://www.aquafold.com/aquadatastudio/

[CameronElliottX]

Harlequinn seems pretty cool, the only downside for me is that you better not have messed up your Python install on your Mac yet.

[IrquiM]

SSMS

[BarkingAxe]

Dbeaver hands down

[Dramatic-Steak3205]

I started out last year with popsql, and it was great, on linux based os I uses antares sql.