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 in use today are generally represented in rows and columns in a sequence of tables. Data may then be accessed, managed, updated, regulated, and organized with ease. For creating and querying data, most databases utilize structured query language (SQL).
How Does A Database Work?
Potentially, you can just make an app with a search bar where you can type an email address, and then the app will send that request to your API. The API will then translate that request into a database query that will fetch you whatever information you're looking for.
Why You Should Have Your Own Personal Database
We are not talking about Google Drive here; we are talking about your own personal, hyper-customized database that you have full control over. Building your own database is a really great skill to have, and once you have one, there are countless things you can do with it.
Creating a database on its own can be a really good thing to add to your portfolio. It will add credibility to your resume and help you stand out when applying for jobs. If you're able to build a database and an app to query it, you'll basically be doing full-stack development. Even if you aren't an expert yet, you'll have enough knowledge to put together your own MVPs (Minimum Viable Products).
It can serve as the foundation for your own startups, which is an incredibly empowering thing to be able to do. You get all these benefits from the simple act of trying to build it!
You May Also Like:
• What Is RAM? Different Types Of RAM.
• Coding vs Programming vs Development: Key Differences
• What Is A QR Code? How Does It Work?
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 relationships between different pieces of data.
One use case could be to store information about people you email. You can store their email address and connect that to their name, home address, age, and birthday. You might also want to add notes so you can easily remember what they do, or create a tagging system to find people quickly.
Imagine that every time you make a new friend or someone emails you, you make a new entry into your database. In the future, if you're looking for a person with a specific skill, 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 someone to refresh your memory on their interests. You could also create a system for setting your own reminders. Maybe you want to send an email to a certain person three weeks later, or set automated happy birthday messages. These are just some of the things you can do within your database.
While many of these things can definitely be accomplished with Google Drive, the idea is not for it to be super easy. The idea is that it should be a passion project where you get excited about creating a hyper-useful, super-customized system tailored perfectly to your specific needs.
How A Personal Database Stands Out
You can think of Google Drive 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 is like a tailored suit—custom-built to fit just one individual absolutely perfectly.
Steps To Build Your Own Database
This is a bigger project, but you shouldn't be scared of it. Even attempting it and failing will teach you incredibly valuable programming skills. Here is how you can get started:
- Define Your Constraints: Start small. What do you actually want to store? If you've never built a database before, starting with just names and email addresses is perfect. You can always add more later.
- Choose Your Language: Research the most commonly used language for databases, which is SQL. Commit to spending an hour or two learning the basics of how it works.
- Create Tables: Figure out how to create a basic database, set up tables, and add new data entries into those tables.
- Use Python Libraries: Once you understand basic SQL, look into Python libraries for creating and managing SQL databases to make things run a bit smoother.
- Build an Interface: Consider creating a simple Python script that gives you a command-line or text interface to interact with your data.
What Is An API?
If you want to take this a step further, we recommend learning how to create an Application Programming Interface (API). An API is basically the interface between an app and a database. It acts as a translator: we send our code to the API, and the API translates that code into SQL commands that our database understands.
If you think of platforms like Facebook, Instagram, TikTok, or WhatsApp, they are essentially just massive databases under the hood. Their mobile and web applications simply exist to take whatever is in the database and display it to the user in a friendly way.
You could use a framework like Flutter to build a mobile app that talks to your new API and database. Successfully developing your own full-stack application is a fantastic portfolio piece that proves to employers you are passionate, ambitious, and capable of taking on complex tasks in your free time.
Resource Cheat Sheet:
Learn how to create a REST API with Flask here: Real Python: Flask Connexion REST API
ليست هناك تعليقات:
إرسال تعليق