search

pebble-dev / rebblestore-api

Rebble Store api code.
MIT License
39 stars 8 forks source link

App DB format #1

Closed TheTechmage closed 6 years ago

TheTechmage commented 7 years ago

We need to figure out some form a schema to store app information in.

HenryDelMal commented 7 years ago

Apart of schema, we'll use sqlite before and then select other engine? In Discord was proposed postgres

TheTechmage commented 7 years ago

SQLite first is indeed the plan. So long as we stick with SQL syntax, we should be able to easily switch libraries later due to Go's SQL library.

~ Sent from my Alphabet phone

On Dec 23, 2016 6:55 PM, "Henry López del Pino" notifications@github.com wrote:

Apart of schema, we'll use sqlite before and then select other engine? In Discord was proposed postgres

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/pebble-dev/rebblestore-api/issues/1#issuecomment-269063652, or mute the thread https://github.com/notifications/unsubscribe-auth/AAfFs0KrsHQrL32mDHvSKXv6r2NrzvGGks5rLHuPgaJpZM4LUT_T .

Klikini commented 7 years ago

Here is a draft schema for PostgreSQL: https://gist.github.com/Klikini/2a95651082cfd282bfdd5984f7275a5b

Edit 1: I have removed the developers table because it was redundant. Any user can upload apps. A separate developer status flag can be added if needed in the future.

Edit 2: Oops, I totally forgot about platforms! Each version of an app can now specify a list of compatible platforms.

Edit 3: Added a field to apps to allow developers to opt-out of having their app included in store exports/archives.