riskassessment
riskassessment copied to clipboard
Future DB option: Move to PostgreSQL from SQLite
To enhance scalability and address SQLite's slow read/write speed, we may shift to PostgreSQL as the user base grows, requiring concurrent access. PostgreSQL, being the most standard SQL variant, allows seamless migration, with the majority of SQL code written for SQLite functioning effortlessly on PostgreSQL. This transition could be a valuable improvement in terms of speed, scalability and security.