GunKurnia·Jul 27Your SQL JOIN Is Taking Forever? The Missing Index Might Be the Real CulpritHow a simple missing index can turn a query that should finish in seconds into one that runs for hours.
GunKurnia·Jun 10The Beginner’s Guide to Learning Agentic AI: From Zero to Your First AI AgentHow to go from “AI is just a chatbot” to building systems that actually do things
GunKurnia·Jun 7Python Can Style Your Fonts Too — And It’s Easier Than You ThinkFrom terminal text to stunning PDFs, Python has a library for every font need you didn’t know you had.
GunKurnia·Dec 7, 2025Mastering the MOD Function in SQL: What It Is and How to Use It in Real-World ScenariosThe SQL MOD function is a powerful yet simple tool used to calculate the remainder of a division, making it essential for tasks such as…
GunKurnia·Aug 30, 2025Is Using OR with Multiple LIKE Conditions in SQL Practical? Exploring Easier AlternativesWhen working with SQL queries, filtering text data with the LIKE operator is a common task. For example, you may want to search for rows…
GunKurnia·Aug 17, 2025Can a Single SQL Field Containing Both String and Numeric Values Be Used for Joins?In database design and SQL operations, we usually expect fields (columns) to have a consistent data type — for example, VARCHAR for…
GunKurnia·Jun 11, 2025🎯 Unlocking the Power of SQL INTERSECT: When and Why to Use ItSQL INTERSECT is a powerful yet underutilized operator that helps you quickly find overlapping records between datasets—simple and elegant
GunKurnia·Apr 18, 2025Mastering Pagination in Web Scraping: Efficient Techniques for Multi-Page Data CollectionMastering pagination transforms your web scraper from a single-page tool into a scalable, multi-page data powerhouse — making large-scale…
GunKurnia·Apr 11, 2025Web Scraping Data from Paginated Websites: A Comprehensive GuideThis guide provides a comprehensive overview of web scraping data from paginated websites, covering automated page navigation, structured…
GunKurnia·Apr 11, 2025How to Extract Text, Tables, and Numbers from PDFs EfficientlyEfficient PDF extraction requires using the right tools and techniques to accurately retrieve text, tables, and numbers while preserving…