search

goodmami / wn

A modern, interlingual wordnet interface for Python
https://wn.readthedocs.io/
MIT License
196 stars 19 forks source link

Explore the use of an ORM #150

Open goodmami opened 2 years ago

goodmami commented 2 years ago

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 commented 1 year ago

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 commented 1 year ago

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 https://github.com/goodmami/wn/issues/150#issuecomment-1277033469, 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/