Welcome to reliable.codes, where I channel my passion for coding, detail-oriented thinking, and over 15 years of IT experience into a structured order of thoughts. I’m Oliver Lippert, and if the term “nerd” resonates with you, you’re in the right place. For a more detailed overview of my professional journey, you can check out my LinkedIn profile.
In the ever-evolving world of IT, I find myself navigating through complex projects for international organizations, wearing multiple hats from intensive meeting sessions to diving deep into code bases for debugging.
## Bits & Bytes Saga: The Nerdy Corner > Dive into the world of coding with Oliver Lippert at reliable.codes - your go-to digital guide for IT solutions. Join this coding enthusiast on a journey through 15+ years of experience, unraveling complexities, sharing anecdotes, and offering valuable insights. Whether you're a seasoned developer or just starting, subscribe for a steady stream of fresh content. Explore the intersection of coding and passion where every post is an opportunity for personal discovery. Welcome to Bits & Bytes Saga: The Nerdy Corner at reliable.codes - [Use MySQL prepared Statements in PHP for more security](https://reliable.codes/blog/prepared-database-statements-in-php-with-mysql/): Learn how to prevent SQL injection in your PHP applications using MySQL prepared statements. Secure your database queries with this simple, low-effort guide. - [SSH - Access your server remotely](https://reliable.codes/blog/use-secure-shell-to-access-servers-remotely/): SSH is the tool of choice if you need to access a server remotely. It securely opens a connection and you can run any command as if you would run it as if it would be your local computer. You can even use it for file transfer and other usecases. - [Complete guide to setting up your first virtual private server (VPS) at Hetzner](https://reliable.codes/blog/virtual-private-server-at-hetzner/): Learn to set up your first VPS at Hetzner with this step-by-step guide. Perfect for developers wanting to host applications, self-hosters seeking affordable infrastructure, and sysadmins exploring cloud deployment options. - [Easily understand Git Revisions, Branches and Tags](https://reliable.codes/blog/git-revisions-branches-tags/): Struggling with Git branches, tags, or revisions? Learn how they work. Especially in critical situations this understanding will impact your decisions for the better. - [Git - Distributed version control](https://reliable.codes/blog/git-version-control/): Learn how to use Git for effective version control, track changes, and collaborate seamlessly. This guide covers essential Git commands and concepts - a perfect starting point. - [What is a database transaction (using MySQL)?](https://reliable.codes/blog/mysql-transactions/): Learn what database transactions are and when to use them. This guide explains the stability and reliability improvements that come with MySQL transactions, making it easy for developers and sysadmins to understand and implement. - [How to connect PHP with MySQL](https://reliable.codes/blog/connect-php-to-mysql/): Discover how to easily integrate PHP with MySQL for efficient backend development. Ideal for developers, sysadmins, and self-hosters, this guide covers essential steps and best practices for managing and storing data cost-effectively. - [My Structured Query Language (MySQL)](https://reliable.codes/blog/mysql-my-structured-query-langauge/): With a database you can store all your information that is needed in your project. First you define the structure of your data and how it relates to each other, you also can define some rules to ensure stored data is valid and finally the database will take over the heavy lifting for you. No matter if a small project with 10 information or complex systems with millions or billions of data entries. - [PHP Hypertext Processor](https://reliable.codes/blog/php-hypertext-processor/): Learn how to build dynamic web applications with PHP. From generating dynamic HTML to serving API requests and running background processes, PHP offers an easy entry point into backend development. Perfect for junior developers, system administrators, and self-hosters. - [File Transfer Protocol (FTP)](https://reliable.codes/blog/ftp-file-transfer-protocol/): Discover how to efficiently upload multiple files of various sizes and types to remote storage using the File Transfer Protocol (FTP). This guide covers both graphical and command-line FTP clients, making it perfect for developers, sysadmins, and self-hosters. - [DNS changes in under 10 minutes](https://reliable.codes/blog/fast-dns-changes/): Discover how to accelerate DNS changes to under 10 minutes, minimizing downtime and optimizing your migration process. Perfect for developers, sysadmins, and self-hosters. - [Domain Name System (DNS)](https://reliable.codes/blog/dns-domain-name-system/): Discover how the Domain Name System (DNS) works and why it’s crucial for managing domain addresses. This guide covers DNS server hierarchy, zone files, entry types, and caching, making it an essential read for developers, sysadmins, and self-hosters. - [Node.js - JavaScript in Server Applications](https://reliable.codes/blog/nodejs-javascript-server-applications/): Learn how to use Node.js to run JavaScript on the server side, from basic CLI applications to serving dynamic websites. Perfect for developers, sysadmins, and self-hosters. - [Mastering YML (YAML): A guide for Developers, Admins, and Self-Hosters](https://reliable.codes/blog/how-to-read-and-write-yml/): Discover the essentials of YML (YAML) in this in-depth guide. Learn to read, write, and structure YML files with ease, perfect for developers, sysadmins, and self-hosters managing configurations or coding projects. - [Understanding JSON: A Complete Guide to Reading and Writing JSON Files](https://reliable.codes/blog/how-to-read-and-write-json/): Learn how to read, write, and structure JSON files in this comprehensive guide. Explore JSON’s role in modern development, configuration, and data exchange, tailored for anyone working with code or configs. - [Easily use temporary files in Jetbrains (Scratch Files)](https://reliable.codes/blog/jetbrains-scratch-files/): Learn how to leverage scratch files in JetBrains IDEs for fast, temporary code snippets that won’t clutter your projects. Create, manage, and execute cross-project files effortlessly while keeping your codebase clean. - [How to encode and decode special characters in URLs](https://reliable.codes/blog/encode-decode-url/): Enhance your web browsing experience by mastering URL encoding techniques, enabling you to manage special characters with precision and ease. Uncover the simplicity of percent-encoding, ensuring smooth navigation through complex web structures and dynamic content without compromising data integrity. - [Demystifying URL Structure: A Comprehensive Guide to Understanding and Interpreting URLs](https://reliable.codes/blog/understanding-how-to-read-urls/): Ever wondered about the intricacies of URLs like “https://reliable.codes”? This comprehensive guide breaks down URL structures, providing insights into each segment to enhance your understanding of navigating the web. - [Demystifying JavaScript: A Beginner's Guide to Understanding Source Code](https://reliable.codes/blog/understanding-javascript-source-code/): Unravel the intricacies of JavaScript source code with this beginner-friendly guide. Explore fundamental concepts like variables, functions, loops, and objects through practical examples. Dive into the world of programming logic and enhance your understanding of web development. - [Efficient Dependency Management with NPM](https://reliable.codes/blog/document-and-manage-dependencies-with-npm/): Learn how to efficiently manage dependencies in your projects using NPM. Avoid losing control and maintain oversight with proper documentation and management techniques. - [Streamline Web-Development with Bulma CSS Framework](https://reliable.codes/blog/bulma-css-framework/): Boost your web development efficiency by leveraging the power of CSS Frameworks. Explore how Bulma simplifies styling, allowing you to create stunning websites effortlessly. - [Level up your programming by using IDEs like WebStorm](https://reliable.codes/blog/next-level-programming-using-an-ide-like-webstorm/): Elevate your programming skills using WebStorm and IDEs. Avoid common errors, enhance code navigation, maintain code consistency, and seamlessly integrate external tools for a superior development experience. - [Mastering CSS: Unleashing Style and Elegance](https://reliable.codes/blog/css-adds-style-and-elegance-to-any-website/): Discover the art of styling with CSS and learn how to define your unique web design, merging elegance and functionality with professional know-how. - [Effortless Website Hosting on a Budget with Namecheap](https://reliable.codes/blog/shared-web-hosting-at-namecheap/): Discover how to effortlessly host your website on a small budget with Namecheap’s shared hosting. Explore the process from selecting a plan to configuring SSL, and learn to upload your site for a seamless online presence. - [HTML - the hidden power of the WEB](https://reliable.codes/blog/html-fundamentals-web-structure-guide/): Uncover the essential role of HTML in structuring web content. This post provides a foundational introduction to HTML, highlighting its crucial role in organizing information for browsers. Explore HTML document structure, the significance of head and body sections, and build a step-by-step “About Me” page. Delve into HTML with practical examples, laying the groundwork for further exploration in web development.