Tracing 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
A PostgreSQL C Extension for Generating Random Integers Between Specified ValuesThe rand_ext extension consists of several key files:Sep 21Sep 21
Load 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
Performance 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
RFM 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
Function FOMONTH (SQL SERVER)FOMONTH or SOMONTH this is opposite to function EOMONTH (SQL SERVERFeb 28, 2022Feb 28, 2022
select table without NULL rowsSelect any number of columns tables dynamically — except NULL rows (SQL SERVER)Feb 28, 2022Feb 28, 2022
Generate 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
Get list of numbers from string (Oracle PL/SQL) — with Pipelined table functionremove symbol & convert comma separated values to rowsSep 7, 2021Sep 7, 2021