This week there was not much work on Clojure or Simply Scheme, or even as much Kotlin as I would have liked.
Around mid-week, I had some problems with my mail server. This is the mail server I am running (an instance of Apache James), and not the mail server I am writing. James first puts messages into a spool table and decides what to do with them from there, and that had filled up to the capacity of my VPS account.
I had to delete the DB and uninstall MySQL. I had problems re-installing it, so I installed Postgres. So far it is working out okay. I still got a lot of records in my spool table and a lot of files of 1 GB. I cleared out my spool table by eliminating any records that were not to any users in the domains that I manage, restarted, and things seemed okay. I will have to learn more about the write-ahead log in Postgres.
I had backups for my blogs, and I reinstalled MySQL (as you can tell since you are reading this). I had thought about abandoning MySQL altogether and going with a static site generator. I looked a bit at Cryogen, a static site generator in Clojure, and decided against it. It looks like you cannot have too many nested directories. This blog has 537 posts and 12 pages. I don’t want to deal with too many files in a directory. I would at least like a different directory for each year. I will have a look at JBake as well. I would like to stick to the JVM if possible.
I might also give another go at porting WordPress. There is a program called pgLoader (written in Common Lisp) that can migrate different data stores (including MySQL) to Postgres. Perhaps I will make it a Luminus app.