This project contains supporting code for the TimescaleDB video on YouTube.
In order to use this project, you'll need to set up the following tools:
This project uses TimescaleDB as it's primary data store. There are a number of ways to get a timescale DB instance up and running.
This is the easiest approach to get started, and it's free for 30 days. This allows you to easily try timescale before committing to any purchase or use case.
You can get the managed version of timescale on their website
If you want to run it locally, you can do so by extending postgres. Timescale have some great documentation on how to do that.
Finally, another great approach is to use docker. The documentation provides instructions here as well. Be warned that if you're running docker on a non linux machine, it will be slower due to having to run through a hypervisor.
Python3 is used as the primary language for downloading data and then loading it into timescaleDB. The recommended version of python to use is 3.11.x or greater.
To install on macOS, one can use homebrew to do so using the following commands
$ brew install python
$ sudo pacman -S python
$ sudo apt install python
In the video we interact with the database using psql, which is a command line tool provided by postgres.
To install it for macOS, you can use homebrew
$ brew install postgresql
$ sudo pacman -S postgresql
migrate is used for database migrations. To install it, you can do so one of two ways, depending on if you have go installed on your system or not.
$ go install -tags 'postgres' github.com/golang-migrate/migrate/v4/cmd/migrate@latest
$ brew install migrate
$ yay -S migrate