Remember the old adage, embrace, extend, extinguish.
They will extinguish postgres?
Postgres IDE in VS Code
361–370 of 433 posts
Re: Postgres IDE in VS Code
#362Tried it, queries work but i can't even show the columns and other meta data. it says no connnection even though i have a connection to do queries.
Re: Postgres IDE in VS Code
#363Re: Postgres IDE in VS Code
#364Earlier quoted context omitted.
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.
Do you have multiple separate apps that can change a shared DB schema? How do you keep that all in sync across your apps?
So usually one is the “main” but, personally speaking, I’d just say “don’t do it,” for the obvious issues I suspect you’re aware of ;-)
By “don’t do it,” I mean having multiple apps talk to one DB schema.
Re: Postgres IDE in VS Code
#365>> 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).
When for-profit companies write "Democratizes X for all" it means "for people who can pay and aren't embargoed". When they write "Simplify" it means "Get locked in to our ecosystem". When they write "Your favorite X" it means "The product we're selling to you", and so on.
Once you start reading press releases with this business-dictionary, it gets a lot easier to just close the tab and move on.
Re: Postgres IDE in VS Code
#366I used Azure Data Studio with SQL Server for a while—decent, but still clunky. I believe this plugin is the evolution of that, so it’s probably solid too—but can't beat out what I'm currently using since it targets only Postgres.
It’s going to be tough to beat SQLTools for Sublime Text (https://code.mteixeira.dev/SublimeText-SQLTools/). It’s simple, fast, does the basics right, and crucially, works for many of the usual suspects.
Most IDEs try to do everything and fail, yet only target one db vendor. They’re _all_ bloated and buggy, with endless trees and menus, bells and whistles. Results grids are slow, copy/paste is janky, formatting is never quite right—or outright misleading.
SQLTools stays out of the way and just works.
...also, I don’t want AI-powered nonsense. I’ll reach for that when I need it. Get off my lawn.
Re: Postgres IDE in VS Code
#367Earlier 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.
SQL Server is very good, while cheaper than Oracle. This is a good selling point for enterprises that care about cost (or are too cheap).
Why not Postgresql??? It is fre and the best.
Re: Postgres IDE in VS Code
#368>> 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).
Even for DuckDB, I use DBeaver CE the last 9 years professionally. Also when I do Python Dev I reach for JupySQL in Jupyter when I need something quick and it works in VSCode through Jupyter plugin..
Re: Postgres IDE in VS Code
#369This 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…
Wow, this is precisely how ClickHouse stores table metadata! A set of .sql files in the directories, corresponding to databases.
Re: Postgres IDE in VS Code
#370This is not available in Cursor. Extension ID "ms-ossdata.vscode-pgsql" returns no results. I wonder if Microsoft is blocking VSCode forks from having this extension?