PopSQL

Blog

Read our changelog to hear first

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.

Post cover image

Mastering dbt Testing for Your Cloud Database (Best Practices)

AUG 11, 2023

In this guide, we aim to provide an in-depth understanding of the importance of dbt testing in data engineering, explore various types of dbt tests, and offer effective strategies to incorporate these tests into your data workflow.

Post cover image

Normalization in SQL DBMS: 1NF, 2NF, 3NF, and BCNF Examples

JUL 26, 2023

In this article, you'll learn what normalization is, what the benefits are, and how to perform normalization in SQL using some database normalization examples.

Post cover image

How to Write a dbt Model in SQL: Examples & Best Practices

JUL 13, 2023

Unlock the power of dbt, a transformative tool for designing, implementing, and testing data model workflows. Our comprehensive guide demonstrates how to use dbt models, streamline workflow standardization, and effectively manage dependencies.

Post cover image

An Exploration of the Modern Data Stack

JUL 5, 2023

The modern data stack provides efficient, cost-effective data processing solutions. This article delves into its makeup, advantages, contrasts with traditional stacks, practical implementation advice, and PopSQL's contribution in this landscape.

Post cover image

New ways to focus, work faster and more efficiently with BigQuery using PopSQL

JUL 26, 2022

New enhancements to make PopSQL the best way for data analysts to work with their BigQuery data

Ready for a modern SQL editor?