Category: Administration

Notes from a Data Scientist: A Personal Review of Query Languages

I share from personal experience where and when it was useful. A general overview and bullet points to clarify what can be explored further — but this is based solely on my subjective personal experience, yours may be quite different. Why is it important to know and be able to work with query languages? In essence, there are several key aspects in Data Science [...]

Life in 2030

Frenchman Fabrice Grinda has always loved taking risks — he has successfully invested in hundreds of companies: Alibaba, Airbnb, BlaBlaCar, Uber, and even the Russian equivalent of Booking — the service Oktogo. He has a special intuition for trends and the potential future. Monsieur Grinda not only invested in others' businesses but also created his own. For example, the online classifieds platform OLX, which is used by [...]

Introduction to the Networking Component of Cloud Infrastructure

Cloud computing is increasingly infiltrating our lives, and there is probably no one who hasn't used some cloud services at least once. However, what exactly is the cloud and how does it work? Very few know even at an introductory level. 5G is becoming a reality, and telecom infrastructure is starting to transition [...]

So, so, so, and no ticking. How do Intel Core processors of different generations differ based on the same architecture?

With the emergence of Intel's seventh-generation Core processors, it became clear to many that the 'Tick-Tock' strategy that Intel had been following was flawed. The promise to reduce the technological process from 14 to 10 nm remained just a promise, leading to a long 'Tock' era of Skylake, during which Kaby Lake (the seventh generation) occurred, along with the sudden Coffee Lake (the eighth) with minimal changes to the process technology [...]

Implementation of a role-based access model using Row Level Security in PostgreSQL

The development of the topic Study on implementing Row Level Security in PostgreSQL and an expanded response to the comment. The strategy used involves the concept of 'Business Logic in the Database', which was described in more detail here — Study on implementing business logic at the level of stored functions in PostgreSQL. The theoretical part is well described in the Postgres Pro documentation — Row Protection Policies. Below is a practical [...]

A Study on Implementing Row Level Security in PostgreSQL

As an addition to the study on implementing business logic at the level of PostgreSQL stored functions, and primarily as a detailed response to the comment. The theoretical part is well described in the Postgres Pro documentation — Row-Level Security Policies. Below is a practical implementation of a small specific business task — hiding deleted data. The study dedicated to the implementation of the Role-Based Model using RLS is presented […]

A Study on Implementing Business Logic at the Level of Stored Functions in PostgreSQL

The motivating factor for writing this study was the article "During quarantine, the load increased 5 times, but we were ready." How Lingualeo transitioned to PostgreSQL with 23 million users. An article published 4 years ago — Implementing business logic in MySQL — also seemed interesting. It was intriguing that the same idea — 'to implement business logic in the database' — came up in […]

ELK SIEM Open Distro: Visualizing ELK and SIEM dashboards in ELK

This post will describe the setup of information panel visualization for ELK and SIEM in ELK. The article is divided into the following sections: 1- Overview of ELK SIEM 2- Default dashboards 3- Creating your first dashboards. Table of contents for all posts. Introduction. Deployment of infrastructure and technologies for SOC as a Service (SOCasS) ELK stack — installation and configuration. A walk through open Distro […]

Post Mortem on Quay.io Downtime

Note: In early August, Red Hat publicly addressed the availability issues that users of its Quay.io service experienced in the preceding months (the service is based on a container image registry that came to the company with the acquisition of CoreOS). Regardless of your interest in this service per se, the journey taken by the company's SRE engineers is informative […]

Making the Linux terminal beautiful and convenient

All Linux distributions come with a functional and customizable terminal emulator. There are plenty of ready-made themes on the internet, and sometimes even within the terminal itself, to make it look appealing. However, to transform the standard terminal (in any DE, of any distribution) into something beautiful yet convenient and easy to use, I spent a lot of time. So, how can we make the default […]

Buy reliable website hosting with DDoS protection, VPS VDS servers 🔥 Buy reliable website hosting with DDoS protection, VPS VDS servers | ProHoster