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.
You’re welcome.
Image from Reichenau Gospels, an 11th century manuscript housed at The Walters Art Museum, manuscript information here, image from World Document Library, image assumed allowed under Fair Use.