January 2024 Summaries

The text discusses five useful queries for estimating BigQuery costs and optimizing usage. These include total costs by day in the last 7 days, costs per application or user, cost analysis based on query types, total costs by project in the last 7 days, and dry runs of specific queries to estimate costs. The text also mentions that these queries can help manage budgets and efficiently allocate resources within BigQuery.

This blog discusses the significance of carefully designed data type mapping during database replication and how PeerDB handles this process. It highlights the benefits of native data type mapping, such as saving transformation costs, enhancing query richness, and reducing technical debt. The article also presents case studies on how PeerDB manages various complex types like nulls in arrays, double precision numbers, and HStore during replication. Finally, it provides a high-level glance at PeerDB's mapping for different data types.

PeerDB uses SSH Tunneling for securely connecting and replicating data from Postgres databases to various targets such as Data Warehouses, Queues, and Storage. SSH Tunneling is a method that creates a protected pathway for data transmission over unsecured networks by encrypting the information exchanged. PeerDB leverages this technique to access protected resources securely and cost-effectively while minimizing the need for complex infrastructure. The setup involves configuring a Bastion or JumpBox and setting up firewall rules, after which PeerDB automatically sets up and uses the SSH Tunnel to connect with the protected Postgres database.

In a whimsical tale of databases celebrating the New Year, Postgres decides to bake cookies as gifts for his friend Snowflake. He creates a table in Postgres to store the cookies and uses SQL functions to generate various cookie shapes. To send these treats to Snowflake, he enlists the help of PeerDB, a magical tool that also speaks SQL. Postgres registers both databases with PeerDB and creates a mirror to transport the cookies from his database to Snowflake's. The story concludes with an imaginative depiction of Snowflake receiving and enjoying the delicious gifts.