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

321–330 of 433 posts

Re: Postgres IDE in VS Code

#321

Post by smt88 »

tonyhart7 wrote: post #194
smt88 wrote: post #133

Earlier quoted context omitted.

SQL Server, like Oracle, is technically fantastic. They were both ahead of Postgres for a long time and many people would argue they still are. The reason people don't use them more often is that they're not free or even inexpensive.

I mean they should be, they backed by huge corporation plus they can take notes from Open source DB like postgress and improve their system better

You have it backwards. FOSS projects are still currently learning from SQL Server and Oracle. That may change in the next 5-10 years as Postgres has already become the lingua franca of the DB world.

Re: Postgres IDE in VS Code

#322

Post by deepsun »

timewizard wrote: post #249
meta_ai_x wrote: post #234

Earlier quoted context omitted.

Automatic Schema Visualization always miss the biggest point. When you generate visualization, you should only show key table and key fields within the table and hide all the helper, secondary fields and tables. In an LLM world this should be easy for LLMs to pick out key tables and fields and only display those

Why would you need an LLM to do this? The whole point is that SQL describes it's own relationships. You literally have everything you need out of the box.

LLM All THe ThiNgS!

Re: Postgres IDE in VS Code

#323

Post by bigfatkitten »

wredcoll wrote: post #282
semiquaver wrote: post #278

Earlier quoted context omitted.

I’m confused. Isn’t including the canonical state of the database schema in version control along with all the migrations that brought it to that point a completely standard part of every web framework?

That "works" for about as long as you have <10 employees and <3 customers or so. After that the railsapp doesn't get to be the sole owner of the db.

Providing access to other services is what APIs are for.

Jeff Bezos famously said[1] that anyone who does otherwise should be fired, and I agree.

[1] https://news.ycombinator.com/item?id=18916406

Re: Postgres IDE in VS Code

#324

Post by written-beyond »

jasonthorsness wrote: post #36

I use DataGrip, but only for very simple tasks and only against PG and occasionally SQLite and it has always felt like way overkill for me (and it's a heavy app). This will be a more convenient option!

Beekeeper for small stuff, that's my rule. However, I feel this may start to change that for me.

Data grip for big serious stuff.

Re: Postgres IDE in VS Code

#325

Post by written-beyond »

MonkeyClub wrote: post #299
getgalaxy wrote: post #65

Super cool for them to finally add in VSCode. My team is trying to build even more here by building a dedicated SQL editor with a context aware AI copilot, and with sharing and collaboration so we don’t need to send queries in slack anymore :) Check it out and get on the waitlist getgalaxy.io/explore/product-tour happy to chat live with anyone if interested, support@getgalaxy.io

Your whole comment history seems to be spamming for your app. Not a good way to generate potential user interest or generally good feelings towards it. Just saying.

I agree, I immediately felt that their product was cheapened for me. The only other "newish" developer tool I used were Beekeeper and Bruno and that too only because there were a lot of users naturally shilling for them (like I am now) on HN.

Re: Postgres IDE in VS Code

#326

Post by WuxiFingerHold »

>> all without ever leaving your favorite code editor

How do I install this on Neovim then? Is there a LSP? Or is this Microsoft proprietary? I wonder how much better without Copilot integration this is then the competition.

I'm using DBeaver CE currently. Does all I need (also for SQLite).

Re: Postgres IDE in VS Code

#327

Post by written-beyond »

VeejayRampay wrote: post #180
ThatMedicIsASpy wrote: post #179

Earlier quoted context omitted.

Figure 6 in the article shows it.

thanks a lot I really wonder why they would call it "server name" instead of database host though

True it's a little confusing, I think it's probably because they use that generic term a lot around code for other places that may have a context specific name for the "server" is called.

Re: Postgres IDE in VS Code

#328

Post by dehugger »

codeulike wrote: post #228
AdrianB1 wrote: post #207

Earlier quoted context omitted.

No, it has a different purpose; VS Code extension and the former ADS are targeted for development, while SSMS is for server and database administration. I am a heavy user of SSMS and can do everything I ever need there, I don't use the VS Code extension for MS SQL even if I have it installed and I use VS Code quite a lot. This is because I am also acting as a backup and supervisor for our DBA team, so I am involved i…

SSMS is also for Development, I've been using it for that for 20 years

I agree, I work on an application with a lot of business logic in SQL and SSMS ends up being my primary development IDE because of that.

Re: Postgres IDE in VS Code

#329

Post by WuxiFingerHold »

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…

Hmmm, interesting. I used Datagrip for some years, now DBeaver (as I don't have a JB subscription anymore). Datagrip was and probably still is very powerful with top intellisense. Now I'm using DBeaver and it's very solid. Ok, I'm not spending my whole day in it, but when I need it, it does the job well.

Re: Postgres IDE in VS Code

#330

Post by pamelafox »

justusthane wrote: post #312
pamelafox wrote: post #256

Congrats to the team on launching this! I was actually the first to demo it, as part of our sponsored session at Microsoft last week. Here's the talk where I used it: https://www.youtube.com/watch?v=k6Vm2hakkV4 I also did a theater session at our MSFT booth, but the recording isn't up yet. You can follow the steps in this repo to check out all the features that I demo'd, however: https://github.com/Azure-Samples/post…

Hey, just a heads up that your website 404s if visted at "pamelafox.org", which is how it appears in your bio.

Thanks, I need to move that website to GitHub Pages soon, the current host isn't handling the naked domain well. Changed to www.pamelafox.org for now.
Post reply on HN