Hi Bert, thanks for the thought - sqlalchemy is something I need to look at - however, for this sort of basic analysis an embedded database is simple and there are no 'production database' issues. Here SQLite is perfectly adeqate, although for a large dataset, I might opt for the embedded OLAP database, DuckDB.

I'll definitely look at sqlalchemy in the future, though, from the brief look I've had, it seems interesting.

Technology, data science and programming

Love podcasts or audiobooks? Learn on the go with our new app.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Alan Jones

Alan Jones

Technology, data science and programming

More from Medium

Took My Chances On A Big Jet Plane…

Brief Note on LBO Analysis, FCF Margins, and Credit Rating

The Future of Humanity: Terraforming Mars, Interstellar Travel, Immortality, and Our Destiny…

WEBB’S SUCCESSFULLY COMPLETED ITS MAJOR DEPLOYMENTS