I wonder how well this IDE works if you use AWS or GCP instead of Azure.
Postgres IDE in VS Code
111–120 of 433 posts
Re: Postgres IDE in VS Code
#112This solves a major problem that I built an npm package called "pgstrap"[1] for. It generates a "database structure" directory so that my database schema is available to LLMs (it also makes code review easier because you can see the changes to various tables). So I have a SQL file for each table in my database, neatly organized into directories for each schema. Rails has a similar idea with schema.rb I'm not sure whe…
I just use a MCP server (with copilot or cline) that has a read only login to my database.
Re: Postgres IDE in VS Code
#113Oh 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.
SQL server is in "cash cow mode" at this point. Investing more into tooling is unlikely to increase revenues at this stage.
Re: Postgres IDE in VS Code
#114I wonder how well this IDE works if you use AWS or GCP instead of Azure.
I run a personal Postgres server so I'm wondering how well it does there
Re: Postgres IDE in VS Code
#115I 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...).
> 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,
When was that?
Re: Postgres IDE in VS Code
#116I 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...).
Easily VSCode, if we're talking about developer reach. I'm not big into Microsoft stuff, but almost every 'serious' .Net developer I personally know is using Rider, so I can only assume that Visual Studio is retreating to the same space occupied by Eclipse and Netbeans, i.e. still used, but mostly only in places where change is hard. I'm an emacs user and even I keep a copy of VSCode installed just because I occasion…
I only use Rider because it's cross-platform. It's not inherently better (or worse) than Visual Studio with Resharper installed.
Re: Postgres IDE in VS Code
#117I wonder how well this IDE works if you use AWS or GCP instead of Azure.
I assume you run cloud-sql-proxy as usual (for proper TLS and passwordless IAM authentication), and then it's just another postgresql port for you. Any tool like psql can connect to it.
Re: Postgres IDE in VS Code
#118I still think Jetbrains has the gold standard in IDE - Database interaction
Interesting in knowing why you think that
Datagrip, as an extension, lets you work with SQL, highlighting, autocompletion, and more, inside non-SQL files, such as your programming language files. I think they call this 'language injection'.
Re: Postgres IDE in VS Code
#119Re: Postgres IDE in VS Code
#120Earlier quoted context omitted.
[flagged]
" 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.