Best of Google BigQuery — 2023

1. 1
   Article

   Hacker Noon·3y

   16 SQL Techniques Every Beginner Needs to Know

   Learn SQL techniques for data warehousing, including handling incremental tables, using MERGE statements, and converting tables to JSON objects.

   102

   5
2. 2
   Article

   GoPenAI·3y

   The Strange Death of Stack Overflow

   From the founding of Stack Overflow in 2008 to the first quarter of 2014, the number of new questions and answers posted grew steadily. From 2013 to 2015, the growth has been stagnant, then accelerated from 2015 to 2017. From 2019 to 2021 was a sharp spike in the growth of new users.

   82

   20
3. 3
   Article

   Supabase·3y

   Supabase Logs: open source logging server

   Supabase Logs is an open-source logging server that supports self-hosting and CLI development. It leverages Logflare to handle billions of log events daily from various tools in the Supabase infrastructure. The ingestion pipeline involves multiple methods, while the querying pipeline utilizes Logflare Endpoints. These endpoints provide various benefits such as query parameters, read-through caching, active cache warming, and query sandboxing. In the future, Supabase plans to integrate Logflare into the platform through a Management API and support multiple backends.

   18