What is a graph database?

Much has been written about graph databases as a distinct type of database in the last few years and it is easy to forgive in believing the accompanying marketing material warranting differentiation of graph databases from any other database.

Creating a Database: Converting a Spreadsheet to a Relational Database (Part 1)

This is the first article in a three part series. The goal of this series is to show how to create a relational database for SQL. The whole process is to convert a data in one spreadsheet in Excel to a relational database for SQL.

SQL Querying 101

What is SQL and why is it useful? If you want to build full stack applications, it’s important to create apps that use data from databases. Databases store simple variables and data structures in memory.

Designing Relational Database in Example

In this story I want to share with you a basic relational database which helped me to understand ideas of organizing data for relational…

A Beginner’s Reference to SQL vs. NoSQL

In this tutorial, we will be looking at the difference between SQL and NoSQL based on certain parameters. Before we begin, let’s analyze each individually to develop our understanding of these contrasting concepts. A Beginner’s Reference to SQL vs. NoSQL

ERR Diagram, SQL Processing and Data Studio Dashboard

This project aims to walk you through how to leverage SQL in relationship mapping and data processing with multiple datasets, and to create an automated reporting dashboard.

To Relational or Not to Relational?

Working on your next project but not sure which back-end technology to use? For starters, databases come in two flavors: relational and non-relational.

5 Reasons to Use SQLite the Tiny GIANT for Your Next Project

SQLite database is a tiny giant in the SQL area with a fully-featured SQL database engine and billions of deployments. All the reads and writes operations are taking place directly on a single file.

What’s behind a simple SQL query?

A brief behind the scenes examination of what happens when an app/developer runs a SQL query to fetch data from a PostgresDB database.

Examining the Postgres catalog with Python

I recently needed to write a program to automatically extract insights from database catalogs and this led me to write a simple Python module to connect to a Postgres database, get information from the catalog, and load that information into a Pandas dataframe for further processing in Python. This article describes the process I followed.

SQL for Web Developers (Part II)

Before we continue to create our first database, let‘s examine a common and important principle that all web developers should be familiar…CRUD stands for Create, Read, Update, and Delete which are the four basic functions of persistent storage.

SQL for Web Developers (Part I)

SQL(Structured Query Language) is a special-purpose language developed to work with relational databases. More specifically it’s used to manage and manipulate data in those databases.