How to Recover MySQL Database from ibdata1 File? – A Complete Guide

  • 1.7K Views
  • 7 mins read
Preview post image

Your MySQL database/tables can get corrupted due to certain reasons. When the database is corrupted, you may fail to open or access the tables in it. Sometimes, you encounter random corruption-based errors, like Index for table ‘.\\mysql\\user’ is corrupt or Table ‘.\\mysql\\user’ is marked as crashed and should be repaired. In such cases, you need to restore the MySQL database to regain access. In MySQL, you can restore the database tables using different recovery methods. In this article, we will explain how to restore the MySQL database using the ibdata1 file.

Engineering Management II: Outcomes and alignment

  • avatar
  • 582 Views
  • 3 mins read
Preview post image

The more responsibility you take on, the less your job is about your own output. For engineers who step into management, this can feel unnatural. You're used to solving problems directly, writing code, and moving fast. You may even know the exact way to solve something, and it can feel frustrating to slow down long enough to explain it to someone else. But that's the shift.

Engineering Management I: Building trust and protecting focus

  • avatar
  • 738 Views
  • 6 mins read
Preview post image

Engineering management is one of those roles that looks simple on paper but feels very different once you're in it. At its core, it's about enabling others rather than measuring yourself only by your own output. You're not just writing code or solving problems directly anymore. Instead, you're creating the right environment for your team to do their best work, keeping them aligned, and helping them grow.

 Join Our Monthly Newsletter

Get the latest news and popular articles to your inbox every month

We never send SPAM nor unsolicited emails

Implementing Commands and Queries in Laravel 12

  • avatar
  • 3.0K Views
  • 4 Likes
  • 8 mins read
Preview post image

CQRS, short for Command Query Responsibility Segregation, is a simple yet powerful way to split the responsibility for writing and reading data in an application. Instead of having a single service or model method that both changes and retrieves data, you give commands the job of making changes and queries the job of fetching information. This split can make large projects much easier to follow, especially as business rules grow and read and write requirements start to differ.

Configuring multiple websites on a single Nginx server

  • avatar
  • 2.0K Views
  • 3 Likes
  • 6 mins read
Preview post image

Nginx is a powerful and lightweight web server that's commonly used to serve websites and static content. If you're running several websites on a single machine, configuring Nginx to manage them properly is efficient and straightforward. This article walks you through installing Nginx, setting up multiple sites, configuring firewall access, and organizing your folders and logs in a clean and practical way.

How to use the AD Keyboard module with Arduino

  • avatar
  • 1.3K Views
  • 7 mins read
Preview post image

When working on simple Arduino projects that need basic navigation or input, the AD keyboard module is a handy little tool. It's a 5-button unit that behaves like a directional pad, with four arrow-style buttons and one additional button. It doesn't require any soldering or setup, which makes it a practical choice for prototyping or small projects. You can plug it in and start using it right away, thanks to its three-pin layout and built-in resistors.

MySQL 8 setup with remote connections

  • avatar
  • 1.2K Views
  • 7 mins read
Preview post image

Setting up a MySQL 8 server can seem complicated at first, but with a clear and structured approach, the process becomes much more manageable. This guide explains how to install MySQL 8 on Debian-based systems, configure it to accept remote connections, and test that it is running correctly. The instructions are practical and direct, suitable for environments that require reliable and straightforward configuration.

Managing yourself in a Startup without losing focus

  • avatar
  • 900 Views
  • 1 Like
  • 4 mins read
Preview post image

Managing a startup isn't the same as managing a traditional company. Things move faster, roles shift often, and structure can be more of a goal than a reality. What works in a bigger or more stable organization often doesn't apply. People wear many hats, context changes every few weeks, and there's a constant need to adjust. In that environment, knowing how to manage yourself and others becomes less about control and more about adaptability. This article looks at how to stay effective and useful in that kind of setting, even when everything feels a bit chaotic.

Understanding Hexagonal Architecture with practical example

Available to registered members only
  • avatar
  • 1.5K Views
  • 1 Like
  • 7 mins read
Preview post image

Hexagonal architecture, also called ports and adapters, is a software design approach that helps structure an application by clearly separating the core logic from technical details and external systems. Instead of shaping your app around frameworks, protocols, or storage, you keep your focus on what the application does, and let everything else connect to it through interfaces. The pattern isn't tied to any specific language. The examples in this article are written in PHP to show how the idea can be applied, but the approach works the same way in any backend system.

Tag-based cache inside Laravel repositories

Available to Premium members only
  • avatar
  • 1.1K Views
  • 12 mins read
Preview post image

Working with cache can drastically improve the performance of an application, especially when dealing with data that doesn't change too often. While Laravel provides solid support for caching through multiple drivers, it doesn't offer native support for cache tags. To work around this limitation, we'll integrate Symfony's Cache component, which brings tag support and fits well into the repository pattern we've already established. In this article, we'll build on the existing structure and focus on using cache tags to group and clear related data more efficiently.