Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Postgres IDE in VS Code

techcommunity.microsoft.com

Post reply on HN
Print view View original

371–380 of 433 posts

Re: Postgres IDE in VS Code

#371

Post by specialist »

AdrianB1 wrote: post #219
qntmfred wrote: post #24

will definitely be taking a look at this. i started my career on mostly SQL Server and using SSMS fits my brain like a glove. i've been so dissatisfied with the typical options (pgadmin, dbeaver, datagrip, etc) for managing/querying postgres since i started using it probably like 10 years ago. postgres itself is great (don't get it twisted either, SQL Server is fantastic. just costs money) but i never understood why…

In my experience most SQL developers don't care too much about tooling. In most cases someone designs the database and tables, developers don't care about databases and care mostly about tables and views, rarely about indexes. The ones that care, and need tooling, are usually called development DBAs and they are very rare. Rare enough I was never able to hire one and keep them (we don't pay enough for how rare they a…

All true.

I loved workgroup style app development. R:Base, Access, dBase, FoxPro. Then I switched to UI work for a stretch.

Circling back to back-end work, naive me embraced Hibernate (2004?), assuming it'd be familiar and good.

I was wrong.

Now that I have a lot of free time, I'm finally recreating the workgroup style experience, for the general dev population. Sort of.

Using Hibernate, our workflow became: rough in some ORM hack, capture the generated SQL, use SQL Query Analyzer and Toad to make it work (and performant), coerce Hibernate to regenerate the SQL we want. Totally backwards, right?

Eventually we gave up and just used HQL.

At that point, why even bother with ORM?

So I created a "SQL first" workflow. Treat your SQL (DML) as source code, use those explicit queries to generate the prepared statements (and typesafe DAOs, DTOs, etc). In other words, auto-generate all the things you'd do yourself, if only you had more time.

I used my tool for years. Am currently making it usable for other devs. eg Spent last week making my grammar for MySQL "good enough" for initial release. Already have PostgreSQL and SQLite, plus my original turrible "poor mans SQL" grammar (comparable SQL-92). Which I'll cull once I have "good enough" T-SQL and PL/SQL grammars.

Any way. Thanks for reading.

I only meant to confirm your experience with development DBAs. The only such person I was able to retain was near retirement and was tired of the hustle.

Re: Postgres IDE in VS Code

#372

Post by jeroenhd »

mohsen1 wrote: post #370

This is not available in Cursor. Extension ID "ms-ossdata.vscode-pgsql" returns no results. I wonder if Microsoft is blocking VSCode forks from having this extension?

Cursor was based on quite an old version of VS Code laat time I checked, so it's possible Microsoft just didn't target compatibility with a release from six months ago.

This is also what's said here by one of the devs: https://github.com/microsoft/vscode-pgsql/issues/15

Looks like manually loading the VSIX to bypass the compatibility check should work but who knows how stable that'll be.

Re: Postgres IDE in VS Code

#373

Post by jeroenhd »

polishdude20 wrote: post #225
FeloniousHam wrote: post #148

Earlier quoted context omitted.

I've found Datagrip to be far and away the most impressive universal database tool. I feel like I've tried them all, and they all have a quality of having been developed by database people, rather than IDE designers. The depth of capability, extensibility, pace of improvement--I'm a very happy customer. I don't want to poop on open source, but pgadmin and dbeaver and not even close to playing in the same league. I wo…

I'd love to try datagrip, what are some advantages over pgadmin or others?

Many people love Datagrip because it's got the polish and style of Jetbrains' other products. Others hate it and much prefer the more classic designs of DBeaver or the browser UI of PGAdmin.

I think it's worth downloading the 30 day trial and giving it a quick whirl. The people who dislike it seem to get hesitant quite quickly, so I doubt you'd need more than a day to decide if it's for you or not. There are all kinds of cool and fancy plugins you can set up, but I wouldn't bother with that if you decide the UX just isn't for you.

It supports quite literally every database I've thrown at it, which is pretty nice.

The way it support projects is also rather useful to me as a developer. Most SQL tools seem to be focused on being an interface first and maybe having a few SQL files open second, but Datagrip's basis as an IDE makes it very easy to maintain collections of scripts (version migrations etc).

That said, I'm not sure if the 99 bucks (a year if you want updates, though you get a perpetual license for the current version) is worth it. I use it because it's part of Jetbrains' all products pack, which I paid to use other IDEs, essentially giving me Datagrip for free. If you're not already a Jetbrains customer you could definitely give it a go, but the value per dollar it provides is very different.

Re: Postgres IDE in VS Code

#374

Post by jeroenhd »

mierz00 wrote: post #277
impalallama wrote: post #21

Biggest thing that JetBrains has over VSCode for me was their very clean built in database tooling

Every year or so I try to go back to VSCode but I can’t get past how good the git and database integrations are in JetBrains.

I think Code has fine git integration, but they way they implement it is just very Microsoft. The UI is very much like the one they use in their professional Visual Studio UI, and whether that's a good thing or not is definitely a very personal choice.

I much prefer JB's git integration, but I wouldn't discount it just because the UI is so completely different.

Re: Postgres IDE in VS Code

#375

Post by throwaway7783 »

scott_w wrote: post #364
sbarre wrote: post #295

Earlier quoted context omitted.

Do you have multiple separate apps that can change a shared DB schema? How do you keep that all in sync across your apps?

So usually one is the “main” but, personally speaking, I’d just say “don’t do it,” for the obvious issues I suspect you’re aware of ;-) By “don’t do it,” I mean having multiple apps talk to one DB schema.

"don't do it" is the right answer. Others have pointed it out as well, many large SaaS companies I worked with, have had apps owning their databases. Anyone else needs anything - use APIs (and ETL if you need everything)

Re: Postgres IDE in VS Code

#378

Post by ParetoOptimal »

kstrauser wrote: post #38
krferriter wrote: post #33

Earlier quoted context omitted.

Can't use it for commercial, non-profit, or revenue-generating activities? Uh, this actually seems insane to me? What is it for then?

My initial reaction is "entrapment". Edit: That's uncharitable of me. I strongly doubt that's the plan. But it genuinely was the first thing that came to mind.

A more than justified reaction with Microsoft.

Re: Postgres IDE in VS Code

#379

Post by ParetoOptimal »

ldjkfkdsjnv wrote: post #52
kstrauser wrote: post #27

It has a proprietary license[0]. That makes it a non-starter. Too bad: it looks nifty! > The software is licensed, not sold. Microsoft reserves all other rights. Unless applicable law gives you more rights despite this limitation, you will not (and have no right to):[…] d) use the software for commercial, non-profit, or revenue-generating activities Oops. Better not install this on your work laptop! [0] https://marke…

does anyone actually think like this?

Are you insinuating that the way the majority thinks is more correct and should be preferred?
Post reply on HN