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

131–140 of 433 posts

Re: Postgres IDE in VS Code

#131

Post by doubleorseven »

coliveira wrote: post #125
pier25 wrote: post #8

Oh woah this looks great. Quite amazing they put the effort into this for Postgres instead of SQL Server. The demand must be a lot higher.

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.

There is a parallel world, called enterprise. The enterprise people in this world, like enterprise software. They were born to be enterprise oriented. This is fine. Not everyone is like you and it's ok to use a robust product like MSSQL.

Re: Postgres IDE in VS Code

#132

Post by harrall »

coliveira wrote: post #125
pier25 wrote: post #8

Oh woah this looks great. Quite amazing they put the effort into this for Postgres instead of SQL Server. The demand must be a lot higher.

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 is technically very, very good.

But they charge you an arm and a leg for the pleasure, but it can be worthwhile for enterprise.

Re: Postgres IDE in VS Code

#133

Post by smt88 »

coliveira wrote: post #125
pier25 wrote: post #8

Oh woah this looks great. Quite amazing they put the effort into this for Postgres instead of SQL Server. The demand must be a lot higher.

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.

Re: Postgres IDE in VS Code

#134

Post by dontlaugh »

Toritori12 wrote: post #64

I wonder what is the most "valuable" IDE right now for MS. A few years ago VsCode was marketed essentially as "Visual studio for beginners", where you were supposed to move to Visual Studio after you became a real dev, but since then VSCode has been growing and growing and stands now as the most used "IDE", where Visual Studio is mostly seen as "legacy" (oversimplification, great IDE for CPP and .NET but still...).

Visual Studio is still widely used in the games industry, being pretty much a requirement for targeting some platforms.

It is becoming common for some to use Rider primarily, but VS is still used as part of the build system.

Re: Postgres IDE in VS Code

#136

Post by deadbabe »

dpflan wrote: post #85
codingjerk wrote: post #57

Looks promising, but I'll probably stick to `psql`

I wonder about people’s development workflows. If you are using a tool like this, how much time are you spending in the command-line (where all such tools can be interfaced)? Are most tools used wrapped in some layer like this?

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.

Re: Postgres IDE in VS Code

#138

Post by dang »

lolinder wrote: post #97
dang wrote: post #83

Earlier quoted context omitted.

Please don't harangue new users as soon as they show up to HN. Whatever legitimate point you have is drowned out by the atmosphere of hostility you create. Not only that but it damages the reputation of this community. You ( https://news.ycombinator.com/newsguidelines.html ). There's no reason why you can't make your substantive points while doing so. (Edit: you needn't look far for a good example: https://news.ycomb…

I didn't mean it to be haranguing, but OP was giving what amounted to legal advice that was actually wrong and dangerous. I do think that needs to be called out and clarified—not as a personal attack on OP but just as a matter of safety for readers. I'll acknowledge that kstrauser may have done a better job of sounding friendly about it, but I don't think my question was out of line nor even particularly aggressive g…

I'm sorry to press the point, but I don't think you're correctly assessing the impact of comments like your GP post, especially on a legit new user like lossyrob.

You may not have meant to be haranguing, but intent doesn't communicate itself—at least not in the tiny textblobs which are all we have here. It has to be included in the message.

When I look at your comment from that point of view, I notice that it leads with a hostile personal trope ("You do recognize...?"), followed by a putdown of everything this team is probably hoping for ("no one should use this"), followed by a personal attack ("you shouldn't be encouraging"), followed by a pedantic hammer-blow ("legally the license is the license") that takes the spotlight away from anything new or exciting about their work. That is followed by a sentence that basically shames them for what was obviously just an oversight. How is a newcomer (or anyone, for that matter) supposed to feel when they encounter that?

You're a good HN member and I'm sure you didn't intend to condemn or humiliate anyone. The problem is that people routinely underestimate the provocation in their own comments and overestimate the provocation in others'. If the error is 10x in each direction, that's a huge skew [1]. That's why it's hard to track the impact that one's posts have—especially the righteously indignant sort of post [2].

I suppose one of the moderators' jobs is to step in and try to articulate that explicitly, in the hope of persuading enough users to generate a bit of a system correction.

[1] https://hn.algolia.com/?dateRange=all&page=0&prefix=true&que...

[2] which, by the way, I can feel a bit of in my own comment just now, and I'm probably underestimating it too.

Re: Postgres IDE in VS Code

#139

Post by maxluk »

abetaha wrote: post #93

This looks great. Would all the functionality work if the databases are hosted on other cloud providers?

I am PM from the project - short answer is yes - you can connect to any Postgres endpoint. There are some Azure specific features, like EntraID supported by the extension that don't exist in other cloud providers.

Re: Postgres IDE in VS Code

#140

Post by dang »

franktankbank wrote: post #120
dang wrote: post #86

Earlier quoted context omitted.

" Please don't post insinuations about astroturfing, shilling, bots, brigading, foreign agents and the like. It degrades discussion and is usually mistaken. If you're worried about abuse, email hn@ycombinator.com and we'll look at the data. " https://news.ycombinator.com/newsguidelines.html https://hn.algolia.com/?sort=byDate&dateRange=all&type=comme...

Huh, I'm not sure I said anything like the above.

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

Post reply on HN