Xwitter

Project type:

Class Library


Technologies&Frameworks used:

.NET
C#
TCP/IP


Xwitter on Github
Check out this project here

Xwitter is a simple twitter like web app

Users can create an account and post their stuff, and others can comment it.

Each post and user profiles have their own url

Project follows clean architecture & CQRS & Repository pattern

FunFact:
This project was origally going to use two databases, MSSQl and PostGreSQL. MSSQL was used for storing user accounts, and PostGreSQL for storing posts and comments, since PostGre supports arrays in columns by default. I found it very helpful for cases like having post reference by array of id's every comment that is posted under it in another table. However, when deploying it on my Linux virtual machine, I realized MSSQL requires at least 2GB of RAM to run, but I only had 1GB.
Not wanting to pay more monthly for a bigger VM, I removed MSSQL from the project, and now PostgreSQL handles everything.

Todo list:
  • Add follow other people feature
  • Add like feature for posts
  • Add replies to comments feature
  • Replace more complicated linq queries used in entity framework with stored procedures