Upcoming

No upcoming hack day planned yet.

2024-08-31

What we did

• Inventory tracking ( dtinth, rayriffy): Building the tool and produce labels so we can identify which equipments belong to Creatorsgarten and which are not.

  • rayriffy updated creatorsgarten/inventory to use Biome and implemented the UI for adding items, containers, and tags.
  • dtinth migrated the DB migration system to use Drizzle Kit instead of Supabase CLI (the app still runs on Supabase) as he prefers to manage Postgres functions and row-level security policies separately from the table schemas. Using migrations to deploy Postgres functions means that multiple copies of the function code will be stored in the codebase, which can make searching for the function more difficult. Rather than doing that, we just have an idempotent SQL script that replaces the functions and policies on the DB. Implemented a backend using Postgres functions, and added a Playwright test.
  • We printed more stickers and flags and attached them to our equipments.

• Event photos: faypichaya raised an issue about event photos management “รูปอีเว้นในงานนี่ทีมเรามีวิธีเก้บอะไรมั้ย หรือโยนเข้าไดฟ์ปกติเลย”. Maybe we should consolidate the public event photos so people can find the photos of past events.

  • rayriffy set up public albums on iCloud Photos, and prototyped a web interface that loads the photos from these albums.

• Insta360 Link websockets protocol reverse engineering ( dtinth, rayriffy): Insta360 Link Controller software version 1.4.1 supports remotely controlling the webcam using a web interface on the phone. From preliminary inspection, it is using the WebSocket protocol but the messages are binary format. The goal is to decipher this format and allow us to programmatically control the camera. Combined with Chrome’s FaceDetection API, we may be able to improve the face auto-tracking algorithm so that we (as the livestreaming crew) don’t have to babysit the camera as often.

  • dtinth reverse-engineered the protocol (with huge help from Claude) a little bit (only supporting setting pan and tilt speed, and setting the zoom level). Read the write up.
  • rayriffy implemented a custom controller that allows controlling the camera using a gamepad, using Web Gamepad API. A custom controller allows for more precise and smooth control of the camera. The code is published at creatorsgarten/insta360-link-controller. See video demo by @rayriffy and write up on Facebook.
  • We haven’t tried integrating with face detection yet.

• Check-in experience ( dtinth): Play with a hardware barcode scanner.

  • dtinth experimented with the OBZ barcode scanner to create a custom frontend where ticket holders can present their QR code to check in to the event.

Other ideas

• Image management ( dtinth): I am thinking about image hosting solutions, right now images are hosted on GitHub / Discord / Thai’s R3 bucket. I built a system to upload images to Cloudinary after got inspired from talking with Cloudinary people at CityJS Singapore. However, this system is not integrated with our wiki editor yet.

• Wiki editor ( rayriffy): Riffy has an idea for improving the editor using Plate JS.

• For JavaScript Bangkok 2.0.0 and other future Creatorsgarten events:

  • Live transcription system ( dtinth): Experiment with how we can live-transcribe a tech talk. English language is pretty much solved (thanks to Speechmatics) but Thai language talks has a lot to experiment and research.