Help with data-design for a personal note taking app for school (possibly using auth, idk)
I would like to make a personal note taking app using t3, in which I can keep my notes grouped per-class
- full-text search, or maybe like a tag system where I have a field that is full-searched (would be formatted like
statistics, creating a confidence interval
or statistics, interpreting a confidence interval
)
- support complex math equations
- support markdown or some other formatting for taking notes
- if possible, able to insert custom drawings using my phone or touchscreen laptop5 Replies
Equations are just strings
Markdown is just string
Custom drawings can be base64 encoded or upload to a separate file storage solution like s3 (so u store it as a url)
Full test search is just specific query syntax on a particular column
I think a good start is to discern what should go in the db versus what should go in file storage
Hmm ok
Should text always go in db
Like should I have a column which stores the whole content of the note
If you store the content of your notes in the db. You can then use full text search on the entire note instead of just the tags (if you’re inteeesred in that functionality)
Also I’m making the assumption you’re using postgres or similar
Also would be good idea to think how normalised you want the database to be (or if you’re unsure what this means, learn about database normalisation first)
Hmm ok
Where should I look for normalization? What’s the best database for something like this? What tools are good for full text?
I think you should look into Postgres and do a few google searches on the questions you just asked 🙂