Search results

Matches found for tag 'MariaDB': 4

Using UUIDs instead of Integer Autoincrement Primary Keys with SQLAlchemy and MariaDb

9 April 2020 Updated 9 April 2020 by Peter

We all know the Integer Autoincrement Primary Key. Works great, much software is doing it this way. It is fast. But it also has limitations. An alternative for the Integer Autoincrement Primary Key is the UUID (Universally Unique IDentifier) Primary Key. A UUID is a 128-bit number. It can be represented by a string, for example: 05390f2b-48e8-45c7-8ae4-08272dc69122 or a hex string (the same as above ...
Read more

Converting to a multilanguage database

25 August 2019 Updated 30 August 2019 by Peter

When I started this project, this website, I kept in mind that it had to support multiple languages. But of course I did not really look into database design because of all the other things I had to learn, add and implement. After a certain moment I could display and select multiple languages but that was for the texts in the code and templates and not for the database content items like blog posts ...
Read more

Reorganize, restructure, move to content items, add themes, add more languages

14 August 2019 Updated 14 August 2019 by Peter

This post is about editing code, a lot of editing, huge amounts of editing! When you implement much functionality, you notice things that need attention, things that need you to research, how do others do this, what is the plural of certain words, etc. I maintain a todo list and every time I noticed something that needed attention I added it to this list. The list got too big so I decided to stop adding ...
Read more

Flask + SQLAlchemy + MariaDB profiling

29 July 2019 Updated 29 August 2019 by Peter

Performance is a never ending story. At a certain moment I noticed that putting the home page on the screen took some 370 milliseconds using the Flask development server with debug messages shown. That seemed far too long! How did I notice this? Because at the bottom of every page I show the time it takes to generate a page. Please note that the timings below are from a more optimized version of the ...
Read more