exa-analytics / exa

The exa framework for data management, processing, and visualization
https://exa-analytics.github.io/exa
Apache License 2.0
2 stars 10 forks source link

Issue 172 #187

Closed tjduigna closed 4 years ago

tjduigna commented 4 years ago

Closes #172

Provides the RawDAO and DAO classes as a relatively simple interface for fetching and persisting data in relational data storage systems. Additionally provides a number of pytest fixtures for sqlite and postgres and test examples that demonstrate the API.

Thoughts so far:

tjduigna commented 4 years ago

Opting to remove the related functionality as it was not well thought out and fundamentally limited in its functionality. It should be redesigned to support generic join statements.

I think better support for SQL clauses that come after the FROM like GROUP BY, ORDER BY, and HAVING is worth adding here. This way the implementation of the RawDAO is complete and single-table only. Extending the DAO for related queries and offloading that work to the database can be an enhancement on the single table API.