3 ms·
Why not set the text files as the SSOT and have a hook that populates the database when the files change?
by joshspankit 3y ago
Why 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).