Microsoft buffs up its open-source halo to fine sheen with PostgreSQL GUI in Azure Data Studio

And an extension for those who prefer Visual Studio Code – but all very preview at the mo

Microsoft has booted out a Postgres GUI for those moments when the command line is just too scary.

Azure Data Studio received a preview of support for PostgreSQL last night. Its stablemate, Visual Studio Code, has been given a corresponding extension.

The thinking has been that while users may be used to hacking away at the psql command line, something a little more visual can often be a delightful palette cleanser. Or simply a less intimidating way of getting users acquainted with the database.

Users are spoiled for choice these days when it comes to graphical tools. DBeaver, for example, has done a sterling job of wrapping a variety of popular databases up in a cuddly-ish front-end – and if PostgreSQL is your thing there is always the venerable pgAdmin.

As with many things in the open-source world, devs will have their own personal preference and be terribly passionate about it.

Microsoft's foray into the PostgresSQL GUI world can now be added, and with the cross-platform, open-source VS Code proving popular among developers, having the functionality accessible through an extension will appeal to many.

Connecting to databases is simple enough, and the server can be on-premises, lurking in a VM or exposed as a service by a cloud provider (Microsoft has not insisted on Azure).

Disappointingly for VS Code users, the connection has been set up for a default port and requires tinkering with configuration files if you've opted for something different. This is preview code after all.

Once in, servers may be grouped and database objects viewed via an explorer-type navigator, as one would expect. Azure Data Studio has also come equipped with a terminal, so devs can always drop into psql if needed.

The query editor, while not as complicated as some, includes IntelliSense's context-aware code completion and allows developers to jump to the definition of objects.

In an entirely unscientific test, I took Azure Data Studio out for a spin and, having installed the preview extension, pointed it at a locally running PostgreSQL server.

Generally, performance was good and having the database objects navigable within the GUI was handy. It was clearly not as full-featured as some alternatives, but it was quick and easy to get into. Users expecting a full-on administration experience will be disappointed, but as a quick query tool it is an admirable first effort.

It is also very, very preview and I'd advise against letting it loose on anything production-like just yet.

The gang are keen to get the community involved, and that default port issue? Already in GitHub. ®

Similar topics

Other stories you might like

  • Amazon warehouse staff granted second chance to vote for unionization

    US labor watchdog tosses previous failed result in the trash

    America's labor watchdog has given workers at Amazon’s warehouse in Bessemer, Alabama, another crack at voting for unionization after their first attempt failed earlier this year.

    “It is ordered that the election that commenced on February 8 is set aside, and a new election shall be conducted,” Lisa Henderson, regional director at the National Labor Relations Board, ruled [PDF] on Tuesday.

    “The National Labor Relations Board will conduct a second secret ballot election among the unit employees. Employees will vote whether they wish to be represented for purposes of collective bargaining by the Retail, Wholesale and Department Store Union.”

    Continue reading
  • It's the flu season – FluBot, that is: Surge of info-stealing Android malware detected

    And a bunch of bank-account-raiding trojans also identified

    FluBot, a family of Android malware, is circulating again via SMS messaging, according to authorities in Finland.

    The Nordic country's National Cyber Security Center (NCSC-FI) lately warned that scam messages written in Finnish are being sent in the hope that recipients will click the included link to a website that requests permission to install an application that's malicious.

    "The messages are written in Finnish," the NCSC-FI explained. "They are written without Scandinavian letters (å, ä and ö) and include, for example, the characters +, /, &, % and @ in illogical places in the text to make it more difficult for telecommunications operators to filter the messages. The theme of the text may be that the recipient has received a voicemail message or a message from their mobile operator."

    Continue reading
  • AsmREPL: Wing your way through x86-64 assembly language

    Assemblers unite

    Ruby developer and internet japester Aaron Patterson has published a REPL for 64-bit x86 assembly language, enabling interactive coding in the lowest-level language of all.

    REPL stands for "read-evaluate-print loop", and REPLs were first seen in Lisp development environments such as Lisp Machines. They allow incremental development: programmers can write code on the fly, entering expressions or blocks of code, having them evaluated – executed – immediately, and the results printed out. This was viable because of the way Lisp blurred the lines between interpreted and compiled languages; these days, they're a standard feature of most scripting languages.

    Patterson has previously offered ground-breaking developer productivity enhancements such as an analogue terminal bell and performance-enhancing firmware for the Stack Overflow keyboard. This only has Ctrl, C, and V keys for extra-easy copy-pasting, but Patterson's firmware removes the tedious need to hold control.

    Continue reading

Biting the hand that feeds IT © 1998–2021