What Are Databases & APIs? How They Work & How to Build Your Own

What Is A Database?

Basically, any database is considered an organized collection of structured data or information that is stored electronically in a computer system. Database Management Systems (DBMS) control the database. The data, the DBMS, and the applications associated with them are referred to as a database system, which is commonly abbreviated as just a "database."

To make processing and data querying efficient, data in the most popular types of databases used today are generally represented in rows and columns within a sequence of tables. This allows data to be accessed, managed, updated, regulated, and organized with ease. To create and query this data, most databases utilize Structured Query Language (SQL).

How Does A Database Actually Work?

Imagine you are building a contact book application. Your app has a search bar where you can type a friend's name. When you hit "Search," the app sends that request to an API (Application Programming Interface).

The API then translates that request into a specific database query (using SQL). The database searches through its massive tables, filters out all the irrelevant rows, finds the exact contact you asked for, and sends that specific data back through the API so your app can display it on the screen.

Why You Should Have Your Own Personal Database

We are not talking about Google Drive or Excel spreadsheets here; we are talking about your own personal, hyper-customized database that you have full control over. Building your own database is a highly valuable skill to have, and once you have one, there are countless things you can do with it.

Creating a database from scratch is a fantastic project to add to your portfolio. It adds credibility to your resume and helps you stand out when applying for tech jobs. If you can build a database and an app to query it, you are essentially doing full-stack development. Even if you aren't an expert yet, you will have enough knowledge to put together your own Minimum Viable Products (MVPs) for future startups.

The Benefits Of Having Your Own Database

You can think of a personal database almost like Google Drive on steroids. Because you have full control, you can create complex, relational links between different pieces of data.

One use case could be storing information about your professional network. You can store a contact's email address and connect it to their name, company, age, and birthday. You might also want to add a custom tagging system to find people quickly.

Imagine that every time you meet someone new, you make a new entry in your database. In the future, if you need a person with a specific skill—like a Graphic Designer—you can simply search your database for that tag. This prevents those awkward moments where you have to ask, "What did you do for work again?"

Custom Reminders & Systems

By creating your own database, you can review your notes before meeting up with a client to refresh your memory on their interests. You could also program a system for setting your own automated reminders, like sending an email to a specific person three weeks later, or triggering automated happy birthday messages.

While some of these things can be accomplished with standard spreadsheet software, the idea is not for it to be easy. The goal is to tackle a passion project where you get to build a hyper-useful, super-customized system tailored perfectly to your specific needs.

How A Personal Database Stands Out

You can think of software like Google Drive or Notion like buying a suit right off the rack at a shop. It is made so that it fits most people pretty well, but it won't fit any specific person perfectly. A personal database, on the other hand, is like a tailored suit—custom-built from scratch to fit your exact dimensions and needs perfectly.

Steps To Build Your Own Database

This is a big project, but you shouldn't be intimidated by it. Even attempting it and failing will teach you incredibly valuable programming skills. Here is how you can get started:

1. Define Your Constraints: Start small. What do you actually want to store? If you've never built a database before, starting with just a table of "Names" and "Email Addresses" is perfect. You can always scale up later.
2. Choose Your Language: Research the most commonly used language for databases: SQL (Structured Query Language). Commit to spending an hour or two learning the basic commands.
3. Create Tables: Figure out how to spin up a basic database environment (like SQLite or PostgreSQL), set up your first table, and add new data entries into it.
4. Use Python Libraries: Once you understand basic SQL, look into Python libraries (like `sqlite3` or `SQLAlchemy`) for creating and managing databases automatically via code.
5. Build an Interface: Create a simple Python script that gives you a command-line interface to easily search or add to your data without writing raw SQL every time.

What Is An API?

If you want to take your database project a step further, we highly recommend learning how to create an Application Programming Interface (API). An API is basically the middleman between a front-end app and a back-end database.

It acts as a translator: your app sends a request to the API, and the API translates that request into SQL commands that your database understands. If you think of platforms like Facebook, Instagram, or WhatsApp, they are essentially just massive databases under the hood. Their mobile apps simply exist to fetch data from the database (via an API) and display it to the user in a visually pleasing way.

You could use a framework like Flutter or React to build a mobile app that talks to your new custom API and database. Successfully developing your own full-stack application is a fantastic portfolio piece that proves to employers you are an ambitious developer capable of taking on complex systems.