v2.0.103

Toggle v2.0.103's commit message

refactor: decouple usagelimiter from the db package to unblock each s…

…ervice owning its own queries when we split up the shared db package (#5372)

* refactor: decouple usagelimiter from the db package to unblock each service owning its own queries when we split up the shared db package

* [autofix.ci] apply automated fixes

* fix: clean up error handling

---------

Co-authored-by: autofix-ci[bot] <114827586+autofix-ci[bot]@users.noreply.github.com>

v2.0.101

Toggle v2.0.101's commit message

delete projects (#5326)

* feat: create and delete projects

* fix: cascade

* fix: auth

* fix: use primary DB for app existence check in DeleteApp

The pre-check used the read-only replica (s.db.RO()) which can lag
behind the primary and cause false 404s on recently created apps.
Switch to s.db.RW() to read from the primary.

v2.0.100

Toggle v2.0.100's commit message

Refactor frontline database layer and add SQL query documentation (#5288

)

* refactor: copy new mysql package

* fix: generate into new mysql package

* refactor: move frontline queries

* optimize frontline database

* fix: remove wrong index

* chore: clean up indices

some were also uncommented for no reason, I have checked the db

* docs: make sql comments more helpful and less verbose

* Update dev/k8s/manifests/frontline.yaml

Co-authored-by: coderabbitai[bot] <136622811+coderabbitai[bot]@users.noreply.github.com>

* Update svc/frontline/config.go

Co-authored-by: coderabbitai[bot] <136622811+coderabbitai[bot]@users.noreply.github.com>

---------

Co-authored-by: coderabbitai[bot] <136622811+coderabbitai[bot]@users.noreply.github.com>