"Today I will discover America to you based on OpenStreetMap data in PostgreSQL15/PostGIS and my project openstreetmap_h3"

Roads and building density in North America. 100GB geodata processing OSM data in PostgreSQL: https://bit.ly/3HY1GoA

"First of all, I say hello to the haters and skeptics. What I developed is really unique and solves the problem of transforming and analyzing geodata using the usual and familiar tools"

How to put the whole world into a regular laptop — PostgreSQL and OpenStreetMap: https://bit.ly/3IcIS5e

"In this article, I will introduce NoSQL concepts and show how they are related to Elasticsearch, and we will consider this search engine as a NoSQL document store"

Elasticsearch as NoSQL Database: https://bit.ly/3xzAqrJ

Building your own CLI with Swift

In this article we'll explore how to build your own command line tools with Swift Programming Language: https://bit.ly/3xALMvL

How to write simple intelligent code search with Open AI

In this article, we will briefly review a technology that underlies ChatGPT — embeddings. Also we'll write a simple intelligent search in a codebase of a project: https://bit.ly/3ICXjB4

The Best NBA Fantasy Apps in 2023

For a basketball fan, the NBA season is the best time of the year, and fantasy sports app development have become the latest trend where you can create your own team and can compete with real-time teams: https://bit.ly/3Klo3Hz

"If there aren’t many elements, it can speed things up a lot, and so can hotkeys. But with the wrong approach it will only produce lists within lists and icons piling up make things worse"

How to improve user experience with interfaces: https://bit.ly/3Inhp0Z

«Divide and Conquer» for OpenStreetMap world inside PostgreSQL

Let's continue the story with secrets about OpenStreetMap geodata, on which many companies have built their business, but not everyone shares the details... Today we'll open crucial details: https://bit.ly/3Eu3HYR

SwiftUI & ChatGPT. The world is changing. Again

Everything that follows from this point forward input prompts, followed by ChatCGP’s responses, complete with sample code in Swift: https://bit.ly/3IzYLTv

"Most of the processes that people use in their work lives can be represented as some object that goes through some flow. Each flow contains many stages, in each one of them the object can be manipulated by certain group of users.

In this article I want to suggest an approaches to effectively handle such flow based systems"

State Management for processes flow: https://bit.ly/3SBDuxh

"I just started to learn Game Development, and decided to run write my personal blog about it. So there you can find information that i've gathered and my personal problems with learning"

Let's start in GameDev: https://bit.ly/3krUtWq

How to Create a Color Picker in React Native

A color picker allows users to select a specific color from a range of colors. In this tutorial, we will show you how to create a color picker in React Native: https://bit.ly/3SBv88P

PostgreSQL 16: Part 4 or CommitFest 2023-01

We continue to follow the news of the PostgreSQL 16 release, and today, the results of the fourth CommitFest are on the table. Let's have a look: https://bit.ly/40dbd2U

Writing The Matrix in Python: easy guide

Any beginner programmer can write a model of the cult splash screensaver with the green streams of digits flowing down the screen. Let's try to create it in the "great and mighty" Python: https://bit.ly/42gB2AM

Journey to find a headset with a good side talk cancellation mic for calls in an open office

All AI-based noise cancellations suck, only the physical cancellation technique works! And physical cancellation is implemented well only in Jabra devices yet, but other features suck them! All Bluetooth headsets suck too! So, no solution yet, just complaints: https://bit.ly/3mYhGQX

Cross-Platform System Programming Guide for UNIX & Windows: Level 1

In this tutorial we'll learn how to write cross-platform code in C using the system functions on popular OS (Windows, Linux/Android, macOS & FreeBSD) — file management functions and file I/O, console I/O, pipes (unnamed), execution of the new processes: https://bit.ly/3LB0FGN

Tutorial. Onchain Analysis basics

This tutorial is built around the Bitcoin blockchain, but many of the techniques are applicable to any other blockchains as long as they have wallets, balances, and transactions: https://bit.ly/3JRPmbN

The Collatz conjecture is the coolest math trick of all time

On the Internet and in non-fiction literature you can often find various mathematical tricks. The Collatz conjecture leaves all such tricks behind. At first glance, it may seem like some kind of a trick with a catch. However, there is no catch: https://bit.ly/3n9FSjo

As developers, we spend a significant amount of time in the terminal, executing commands, writing scripts, and trying to solve problems. But, how many times have you found yourself stuck, trying to remember the correct syntax or flag for a command, or spending hours looking for a specific code snippet?

Boosting Your Terminal Productivity. Shell GPT: https://bit.ly/3TFdPEp

"For me, the main source of knowledge is reports from other researchers in this field. When reading reports, I find interesting techniques that I later apply in my work"

From research to practice — a portal to run virtual machines with vulnerabilities: https://bit.ly/42EDp0k