Database proposal

Use an embedded database that supports foreign keys and transactions, such as sqlite.

Table definitions

users

• user_id: string
• private_key: string
• parent_user_id: nullable

files

• file_name: string, unique constraint
• content_type: string
• user_id: string, foreign key to users.user_id
• upload_time: timestamp
• data: blob