databases

Developing the Greenwood Academy Database: A Comprehensive Guide In this article we will talk about the creation of a database that is made for Greenwood Academy. We will cover parts of Structured Query Language including database design, data manipulation, querying and techniques to make things work better. This project is meant to manage student records, courses that are available and exam resu…

One PostgreSQL feature I recently revisited is earthdistance, a nice reminder that not every problem involving latitude and longitude requires a full GIS stack. The earthdistance extension provides a straightforward way to calculate great-circle distances between locations on Earth. Combined with PostgreSQL’s cube extension, ll_to_earth() converts latitude and longitude into a representation that…

So how do we handle such bugs? This is what we are going to try to answer in this article.

I’ve completed V1 of my Personal Expense Tracker , a small learning project built with Python and SQLite . This project was created primarily to learn by building rather than following a tutorial step by step. The goal of V1 was not to build a production-ready expense tracker. The goal was: Build the core application flow, understand the responsibilities of each layer, and make the fundamental fu…

Oracle Database: A Deep Dive into the Enterprise RDBMS Oracle Database remains one of the most widely deployed relational database management systems (RDBMS) in enterprise environments. Known for its reliability, scalability, and rich feature set, it powers mission-critical workloads across finance, telecommunications, healthcare, and government sectors. This post explores Oracle Database's archi…