Blog on TextQuery updates, usage tips, and data insights.
ISO 3166-1 alpha-2 is a popular standard to represent countries using a short two-letter code. You might have already encountered them: IN, US, GB. They are used everywhere to ensure consistency with…
Suppose you have a table `website_visitors` in which you regularly want to import visitors' data from a CSV. Postgres has a built-in command that makes working with CSV files pretty convenient: \COPY.…
Grouping by a time interval is a commonly needed SQL query. The time interval could be a day, week, or month. An example of this could be: finding the count of all the newly registered users for the p…
Like many other data warehouses, BigQuery has low storage costs, which makes it ideal for dumping logs that can be analyzed later. HTTP request logs are often stored in BigQuery for this reason. These…
Bash has its quirks, but it comes in real handy when you want to do something quickly. I frequently use bash for scraping, making small scripts for myself, and automating daily tasks. Once you get the…
There are various DB operations that can require multiple SQL queries. Suppose you have two tables called `banned_users` and `users`. The `banned_users` table has an `AUTOINCREMENT` column called `i…