When we start serving HTML files with our FastAPI application, we need a way to send images, CSS- and JavaScript files without creating an endpoint for each file. Let us solve this problem with a static route. This post is part of my journey to learn Python. You find the code for this post in …
One would assume that renaming a default constraint should work the same way as renaming a primary key. For some unknown reason that was not the case as I had to fix the (dynamically generated) names of default constraints. The format that worked at last was this one:
|
1 |
exec sp_rename N'SCHEMA.NAME_OLD', N'NAME_NEW' , N'OBJECT'; |
Without the N in front of …
Last week we added Alembic to our to-do app to be ready for upcoming changes to the tables. In this post we extend our FastAPI application, but in an unexpected direction: we add a web interface. Let us find out how we can do that. This post is part of my journey to learn Python. …
Unlike most other tools, PowerShell does not offer us a -version flag to tell us its version number. There is a -Version flag (with a capital V), but that we need to use a specific version of PowerShell. What can we do to find out what version we run? We can open a PowerShell terminal …
Our current way to create the tables in the database when we run the application works fine until we need to extend an existing table. Then SQLAlchemy will not do that for us, and we must make the change manually. With Alembic we have a solution for that problem that works great with SQLAlchemy. Let …
There is not much more annoying that fixing a bug in a JavaScript file and then find problems in production because the browsers of your users cached the old file. While the first reaction is to disable all caching, there is a better way in ASP.NET: append the file version to the JavaScript file name. …
Last week we moved from an in-memory data store to SQLAlchemy and persist our tasks inside an SQLite database. We have two things we need to optimize, or else we end up with problems along the way. This post is part of my journey to learn Python. You find the code for this post in …
There are not many things that are more annoying to start your day than this message in Visual Studio 2022: Nothing changed in my account, nothing changed in the infrastructure, yet here we are, and Visual Studio can no longer find our account. Without that account, we cannot access the company NuGet feed, then that …
Until now we kept our data in a variable. While that worked with an example application, the data vanishes as soon as we restart our API. To get a more realistic application, we need to persist data for a longer time. Let us explore how we can integrate SQLAlchemy with FastAPI. This post is part …
I run into this annoying problem after the upgrade of IdentityServer to .Net 8. The IDP application works fine, but as soon as I tried to log in on a client, I got this error: SqlException: Incorrect syntax near ‘$’. In the console I got a slightly more search-friendly error, that lead to the source …