Skip to content

mysql

Migrating a LAMP VPS

I recently switched my LAMP virtual server to a different VPS provider. The LAMP server that is serving you this site. So the migration worked! Here are the steps, for future reference. Mostly for myself, but maybe you — someone who came here from Google — can use this too. This should work on any small to medium sized VPS. Let’s go! Lower your DNS records TTL value When you… Read More »Migrating a LAMP VPS

Cruddiy: table relationship support via foreign keys

Read here what Cruddiy is and what it can do for you: here is the code. TLDR: Cruddiy is no-code Bootstrap 4 PHP form builder for MySQL tables. I started Cruddiy when the Covid-19 lockdowns happened this spring, to keep me busy. And I released it on GitHub. After 25 stars 🤩 and 13 forks on GitHub and a couple of really encouraging messages on the original Cruddiy post, I… Read More »Cruddiy: table relationship support via foreign keys

Foster: how to build your own bookshelf management web application

foster/ˈfɒstə/verb 1. Encourage the development of (something, especially something desirable). “the teacher’s task is to foster learning” TLDR: I made a personal bookshelf management web application and named it Foster and you can find it here. Here’s what I did — with gifs–, so you might build your own. Name I named it Foster. Because of *this* blog post — it accompanies the application, so it’s self-referential. And also, because… Read More »Foster: how to build your own bookshelf management web application

About WordPress, emojis, MySQL and latin1, utf8 and utf8mb4 character sets

PSA: the MySQL utf8 character set is not real Unicode utf8. Instead use utf8mb4. So you landed here because some parts of your website are garbled. And this happened after a server or website migration. You exported your database and imported this export or dump on the new server. And now your posts look like this: When they should look like this: These are screenshots from this website. This website… Read More »About WordPress, emojis, MySQL and latin1, utf8 and utf8mb4 character sets

Django in 10 minutes

This post is for myself, two weeks ago. I needed something like this. Or, maybe it’s for you? You know a little bit of Python, kind of understand the MVC concept and have a clear understanding of RDBMS? Congratulations, you will have no trouble getting something up and running in Django in a couple of minutes. Whether you need to move a database to an editable, shareable environment for less… Read More »Django in 10 minutes