search

downforacross / downforacross.com

Web frontend for downforacross.com -- continuation of stevenhao/crosswordsio
https://downforacrosscom.downforacross1.now.sh
MIT License
220 stars 92 forks source link

Use Sequences for GID, PID #311

Closed christianscarlett closed 2 months ago

christianscarlett commented 4 months ago

Adds 2 sequences for generating GIDs and PIDs. https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-sequences/

Migrations needed to be run before this is deployed are in server/sql/create_id_counters.sql

I tried to clean up all firebase references to GID and PID, but there was one in Replays I wasn't sure what to do with.

There are only a couple firebase references left in the client code:

  1. Replays
  2. Composition
  3. User auth
  4. Battle

I'm not sure any of these are used, maybe we can clean these up too.

Tested uploading a puzzle and creating + opening games on local frontend, backend, and db:

ScreenRecording2024-02-14at9 44 56PM-ezgif com-video-to-gif-converter

vercel[bot] commented 4 months ago

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name Status Preview Comments Updated (UTC)
downforacross.com ✅ Ready (Inspect) Visit Preview 💬 Add feedback Feb 15, 2024 3:00am