angle-uparrow-clockwisearrow-counterclockwisearrow-down-uparrow-leftatcalendarcard-listchatcheckenvelopefolderhouseinfo-circlepencilpeoplepersonperson-fillperson-plusphoneplusquestion-circlesearchtagtrashx

Category

5 February 2024 Updated 7 February 2024
Use a PostgreSQL function and a PostgreSQL trigger to limit the maximum number of rows per user.
18 January 2024 Updated 18 January 2024
Create a small helper function to make debugging of dynamic SQLAlchemy filters a breeze.
10 April 2023 Updated 10 April 2023
Respect the privacy of your visitors, do not connect them to a third-party Captcha service!
16 July 2022 Updated 16 July 2022
Cascade Deletes is much more than just adding 'all, delete' to the relationship.
28 May 2022 Updated 29 May 2022
Using UUIDs is fine, but when you're dealing with millions of records, stick with BigIntegers
12 April 2022 Updated 12 April 2022
4 June 2021 Updated 4 June 2021
I wanted an asynchronous SQLAlchemy API but ended up building a synchronous SQLAlchemy API.
8 March 2021 Updated 8 March 2021
WTForms QuerySelectField and QuerySelectMultipleField make it easy to manage SQLAlchemy relationship data.
9 April 2020 Updated 9 April 2020
UUID Primary Keys are 'universe unique' and have many advantages. Consider using them in your next project.
8 February 2020 Updated 16 February 2020
29 August 2019 Updated 30 August 2019
Reduce the carbon dioxide (CO2) emissions of your web app using query result caching and template caching.
25 August 2019 Updated 30 August 2019
We add a table with translations for every table that has fields that must be shown in multiple languages.
29 July 2019 Updated 29 August 2019
Checking timing is another way of looking for errors
24 June 2019 Updated 31 August 2019
Why you should try to avoid client-side datetime calculations with SQLAlchemy unless ...
21 June 2019 Updated 29 August 2019
This post shows how to build a query builder for all your select queries
17 June 2019 Updated 31 August 2019
What is the use of defining a relationship with back_populates? Start thinking tuples.
9 March 2019 Updated 28 August 2019
Auto Detect does not detect column type changes by default. You must turn this on by editing the alembic/env.py file.