After some time working on a PERN stack app, this app needs a re-evaluation of it's main design with regards to the backend.

Main parts of the issue to be resolved:

• Decide if and how much of the frontend-soundslip structure can be salvaged.
• Decide if postgres needs to be the backend for this project. RPCs with Chia need looking at, as well as Socket Supply Co.
• If postgres remains the best option for this project, redesign the SQL tables, all of them...
• Design a 5 stage MVP and start on v1.

It's time to decide on the main stack for the app:

Frontend:

NextJS
ReactJS

Backend:

Express
Nodejs

Dev Dependencies:
Jest

Here is the first draft of the table schemas I'm considering for the backend:

User:

id SERIAL PRIMARY KEY
name VARCHAR(100)
password TEXT
profile-url TEXT

Audiodata:



id SERIAL PRIMARY KEY

title VARCHAR(100)
description VARCHAR(255)
tag VARCHAR(20)

likes INT
created TIMESTAMP



Audiosource:



id SERIAL PRIMARY KEY
audio-data-id INT

hostname: VARCHAR(255)
host-url TEXT
encrypted BOOL

mime-type VARCHAR(25)
metadata-url TEXT
chain-data-url TEXT

CONSTRAINT fk_audiodata
FOREIGN KEY(audio-data-id)
REFERENCES audiodata(id)



Comment:



id: SERIAL PRIMARY KEY
content: VARCHAR(255)
owner: [ user id ]
target: [ audiodata id ]
likes: INT

Opening for discussion