My blog: notes on programming

Concurrency with Python and AsyncIO    21 December, 2023
How to write Python coroutines and run them concurrently with Python AsyncIO library. Read...

What's FastAPI?     25 April, 2023
Introduction into FastAPI Read...

TCP/IP Networking introduction     30 December, 2022
TCP/IP Networking from scratch Read...

Python context manager: try / finally in better way     30 December, 2021
Python context manager: replacing try / catch by with block. Read...

Pandas DataFrame useful functions     30 March, 2021
How to create Pandas DataFrame from data or other data frames. Read...

Atomic operations in MongoDB     28 February, 2021
How to prevent data loss and keep data consistent in MongoDB without transactions. Read...

Join-like operation in MongoDB     31 January, 2021
How to structure and query MongoDB collection to get the related data. Read...

Tips on Django ORM aggregation     31 August, 2020
What's data aggregation, Django ORM aggregate() and annotate() tips. Read...

Django REST framework serializers tips     27 July, 2020
Tips how to use DRF serializers. Read...

PostgeSQL database console useful commands     18 June, 2020
The list of useful commands in the PostgreSQL command line client (console). Read...

Create real world in browser with JavaScript physics engine Matter.js     26 February, 2020
Simple example and hints. Read...

Dajngo QuerySet how to...     31 January, 2020
Django QuerySet tips. Read...

How to export query output from Postgres SQL client into Google spreadsheet     29 December, 2019
The article tells how to change Postgres SQL console client output format to Google spreadsheet compatible. Read...

Encrypt Linux partition with cryptsetup     29 November, 2019
The article tells how to protect your data encrypting a Linux partition with cryptsetup. Read...

Python unit testing: call the same test method with parameters by data decorator     27 October, 2019
The article tells how to call test method several times with parameters by data decorator. Read...

Python unit testing: mocking with patch decorator     29 September, 2019
The article tells how to mock external calls with patch decorator in unit tests. Read...

NumPy Array cheatsheet     27 August, 2019
The article is a brief summary of NumPy Array functionality. Read...

GIT revert changes tips     26 July, 2019
The article explains how to discard or revert file changes or GIT command results. Read...

Django ORM performance tips: changing data     29 June, 2019
The article explains how to insert, update or delete the database data with Django ORM in efficient way with less or faster SQL queries. Read...

Django ORM performance tips     29 May, 2019
The article explains how to use QuerySet API to produce less SQL queries or more effecient SQL so the database operations work faster. Read...

Logging: how to test a web application without affecting the users     1 May, 2019
Add logs to your server web application and check them with grep command. Read...

Unit testing - why, how and when     19 Apr, 2010
When we should write unit tests, benefits from unit testing and what requirements are for these tests. Read...

Power of Linux command line
Useful Linux commands for productive work. Read...