Markus is a software developer based in Estonia. He works in the software development industry (Full-stack), primarily uses Linux and has his own home server, along with multiple remote cloud servers
Programming
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
Programming
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
Programming
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
Programming
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 NumbersPort numbers are the numerical
Linux Gaming
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 PlayIf
Programming
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?
Programming
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
Programming
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 system.
Programming
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
Programming
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 foo() { var x
Programming
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 GreatJavaScript is a popular and versatile programming language that
Programming
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,
Programming
The ELK stack is a popular combination of open-source tools for collecting, storing, analyzing, and visualizing data. ELK stands for Elasticsearch, Logstash, and Kibana. Elasticsearch is a distributed search and analytics engine that can handle large volumes of structured and unstructured data. Logstash is a data processing pipeline that can
Programming
Caching is a technique of storing frequently used data in a fast and accessible memory, such as RAM, to reduce the latency and cost of retrieving it from a slower and more expensive source, such as a database or a network. Caching can improve the performance, scalability, and reliability of
Programming
Java is one of the most popular and widely used programming languages in the world. It is known for its simplicity, portability, and versatility. However, Java is not without its challenges. There are some concepts that are harder to understand and master than others, and require more time, effort, and
Programming
Programming is a skill that requires a lot of logical thinking, creativity, and patience. It can also be very rewarding and fun, especially when you can create something useful or beautiful with code. However, programming is not always easy. There are some concepts that are notoriously difficult to understand, even