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

191–200 of 433 posts

Re: Postgres IDE in VS Code

#191

Post by pvg »

franktankbank wrote: post #169
dang wrote: post #140

Earlier quoted context omitted.

It's in the same general space, no? If it helps at all, there's also this: " Assume good faith " - https://news.ycombinator.com/newsguidelines.html

Not to belabor the point too much, but assuming good faith is different from trusting anonymous advice from people claiming to be official advocates that could do real damage to your company if legal wanted to bone you. Yes they are a new user, but they appear to have made the account just to make that comment.

but they appear to have made the account just to make that comment

People making accounts so they can talk about their work is one of the best reasons for people to make an account and a big part of what makes HN threads interesting.

people claiming to be official advocates that could do real damage to your company if legal wanted to bone you.

That seems like the opposite of assuming good faith.

Re: Postgres IDE in VS Code

#192

Post by kstrauser »

lossyrob wrote: post #182
kstrauser wrote: post #56

Earlier quoted context omitted.

That's good to know! Right now it's pretty much illegal for anyone to use it in the situations most people would want to use it for. Any idea what the eventual license will be?

We're working the details out right now, but the change will make it clear that the extension has a free license without restrictions. Stay tuned!

Right on. I'll keep an eye out for it!

Re: Postgres IDE in VS Code

#194

Post by tonyhart7 »

smt88 wrote: post #133
coliveira wrote: post #125

Earlier quoted context omitted.

MS SQL server is a legacy system. I don't think any business would create a new database using SQL server unless, for some technical reason, they don't have any other option.

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

Re: Postgres IDE in VS Code

#195

Post by wenc »

bdcravens wrote: post #103

Looks nice enough. I only wish there was an easy way to spread VS Code across multiple monitors. I commonly will work in code on one monitor, and the database tool (DataGrip currently) on another.

You can already do that. I run VS Code on multiple monitors.

Any tab called be pulled into its own window and moved to a different screen.

Even the terminal panel can be popped out into a tab or panel or window. (The UI is not obvious but once you see it you can’t unsee it)

It’s pretty cool to have the code and terminal side by side in the editor window. (Of course this was always possible with emacs)

Re: Postgres IDE in VS Code

#196

Post by deleed »

tombert wrote: post #187

I've never used any of these kind of graphical SQL editors. I'm reasonably ok with SQL but I've always just done text queries. Does anyone here feel that the graphical editors actually save them time or make their lives easier?

You don't use it but still it's nice feature to have, isn't it?

Re: Postgres IDE in VS Code

#197

Post by dpflan »

codingjerk wrote: post #174
deadbabe wrote: post #136

Earlier quoted context omitted.

There’s a lot of developers that are scared of the command-line. Truth is you don’t really need these IDEs if you truly know SQL and your database, writing queries isn’t difficult. Keeping a file with common queries isn’t hard either. But most developers just keep a very shallow pool of knowledge and lean into ORMs etc.

I'm using CLIs like A LOT, but still would be happy to get _good_ autocomplete for SQL. `psql` is pretty bad at it and in `\e` you will just end up in an editor, which will probably don't know about your schema. I've tried many tools, but seems like I like DataGrip (or databases in PyCharm Professional) the most, so I use EAP from time to time, when I'm going to write a lot of SQL.

Hm, is there a psql extension to augment the CLI and provide better autocomplete, maybe even interface with LLM? And then it just stores whatever metadata (like queries you want to save) in its own tables...

Re: Postgres IDE in VS Code

#198

Post by franktankbank »

pvg wrote: post #191
franktankbank wrote: post #169

Earlier quoted context omitted.

Not to belabor the point too much, but assuming good faith is different from trusting anonymous advice from people claiming to be official advocates that could do real damage to your company if legal wanted to bone you. Yes they are a new user, but they appear to have made the account just to make that comment.

but they appear to have made the account just to make that comment People making accounts so they can talk about their work is one of the best reasons for people to make an account and a big part of what makes HN threads interesting. people claiming to be official advocates that could do real damage to your company if legal wanted to bone you. That seems like the opposite of assuming good faith.

> People making accounts so they can talk about their work is one of the best reasons for people to make an account and a big part of what makes HN threads interesting.

Uhuh but coming in to give bad legal advice as your first comment for the benefit of the largest most litigious corp on the planet, is that what makes HN threads interesting?

> That seems like the opposite of assuming good faith.

That wasn't a statement towards the individual. That was a statement of what could befall someone who took their advice.

Re: Postgres IDE in VS Code

#199

Post by mcv »

tombert wrote: post #187

I've never used any of these kind of graphical SQL editors. I'm reasonably ok with SQL but I've always just done text queries. Does anyone here feel that the graphical editors actually save them time or make their lives easier?

I haven't used it for relational databases, but I can imagine it's useful to visualize complex relationships between tables.

Re: Postgres IDE in VS Code

#200

Post by hbn »

tombert wrote: post #187

I've never used any of these kind of graphical SQL editors. I'm reasonably ok with SQL but I've always just done text queries. Does anyone here feel that the graphical editors actually save them time or make their lives easier?

Just today I've been dealing with an issue trying to update an XML column because the XML I'm trying to insert was escaping the string in the update query.

But with DataGrip I could just pull the row I was interested and paste in the string from the UI.

Surely there's another workaround that wouldn't involve a UI but this made it pretty easy.

Post reply on HN