riskassessment icon indicating copy to clipboard operation
riskassessment copied to clipboard

Future DB option: Move to PostgreSQL from SQLite

Open mayank-procogia opened this issue 1 year ago • 0 comments

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.

mayank-procogia avatar Dec 04 '23 12:12 mayank-procogia