Providing access to other services is what APIs are for. Jeff Bezos famously said[1] that anyone who does otherwise should be fired, and I agree. [1] https://news.ycombinator.com/item?id=18916406
> Providing access to other services is what APIs are for. Yeah, and databases expose extensive APIs with extremely battle-tested security and permissions models for multiple consumers.
That’s why your bank lets you connect directly to their database to see your transaction history.
If eight years is recent enough, Microsoft moved its German office to Munich and got the city of Munich to shut down its Linux migration in return. Not exactly dishonest, but a power move to destroy the competition that I happen to be rooting for. Personal experience is irrelevant if the facts are not in doubt. One of these is that Microsoft was a pretty bad actor when nobody reigned them in, and I was around at the…
How can this be described as anything other than business? Local governments making concessions to businesses generating jobs and SALT is par for the course and Microsoft isn't special here. > One of these is that Microsoft was a pretty bad actor when nobody reigned them in, and I was around at the time. So was I (was working in Redmond at the time), and their behavior was no worse than what Apple or Google are up to…
It's a huge public company, it doesn't deserve sympathy. I don't trust them, for which I have reasons past and current, and I don't need to, there is no moral obligation. Won't anybody think of the poor highest valued company in the world?
This 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?
You can download the .vsix file directly from marketplace.visualstudio and install it in cursor.
"don't do it" is the right answer. Others have pointed it out as well, many large SaaS companies I worked with, have had apps owning their databases. Anyone else needs anything - use APIs (and ETL if you need everything)
It's definitely not the right answer. It's actually the completely wrong answer. Services are slow, restrictive, and don't enjoy the benefits of an actual DBMS, like transactions. You also add additional dependencies and failure points.
This isn’t a discussion of whether you should use services or not, only what to do in the case where you do have separate services interacting with a schema. And, in this case, trying to maintain consistency with multiple apps accessing the DB directly can quickly turn into a nightmare. Better to maintain separate services interacting over some contract to insulate multiple codebases from the internals of each other.
How can this be described as anything other than business? Local governments making concessions to businesses generating jobs and SALT is par for the course and Microsoft isn't special here. > One of these is that Microsoft was a pretty bad actor when nobody reigned them in, and I was around at the time. So was I (was working in Redmond at the time), and their behavior was no worse than what Apple or Google are up to…
It's a huge public company, it doesn't deserve sympathy. I don't trust them, for which I have reasons past and current, and I don't need to, there is no moral obligation. Won't anybody think of the poor highest valued company in the world?
It's not about "thinking of the poor company". It's about lazy low-effort, low-quality comments from people that are sharing their "opinions" that are really just regurgitated interpretations from other low-quality comments. Turtles all the way down.
Nice. The few db managers I’ve tried in VS Code are so awkward, creating files for queries and opening multiple panes that barely fit in the crowded IDE space It makes me wish for something like phpmyadmin or adminer
Isn't that exactly what pgadmin is? https://www.pgadmin.org/
Nice, thank you! Might spin up a docker with it to keep running :)
I guess not everything needs to live inside my IDE
The SQL Server driver for Django. Originally maintained by someone from Nebraska, Microsoft then took ownership of the project (now lives under the Microsoft GH organization). The last commit was 11 months ago. Has not supported a current release of Django for over a year now. There are almost certainly security implications for sticking on the now deprecated Django 5.0. The issues are begging for anyone at Microsoft…
Microsoft also loves to sideline some author so some PM can say "look at this OSS project we now control!!!!" and then add controls and processes that nobody gets to even know about except for MSFT and then weird, inevitably a few years later its just a disaster area.
Yeah, it's specifically the old applications I miss. They were really well designed, incredibly snappy and responsive. When SSMS was launched it was really slow and clunky on my computer. I switched to Postgres around that time so I'm 20 years out of touch at this point.
I had forgotten about query analyzer, didn't it exist alongside ssms? I think I used to roll it out when things got really serious
Query Analyzer was eventually superseded by SSMS but there was an overlap period IIRC.
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.
I'm a developer advocate at Microsoft, and from my perspective, both teams have been putting in a bunch of effort improving their extensions. I participated in usability studies with both the teams behind the SQL Server extension and new PostgreSQL extension, and then once they were ready, I participated in bug bashes. Both teams seem to very much want developers to enjoy their tools, so please do send them feedback…