We use Seq to find valuable insights in the vast sea of our structured log messages. While the search usually works straightforward without any surprises, this time we run into a minor problem. We wanted to find all log messages where property FieldX did not match a specific value. Therefore, we appended this clause to …
FastAPI offers us two main options to specify what data we want: as part of the path or as query parameters. In this post we expand on our minimalistic example and dig a bit deeper into the basic concepts of FastAPI. This post is part of my journey to learn Python. You find the code …
DbUp is a great tool to manage changes to our database schemas. While its strength is with changing tables, we can use DbUp to insert seed data as well. It even works with binary data, if we use the right settings and find the correct method of SqlCommand. Accept code for migrations While it …
If we do not want to keep starting our API and manually click through the endpoints to see if everything still works, we need to put a little effort into testing. Thanks to the underlying Starlette toolkit, we can test our FastAPI application in-memory and do not need a dedicated server. Let us explore how …
I needed to find all columns with an underscore (_) in their name and came up with this query:
|
1 2 3 4 5 6 7 |
SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME like '%_%' ORDER BY TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME |
But instead of showing me columns with a _ in their name, I got every column back that exists in my database. When I replace _ with anything else, I got the expected result. What …
While our application waits on IO (Input / Output), our CPUs idle around. If we would have a way to let the program step aside and let other code run while we wait on a file or a response, we could get more work done at the same time. That is the basic idea behind …
As long as your application does not use Blazor, upgrading from .Net 7 to .Net 8 is a walk in the park. The only obstacle we run into while upgrading the user group site was the publish task. Microsoft has made some simplifications to the runtime identifiers that are a breaking change. For .Net 7 …
There are many projects in Python that we can use to create an API. After exploring a few options, I decided to go with FastAPI and explore it over the next few weeks. FastAPI is not only fast when it comes to serving requests, but also when it comes to writing code for it. Let …
Maybe it is just my confirmation bias, but I think the number of made-up points to win arguments get out of hand. The points get shallower and more ridiculous with every month, and it seems that there is no end in sight on how low the bar could get. When it comes to practices and …
The Garbage Collector (GC) in Python frees the memory from no longer needed objects. This usually works without any problem in the background and prevents us from memory leaks. However, for certain tasks we may pay a performance penalty that we can prevent by tuning the GC. Let us explore the options we have. This …