zephyr
0 Followers · 0 Following
  • Joined on 2023-07-08
Repositories
8
 Projects Packages Public Activity Starred Repositories
1
zephyr pushed to schema-updates at ligmo/ligmo 2025-05-05 18:16:17 -04:00
5b9140a7d1 schema: adjust emote-on-list unique constraint
zephyr opened issue ligmo/ligmo#16 2025-05-05 16:14:28 -04:00
decide the name of a collection of emotes
zephyr created pull request ligmo/ligmo#15 2025-05-05 13:54:04 -04:00
schema: adjustments
zephyr created branch schema-updates in ligmo/ligmo 2025-05-05 13:53:50 -04:00
zephyr pushed to schema-updates at ligmo/ligmo 2025-05-05 13:53:50 -04:00
692e0f7c86 schema: adjustments
zephyr commented on issue ligmo/ligmo#7 2025-05-04 14:15:44 -04:00
Create Basic Svelte Dashboard UI

Mirroring from discord.

The only interactions that 98% of users will use are searching and adding emotes to a single emote set, so I think the design should be more single-emote-list-centric. A…

zephyr opened issue ligmo/ligmo#14 2025-05-04 08:52:46 -04:00
api models
zephyr pushed to main at ligmo/ligmo 2025-05-03 19:10:27 -04:00
2c81978ea2 schema: initialize database (#12)
zephyr deleted branch schema from ligmo/ligmo 2025-05-03 19:10:27 -04:00
zephyr merged pull request ligmo/ligmo#12 2025-05-03 19:10:26 -04:00
schema: initialize database
zephyr closed issue ligmo/ligmo#9 2025-05-03 19:10:26 -04:00
Create DB Schema
zephyr pushed to schema at ligmo/ligmo 2025-05-03 19:06:27 -04:00
aa5a043198 schema: separate name deduplication from display name
91269b5f1c schema: fix typos
Compare 2 commits »
zephyr pushed to schema at ligmo/ligmo 2025-05-03 18:54:50 -04:00
2b772fab7e schema: rename connection.connection -> connection.platform_id
zephyr commented on pull request ligmo/ligmo#12 2025-05-03 18:53:49 -04:00
schema: initialize database

The todo is more about whether we need to do more than that for unique users, particularly because COLLATE NOCASE only works with ASCII. It might be better to have a separate column for canonicaliz…

zephyr pushed to schema at ligmo/ligmo 2025-05-03 18:52:15 -04:00
73e7c56ad2 schema: soft-delete for emotes in a list
74a7520200 schema: add list editors table
0155c600a3 schema: allow users to be soft-deleted
56b548d7a8 schema: consolidate to one file
Compare 4 commits »
zephyr pushed to schema at ligmo/ligmo 2025-05-03 18:09:29 -04:00
f147e51c6c schema: users and their connections
34961c1193 schema: allow renaming emotes in a list
Compare 2 commits »
zephyr pushed to schema at ligmo/ligmo 2025-05-03 16:45:24 -04:00
6127b3ccab schema: use _at for timestamps
e2db1c9dbb schema: define emote lists
Compare 2 commits »
zephyr commented on pull request ligmo/ligmo#12 2025-05-03 16:23:04 -04:00
schema: initialize database

Soft delete would work, but eventually there has to be something to turn a soft delete into a hard delete for the purpose of GDPR and friends.

zephyr commented on pull request ligmo/ligmo#12 2025-05-03 16:21:30 -04:00
schema: initialize database

I'm weakly anti-_at. As a name, I don't feel it adds anything; just "created" being an integer tells me what it means. (If this were Postgres, we'd have actual time types, which would be even…

zephyr pushed to schema at ligmo/ligmo 2025-05-03 16:18:24 -04:00
fb13e785d3 schema: use blob for emote ids