News
An Implementation Guide to Building a Duck DB-Python Analytics Pipeline with SQL, Data Frames, Parquet, UDFs, and Performance Profiling
3+ hour, 49+ min ago (1095+ words) In this tutorial, we build a comprehensive, hands-on understanding of Duck DB-Python by working through its features directly in code on Colab. We start with the fundamentals of connection management and data generation, then move into real analytical workflows, including…...
SQLAlchemy 1. 4 -> 2. 0 migration tool for repetitive legacy patterns
2+ hour, 58+ min ago (196+ words) I built a scanner-first SQLAlchemy 1. 4 -> 2. 0 migration tool for a narrow documented subset of legacy patterns. It is intentionally not a full "AI migration" promise. It handles supported patterns like: select([. .]) session. query(Model). get(pk) simple string relationship joins simple…...
Introduction to SQL: DDL, DML, and Querying Data
22+ hour, 37+ min ago (416+ words) As a beginner database administrator, my first assignment was to build a school database for Nairobi Academy from scratch. At first this seemed impossible, especially since I had repeated cases of errors in my queries the whole week. But I…...
Entity mapping in depth: attributes, types, and nullable fields
18+ hour, 49+ min ago (401+ words) In the previous article we created a simple entity and performed CRUD operations. Now let's look at how entity mapping actually works under the hood, and how to handle more realistic scenarios like nullable fields and optimistic locking. Every Trysil…...
How to safely rename files in Bash
20+ hour, 21+ min ago (598+ words) Most file mistakes in Bash are not cp or mv problems. They are navigation problems. You think you are in one directory, but you are in another. You assume a file name is unique, but there are two copies. You…...
Understanding SQL Basics: DDL, DML, Filtering, and Data Transformation
1+ day, 1+ hour ago (671+ words) This week I was focused on building a solid foundation in SQL by working with student, subject, and exam result data. Along the way, I explored key concepts like DDL, DML, filtering using WHERE, and transforming data using CASE WHEN....
How Hard Is It to Add an Index to an Open Format? Lessons from the Apache Iceberg Community
1+ day, 5+ hour ago (1653+ words) The Apache Iceberg community is discussing "secondary indexes." This topic is far more complex than it appears on the surface. Adding an index is not a simple engineering problem of "how to store an index file." It requires deep thinking…...
Blind SQL Injection: From Conditional Responses to Out-of-Band Exfiltration
1+ day, 15+ hour ago (1690+ words) A practical walkthrough of SQL injection techniques, from basic data extraction to advanced blind exploitation. I'm currently doing an offensive security internship, working through Port Swigger's Web Security Academy to sharpen my web application testing skills. SQL injection was the…...
These 8 useful Bash patterns are hiding in real projects'here's how to use them
2+ day, 56+ min ago (17+ words) How-To Geek...
FRND Product Analyst Interview Question
1+ day, 20+ hour ago (211+ words) This SQL Question was asked in my product analyst interview. Problem Statement: An E-commerce site is there. we need to find out for each user's first " FRND Product Analyst Interview Question This SQL Question was asked in my product analyst…...