For context, I’m developing a desktop application for snippet storation. There’s currently one table in which all snippets are saved, among other data types as ID, description, title and hashtags.
I have two ideas: the first one is to create a new table for every user, which may be not the ideal approach and would cause several problems. The second one is to create a new table which would contain every user registered and an extra column on the main table which would contain the username of the snippet whom belong to.
The truth is that I’m not sure if the two ideas are optimal.
Currently, my application is written in Python and the tables are in SQL Server.