#Databases
38 articles tagged with #Databases
Project: Build a Full-Stack To-Do App with React, Node.js and MongoDB
A full-stack to-do app is the perfect first MERN project — it covers every concept you'll use in production: REST APIs, database CRUD operations, JWT authentication, and deploying a frontend and backend separately. Build it once, understand the full stack.
Project: Build a REST API with Python and FastAPI
FastAPI is the fastest-growing Python web framework — and for good reason. In this hands-on project you'll build a fully functional REST API with auto-generated documentation, database persistence, and deployment on Render, all in a single afternoon.
Vector Databases Explained: The Memory Layer Powering AI Apps
Vector databases are the storage layer behind RAG systems, semantic search, and AI- powered recommendations. This guide explains what they are, how they differ from traditional databases, and how to choose and use one in a real application.
Async Python: asyncio Explained for Beginners
Async Python lets a single thread handle hundreds of concurrent I/O operations — making it essential for web APIs, database calls, and AI integrations. This guide explains coroutines, the event loop, await, gather, and real patterns you'll use in FastAPI, httpx, and LLM streaming.
AWS for Beginners: Cloud Computing Fundamentals
Amazon Web Services is the world's most widely used cloud platform. This guide covers the core services every developer needs — EC2 (virtual servers), S3 (storage), IAM (access control), VPC (networking), and RDS (databases) — with practical setup instructions and free tier guidance.
Vector Databases Explained: How AI Remembers
A vector database stores data as numerical embeddings and finds items by meaning, letting AI apps search, recommend, and recall information by similarity.
Function Calling and Tool Use in LLMs
Function calling lets a language model request real actions like API calls or database lookups, turning a text generator into a system that gets things done.
SQL Basics: A Complete Beginner's Guide
SQL is the language for asking questions of relational databases. Learn to select, filter, join, and aggregate data with clear, practical explanations.
AWS for Beginners: Core Services Explained
AWS offers on-demand computing, storage, and databases you rent by the hour. Learn the core services beginners actually use and how they fit together.
SQL Injection Explained and How to Prevent It
Understand SQL injection: how attackers exploit database queries, why it happens, and the parameterized-query defense that reliably prevents it every time.
Vector Databases Explained for Beginners
A vector database stores data as numeric embeddings so you can search by meaning, not keywords. Learn how they work and why modern AI apps rely on them.
Build a REST API With FastAPI: A Complete Project
Build a REST API with FastAPI using path operations, Pydantic models, and a database. This complete project covers CRUD, validation, and automatic docs.
What Is Data Modeling in Databases
Data modeling is the process of designing how data is structured and related in a database. Learn conceptual, logical, and physical models plus normalization.
What Is Caching and How Redis Works
Caching stores frequently used data in fast memory to cut latency and database load. Learn how caching works and why Redis is the go-to in-memory store.
What Is SQL Injection and How to Prevent It
SQL injection lets attackers manipulate your database by smuggling code into inputs. Learn how it works and how parameterized queries stop it cold.
Build an Expense Tracker With Python
Build an expense tracker in Python that records spending, stores it in a CSV or SQLite database, and reports totals by category. A practical project for learning file I/O and data.
Vector Databases: A Practical Beginner Walkthrough
A practical beginner walkthrough of vector databases: how embeddings and similarity search work, and why retrieval-augmented generation depends on them.
How to Connect Python to a SQL Database
Learn how to connect Python to a SQL database, run queries safely, load results into pandas, and automate reports — a core skill for every data analyst.
How Does Cryptocurrency Work? A Plain-English Guide
Cryptocurrency works by recording every transaction on a shared, tamper-resistant ledger called a blockchain instead of a bank's private database. This guide breaks down blockchains, wallets, mining, and how coins actually move between people.
What Is a Database? A Plain-English Guide
A database is an organized collection of data stored so it can be easily accessed, managed, and updated by software. This guide explains the core types, how databases work, and why nearly every application depends on one.
Best Data Analysis Tools and How to Choose One
The right data analysis tool depends on your data size, technical skill, and whether you need visualization, statistics, or database querying. This guide covers spreadsheet, SQL, BI, and programming-based tools and when each one makes sense.
What Does a Database Analyst Do? Role, Skills, and Path
A database analyst designs, maintains, and optimizes the databases that store an organization's data, ensuring it stays accurate, secure, and fast to query. This guide covers the role's daily work, required skills, and how to break into it.
What Is a Unique Identifier and Why It Matters
A unique identifier is a value guaranteed to distinguish one record from every other in a system, forming the backbone of databases and APIs. This guide explains common types and how to choose the right one.
SQL Commands Every Data Analyst Should Know
SQL commands let you create, query, update, and manage data inside a relational database. This guide covers the core command categories, the most commonly used statements, and how they fit together in real queries.
What Does SQL Stand For? A Beginner's Guide
SQL stands for Structured Query Language, the standard language used to store, retrieve, and manage data in relational databases. This guide covers what SQL means, how it works, and why it remains essential for data roles today.
What Is the MERN Stack? A Practical Overview
The MERN stack is a set of four JavaScript technologies — MongoDB, Express, React, and Node.js — used together to build full web applications with a single language across front and back end. Here's how each piece fits.
What Is Django? Python's Web Framework Explained
Django is a free, open-source Python web framework that lets developers build secure, database-driven websites quickly by handling routing, database access, and admin tooling out of the box. This guide covers what it does and why it's popular.
What Does a SQL Developer Do? Skills, Tools, and Path
A SQL developer designs, writes, and optimizes database queries and structures that power applications and reports. This guide covers what the role actually involves day to day, the core skills required, and how to break into the field.
What Does a Back End Developer Actually Do?
A back end developer builds the server, database, and application logic that power what users see on the front end. This guide explains core back end responsibilities, common languages, and the skills needed to start in the role.
What Is Metadata? Data About Your Data, Explained
Metadata is structured information that describes other data, such as a file's creation date, a photo's location, or a database column's data type. This guide explains what metadata is, its main types, and why it matters for data work.
PostgreSQL Essentials: Schema, Indexes, Transactions, Tuning
PostgreSQL stores rows in pages, finds them via indexes the planner chooses by cost, and isolates concurrent work with multi-version concurrency control. Learn the working model behind schema design, index selection, transaction isolation, locking and EXPLAIN ANALYZE so you can diagnose slow queries rather than guess at them.
Scalability Fundamentals: How Systems Handle Growth
Load never spreads evenly — it concentrates on whatever is shared and single-threaded, usually the database's write path, a connection pool or a lock. This guide shows where load concentrates at each growth stage, which architectural move relieves each concentration, and what each move costs you in consistency and operability.
7 Signs You Don't Need a Dedicated Vector Database
You probably do not need a dedicated vector database when your corpus fits comfortably in memory, query volume is low, filtering dominates ranking, or your existing database already offers vector search. This names seven concrete conditions, the failure modes of choosing wrongly, and the signals that should make you reconsider later.
How to Add Vector Search to Postgres With pgvector
pgvector adds a vector column type and similarity operators to Postgres, so embedding search and ordinary SQL filtering run in one query against one database. This covers installing the extension, choosing between HNSW and IVFFlat, writing filtered similarity queries, and the pitfalls that make results look wrong.
Pinecone, Weaviate, Qdrant and pgvector: How to Choose
Choose on operational fit, not benchmark tables: pgvector when your data already lives in Postgres, Qdrant when you want a dedicated engine you can self-host, Weaviate when you want built-in hybrid search and modules, Pinecone when you want no operational burden at all.
How to implement graceful shutdown in a Node.js service
Dropped requests during deploys are almost always ordering bugs. Learn the correct SIGTERM sequence: fail readiness so the load balancer drains you, stop accepting connections, finish in-flight work under a deadline, and only then close databases, queues and timers.
Using database read replicas and connection pooling
Scale reads safely: routing queries to replicas, handling replication lag and read-your-writes, sizing connection pools and spotting pool exhaustion.
Docker volumes and bind mounts: handling persistent data
Keep data across container restarts: volumes versus bind mounts, permission and ownership pitfalls, backing up volumes and handling databases in containers.