Database System

The next step is creating the database system and structure. I do this before the AI part because it’s crucial to save the AI output to the database correctly. Therefore it makes sense to develop this first since I already know what content will be put into the database.

I’m using PostgreSQL for the database. I’m working with structured data so a noSQL approach like mongodb doesn’t make a lot of sense. It’s also a lot of data I’m dealing with and that data is relational. So for performance and efficiency reasons I won’t use SQLite either. Lastly I just like PostgreSQL more than mySQL. It’s faster than MySQL by many benchmarks, has a lot more features, better support of SQL standards, and MySQL is not officially supported by many linux distributions. MySQL had the advantage that it was easily available on cPanel and Plesk hosts but since I don’t use php and overall these advantages are fading and it doesn’t really matter much anymore. Additionally PostgreSQL works great with SQLAlchemy which I’ve gotten comfortable using so this is my choice.