I added two PostgreSQL view for flattened time series I'm using in ODM2 Admin. I converted one of these views to be compatible with SQLite and tried it out. The names of the views are probably not desirable, but table names are so long already adding additional words to timeseriesresultvalues seems excessive. Is there a better way to name these?
Maybe someone could add versions of similar views for MSSQL and MySQL? Who is using MySQL?
https://github.com/ODM2/ODM2-performance-optimization/tree/master/PostgreSQL/time%20series%20flattened%20views
https://github.com/ODM2/ODM2-performance-optimization/tree/master/SQLite/time%20series%20flattened%20views
I added two PostgreSQL view for flattened time series I'm using in ODM2 Admin. I converted one of these views to be compatible with SQLite and tried it out. The names of the views are probably not desirable, but table names are so long already adding additional words to timeseriesresultvalues seems excessive. Is there a better way to name these?
Maybe someone could add versions of similar views for MSSQL and MySQL? Who is using MySQL?
https://github.com/ODM2/ODM2-performance-optimization/tree/master/PostgreSQL/time%20series%20flattened%20views
https://github.com/ODM2/ODM2-performance-optimization/tree/master/SQLite/time%20series%20flattened%20views