Skip to content
  • Home
  • About this Site
  • SQL
    • What is a Left-Join in SQL?
    • Entering the Inner Join
    • Grouping the Counts in SQL
  • Python
    • Printing and Declaring Variables in Python
    • Calling Basic API with Python
    • What is .env file?
    • SQLAlchemy
      • Introduction to SQLAlchemy
      • Creating a new table using SQL Alchemy
      • Uploading Data to a Table with SQL Alchemy
    • NumPy
      • NumPy Fundamentals
  • Project – HackerNews
    • Project Introduction
    • Project Visualization and Results
    • Under the Hood
      • Python File Structure and Management
        • HackerNews – Python Structure
        • HackerNews – Connect Everything with sharedVars.py
        • HackerNews – Initializing Tables with runOnce.py
      • Database Design
        • HackerNews – Database Design
      • Functions
        • HackerNews – customFunctionsGeneral Part 1: write_log
        • HackerNews – customFunctionsGeneral Part 2: Postgres Connection
        • HackerNews – customFunctionsGeneral Part 3: Retrieve functions
      • ETL Mechanic
  • Home
  • About this Site
  • SQL
    • What is a Left-Join in SQL?
    • Entering the Inner Join
    • Grouping the Counts in SQL
  • Python
    • Printing and Declaring Variables in Python
    • Calling Basic API with Python
    • What is .env file?
    • SQLAlchemy
      • Introduction to SQLAlchemy
      • Creating a new table using SQL Alchemy
      • Uploading Data to a Table with SQL Alchemy
    • NumPy
      • NumPy Fundamentals
  • Project – HackerNews
    • Project Introduction
    • Project Visualization and Results
    • Under the Hood
      • Python File Structure and Management
        • HackerNews – Python Structure
        • HackerNews – Connect Everything with sharedVars.py
        • HackerNews – Initializing Tables with runOnce.py
      • Database Design
        • HackerNews – Database Design
      • Functions
        • HackerNews – customFunctionsGeneral Part 1: write_log
        • HackerNews – customFunctionsGeneral Part 2: Postgres Connection
        • HackerNews – customFunctionsGeneral Part 3: Retrieve functions
      • ETL Mechanic
The Glit Experience A website where I can show my knowledge and understandings.
The Glit Experience A website where I can show my knowledge and understandings.
  • Home
  • About this Site
  • SQL
    • What is a Left-Join in SQL?
    • Entering the Inner Join
    • Grouping the Counts in SQL
  • Python
    • Printing and Declaring Variables in Python
    • Calling Basic API with Python
    • What is .env file?
    • SQLAlchemy
      • Introduction to SQLAlchemy
      • Creating a new table using SQL Alchemy
      • Uploading Data to a Table with SQL Alchemy
    • NumPy
      • NumPy Fundamentals
  • Project – HackerNews
    • Project Introduction
    • Project Visualization and Results
    • Under the Hood
      • Python File Structure and Management
        • HackerNews – Python Structure
        • HackerNews – Connect Everything with sharedVars.py
        • HackerNews – Initializing Tables with runOnce.py
      • Database Design
        • HackerNews – Database Design
      • Functions
        • HackerNews – customFunctionsGeneral Part 1: write_log
        • HackerNews – customFunctionsGeneral Part 2: Postgres Connection
        • HackerNews – customFunctionsGeneral Part 3: Retrieve functions
      • ETL Mechanic
news, daily newspaper, press-1172463.jpg
Project - HackerNewsPython File Structure and Management

HackerNews – Python Structure

Usually, there will be more than...
glithanMar 4, 2024Mar 4, 2024
PythonSQLAlchemy

Uploading Data to a Table with SQL Alchemy

Let’s say that there is a...
glithanMar 4, 2024Mar 4, 2024
Python

Creating a new table using SQL Alchemy

One of the most common assignments...
glithanMar 4, 2024Mar 4, 2024
news, daily newspaper, press-1172463.jpg
Project - HackerNews

HackerNews – customFunctionsGeneral Part 3: Retrieve functions

With access to the database, we...
glithanMar 4, 2024Mar 4, 2024
news, daily newspaper, press-1172463.jpg
FunctionsProject - HackerNewsUnder the Hood

HackerNews – customFunctionsGeneral Part 2: Postgres Connection

After creating the write_log function, we...
glithanMar 4, 2024Mar 4, 2024
news, daily newspaper, press-1172463.jpg
FunctionsProject - HackerNews

HackerNews – customFunctionsGeneral Part 1: write_log

When doing automated tasks, recording what...
glithanMar 4, 2024Mar 4, 2024
The Glit Experience
NumPy

NumPy Fundamentals

Numpy is an essential Python library...
glithanMar 4, 2024Mar 4, 2024
news, daily newspaper, press-1172463.jpg
Project Introduction

HackerNews – Project Introduction

This is a Python project that...
glithanJan 6, 2024Jan 6, 2024
news, daily newspaper, press-1172463.jpg
Python File Structure and Management

HackerNews – Connect Everything with sharedVars.py

When using a variable that we...
glithanDec 30, 2023Dec 30, 2023
news, daily newspaper, press-1172463.jpg
Project - HackerNewsPython File Structure and Management

HackerNews – Initializing Tables with runOnce.py

In a project, we usually want...
glithanDec 30, 2023Mar 4, 2024
12
  • Home
  • About this Site
  • SQL
  • Python
  • Project – HackerNews
Copyright © 2025 - Yuki Blogger Theme By WP Moose