API pagination playground

This is a repo to tinker with API pagination. It was the basis of my blog post here: https://www.samu.space/api-pagination/.

There are three components:

A Go backend API which handles requests
A Python client which constantly hammers the API and updates & creates records.
A Python client which tries to export all the data via API pagination.

You will need goose, docker-compose, Go and Python3.

go get -u github.com/pressly/goose/cmd/goose
docker-compose up
goose -dir migrations/ postgres "user=calendar dbname=postgres sslmode=disable password=calendar" reset
goose -dir migrations/ postgres "user=calendar dbname=postgres sslmode=disable password=calendar" up
go build

Then,

Start the API: ./api-pagination-playground
Start client who updates and posts data: python3 update_events.py
Try to export all records with the other client: python3 export_events.py