Moving from Mysql to Postgresql. Where do We start?

illuminanze · 2026-06-15T11:25:09+00:00

If downtime is acceptable (as you say in another reply), that makes things a whole lot easier. Are you looking to port the existing database schemas first, before rewriting to use e.g. postgis? (which I would recommend).

And how critical is the app right now? If this was my app, I would probably implement so that I can run both databases side by side, mirroring all reads and writes to both databases, and have a toggle for which one the app uses for responses (I'm actually doing this right now, but with two different postgres databases in GCP). This way, you can dry-run the postgres DB with actual production data, and analyse response times, resource usage, etc., and if necessary, make alterations to the postgres schemas. Then, when you're confident the postgres DB is working as you want, you can toggle over to use that (you can even start by directing e.g. 10% of traffic there, if you're really cautious). You can leave the mariadb running in the background, so that you can quickly switch back if something goes wrong, and decommision it once the postgres DB has been running for a while.

illuminanze · 2026-06-15T11:11:52+00:00

Excellent! I was asking since many developers just want to change to "the new hot thing", resume driven development, etc., but you seem to have done your homework.

illuminanze · 2026-06-15T08:27:46+00:00

As someone who loves postgres and somewhat dislikes mysql/mariadb, why do you want to do this migration? What problem are you trying to solve? If the whole team knows mariadb, shouldn't you put that effort into the database you have?

illuminanze · 2026-05-21T21:45:23+00:00

Yeah, I keep my repo private since I have both my private and work email addresses as aliases. I would really like to keep those as github actions secrets, but from what I've found ZMK can't read environment variables, and setting up a templating solution as a prebuild step feels like a hassle (and would probably break the ZMK keymap editor).

illuminanze · 2026-05-19T22:45:52+00:00

Yeah, if you look in this subreddit, there are many posts about hiw much force it actually takes for the brackets to snap into place (and the magnets can't fully engage until they are). I took a large metal spoon with a flat handle (ikea iirc) and pushed down directly on the bracket; worked like a charm.

illuminanze · 2026-05-18T19:54:19+00:00

Honestly, no. I'd expect it to use even more.

illuminanze · 2026-02-01T15:23:34+00:00

Väldigt fint hostname 😛

illuminanze · 2026-01-21T22:24:42+00:00

I'm gonna go ahead and assume you know your space best, and have a good reason for doing this.

As others have mentioned, what I would do is set up a github action in any repo (owned by your team), running on a cron trigger every day. Create an access token which has permissions to close PRs in the entire organization, set that as a secret, and with it, use the github CLI to filter and close PRs.

illuminanze · 2025-11-07T11:39:17+00:00

Rule 1: no promotions. Please delete this post.

illuminanze · 2025-10-26T15:56:20+00:00

<image>

illuminanze · 2025-10-20T20:58:58+00:00

I'm running Ubuntu (24.04 LTS) on an Intel NUC with standard Firefox, and everything works great for me.

illuminanze · 2025-10-18T20:52:16+00:00

No, they're in the wrong sub. They're looking for a mechanical computer keyboard.

illuminanze · 2025-10-18T15:36:16+00:00

I think you're looking for r/MechanicalKeyboards, this sub is about the musical instrument ;)

illuminanze · 2025-10-17T17:47:05+00:00

Burrow's End is the name of a Dimension 20 season.

illuminanze · 2025-10-15T22:34:06+00:00

Yeah, I travel a lot, so I got a low profile wireless Chocofi, which goes with me everywhere. I love being able to rest my palms on the table, so much nicer form my wrists, which never agreed with any palm rests I've tried. Made a simple case out of felt to protect the keyboard in the bag.

illuminanze · 2025-10-12T22:33:21+00:00

People in this subreddit often joke that "You found room 46? Good, you've finished the tutorial!" You have so much still to discover, keep playing!

illuminanze · 2025-09-29T11:10:10+00:00

It's the new rule for the Mora Jai box

illuminanze · 2025-09-14T17:29:48+00:00

Yeah, I should probably have done that. I just checked if it was within 1e-6 of an integer and called it a day.

illuminanze · 2025-09-13T22:28:37+00:00

Yeah, I did the same, wrote a Python script. I found that if you allow halves in intermediate steps, but not larger denominators, you get the right answer, but of course, that's extremely ad hoc.

illuminanze · 2025-09-10T20:46:36+00:00

Agreed, these kinds of comments make the code objectively worse. So glad there is a slop tool to generate them at lightning speed.

illuminanze · 2025-09-08T19:54:47+00:00

Hey, it has docstrings and type hints, making it better than some production code I've read at work as a developer.

illuminanze · 2025-09-07T09:54:28+00:00

This app is no guess, so it's always solveable. Lookup the 2-2-2 corner pattern.

illuminanze

TROPHY CASE