Regardless of how you feel about Excel, it is still the tool of choice for many data analysts, and being able to provide an Excel file easily does help sometimes.įinally, ADS also provides some basic charting capabilities using query results. While there are (seemingly) a thousand ways to quickly get a result set into CSV, producing a correctly formatted Excel file requires a plugin with almost any other tool. Second, ADS provides the ability to export query results to Excel without any plugins needed. Typically you'd have to wrap your SQL inside of another runtime like Python, but ADS provides the option to select the "SQL" kernel and deals with the connection and SQL wrapping behind the scenes. There are a couple of unique features in Azure Data Studio (ADS) that work with both SQL Server and PostgreSQL connections that I think are worth mentioning.įirst, ADS includes the ability to create and run SQL-based Jupyter Notebooks. Although the primary feature set is currently geared towards SQL Server (for obvious reasons), the ability to connect to PostgreSQL has been available since 2019. Introduced as a beta in December 2017 by the Microsoft database tooling team, Azure Data Studio has been built on top of the same Electron platform as Visual Studio Code. If you love to stay in the terminal but want a little more interactivity, the dbcli tools have been around for quite some time, have a nice community of support, and might make database exploration just a little bit easier sometimes. Syntax highlighting and some basic support for psql backslash commands are included. Although this is not a replacement for psql, it provides an interactive, auto-complete interface for writing SQL and getting results. pgcliįirst on the list is pgcli, a Python-based command-line tool and one of many dbcli tools created for various databases. If they can be helpful to my (or your) development workflow in certain situations, I think it's worth digging a little deeper. Often, it's this next set of PostgreSQL tools that has gained enough attention from community members that there's obviously a value proposition to investigate further. What I was more interested in were the mentions that happened just after the more popular tools I expected to see. However, if your company or team already uses JetBrain's tools, you might have access to these popular tools. The next more popular GUIs (Datagrip and IntelliJ) are licensed per seat. The most popular GUIs (pgAdmin and DBeaver) are open source and freely available to use. Most of these aren't surprising if you've been working with databases, PostgreSQL or not. PgAdmin (35 %), DBeaver (26 %), Datagrip (13 %), and IntelliJ (10 %) IDEs received the most mentions. It's clear, however, that many users with all levels of experience do trust other tools as well. □ PostgreSQL Querying and AdministrationĪs we just said, psql is by far the most popular tool for interacting with PostgreSQL. What other tools did folks bring up often for interacting with PostgreSQL along the three use cases mentioned above? PostgreSQL Tools: What Do We Have Against psql?Ībsolutely nothing! As evidenced by the majority of respondents (69.4 %) that mentioned using psql for querying and administration, it's the ubiquitous choice for so many PostgreSQL users and there is already good documentation and community contributed resources ( by Leatitia Avrot is a great example) to learn more about it. During this year's survey, we modified the questions slightly so that we could focus on three specific use cases and the PostgreSQL tools that the community finds most helpful for each: querying and administration, development, and data visualization. In the database community, however, there are usually two things that drive lots of discussion year after year: performance and tooling. The State of PostgreSQL 2022 survey closed a few weeks ago, and we're hard at work cleaning and analyzing the data to provide the best insights we can for the PostgreSQL community.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |