this post was submitted on 05 Aug 2023
11 points (86.7% liked)
Ask Comrades
11 readers
1 users here now
Open-ended questions community for Lemmygrad.
founded 4 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
With that small of a dataset imo either option is fine. If it were me I would use an ORM + sqlite just to start, in case I ever needed to migrate to a "real" database.
Thank you!
I am writing in C (the CLI, which I'll just have the bots use) and have never used any databases, would using the sqlite interface straightup with C and some cursory reading of docs be too much, do you think? Course I can switch it all to c++ and then there appears to be at least one nice ORM
I think if you're storing vocabulary etc, using the C interface for sqlite wouldn't be too unwieldy and would be a good learning experience if you haven't done much raw SQL query writing of your own. Even when you use an ORM there are often times you need to write your own queries for more complicated situations.
One other suggestion: once you have the CLI and bots working, you could abstract this even more. Have a service process that communicates in some way (IPCC, a network port, etc.) that does the actual text analysis. Your cli and bots can then just interface over that channel. This gives separation of duties so you can easily implement new clients/servers or rework them much more easily.