ISnackable / saf-duty

saf-duty; A Duty Roster planner for the Singapore Armed Forces (SAF). It's tailored for military uses. GPL-3.0 License.
https://afpn-cdo.vercel.app
GNU General Public License v3.0
2 stars 1 forks source link

[Feature Request]: Migrate to supabase and shadcn/ui #11

Closed ISnackable closed 5 months ago

ISnackable commented 1 year ago

Below is the simple comparison of the two database as a service products.

supabase uses a relational database management system called PostgreSQL, it offers a free-tier hobby plan with:

sanity.io is a schemaless database built on top of Google cloud, it offers a free-tier plan with:

Additional notes:

Sanity is comparable to Firebase in how they store data, where firestore allows you to store “documents”. sanity.io is also the same and they basically use their plan. Thus, it may also be a viable option to switch to Firebase.

ISnackable commented 1 year ago

This is still a valid option as postgresql is faster in term of read/write. Using supabase also allows us to entirely remove backend. allowing us to move to pure react, without needing us to host on vercel.

However, there still need to be some sort of validation, this means we require advance knowledge of postgresql.

Also for admin role: https://github.com/supabase-community/supabase-custom-claims

https://github.com/orgs/supabase/discussions/1148#discussioncomment-2222768

ISnackable commented 1 year ago

Okay, I decided that I'm too lazy and don't care about implementing this.

ISnackable commented 1 year ago

Wait... I could probably do this but I'll take a long ASS time track: https://github.com/ISnackable/saf-duty/tree/wip/migrate-to-supabase

ISnackable commented 5 months ago

Done!