13 ms·

Postgres IDE in VS Code

• wolframhempel 1y ago
  Looks amazing- and the point they're making in the article is correct. Switching back and forth from VS to PG Admin creates friction that this seems to solve in a much nicer way
• wiseowise 1y ago
  Let me guess: proprietary, like Pylance, and unavailable in VSCodium?
  • deleted 1y ago
    [deleted]
  • someothherguyy 1y ago
    Looks like it
  • deleted 1y ago
    [deleted]
  • formerly_proven 1y ago
    That's the point of the VS Code strategy, yes.
  • ParetoOptimal 1y ago
    Not to worry, we can surely assume Microsoft will act in good faith.
• tonyhart7 1y ago
  [flagged]
• huqedato 1y ago
  Very nice and long awaited. Thanks Ms. There are basic features available now (visualisations and query). Looking ahead for more, such table/data editing etc.
  • briffle 1y ago
    I like that I can run this remotely with the vscode ssh extension to my remote systems. But compared to dbeaver, I miss some of the features of dbeaver. Like showing an estimate of large each table is, and seeing how many rows in the 'properties tab'. And being able to see the ERD graphics for individual tables (to show foreign keys, etc). Also like with dbeaver that you can take the results and export them in many different formats. like directly to excel for some of my co-workers who live and die in excel.
• highwaylights 1y ago
  Nice that they’ve got it working so well with copilot, the only thing keeping me from buying a premium sub is that they don’t bundle GitHub copilot with office copilot. It seems like all their copilots are seperate subs, which seems like a missed opportunity honestly.
• pier25 1y ago
  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.
  • Wojtkie 1y ago
    The copilot integrations look sweet, as does the schema view. The MSSQL extension doesn't have those, but the rest of it looks similar to the Postgres one.
    • croblesm 1y ago
      Lead PM for MSSQL extension in VS Code here. I’m glad to share that we have both features (Schema Designer, GitHub Copilot) into the MSSQL extension for VS Code. You can check out this end-to-end demo showcasing those capabilities: https://aka.ms/vscode-mssql-copilot-demo https://aka.ms/vscode-mssql-copilot-demo As I’ve mentioned in a few other threads, the PostgreSQL team recently forked our MSSQL extension to kick off a fresh implementation for Postgres. It’s built on the same foundation we’re actively improving and evolving for both extensions.
  • nevi-me 1y ago
    I speculate that it's because the MSSQL tools have been maintained as part of Azure Data Studio, and were in better shape. ADS is being sunset, and I was surprised when trying to install the Postgres extension on VS Code to find that it had its last meaningful contribution 6 years ago [0]. It couldn't work on newer VS Code versions. I use ADS with both Postgres and MSSQL, prior to this announcement, I kept using ADS because there was nothing to migrate to. [0] https://github.com/microsoft/vscode-postgresql/commits/master/ https://github.com/microsoft/vscode-postgresql/commits/maste...
    • hobs 1y ago
      They built the postgres plugin in a way that nobody could usefully contribute to unless they worked at msft - like the rest of ADS the level of control they tried to maintain meant nobody wanted to work on it.
• someothherguyy 1y ago
  https://github.com/Microsoft/vscode-pgsql https://github.com/Microsoft/vscode-pgsql no source, not a promising privacy policy https://github.com/microsoft/vscode-pgsql/blob/main/PRIVACY https://github.com/microsoft/vscode-pgsql/blob/main/PRIVACY
  • deleted 1y ago
    [deleted]
  • uludag 1y ago
    I imagine this is part of Microsoft's plan to the vscode forks: open sourcing copilot to rally developers round it, along with pushing premium closed sourced extensions, which will almost definitely be incompatible with the forks.
• conradfr 1y ago
  [flagged]
  • deleted 1y ago
    [deleted]
• SomaticPirate 1y ago
  I still think Jetbrains has the gold standard in IDE - Database interaction
  • deleted 1y ago
    [deleted]
  • tdhz77 1y ago
    Interesting in knowing why you think that
    • leosanchez 1y ago
      It even lints your SQL queries written in other languages. Truly gold standard.
      • bni 1y ago
        And autocompletes, syntax highlight it. I couldn't imagine being without this.
    • ivanjermakov 1y ago
      Because of a rich feature set and amazing integration with DB providers. Good starting point: https://www.jetbrains.com/pages/intellij-idea-databases/ https://www.jetbrains.com/pages/intellij-idea-databases/
    • newlisp 1y ago
      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'.
  • mrits 1y ago
    I've been using DataGrip for a few weeks and admit it is a nice upgrade to DBVisualizer that I've been using for 10 years. The intellisense and features like being able to select the query in the current window are big time savers for me. I'm still on a trial and not certain I'll purchase it just because things are moving so fast in this field. I feel like not having it in my VSCode Agent loop is a huge negative at this point
• _ink_ 1y ago
  > [...] all without ever leaving your favorite code editor. That's cool. How do I get this into JetBrains IDEs?
  • jrockway 1y ago
    I feel like JetBrains' competing product is DataGrip, which even though I'm an Emacs user, I've happily paid for forever. I believe that if you just use the combined suite (IntelliJ?) then you get SQL completion based on your loaded database everywhere in the IDE. Something fun I accidentally learned this way is that the completion is so accurate I didn't even notice that I made a mistake in a database table I recently added. I used camelCase column names, which Postgres doesn't accept without quotes. Datagrip always added the quotes where I needed them, so I didn't notice, but it annoyed people on my team that used different database tools and they renamed them ;) JetBrains has always done their completion / language integration differently than VSCode + LSP, but it seems to work well. My only complaint is that GoLand organizes imports differently than gopls / goimports, but my knowledge there is a few years out of date. I've worked on teams with a lot of GoLand users and nothing has really bothered me on this front recently, so they probably fixed it years ago.
    • throwaeay 1y ago
      > I believe that if you just use the combined suite (IntelliJ?) then you get SQL completion based on your loaded database everywhere in the IDE. Yes, Intellj will recognize that the string in my code is an SQL statement and use auto complete and validation when it is connected to a database. I've looked at the announcement and it seems that the functionality of Jetbrains is similar.
    • pzmarzly 1y ago
      Out of curiosity: how do you set up your CI checks (linter, formatting) if the opensource tools behave differently from JetBrains'? Do you use Qodana[0]? One benefit of using VSCode/Sublime Text/vim/emacs language integrations is that I roughly know what command to run to get the same results in the terminal as I get in the editor. With JetBrains does-it--all IDEs, I have no clue. [0] https://www.jetbrains.com/help/qodana/getting-started.html https://www.jetbrains.com/help/qodana/getting-started.html
• impalallama 1y ago
  Biggest thing that JetBrains has over VSCode for me was their very clean built in database tooling
  • bdcravens 1y ago
    You can also run the database tool separate (DataGrip). That's what I do.
    • Version467 1y ago
      I didn't know about DataGrip. Looks cool.
  • mierz00 1y ago
    Every year or so I try to go back to VSCode but I can’t get past how good the git and database integrations are in JetBrains.
    • jeroenhd 1y ago
      I think Code has fine git integration, but they way they implement it is just very Microsoft. The UI is very much like the one they use in their professional Visual Studio UI, and whether that's a good thing or not is definitely a very personal choice. I much prefer JB's git integration, but I wouldn't discount it just because the UI is so completely different.
• qntmfred 1y ago
  will 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 there wasn't more uproar in the community about its DBMS tooling ecosystem
  • FeloniousHam 1y ago
    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 work in Oracle and Datagrip saved my sanity.
    • Errsher 1y ago
      Are there any features in datagrip in particular that you like that aren't in dbeaver?
      • cerved 1y ago
        More streamlined UI. I find the graph viewer to display some things nicer, like coloring tables, bringing in related tables. Slightly better introspection and code formatting. Easier refactoring capabilities. Easier to get IdeaVim working then whatever Ecplise plugin is needed in DBeaver. In my experience, DataGrip has been easier to get up and running out of the box and bringing the big IDE guns than DBeaver but DBeaver also does done this really well. For example I have never been able to setup DG with Access but DBeaver works pretty good out of the box with that garbage. Also it's free. Both are solid
      • cwbriscoe 1y ago
        I used DBeaver (community edition) before Datagrip and I would have to give the nod to datagrip overall. I wouldn't have even tried it if I did not have the etbrains all product pack. DBeaver is great, don't get me wrong, but Datagrip just seems a lot more polished overall and the settings and the UI just seem more intuitive to me.
• mrits 1y ago
  I'm sure nobody cares, but I just independently stumbled upon this an hour ago and wondered why more people haven't used it.
• kstrauser 1y ago
  It has a proprietary license[0]. That makes it a non-starter. Too bad: it looks nifty! > The software is licensed, not sold. Microsoft reserves all other rights. Unless applicable law gives you more rights despite this limitation, you will not (and have no right to):[…] d) use the software for commercial, non-profit, or revenue-generating activities Oops. Better not install this on your work laptop! [0] https://marketplace.visualstudio.com/items/ms-ossdata.vscode-pgsql/license https://marketplace.visualstudio.com/items/ms-ossdata.vscode...
  • jasonthorsness 1y ago
    I worry that with the threat of Cursor this will be more common now. Microsoft's business interest will prevent them from funding development work that directly benefit the popular forks (for years they probably assumed no fork could ever gain traction...).
    • kstrauser 1y ago
      I suspect you're right. And thus came the end of the era of free VSCode.
    • Onavo 1y ago
      Microsoft owns shares of Cursor through OpenAI
  • krferriter 1y ago
    Can't use it for commercial, non-profit, or revenue-generating activities? Uh, this actually seems insane to me? What is it for then?
    • kstrauser 1y ago
      My initial reaction is "entrapment". Edit: That's uncharitable of me. I strongly doubt that's the plan. But it genuinely was the first thing that came to mind.
      • 1y ago
• jasonthorsness 1y ago
  I use DataGrip, but only for very simple tasks and only against PG and occasionally SQLite and it has always felt like way overkill for me (and it's a heavy app). This will be a more convenient option!
  • codingjerk 1y ago
    DataGrip would be perfect if it had a community edition. As someone who connects to a database only two or three times a week, I’m not willing to pay for it.
    • jasonthorsness 1y ago
      Yeah I already have the all-products pack for Goland, Clion, and Resharper, I wouldn't have purchased DataGrip separately
      • cwbriscoe 1y ago
        Yeah same. As great as Datagrip is, I would have stuck with DBeaver if I didn't have the All Products Pack.
      • kerenskiy 1y ago
        You don't need to buy DataGrip to get all the same functionality. It's built-in in every paid IDE as Database Tools plugin
    • getgalaxy 1y ago
      try galaxy instead ;) getgalaxy.io
  • written-beyond 1y ago
    Beekeeper for small stuff, that's my rule. However, I feel this may start to change that for me. Data grip for big serious stuff.
• pgwhalen 1y ago
  Doesn't look like there's much beyond what's currently possible in DataGrip yet (which is far beyond any other SQL client I've used), but nice to see a competitor in the space - especially one that will push JetBrains on the AI assistance side of things.
• nico 1y ago
  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
  • lyu07282 1y ago
    Isn't that exactly what pgadmin is? https://www.pgadmin.org/ https://www.pgadmin.org/
    • nico 1y ago
      Nice, thank you! Might spin up a docker with it to keep running :) I guess not everything needs to live inside my IDE
• nrmitchi 1y ago
  [flagged]
  • deleted 1y ago
    [deleted]
• codingjerk 1y ago
  Looks promising, but I'll probably stick to `psql`
  • dpflan 1y ago
    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?
    • deadbabe 1y ago
      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.
      • homebrewer 1y ago
        I am very comfortable in the command line and still work with databases in IDEA. It gives you: — autocompletion for everything — table/function names, types; very helpful on projects with hundreds to thousands of tables — navigation ("jump to referenced table", "find foreign keys to this column", etc) — data export in two dozen formats (configurable) — exactly the same UI for working with 30 database engines (or however many it supports, I'm too lazy to count). Especially helpful with databases that have atrocious CLI clients, like Oracle. — a nice tree-structured view of your database; or you can generate a (possibly vector) diagram for the rare case when that helps — high quality autoformatter that works for every SQL dialect it supports, and in the same way — minor things like the ability to extract a subquery with a couple of key presses, or rename a table alias Probably something else I'm forgetting. Saving a couple of keystrokes when writing SQL has little to do with it.
      • codingjerk 1y ago
        I'm using CLIs like A LOT, but still would be happy to get _good_ autocomplete for SQL. `psql` is pretty bad at it and in `\e` you will just end up in an editor, which will probably don't know about your schema. I've tried many tools, but seems like I like DataGrip (or databases in PyCharm Professional) the most, so I use EAP from time to time, when I'm going to write a lot of SQL.
• prmph 1y ago
  [flagged]
  • deleted 1y ago
    [deleted]
• Toritori12 1y ago
  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...).
  • jjeaff 1y ago
    it has to be VS Code by a long shot. They don't charge for it, but it serves as an enormous draw to keep people in the MS ecosphere and keeps MS in the developer game.
    • rafaelmn 1y ago
      That's ironic since I develop most of my Microsoft related tech with JetBrains products and only use vs code for frontend/node - non Microsoft stuff.
  • pjmlp 1y ago
    Monetarily, Visual Studio. There are tons of enterprise development workflows, and plugins, that probably will never be ported into VSCode, from their .NET and COM implementations. Now in terms of mindshare, and gateway drug into Microsoft ecosystem, definitely VSCode. It is also the best Web IDE, for the return of timesharing development, sorry cloud. That alone means everyone that is on Github and Azure, gets to use it as the modern version from X Windows and RDP/Citrix sessions. Not bad, for Eclipse v2 (Enrich Gamma is one of the main architects), pity the whole Electron shell though.
    • pphysch 1y ago
      How is VSCode a "gateway drug" into the MS ecosystem? It's good PR, for sure, but it has little to no conceptual/GUI overlap with, say, Windows. FWIW I use it via Linux .deb and integrate with a private GitLab.
• getgalaxy 1y ago
  Super cool for them to finally add in VSCode. My team is trying to build even more here by building a dedicated SQL editor with a context aware AI copilot, and with sharing and collaboration so we don’t need to send queries in slack anymore :) Check it out and get on the waitlist getgalaxy.io/explore/product-tour happy to chat live with anyone if interested, support@getgalaxy.io
  • MonkeyClub 1y ago
    Your whole comment history seems to be spamming for your app. Not a good way to generate potential user interest or generally good feelings towards it. Just saying.
    • written-beyond 1y ago
      I agree, I immediately felt that their product was cheapened for me. The only other "newish" developer tool I used were Beekeeper and Bruno and that too only because there were a lot of users naturally shilling for them (like I am now) on HN.
  • sphars 1y ago
    The GIF on your landing page is very jarring, with the constant zooming in and out. Way too fast to read what you're zooming into.
• FajitaNachos 1y ago
  Postico has always been my defacto way to interact with Postgres. Curious if there are any Postico users who have tried this yet.
  • georgel 1y ago
    10+ year user of Postico. I will give this a try. I hope Copilot can start recognizing the schema when I use node-pg.
  • deepsun 1y ago
    Very Mac-oriented, and I think IntelliJ built-in DB editor has way more functions / features.
    • jasoncartwright 1y ago
      The heavy Mac UX compliance is the reason why I enjoy using Postico for 99% of straightforward Postgres tasks
• saqadri 1y ago
  This is so cool. A big reason I used prisma was for prisma studio. Having this kind of support in vscode is nice to see
  • gniting 1y ago
    (prisma team member) We're going to be rolling out Prisma Studio as a VS Code extension soon!
    • ketzo 1y ago
      Ooooh can’t wait for that, and for further investment in Prisma Studio generally — already a really nice tool, I just want some slightly more power-user-y stuff!
• weitendorf 1y ago
  The AI integration is interesting to me. I have been trying to get Claude to help me with postgres from within my product and have found its ability and understanding of postgres/sql to be significantly worse than with common programming languages. Maybe it's because my tolerance for imperfection is much lower for databases than web apps, but it is so bad that I can't trust it for anything database-related beyond text transformations and generating boilerplate queries. It will incorrectly tell me things like postgres doesn't support TABLE OF <TYPE>, or make syntax errors for ON CONFLICT, and immediately agree with any "what about" or "are you sure" I throw at it. Curious if anybody else has run into this. Obviously LLMs are not always great in specialized domains like this but the poor performance with something as popular as postgres is pretty uncharacteristic IMMO.
  • dwedge 1y ago
    I think it's more that LLMs are a given percentage (let's say 30%) inaccurate in general, and the results of this inaccuracy are just more immediately obvious with SQL
• seveibar 1y ago
  This 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 whether or not it's better to have your editor database-aware or to have your codebase have appropriate context committed. On one hand, less generated code/artifacts make for a cleaner codebase. On the other hand, not everyone uses VC Code or will know how to use this integration. Database browser GUIs have never really had a single winner. That said, VS Code does have enough dominance to potentially make themselves "the standard way to view a database in development" [1] https://github.com/seveibar/pgstrap https://github.com/seveibar/pgstrap
  • netghost 1y ago
    That seems like a really pragmatic tool, thanks for sharing it! I'm curious, do you output triggers, store procedures, and such? Many tools seem to stop after you've defined tables, columns, and indices, but I'd love some better tooling to make use of the rest of the DB's features.
    • seveibar 1y ago
      Yep! It basically runs pg_dump and categorizes all of the output into different files so it should be comprehensive. I think there's `functions/function_name.sql`, `misc.sql`, `triggers.sql` etc.
      • what 1y ago
        You built it but you don’t know what it outputs?
      • netghost 1y ago
        Thanks! And curses. Now I'm going down another rabbit hole rehashing ways to interface with my database in a side project that is doomed to never get past the "there has to be a better way to…" phase ;)
• abetaha 1y ago
  This looks great. Would all the functionality work if the databases are hosted on other cloud providers?
  • maxluk 1y ago
    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.
    • abetaha 1y ago
      Thank you, this is great
• barfolomew 1y ago
  I will be using this. 100%. very handy
• bdcravens 1y ago
  Looks nice enough. I only wish there was an easy way to spread VS Code across multiple monitors. I commonly will work in code on one monitor, and the database tool (DataGrip currently) on another.
  • Fire-Dragon-DoL 1y ago
    I noticed yesterday that you can pull out a tab into its own window. It's not "natural" cross monitor, but you can place the windows on both. Not sure if that helps
  • jayflux 1y ago
    VS Code has had multi monitor support for a while now https://code.visualstudio.com/docs/configure/custom-layout#_floating-windows https://code.visualstudio.com/docs/configure/custom-layout#_...
  • bartvk 1y ago
    Have you thought about just solving the problem with hardware? I.e. one giant 38" wide screen?
  • wenc 1y ago
    You can already do that. I run VS Code on multiple monitors. Any tab called be pulled into its own window and moved to a different screen. Even the terminal panel can be popped out into a tab or panel or window. (The UI is not obvious but once you see it you can’t unsee it) It’s pretty cool to have the code and terminal side by side in the editor window. (Of course this was always possible with emacs)
• cebert 1y ago
  I wonder how well this IDE works if you use AWS or GCP instead of Azure.
  • tsumnia 1y ago
    I run a personal Postgres server so I'm wondering how well it does there
  • deepsun 1y ago
    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.
  • maxluk 1y ago
    PM on the project here - All clouds and on-prem/local/docker work great! We test those, so if you have issues, please report in the repo we'll fix them.
• zamacho 1y ago
  Is there a similar extension for MySQL in VS Code?
  • jamesgeck0 1y ago
    Database Client is fairly similar. I don't think it does the schema diagrams or AI stuff, but it can do notebooks. Has a shareware pricing model, free for up to three active connections. https://database-client.com/ https://database-client.com/
• deelowe 1y ago
  Does something like this exist for mysql?
  • vincnetas 1y ago
    DBeaver?
    • deelowe 1y ago
      For vscode? I thought dbeaver was its own app.
      • p4ul 1y ago
        Your understanding is correct, dbeaver is a stand-alone application.
• rubabu 1y ago
  does this work for non-Azure?
  • maxluk 1y ago
    PM on the project here - Yes! It works on any Postgres, on-prem or cloud
    • gabrieledarrigo 1y ago
      Hi maxlux, is it possible to configure a connection over SSH?
      • maxluk 1y ago
        Not directly in the extension connection object, but it's in on the roadmap. In the meantime, you can create ssh tunnel using vscode remotes and then just connect through it.
• 0x8j0rn4r80r93 1y ago
  This is great!
• helpfulContrib 1y ago
  Has there been a final solution to the VSCode phoning-home problem? Last time I tried to use it in my environment, it triggered too many 'external network requests' for the liking of our IT guy. We relegated it to the "Do Not Use" pile as a result. Has this been resolved? Nobody in my team wants to use an IDE that sends data back to its masters ..
• gitroom 1y ago
  [dead]
• nodesocket 1y ago
  This might already exist, but seems like AI would be a natural fit and efficient at recommending indexes based off queries. I’ve been building a Python SQLite3 app and I gave ChatGPT the entire schema along with all queries and it did a fantastic job at recommending queries and explaining them. Compound indexes, unique indexes, compound primary keys. Taken a step further, if a process ran live inspecting queries in real time and then sent notifications of missing indexes would be super useful.
  • tudorg 1y ago
    I think you are describing Xata Agent :) https://github.com/xataio/agent https://github.com/xataio/agent It watches metrics/logs, queries pg_stat_stetements for slow queries, the sends slack notification with suggestions, including indexes, but can be more varied than that.
• jenny91 1y ago
  Glad to see them releasing it under an MIT license.
  • hamandcheese 1y ago
    It's not. There is no actual code in the repo.
    • jenny91 1y ago
      Wow. What the heck?
• qwertywert_ 1y ago
  Isn't PGAdmin good enough? Not hating, but I'm not a database guy either so just curious why create a VSCode extension for GUI stuff.
  • lukebuehler 1y ago
    it's nice to have copilot in the db admin tool. I use pgadmin every day, and it's great, but lately i have found myself wishing to have AI support in writing certain queries.
  • ketzo 1y ago
    The longer I work in engineering the fewer windows I want open on my screen If this is “PGAdmin, but 50% worse, but it just lives as another tab in your editor instead of another application” that is genuinely a huge win for me Probably that’s because my day-to-day isn’t actually database administration, it’s application development where I need to be able to work with a database from time to time — so the preservation of context, however marginal, is really nice.
  • drited 1y ago
    Can you setup entra authentication with PgAdmin? I'm more of a MS Sql person so I don't know, but if not the security improvement from this would be a huge improvement
  • deleted 1y ago
    [deleted]
  • deepsun 1y ago
    PgAdmin I think is more for working with data, I use Intellij DB editor mostly for writing complex SQL (with autocomplete, coloring, auto-formatting). It also recognizes your regular programming code strings as SQL and can also autocomplete/highlight typos, but I don't use that, because we're using JOOQ that generates code stubs from live DB.
  • srameshc 1y ago
    I love PGAdmin. For me it works very well. And then there are other tools when I need to work with schema etc. I always feel PGAdmin is an open source product that the team is most actively working on, always keep releasing fixes and updates. I don't want it in my IDE yet.
• todotask2 1y ago
  There seems to be a bug — I can't re-run the query from the query history panel; it returns no results. New query could still get results. Overall, it should have been a separate app because you can't really see all the results in a small panel.
  • pamelafox 1y ago
    Please file that bug in the issue tracker: https://github.com/microsoft/vscode-pgsql/issues https://github.com/microsoft/vscode-pgsql/issues The team is very receptive to feedback, in my experience.
• didip 1y ago
  This is amazing. I imagine later LLM have access to my table metadata and then perhaps down the road, LLM can suggest me better queries based on execution plans that it saw.
  • spiderfarmer 1y ago
    Have you read the article?
• VeejayRampay 1y ago
  I don't really understand the UI though, there's no way to provide a host am I the only one to have that problem?
  • ThatMedicIsASpy 1y ago
    Figure 6 in the article shows it.
    • VeejayRampay 1y ago
      thanks a lot I really wonder why they would call it "server name" instead of database host though
      • written-beyond 1y ago
        True it's a little confusing, I think it's probably because they use that generic term a lot around code for other places that may have a context specific name for the "server" is called.
• Ericson2314 1y ago
  Microsoft Access meets PostgreSQL, 3 decades later?
  • cerved 1y ago
    Is there something related to Access in this that I missed in this or you just being salty, because I have to work with that garbage and if there's something better than DBeaver I can use for that I'm all ears
    • Ericson2314 1y ago
      I'm just picking Access as an example of an old MS "database GUI".
  • jasoncartwright 1y ago
    Ah man, Access. Got a website to over 1m users/month with a dead simple Access DB and ASPv3. Back when a million users was a million users.
• tombert 1y ago
  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?
  • debarshri 1y ago
    We build privileged access management tools. Majority of our users do not like to use CLI. They know workbenches, pgadmin etc. at a wizard level. In my opinion, i see that graphical editors are more product for major section of devs and admins.
  • deleed 1y ago
    You don't use it but still it's nice feature to have, isn't it?
    • tombert 1y ago
      Oh sure, I'm not criticizing its existence.
    • epolanski 1y ago
      I think he went a long way to simply ask what do these tools do that a cli won't.
  • mcv 1y ago
    I haven't used it for relational databases, but I can imagine it's useful to visualize complex relationships between tables.
  • hbn 1y ago
    Just today I've been dealing with an issue trying to update an XML column because the XML I'm trying to insert was escaping the string in the update query. But with DataGrip I could just pull the row I was interested and paste in the string from the UI. Surely there's another workaround that wouldn't involve a UI but this made it pretty easy.
  • harrall 1y ago
• illuminated 1y ago
  I wonder how this compares to pgModeler (https://pgmodeler.io/ https://pgmodeler.io/) which I've been using the most in the recent years, would love is someone who had tried both could share some observations.
• deepsun 1y ago
  Graphical schema image generation was in IntelliJ for like 15 years at least? Since the times with all the craze about UML "disrupting" software engineering.
  • robertlagrant 1y ago
    UML was the late 90s! Rational Rose[0] was the glorious future of class design. Draw the diagram and let the juniors fill in the methods. [0] affectionately Crashional Rose
    • deepsun 1y ago
      I was a junior back then, and was afraid to speak up that Rational Rose is just a waste of time. Don't you dare say that about LLMs!
      • pjmlp 1y ago
        No worries, nowadays we have Enterprise Architect https://www.sparxsystems.eu/ https://www.sparxsystems.eu/
  • meta_ai_x 1y ago
    Automatic Schema Visualization always miss the biggest point. When you generate visualization, you should only show key table and key fields within the table and hide all the helper, secondary fields and tables. In an LLM world this should be easy for LLMs to pick out key tables and fields and only display those
    • deepsun 1y ago
      Some fields are important for HR, others for Security, others for BI. Gotta have different visualizations for everyone. LLM here would be like another person or another team, that decides what's important for me, what I should see and what I should not. Might work, but I'd rather see the full picture and decide myself.
    • 1y ago
• d0100 1y ago
  So it's just Azure Data Studio where it lacks SSH tunneling... I got my hopes up for nothing
  • joseda-hg 1y ago
    Doesn't VSCode have first party SSH tunneling support [1]? What are you missing? [1] https://code.visualstudio.com/docs/remote/tunnels https://code.visualstudio.com/docs/remote/tunnels
    • d0100 1y ago
      I can also create them with ssh But I prefer to keep that info with the db connection, and have it automatically run when I connect It's a pretty standard expectation (Navicat, DBeaver, etc)
• polishdude20 1y ago
  Just tried it, wish there was better refactoring tools available! If love for there to me a "rename variable" feature.
• scirob 1y ago
  the copilote being aware of postgres schema is a thing I manually have to deal with in cursor rules. I keep all the SQL DLL files that created any table in context but then also its best to have cursor rules to tell it to use one orm if possible
• robertlagrant 1y ago
  > Password-less authentication with Entra Id I don't understand why the first four points under this heading are basically the same.
• ryanmccullagh 1y ago
  Remember the old adage, embrace, extend, extinguish.
  • xandrius 1y ago
    They will extinguish postgres?
    • unnouinceput 1y ago
      They definitely tried that with MSSQL. Didn't worked so far. But M$ tactic is always the same. Copy, throw money, copy some more, throw more money. If doesn't work, change the CEO, throw more money until the rival is dead. So yeah, they are throwing money to try to suppress PGSQL from existence. They did that tactic with Delphi (bought the main guy from Borland and that's how we got C#), MSSQL is their answer to PostgreSQL, ASP is their answer to PHP and so on. Oh, and if you think "MS loves Linux" is anything but this tactic, think again - WSL/WSL2 is the proof they still trying to kill Linux.
• pbw 1y ago
  Is there a similar feature available for SQLite? Will there need to be a totally new extension for every DB, or is there a shared portion?
  • Sammi 1y ago
    There are multiple vs code extension for sqlite. I tried a few of them and they were not great. Except this one, which I now use daily: https://marketplace.visualstudio.com/items?itemName=yy0931.vscode-sqlite3-editor https://marketplace.visualstudio.com/items?itemName=yy0931.v...
• computerthings 1y ago
  [dead]
• pamelafox 1y ago
  Congrats to the team on launching this! I was actually the first to demo it, as part of our sponsored session at Microsoft last week. Here's the talk where I used it: https://www.youtube.com/watch?v=k6Vm2hakkV4 https://www.youtube.com/watch?v=k6Vm2hakkV4 I also did a theater session at our MSFT booth, but the recording isn't up yet. You can follow the steps in this repo to check out all the features that I demo'd, however: https://github.com/Azure-Samples/postgresql-extension-playground https://github.com/Azure-Samples/postgresql-extension-playgr... Let the team know about any issues here: https://github.com/microsoft/vscode-pgsql/issues https://github.com/microsoft/vscode-pgsql/issues
  • deleted 1y ago
    [deleted]
  • sieabahlpark 1y ago
    [dead]
  • justusthane 1y ago
    Hey, just a heads up that your website 404s if visted at "pamelafox.org", which is how it appears in your bio.
    • pamelafox 1y ago
      Thanks, I need to move that website to GitHub Pages soon, the current host isn't handling the naked domain well. Changed to www.pamelafox.org for now.
  • deleted 1y ago
    [deleted]
• nsonha 1y ago
  Shame it's not a generic thing that can work with MySQL
• theappsecguy 1y ago
  Ages behind Jetbrains and more of electron dumpster fire. No thanks
  • deleted 1y ago
    [deleted]
• herpdyderp 1y ago
  Too bad I switched to PGlite for local dev (not really because I love PGlite). I unfortunately don't see any PGlite VS Code extensions.
• hn1986 1y ago
  I wonder if this will work with Redshift , which is based on Postgres?
• WuxiFingerHold 1y ago
  >> 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).
  • diggan 1y ago
    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.
    • asrael_io 1y ago
      i feel like we need a first-era unsuck it search engine for this :D
  • fithisux 1y ago
    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..
• ajsharp 1y ago
  and just like that, 90% of the reason i pay for a jetbrains license just...disappeared
  • throwaway2037 1y ago
    The difference? JetBrains won't pull the rug on you, or abandon the product at the next turn in the road.
• dankobgd 1y ago
  Tried 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.
• jtougas 1y ago
  I 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/ 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.
  • overtomanu 1y ago
    There is also an extension for VS Code from the same author https://github.com/mtxr/vscode-sqltools https://github.com/mtxr/vscode-sqltools
    • jtougas 1y ago
      Unfortunately it suffers from many of the same problems.
• mohsen1 1y ago
  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?
  • jeroenhd 1y ago
    Cursor was based on quite an old version of VS Code laat time I checked, so it's possible Microsoft just didn't target compatibility with a release from six months ago. This is also what's said here by one of the devs: https://github.com/microsoft/vscode-pgsql/issues/15 https://github.com/microsoft/vscode-pgsql/issues/15 Looks like manually loading the VSIX to bypass the compatibility check should work but who knows how stable that'll be.
  • oxedom 1y ago
    You can download the .vsix file directly from marketplace.visualstudio and install it in cursor.
• dunefox 1y ago
  "You don't have permission to access url"
• alexpham14 1y ago
  I’m truly grateful for this. It’s really helpful because I love VSCode, and most of my projects use Postgres. The decision to prioritize Postgres support was quite unexpected.