Category: All posts
Oct 07, 2024
For years, developers have been using PostgreSQL for all kinds of workloads, from managing simple web app data to handling complex real-time analytics. As the demand for PostgreSQL grows, so does the need for tools that support fast, collaborative, and streamlined workflows.
However, the experience of connecting and interacting with the database has yet to fully evolve to meet this new landscape, with many developers still connecting to PostgreSQL using psql, pgAdmin, and DBeaver.
While these tools have served developers well for many years, they were not designed to meet the needs and collaborative workflows of developers building modern applications in the cloud. When you add in other tools like Grafana for visualization and GitHub for managing query versioning, it creates a fragmented, siloed workflow that slows developers down.
Earlier this year, we acquired PopSQL to solve that problem and help us build the best PostgreSQL developer experience for the cloud era. Today, we are announcing a big step toward that mission: bringing the amazing capabilities PopSQL offers directly inside the Timescale Console with our new Ops and Data modes. Ops mode focuses on configuring and managing your database services, while Data mode serves as your integrated go-to solution for connecting to your database to develop your application queries, share data insights through dashboards, and help troubleshoot database issues.
With these two modes, we are making developers more productive by providing database operations and an intuitive, collaborative SQL editor that simplifies query writing, collaboration, visualization, and sharing all in one place.
We’ll dive into those features in a minute, but first, let’s take some time to understand the typical experience of developers working with PostgreSQL.
We asked PostgreSQL developers about their day-to-day tools, and here’s what they said in our 2023 State of PostgreSQL survey: most use psql (59.5%) to execute SQL queries, followed by pgAdmin (38%) and DBeaver (30.4%). (Stay tuned for this year’s report! If you haven’t taken this year’s survey yet, do it! It’s open until October 31.)
These tools were built for individual use on local desktops, with limited support for real-time collaboration and no seamless way to share queries or visualizations across teams who rarely work all together in the same office.
psql offers a command-line interface that’s powerful but lacks the user-friendly features needed for quick visualization or sharing. While pgAdmin and DBeaver provide more functionality, they are still rooted in a single-user mindset, making team collaboration cumbersome. The top five includes DataGrip and IntelliJ, which are also single-user desktop tools.
To make matters worse, developers often rely on additional tools for building visualizations, like Grafana, copy-pasting into Slack to share queries or dashboards, using GitHub for query versioning, etc. This fragmented workflow is inefficient and error-prone, with constant copying and pasting across multiple tools.
Before discovering PopSQL, this was exactly the experience we had at Timescale. We used psql for querying data, Grafana for dashboarding, and Slack for collaboration. When writing a query in psql, we collaborated by copying and pasting the SQL in Slack as we made changes, which slowed us down and introduced errors.
Putting that query in Grafana to create a dashboard meant more copying and pasting, and if that query was later updated through Slack conversations, we had to somehow ensure it was kept up to date in Grafana. Finally, finding an agreed-upon query in Slack and its change history required scanning long, buried Slack threads. It was like searching for a needle in a haystack—endless scrolling, broken context, and a lot of wasted time.
“There’s got to be a better way,” we thought. Modern cloud-based development requires a tool that not only allows for writing and running SQL but also enables easy sharing, version control, and visualization—all within a collaborative environment. Sadly, this is something traditional tools weren’t designed to offer.
Then we found PopSQL and fell in love with its intuitive interface, fast query editor with integrated versioning, collaboration options, powerful dashboards, and amazing sharing capabilities. We wanted to bring all of those features to our users through a single integrated web UI that combined the power of the Timescale Console with PopSQL.
Our new Ops and Data Modes, designed to meet the diverse needs of PostgreSQL users, are the heart of the PopSQL and Timescale Console integration.
Ops Mode is for managing and maintaining Timescale services—it’s what the Timescale Console used to be. Whether you're adding replicas, setting up continuous aggregates, or fine-tuning your database settings, Ops Mode gives you a clear, operationally focused view. This mode also leverages PopSQL’s querying capabilities to turn SQL instructions into runnable queries and offers a fast, lightweight SQL editor for running one-off queries to check database stats or troubleshoot minor issues.
Data Mode is all about unlocking the full power of PopSQL. This is where your queries come to life—you can write, visualize, share, and schedule them without ever leaving the console. Think of it as your SQL playground, where you get autocomplete for faster coding, schema exploration to navigate your database and visualizations that transform query results into beautiful, shareable charts.
Switching between modes is just one click away.
Let’s dive deeper into the new capabilities now available directly through the Timescale Console.
PopSQL’s integration into the Timescale Console transforms how teams work with SQL, offering a suite of features that enhance querying, collaboration, and visualization:
Create SQL-based dashboards faster than any other tool, allowing you to deliver insights in minutes rather than weeks compared to traditional dashboarding and BI tools:
PopSQL Notebooks let you tell comprehensive data stories by combining queries, visualizations, and explanations all in one place. Use it to create clear, shareable narratives that make your troubleshooting and analysis easy to understand and explore.
PopSQL makes sharing and organizing SQL easy by creating a centralized, reusable library of peer-reviewed queries, dashboards, and notebooks, improving efficiency and collaboration across your team.
PopSQL is designed to work seamlessly with your Timescale database while also allowing you to connect many popular databases, all from one platform. Whether you’re working in the cloud or locally, PopSQL makes connecting to multiple data sources simple and secure.
Bringing PopSQL into Timescale is just the beginning. Ops Mode and Data Mode are the first steps in modernizing PostgreSQL’s GUI and integrating PopSQL more deeply into the PostgreSQL ecosystem. We’re committed to delivering a cloud-native, collaborative, and scalable PostgreSQL experience that aligns with what developers like you expect today.
As workflows grow more complex and the demand for collaboration increases, we’ll keep evolving this foundation. Over the coming months, you can expect new features that will push the boundaries of what’s possible. We’re especially excited about AI-driven improvements that will take your developer experience to the next level—but we’ll keep the details under wraps for now. Stay tuned—there’s much more to come.
If you’re a Timescale Cloud customer, Data Mode and Ops Mode are already in your console. Try them out, and I’d love to hear your thoughts. If you’re not yet a customer, now’s a great time to get started.
