/dev/trouble
Eric Roller's blog

Thursday, December 25, 2014

Blog Reboot: First Post

I have decided to switch my blog to a different backend; one that is easier to maintain and doesn’t rely on MySQL (which I always found overkill and difficult to backup). Now I only need to extract my old blog posts from that last database dump file…

Update: Having worked through the dump file in a text editor, I found hundreds of duplicate entries marked as ‘inherit’ and ‘nnn-revision-m‘. These entries may be the result of multiple edits of a post. This is exactly the kind of data bloat that I strive to avoid. The current solution stores all entries in simple text files. Easy to back up. Easy to index. No duplication.