Important
This project has been shut down. The last tweet was posted on 2023-06-07, before access to Twitter API was shut down. The source code remains available here for reference (in case someone wants to revive it). The latest aggregated daily stats (from 2023-02-20 to 2023-08-30) is available at https://creatorsgarten.github.io/bkkchangelog/finishedTicketStats.json.
A project to archive and generate a change log based on Traffy Fondue data.
We continuously archive the recently-updated tickets into a MongoDB database. The database is hosted on Ruk-Com Cloud PaaS. The database contains not only the latest ticket data, but also the history at various points in time. This allows us to generate a change log. Note, only tickets that contain a ticket_id are archived.
The database is backed up every Saturday night and the database dump can be downloaded from GitHub Artifacts. This allows you to access the raw data that we have, and maybe you can generate some cool visualizations or do other things with it.
A public API is available for accessing small parts of the database. It provides an API to access the change log in chronological order, as well as an API to find the history of a single ticket. Note that it is hosted on a free Azure App Service instance which can be unstable. For use cases beyond these simple queries, you should probably download the database dump and run your own queries.
🚧 Note, the API is currently very unstable. There may be breaking changes at any time. 🚧
First, install dependencies:
pnpm installThen run the generate script in the poster workspace:
pnpm -C poster run generate 2022-NNRWCZIt will print the tweet text and the image path.
For contributors: To customize...
- The tweet text, edit
poster/src/_tweet.ts. - The image, edit
poster/src/_image.ts.
Some tickets do not have an after-image. In this case, a map is rendered instead. This is powered by Mapbox Static Maps. To work on this feature, you need to set these environment variables after getting an access token for your Mapbox account:
MAPBOX_URL_TEMPLATE="https://api.mapbox.com/styles/v1/mapbox/dark-v10/static/pin-s+ef4444(%s)/%s,15,0/360x360@2x?access_token=____"Replace ____ with your access token.
When faces are detected in Before or After image, they will be redacted. This is powered by Azure Face API. To test this feature, you need to set these environment variables after creating a Face resource in Azure Portal and getting the endpoint and API key:
FACE_API_KEY=
FACE_API_ENDPOINT=Finished tickets within the day will be posted on social on the next day starting at 10:00.
