Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

How is your database structured? One table for everything? Something fancy? How do you use it?


Nothing too fancy, the skeleton of the schema is basically just:

    Tags(tag_id, tag_name)
    Files(file_id, file_address)
    FileTags(file_id,tag_id)
That's for organizing files using tags. I can organize notes like this by either putting notes into many text files and tagging them, or by putting notes directly into the DB with another Notes table. I've prioritized the former, since many of my "notes" are actually photographs of whiteboards or other non-text data. Storing textual notes directly in the sqlite database works well too though.

To interact with the system, I threw together a quick emacs client and a GUI client. Nothing fancy or pretty yet, but functional enough for my day-to-day use.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: