-
Notifications
You must be signed in to change notification settings - Fork 0
Database construction
This project uses Mysql as a DPMS. Mariadb should also work just fine with this application and actually demo site is using Mariadb as DPMS.
Currently database has Five tables users, posts, logins, friends and notifications. Only users, posts and logins are currently fully utilized. friends and notifications are reserved for future improvements.
Current database is quite flexible but there are still some limitations. User messages are currently limited to 320 characters and title is limited to 60 characters. Reason for this is that this is intended to be a microblogging site that has only small posts. 320 character limit was chosen because its double of the classical text message size 160 characters. Currently minimum length of the title is 5 character. This does not have any great particularly good reason but it might help search of the posts a bit.