An independent blog catering to the open-source community. Linux, self-hosting, Linux gaming. Developer health.
As a software engineer, I'm intimately familiar with the thrill of solving complex problems, the satisfaction of optimizing code, and the endless pursuit of knowledge in a rapidly evolving field. Yet.. there's another realm that has captured my attention and countless hours of my time (and
A tiny bug can sometimes lead to colossal consequences. After listening to too many technical podcasts in my spare time.. Let's dive into three infamous cases where a few lines of code caused chaos, destruction, and in one case, an interplanetary facepalm. We'll also see how
In the world of database management, much of your data is most likely never actually deleted. The concept of deletion has evolved over time. Enter soft deletion - a well-known technique that's changed how we think about data lifecycle management. This post explores the ins and outs of
Optimizing SQL queries is essential for improving the performance of a database system. In PostgreSQL, like in any other relational database, the way data is structured and indexed plays a crucial role in query optimization. This article will outline the best practices for structuring data, indexing, and query optimization. So
JSONB, or JSON Binary, is a more efficient way to store and manipulate JSON data in PostgreSQL. It stores data in a decomposed binary format, which allows for faster access to individual elements within the JSON document. It is the recommended way to store JSON data in PostgreSQL. Why Use
Python, a language that has permeated the tech industry, is often praised for its simplicity and ease of use. Fields such as AI and Data Science seem to be all about it. However, when we strip away the veneer of convenience, we are left with a language that presents numerous
Ever been greeted by a "404 Not Found" message while browsing the web? It's one of the many status codes used by the web. 404 is self-explanatory - usually an indication that a resource or page was not found. The (almost) interesting history of Port Numbers
Half-Life is a classic game that has spawned countless mods, some of which have become standalone games themselves. But among the many fan-made creations, there is one that stands out for its originality, quality, and atmosphere: Half-Life: The World Machine . Delta Particles: The Ultimate Half-Life Mod You Need to Play
Port numbers are the numerical identifiers that allow computers to communicate over the internet. They are assigned to different applications and protocols, such as web browsing, email, file transfer, and so on. But how did these port numbers come to be? Who decided which port number belongs to which service?
SQL, or Structured Query Language, is a widely used language for interacting with databases. SQL allows you to create, manipulate, and query data in a structured and efficient way. HOWEVER, THERE IS ONE ASPECT OF SQL THAT OFTEN SPARKS DEBATE AMONG DEVELOPERS - WHICH CASE DO YOU USE ..AND WHY
The Single Responsibility Principle (SRP) is one of the most important concepts in software design. It states that every class or module should have one and only one reason to change . In other words, each class or module should have a single responsibility or a single purpose within the
Logging is an essential part of any software development process. Logging is the act of recording events or messages that occur during the execution of a program. Logging can help developers to debug, monitor, and troubleshoot their applications, as well as provide valuable insights into the performance, behavior, and usage
JavaScript is a language that allows you to declare variables in different ways. You can use the var keyword, which creates a variable that is function-scoped . This means that the variable is accessible within the function where it is declared, and any nested functions. For example: function
JavaScript is a language full of surprises. Sometimes, a seemingly harmless piece of code can produce unexpected results or even throw errors. After all, the language was initially created in just 10 days. Why JavaScript on the Backend is Not That Great JavaScript is a popular and versatile programming language
JavaScript is a popular and versatile programming language that powers many web applications. It is widely used for front-end development, where it can manipulate the Document Object Model (DOM), handle user interactions, and communicate with web servers. However, in recent years, JavaScript has also expanded its reach to the back-end,