Use SQLAlchemy to work with the database #43

New issue

Open

opened 2025-10-14 17:02:36 -06:00 by navan · 0 comments

navan commented

2025-10-14 17:02:36 -06:00

Owner

Originally created by @adalke on 10/13/2021

In 2019 kzfm gave an example of using SQLAlchemy to work with the database.

In my work to replace the JSON-Lines fragment format with a SQLite-based format I quickly discovered that I am hand-writing an ORM. Poorly.

I propose switching using SQLAlchemy in this updated version I am working on.

At this point I don't know how much work that requires. kzfm showed that defining the structure and querying the generated mmpdb database was simple.

*Originally created by @adalke on 10/13/2021* In 2019 [kzfm gave an example](http://blog.kzfmix.com/entry/1560658590) of using [SQLAlchemy](https://www.sqlalchemy.org/) to work with the database. In my work to [replace the JSON-Lines fragment format with a SQLite-based format](https://github.com/rdkit/mmpdb/issues/37) I quickly discovered that I am hand-writing an ORM. Poorly. I propose switching using SQLAlchemy in this updated version I am working on. At this point I don't know how much work that requires. kzfm showed that defining the structure and querying the generated mmpdb database was simple.