Explore the use of an ORM

[goodmami]

All interaction with the SQLite database backend is through direct SQL queries. This has worked so far but it might be worth exploring the use of an ORM instead, for maintainability (SQL is yet another language to learn; fewer lines of code to maintain with an ORM) and for the ability to swap the database engine (Heroku uses Postgresql and not SQLite, as I understand). A potential downside is the overhead or non-optimized queries causing slower performance. This needs to be tested (hence the title of this issue: "explore the use of...").

Of the ORMs available, I've been impressed with Pony, but I'm happy to consider others.

[goodmami]

This approach to hosting an SQLite database in a static web host might be an alternative solution that would allow us to host something like the OMW using only GitHub Pages.

[fcbond]

This does look interesting.

…

On Thu, 13 Oct 2022 at 07:00, Michael Wayne Goodman < ***@***.***> wrote: This approach <https://phiresky.github.io/blog/2021/hosting-sqlite-databases-on-github-pages/> to hosting an SQLite database in a static web host might be an alternative solution that would allow us to host something like the OMW using only GitHub Pages. — Reply to this email directly, view it on GitHub <#150 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAIPZRRYMHI64AGRVXQRFADWC6JN7ANCNFSM5HOHDLGQ> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

-- Francis Bond <https://fcbond.github.io/>