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?
Postgres IDE in VS Code
211–220 of 433 posts
Re: Postgres IDE in VS Code
#212Earlier 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 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
#213I 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...).
It was never marketed like that, for the simple reason that popular VSCode languages like Python/HTML/Javascript were never well supported by regular Visual Studio, so there is no way to move to "proper" Visual Studio if you do Python/web development.
Re: Postgres IDE in VS Code
#214Earlier quoted context omitted.
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.
I spent the early part of my career in MSSQL and the current part in Pg. MSSQL is extremely, extremely capable as a database engine. But it also costs an arm and a leg. People who haven't used it don't know just how capable it is.
Re: Postgres IDE in VS Code
#215will 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…
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…
Re: Postgres IDE in VS Code
#216Earlier 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
Re: Postgres IDE in VS Code
#217Earlier quoted context omitted.
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!
You're a dev on the project and consider yourself authorized to speak on behalf of the project, on a legal matter, on Hacker News. Are you authorized to do the same on a blog hosted on microsoft.com? A lot of people would treat that as authoritative even if bigger enterprises will wait for the shrink-wrap to be updated.
Good: "Your honor, here's a copy of their official blog where they said the license terms are a temporary glitch but that we're fully allowed and encouraged to use the product."
Not good: "Your honor, an anonymous new account on Hacker News said it's totally fine to use this even though the license forbids it."
I'd cheerfully take my chances with the former. The latter? Not so much.
(As mentioned elsewhere, I don't for a second think MS is going to track me down and sue me for using this against the terms of the license. I'd feel a whole lot better if someone officially put that in writing, though.)
Re: Postgres IDE in VS Code
#218I'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
#219will 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…
Re: Postgres IDE in VS Code
#220I'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?