[infamia]

> Or use the trick in using here for my PostgreSQL database: https://news.ycombinator.com/item?id=38114171

I wonder how this approach handles converting decimal fields, considering SQLite does not have a decimal field type and only has floats (i.e., you could potentially lose some precision during the conversion)?

[simonw]

Probably! I don't deal with decimal fields in my projects so I've not explored that yet.