Tag: Database
37 items found
Projects
MSSQL XML Agent: ERP Automation Agent
Portable Windows automation agent that exports XML from MSSQL databases for ERP flows, with scheduling and a web management UI.
Services
Data Migration
Migrate databases, content and files with a tested data migration plan designed to preserve integrity and prevent data loss.
Glossary Terms
ACID (Atomicity, Consistency, Isolation, Durability)
ACID describes Atomicity, Consistency, Isolation, and Durability, the transaction guarantees that keep database writes reliable.
Connection Pool
A connection pool keeps database or service connections open for reuse, lowering latency and connection overhead under traffic.
Database Index
A database index stores selected columns in a separate data structure so queries can avoid scanning a table from start to finish.
Database Indexing
Database indexing creates auxiliary data structures on selected columns so queries find rows faster without scanning every record.
Database Migration
Database migration changes schema or data structures in versioned steps so the database stays aligned with application code.
Database Migration
Database migration applies table, column, index, and data transformation changes through versioned files in a controlled way.
Database Normalization
Database normalization organizes relational tables around dependencies to reduce duplication and protect consistency as data changes.
Database Replication
Database replication copies data across multiple servers to improve availability, redundancy, and read capacity without moving the primary workload.
Database Transaction
A database transaction groups reads and writes into one unit of work that either commits completely or rolls back safely.
Drizzle ORM
Drizzle ORM is a lightweight TypeScript ORM for managing database schemas and SQL queries with compile-time type safety.
Elasticsearch
Elasticsearch is a distributed search engine for fast full-text search, filtering, and analytics over large text and log datasets.
ERD (Entity-Relationship Diagram)
An ERD visualizes database entities, attributes, and relationships so teams can understand and review data model decisions.
Firebase
Firebase provides ready-made backend services for mobile and web apps, including authentication, databases, hosting, messaging, and analytics.
Foreign Key
A foreign key links a value in one table to a key in another table, preserving referential integrity in relational databases.
Graph Database
A graph database models entities as nodes and edges, making relationship-heavy queries fast and natural in NoSQL systems.
IndexedDB
IndexedDB is a browser database for storing large structured data persistently with indexes and asynchronous access.
Knowledge Graph
A knowledge graph models entities such as people, products, documents, and processes with relationships that systems can query.
MongoDB
MongoDB is a document-oriented NoSQL database using BSON documents, flexible schemas, indexes, replication, and horizontal scaling.
MySQL
MySQL is a relational database that stores SQL data in tables, indexes, and transactions, widely used behind web applications and services.
NoSQL
NoSQL databases store data as documents, key-value pairs, wide columns, or graphs, prioritizing flexible schemas and horizontal scale.
ORM (Object-Relational Mapping)
ORM maps database tables as objects, allowing database operations without writing raw SQL through library abstractions.
ORM Migration
ORM migration is the practice of managing database schema changes through code files using ORM tools like Prisma or Drizzle.
PostgreSQL
PostgreSQL is an open-source ACID-compliant relational database that combines SQL, JSON support, indexing, and extensibility.
Primary Key
A primary key is a non-null, non-repeating column or column set that uniquely identifies each row in a database table.
Prisma ORM
Prisma is a modern ORM for TypeScript and Node.js that manages database schemas, migrations, and type-safe queries in one workflow.
Query Optimization
Query optimization improves database queries by reducing reads, choosing useful indexes, and shaping efficient execution plans.
Redis
Redis is an in-memory key-value NoSQL system used for low-latency caching, queues, counters, and session data.
Sharding
Sharding splits a large dataset into independent pieces called shards, distributing read and write load across multiple servers.
SQL (Structured Query Language)
SQL is the standard language for querying, changing, and reporting on structured data stored in relational database tables.
Stored Procedure
A stored procedure is a named SQL block saved in the database and called with parameters to run repeatable data operations.
Supabase
Supabase is a PostgreSQL-based backend platform with auth, file storage, and real-time APIs for faster app development.
Time-Series Database
A time-series database optimizes storage, compression, and time-based queries for timestamped metrics, logs, and sensor data.
Vector Index (pgvector)
A vector index speeds up similarity search by organizing embeddings so nearest neighbors can be found efficiently at scale.