All user publications
Andrey Borokin
Total posts: 24

Developing Smart Contracts on Ethereum Using Python and Vyper
-
Publication Date: 17 January 2025

If you've ever worked on developing smart contracts on the Ethereum blockchain, you're probably familiar with Solidity. It has become the de facto standard for creating decentralized applications (dApps). However, as with any technology, there is no one-size-fits-all solution. This is where Vyper comes in—a programming language designed specifically for writing smart contracts, with an emphasis on simplicity, security, and readability.
Blockchain Data Analysis: Using Python to Explore Transactions
-
Publication Date: 16 January 2025

Blockchain isn’t just another buzzword or the latest tech fad. It’s a distributed system that has radically changed how we store and transmit data. To effectively analyze blockchain data, it’s essential to grasp its core principles: how the technology works, how the data is structured, and why it’s considered so reliable.
Diving into the World of Cryptocurrencies: Origins and Evolution
-
Publication Date: 14 January 2025

The first attempts to create digital currencies emerged long before Bitcoin and other modern cryptocurrencies. One of the key figures in this history is David Chaum, who in 1983 proposed the concept of "ecash"—an electronic currency operating on network protocols. Although his ideas did not find immediate implementation, they laid the groundwork for future developments. In the 1990s, projects like DigiCash, founded by Chaum, aimed to create anonymous electronic payments. Despite its technical innovations, DigiCash faced financial difficulties and could not establish itself in the market. Nevertheless, its developments showcased the potential of using cryptography to secure transactions, marking an important step forward.
Blockchain in the Modern World
-
Publication Date: 14 January 2025

When Satoshi Nakamoto released his famous white paper in 2008, no one could have imagined that a simple idea of a decentralized ledger would revolutionize not only the financial world but much more. At its core, blockchain emerged from the desire to create a system where trust isn’t placed in intermediaries but is built on mathematical proofs and transparent algorithms. It’s a bit like trying to explain to your grandmother why she doesn’t need banks because you have cryptocurrency. Absurd? Perhaps. But it was this boldness that laid the foundation for the technologies we see today.
Setting Up and Restoring PostgreSQL with WAL: A Comprehensive Guide
-
Publication Date: 09 January 2025

First and foremost, it's important to understand what Write-Ahead Logging (WAL) is and why it's so crucial for PostgreSQL. When we talk about database integrity, we mean that despite various failures—be it a power outage, disk failure, or network issue—the data remains as accessible and consistent as possible. To ensure this reliability, PostgreSQL uses the WAL mechanism.
Advanced SQL: Optimization, Transactions, Big Data, and Security
-
Publication Date: 08 January 2025

In this section, we’ll explore some of SQL’s more advanced features for query building. We’ll focus on enhanced SELECT
and JOIN
constructs, different types of subqueries, and how to use window functions. We’ll also discuss how to structure queries so they’re both easy to read and straightforward to optimize.
A Beginner's Guide to SQL: From Creating Tables to Optimization
-
Publication Date: 08 January 2025

SQL (Structured Query Language) is a language used to interact with relational databases. Its main purpose is to provide developers and administrators with a straightforward yet powerful tool for storing, modifying, and retrieving data. Let’s dive into why SQL is so important and why almost every modern information system relies on relational DBMS (Database Management Systems).
Introduction to Pydantic: Basics and Advanced Features
-
Publication Date: 04 June 2024

In modern programming, particularly in Python development, effective data handling is essential. The stability and security of your applications often hinge on how well you manage and validate the data flowing through them. This is where Pydantic comes into play—a library that provides a straightforward approach to data validation and serialization.
Working with aiohttp in Python 3
-
Publication Date: 07 May 2024

aiohttp is an asynchronous Python library designed for building both server-side and client-side web applications. It’s built on top of asyncio, which is part of Python’s standard library and provides support for asynchronous programming. This allows developers to write code capable of handling numerous connections and requests simultaneously—ideal for high-traffic web applications.
Effective Routing in Nginx: A Developer's Cheat Sheet
-
Publication Date: 17 March 2024

Nginx (pronounced "engine-x") has established itself in the market as one of the most powerful and flexible web servers and reverse proxy servers available. Designed to tackle the C10K problem—handling ten thousand simultaneous connections—Nginx has exceeded expectations by offering a high-performance, reliable, and scalable architecture. This is achieved through its asynchronous, event-driven request processing model, making it ideal for modern high-traffic web applications, including static content delivery, proxying, and load balancing.