[bockris]

sqlite and datasette is a killer combo imo https://datasette.readthedocs.io/en/stable/

12GB is not a lot of data, not sure what was happening with your python that it took several hours. Don't get me wrong though, SQL seems like it could be the right tool for this use case.