Anton Sukhachev

Explores how MySQL indexes handle OFFSET pagination and compares ways to improve query performance

4 Bit Adder with implementation

Half Adder using transistors with truth table, and practical implementation

XOR Gate using transistors with truth table, schematic, and practical implementation

OR Gate using transistors with truth table, schematic, and practical implementation

NAND Gate using transistors with truth table, schematic, and practical implementation

AND Gate using transistors with truth table, schematic, and practical implementation

Visualizes SQLite B-Tree index search operations, detailing internal navigation and data retrieval processes

Explores SQLite B-Tree index structure with visualizations, explaining on-disk and in-memory storage mechanisms

Shares insights into developing a PHP skeleton for Bison, offering a behind-the-scenes look at the process

Explains constructing a JSON parser using PHP and Bison, enabling efficient JSON data handling

Details creating an Nginx configuration parser with PHP and Bison, improving server configuration management

Guides on building an Abstract Syntax Tree (AST) parser using PHP and Bison, aiding in code analysis and manipulation

Introduces a PHP skeleton for Bison parser generator, facilitating seamless parser integration into PHP projects

Offers practical tips for reducing Docker image size, enhancing container efficiency and performance

Delves into the PHP engine's process of constructing Abstract Syntax Trees during code compilation

Explores parsing techniques using PHP, Bison, and re2c, demonstrating how to build efficient parsers

Describes creating a Telegram bot that tracks currency availability in Tinkoff ATMs, enhancing user convenience

Compares different approaches to handling collections in PHP, evaluating type safety, IDE support, and performance

Discusses various methods for implementing generics in programming, providing simple examples for clarity

Introduces a solution for implementing generics in PHP, providing a practical approach for developers

Chronicles developing a remote-controlled boat powered by ESP8266 NodeMCU, from prototype to final model

Details constructing a remote-controlled car using ESP8266 NodeMCU and LEGO components, blending electronics and creativity

Curates a list of engaging articles available on the website, spanning various topics

Shares the experience of migrating a personal project to Kubernetes (k8s), highlighting challenges and solutions

Evaluates various PHP process managers and servers, comparing performance and features

Describes developing an online version of the Mafia game using Go, Vanilla JavaScript, and WebSockets

Details designing and implementing a service dedicated to aggregating and categorizing housing ads

Explores methods for classifying housing advertisements, seeking the most effective approach

Explains setting up continuous delivery pipelines using Travis CI and Ansible for automated deployments

Discusses combining Nginx, Lua, and Redis to handle sessions and data delivery efficiently

Introduces SonarQube as a tool for assessing code quality, outlining setup and usage

Shares the process and challenges encountered while upgrading a project from Symfony 2.0 to 2.6