Open jareddarnell opened 4 years ago
Re-implement eval system to use EF Core, PostgresSQL. (It may be a good idea to do a rewrite to store evals as JSON or JSONB.)
JSONB: https://scalegrid.io/blog/using-jsonb-in-postgresql-how-to-effectively-store-index-json-data-in-postgresql/
EF Core: https://docs.microsoft.com/en-us/ef/core/
PostgresSQL for C#: https://www.npgsql.org/doc/basic-usage.html
EF Core and PostgresSQL are already being used in many places in the project and is partially implemented in EvalService.cs
Eval files are:
This is a screenshot of where an exception is thrown. The exception is related to Npgsql turning the CommandText lowercase.
Re-implement eval system to use EF Core, PostgresSQL. (It may be a good idea to do a rewrite to store evals as JSON or JSONB.)
JSONB: https://scalegrid.io/blog/using-jsonb-in-postgresql-how-to-effectively-store-index-json-data-in-postgresql/
EF Core: https://docs.microsoft.com/en-us/ef/core/
PostgresSQL for C#: https://www.npgsql.org/doc/basic-usage.html
EF Core and PostgresSQL are already being used in many places in the project and is partially implemented in EvalService.cs
Eval files are: