HSHarsh Singhinharshcodes.dev路Jan 10 路 5 min readWeb Scraping at Scale With Scrapy and MongoDBA Complete End-to-End ETL Project Introduction Web scraping is often the first step in building real-world data pipelines. While simple scripts using requests and BeautifulSoup work for small tasks, they quickly break down when projects grow in size,...00
HSHarsh Singhinharshcodes.dev路Sep 20, 2025 路 6 min readGPG Key Management: Installation, Generation, and TrustThis document outlines the process of installing GPG, generating a new key pair, and managing key trust, primarily using the command line on Debian/Ubuntu systems. 1. GPG Installation To begin, you need to install the GPG (GNU Privacy Guard) software...00
HSHarsh Singhinharshcodes.dev路Jun 20, 2025 路 4 min readUnderstanding Constants in PL/SQL馃 Introduction In any programming language, there are scenarios where you want certain values to remain unchanged throughout the execution of a program. In PL/SQL (Oracle's Procedural Language extension to SQL), such immutable values are defined usi...00
HSHarsh Singhinharshcodes.dev路Jun 19, 2025 路 4 min read`SELECT INTO` Statement in PL/SQLWhen working with PL/SQL, one of the most common requirements is to fetch data from a database table and store it into variables. This is especially useful when you want to process or display the fetched data within your PL/SQL block. To accomplish t...00
HSHarsh Singhinharshcodes.dev路Jun 18, 2025 路 4 min readVariables Declaration and Initialization in PL/SQLVariables are essential components of any programming language, and PL/SQL is no exception. They serve as containers in the computer's memory that temporarily hold data. In this comprehensive guide, we will dive deep into how to declare, initialize, ...00
