Collection of helm-stuff

A collection of things for Diablo II

Copied from a book by David Foster Wallace

From Matsumoto City in Nagano Prefecture. The lyrics come from the Bon bon, the name of a traditional summer ritual for girls in this region.

I had a discussion with a colleague on how to persist a sorted (linked?) list in MySQL, and would like to write down my thoughts on this since this is likely a problem I will face in the future. There must be a better way of thinking about this than I’ve come up with. If you have an idea, don’t hesitate to send me an email. Problem description We have a sorted list of a generic length....

A simple docker command to start MySQL on a tmpfs. Things to note: Mounting localtime affects MySQL server timezone You need to have a my.cnf at the given location ($HOME/docker/mysql/my.cnf) You probably need to create /var/lib/mysql before running the command Setting sql_mode="" is probably not needed for most applications. sudo docker run -d \ --name mysql7 \ -v/usr/share/zoneinfo/Europe/Stockholm:/etc/localtime:ro \ -v$HOME/docker/mysql/my.cnf:/etc/my.cnf \ -e MYSQL_ROOT_PASSWORD=root \ -e MYSQL_ROOT_HOST='%' \ -p3306:3306 \ --mount type=tmpfs,destination=/var/lib/mysql \ mysql/mysql-server:5....

Some notes on troubleshooting different encodings for sent/received files. Table Encoding å ä ö Å Ä Ö UTF-8 \c3\a5 \c3\a4 \c3\b6 \c3\85 \c3\84 \c3\96 latin1 \e5 \e4 \f6 \c5 \c4 \d6 CP437 \86 \84 \94 \8f \8e \99 CP850 \86 \84 \94 \8f \8e \99 Notes WINDOWS-1252 / CP-1252 is a superset of latin1 All encodings are supersets of ASCII, so \20=SPACE and \0a=NEWLINE Sometimes you will encounter the “ANSI”-encoding. That name is a lie, and means that the creator is stupid in the head....

When you have an international database, how do you make sure that the collation is correct for all locales? Here are some thoughts. Note that you have to be careful when mixing collations in queries or SQL will complain. Table with virtual, generated columns CREATE TABLE `note` ( `id` bigint NOT NULL AUTO_INCREMENT, `text` varchar(256) DEFAULT NULL, `text_swedish` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_swedish_ci GENERATED ALWAYS AS (`text`) VIRTUAL, `text_danish` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_danish_ci GENERATED ALWAYS AS (`text`) VIRTUAL, ....

[Thomas Aquinas’] teachings constitute a complete system, which is why, as ‘Thomism’, they provide the Roman Catholic Church with its philosophy, whose official status was further confirmed by Pope Pius X in Doctoris Angelici (June 1914): ‘The capital theses in the philosophy of St Thomas are not to be placed in the category of opinions capable of being debated one way or another, but are to be considered as the foundations upon which the whole science of natural and divine things is based; if such principles are once removed or in any way impaired, it must necessarily follow that students of the sacred sciences will ultimately fail to perceive so much as the meaning of the words in which the dogmas of divine revelation are proposed by the magistracy of the Church....

When the autumn comes with its gloom and rain, I get this feeling of melancholy and the need to write down my thoughts on paper. This time I will ramble in the form of a blog post. Please don’t read this as me preaching with a “holier than thou”-attitude. It’s meant by me and for me. Maybe I can read this condescendingly in ten years and think of my then primitive philosophy....