Firehose

Demo showing TimescaleDB in Phoenix.

Setup

• Install docker and docker-compose
• docker-compose up -d
• mix deps.get
• mix ecto.create && mix ecto.migrate
• cd assets && npm install && cd -
• mix phx.server
• open http://localhost:4000

TimescaleDB

The trades table is stored in TimescaleDB hypertable which optimizes quering data accross time. To see, run the query:

EXPLAIN SELECT * FROM trades;

For more info, see the TimescaleDB docs