Efficient Flow Control in Apache NiFi with Wait-Notify Processors to Prevent Duplicate WorkIn this article, we will explore how to implement a sequence of actions in Apache NiFi using the Wait and Notify processors, focusing on…Nov 21, 20241Nov 21, 20241
Automating PostgreSQL Schema Version Management Using Python with pg_dumpThis article demonstrates how to automate the process of exporting, modifying, and importing PostgreSQL schema versions using Python. The…Nov 21, 2024Nov 21, 2024
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 8, 202410Nov 8, 202410
A PostgreSQL C Extension for Generating Random Integers Between Specified ValuesThe rand_ext extension consists of several key files:Sep 21, 2024Sep 21, 2024
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, 20233Oct 19, 20233
Performance Analysis of Updating Postgres JSONB and ColumnsThis article focuses on saving and updating data with different types of columns, among them JSONBAug 30, 20231Aug 30, 20231
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, 20225Oct 28, 20225
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
Export worksheets as CSV files using Pythonimport os import pandas as pd from datetime import dateJul 15, 2021Jul 15, 2021
Copy excel sheets and save as another file with VBAin this VBA Module I used simple functions for save as sheets in another excel template filesJul 1, 2021Jul 1, 2021
Random simulation a 1M times; Load data into Excel template, using PythonIn this case, every next row record equals random number between of the last two rows values.Jun 18, 2021Jun 18, 2021
Get data to excel from SQL procedure with parameters — Power QueryExtract data dynamically, with WHERE clause, or with using any parameter to retrieve data using the stored procedure.Feb 13, 2021Feb 13, 2021
Determine the formatting (Bold) of cell from Excel file (Pandas, openpyxl)then add this column to the dataframeJul 18, 2020Jul 18, 2020