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 laptop
5 Replies
jingleberry
jingleberry2y ago
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
Hycord | @ When Replying
Hmm ok Should text always go in db Like should I have a column which stores the whole content of the note
jingleberry
jingleberry2y ago
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)
Hycord | @ When Replying
Hmm ok Where should I look for normalization? What’s the best database for something like this? What tools are good for full text?
jingleberry
jingleberry2y ago
I think you should look into Postgres and do a few google searches on the questions you just asked 🙂
Want results from more Discord servers?
Add your server