Irakli DDTracing Excel Formula Precedents with PythonIn this article, we’ll walk through a Python-based approach to trace Excel formula precedents by extracting formulas, identifying the…Nov 8Nov 8
Irakli DDA PostgreSQL C Extension for Generating Random Integers Between Specified ValuesThe rand_ext extension consists of several key files:Sep 21Sep 21
Irakli DDLoad data from PostgreSQL to Redis using Python (4 methods)They include a basic loop, a loop with a pipeline function, Python multiprocessing, and using both pipeline and multiprocessing together.Oct 19, 2023Oct 19, 2023
Irakli DDPerformance Analysis of Updating Postgres JSONB and ColumnsThis article focuses on saving and updating data with different types of columns, among them JSONBAug 30, 2023Aug 30, 2023
Irakli DDRFM Analysis for Customer Segmentation | in Python using by Azure DatabricksThe idea of RFM analysis is to segment customers based on when their last purchase was, how often they’ve purchased in the past, and how…Oct 28, 2022Oct 28, 2022
Irakli DDFunction FOMONTH (SQL SERVER)FOMONTH or SOMONTH this is opposite to function EOMONTH (SQL SERVERFeb 28, 2022Feb 28, 2022
Irakli DDselect table without NULL rowsSelect any number of columns tables dynamically — except NULL rows (SQL SERVER)Feb 28, 2022Feb 28, 2022
Irakli DDGenerate Dates without loop (MSSQL, Oracle) by Hierarchical QueriesGenerate numbers, days, weekdays, months, quarters.. (MSSQL like an Oracle Connect by Level option)Jan 5, 2022Jan 5, 2022
Irakli DDGet list of numbers from string (Oracle PL/SQL) — with Pipelined table functionremove symbol & convert comma separated values to rowsSep 7, 2021Sep 7, 2021
