Welcome to the LifeTracker Wiki!

Documentation TODO

• Installing Selenium? Maybe mostly self-explanatory except that I'm using chrome and chrome's third party webdriver. Does/should that matter for tests?

• The weirdness that happens when you try to fuss with primary keys in alembic -- there's no good solution, so recreate the database meaning:

  • the manual bits of the recreating the database with Alembic's help (https://alembic.sqlalchemy.org/en/latest/cookbook.html#building-an-up-to-date-database-from-scratch)

• Data ingestion in general and cronometer data ingestion in particular now that it's 'working'

  • When ingesting CSVs, the choices between staying in the ORM and using SQLAlchemy's mid layer or raw SQL -- hard to get a handle on duplicates otherwise unless looping basically one ORM operation per ingested row, mid layer helps but still slow, raw SQL can be very fast but only if psycopg2/postgresql specific.

Additional Documentation

Developer Guides and Resources

• Installation
• Project Architecture/Design
• Database Documentation
• Google Forms Integration
• Useful Commands
• Miscellaneous Domain Knowledge