vlad-ds

-- data for 1 day: 479 MB scanned
SELECT *
FROM `bigquery-public-data.google_trends.international_top_terms` 
WHERE refresh_date = DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY);

-- data for 2 days: 955 MB scanned
SELECT *
FROM `bigquery-public-data.google_trends.international_top_terms` 
WHERE refresh_date > DATE_SUB(CURRENT_DATE, INTERVAL 3 DAY);

vlad-ds

vlad-ds

Remote setup (AWS EC2)

If you run your Telegram bot locally, it will stop working when you close the terminal. The alternative is to host the bot somewhere.

There are many ways to do this. I chose AWS EC2 as it's a cheap and easy option.

Create an AWS account and start an EC2 instance. Install pip, git and github cli. If you use an Amazon Linux image (which is what the free tier offers) you can run the commands in this gist.

Connect to your GitHub account with gh auth login and clone this repo. Create the .env

vlad-ds

#!/bin/bash

# install requirements
sudo yum update -y
sudo yum install -y python3-devel
sudo yum install -y python3-pip
sudo yum install -y git

# install github cli
type -p yum-config-manager >/dev/null || sudo yum install yum-utils

vlad-ds

package com.example.cyborg2

import android.bluetooth.BluetoothA2dp
import android.bluetooth.BluetoothAdapter
import android.bluetooth.BluetoothHeadset
import android.bluetooth.BluetoothProfile
import android.content.BroadcastReceiver
import android.content.Context
import android.content.Intent
import android.content.IntentFilter

vlad-ds

import os

from dotenv import load_dotenv
from telegram import Update
from telegram.ext import Application, CommandHandler, ContextTypes, MessageHandler, filters


load_dotenv()

TOKEN = os.environ["BOT_TOKEN"]