PopSQL

Blog

Read our changelog to hear first

Post cover image

YOY Calculation: How to Calculate Year-Over-Year Growth

OCT 15, 2023

Uncover the significance of Year-over-Year (YoY) growth in business analysis. Our guide offers a quick understanding of its calculation, SQL implementation, and impactful visualization. Ideal for data professionals eager to leverage YoY growth for strategic decision-making.

Post cover image

Snowflake vs Redshift: Key differences and comparison

OCT 12, 2023

Explore the Snowflake vs Redshift comparison to discover your ideal data warehousing match. Learn more about enhancing your data warehousing experience with PopSQL, a modern SQL editor that complements both Snowflake and Redshift.

Post cover image

dbt Best Practices: Superpower Your dbt Project with PopSQL

OCT 10, 2023

Maximize your dbt project's potential with PopSQL. Learn how to connect databases, streamline testing, and manage schema changes efficiently. Enhance your data analysis workflow and productivity with this comprehensive guide.

Post cover image

ChatGPT for SQL: How to Write SQL Queries with OpenAI

SEP 28, 2023

Data is only as good as the queries we run, and SQL remains the quintessential tool for accessing, modifying, and manipulating this data. But what if we could leverage artificial intelligence to help write and optimize SQL queries? We delved deep into how LLMs could revolutionize the SQL writing process.

Post cover image

How to Write dbt Macros using Jinja

SEP 22, 2023

In the dynamic world of data analytics, understanding dbt macros and their interaction with Jinja enhances efficiency. This post delves into the specifics of dbt macros, highlights the wonders of Jinja, and explores how dbt integration can improve macro creation and testing.

Post cover image

Introducing Materialize Support in PopSQL!

SEP 12, 2023

Our platform now supports connections to Materialize. If you've ever wished you could just write materialized views and let the database handle keeping results up to date, your dreams just came true.

Post cover image

Announcing Trino Support in PopSQL!

SEP 7, 2023

We're excited to unveil the latest addition to our PopSQL database connections: Trino SQL engine! For those who may not be familiar, Trino is an exceptional open-source, distributed SQL query engine.

Post cover image

Complex SQL Queries: Examples & Advanced Techniques

AUG 25, 2023

Complex queries in SQL don't need to be hard to write. Learn what they are, how to create them, and some examples in this article.

Ready for a modern SQL editor?