by Christoph Schiessl on JavaScript and Tailwind CSS Creating intuitive drag and drop interfaces requires clear visual feedback to guide users. While Tailwind CSS provides many built-in variants like :hover and :focus, there's no native var…
by Christoph Schiessl on PostgreSQL Implementing business applications with PostgreSQL, or really any relational database, often amounts to executing sequences of transactions. It doesn't matter if a given transaction ends with a COMMIT or
by Christoph Schiessl on JavaScript Visitors who find your website via Google will probably never return again. It doesn't matter how good your content is because the Internet has a whole universe of content, and any given website is like a…
by Christoph Schiessl on Python Some time ago, I published an article presenting the built-in all(iterable) function. The idea behind this function was that it returns True, if all elements of the iterable convert to True (according to the
by Christoph Schiessl on DevOps and Git You have to be aware of Git's internal data structure, before you can understand what orphaned branches are and how to use them. So, let's start by examining this data structure. Surprisingly, this is…
by Christoph Schiessl on PostgreSQL PostgreSQL 9.3 introduced a new feature called MATERIALIZED VIEWs, and this article explains how to use it based on a contrived example. Let's assume you are working on a database to keep track of your cu…
by Christoph Schiessl on Python As a freelance web developer, I have to read a lot of Python code, and sometimes, I see the following pattern to return two values from a function. It may seem trivial, but it takes some background knowledge
by Christoph Schiessl on Python The opposite of position-only parameters is keyword-only parameters, and they are equally or maybe even more common in the Python world. As you may have already guessed, functions can define specific paramete…
by Christoph Schiessl on Python and FastAPI When you build web applications, you generally want to limit their resource consumption as much as possible. Usually, you want to keep file sizes for transfer to the client small or, even better,
by Christoph Schiessl on Python and FastAPI I recently wrote about HTTP caching with strong ETag headers, but sometimes it makes more sense to use weak ETags. So what's the difference? The whole point of ETags is to have a proxy to determin…
by Christoph Schiessl on Python Levenshtein distance is an easy-to-understand algorithm that measures the similarity of a pair of strings. Imagine that you have received one input string, x, and your job is to find the string most similar t…
by Christoph Schiessl on JavaScript I previously explained how to use JavaScript to extract all URLs from your website's sitemap. Today, I want to build on top of this and re-use the same browser functions to extract the and texts from the