4 ms·
My usecase is silly. Basically small to medium database backed cms websites. I just want to evolve them as the client already is using them to serve and store c
by scotty79 3y ago
My usecase is silly. Basically small to medium database backed cms websites. I just want to evolve them as the client already is using them to serve and store content. Also have up to date complete backup of them in git.
I could do it easily if I just kept data in text files instead of sqlite, but I really like the speed of the database queries.
- joshspankit 3y agoWhy not set the text files as the SSOT and have a hook that populates the database when the files change?
- scotty79 3y agoMaybe the other way around? Use database triggers on inserts an updates to store the data in files as well? And create a procedure to update the database from files after git pull?
- joshspankit 3y agoI agree that would be easier to implement, but it violates the SSOT principle by introducing an edge case of lost database changes that have not been written to the files (for example during a system error).