Irakli DDOptimizing PostgreSQL LoggingBest practices for improved performance3 min read·Jan 29, 2024----
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.4 min read·Oct 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 JSONB3 min read·Aug 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…4 min read·Oct 28, 2022----
Irakli DDFunction FOMONTH (SQL SERVER)FOMONTH or SOMONTH this is opposite to function EOMONTH (SQL SERVER1 min read·Feb 28, 2022----
Irakli DDselect table without NULL rowsSelect any number of columns tables dynamically — except NULL rows (SQL SERVER)1 min read·Feb 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)2 min read·Jan 5, 2022----
Irakli DDGet list of numbers from string (Oracle PL/SQL) — with Pipelined table functionremove symbol & convert comma separated values to rows1 min read·Sep 7, 2021----
Irakli DDExport worksheets as CSV files using Pythonimport os import pandas as pd from datetime import date1 min read·Jul 15, 2021----
Irakli DDCopy excel sheets and save as another file with VBAin this VBA Module I used simple functions for save as sheets in another excel template files2 min read·Jul 1, 2021----