[Q] SQLite Bad Practice?

So I feel that I already know the answer to this question (Which is no) but I feel I should ask just in case.

I am developing my first app for android and have a question whether or not my current method of storing data in a SQLite database is considered bad practice and should be re-evaluated before I go any further.

Basically I am creating a changes tracking app. The user can specify a project and add entries for that project to track changes, ideas, etc.

The current way I am storing the data in the SQLite database is by creating an individual table for every project and then storing the entries for that project within that projects table.

This is what my question is in regards to, is it bad practice to create a separate table for each project? I realize that with enough projects my database would be overrun by tables.

If anyone has any suggestions of a better way to do such a structure in SQLite (Projects with entries) it would be greatly appreciated.

Show Accepted Answer

Guest Quick Reply (No URL, BBcode or HTML)

Last post by greta44
4 hours ago
Last post by kwaelchi
1 hour ago
Last post by colleen04
36 minutes ago
Last post by sarah.lang
1 hour ago
Last post by adele91
23 minutes ago
Last post by mgreenfelder
4 hours ago
Last post by ines28
3 hours ago
Last post by stacey45
40 minutes ago