Toksyuryel (toksyuryel)'s status on Monday, 07-May-12 16:50:27 UTC
-
@rotation I'm sketching out what I want the database to look like for my stab at reimplementing status.net in python, and was thinking about using several tables and subtables that all reference back to the main POSTS table as a method of pre-caching metadata like what tags are in the post, what users are mentioned in it, etc to speed up post lookups when searched for on said metadata (such that an exhaustive search should never be necessary). The database software I'd prefer to use is PostgreSQL.