Solving Wordle with information theory and SQLite

I’ve previously spent some time implementing wordle, and since then enjoyed watching others discuss how to solve the game using programming, especially the solutions based on information theory. Naturally, I was interested in trying them out, given my own implementation of the game. Let me show you how I used SQL to solve Wordle, using maths from information theory. Wordle? Briefly, Wordle is a daily word game run by the New York Times, where we need to find a secret 5-letter word within 6 attempts. You may know this game from the American/Dutch TV game Lingo, or the French TV game Motus. To guide us, each character of each attempt is scored as either perfect (right letter, right position) = “🟩”, or wrong position (letter is used but elsewhere) = “🟨”, or a miss (character not used at all in the word) = “⬜” (or “⬛” depending on OS).