Tag: Database
PostgreSQL | Installing PostgreSQL
MySQL | Installing MySQL
SQL Basics | SQL
Graph Database Overview
TiDB Architecture - Understanding Product Components
TiDB Software and Hardware Recommendations
TiDB Overview
TiDB Storage
Graph Database Quick Start Guide
A practical introduction for first-time graph database users
Graph Database
Graph database
MongoDB Sharding Overview
MongoDB Replication Overview
How to Use the MongoDB mongod Command
MongoDB Features
Database Index
Basic Elasticsearch Concepts
SQLite | Installing SQLite | Downloading and Installing the SQLite Command-Line Tool
PostgreSQL | Installing PostgreSQL | Download and Install PostgreSQL
MySQL | Connecting to a Database from the Console
SQL Basics | SQL | Comments
Designing Data-Intensive Applications
Presentation materials created during a group study
SQL Basics
Installing TiUP
This is the installation method used for real production environments.
TiDB HTAP Quick Start Guide
TiDB Computing
Designing Data-Intensive Applications | Chapter 02. Data Models and Query Languages
How to Enable MongoDB Access Control (User Authentication)
Installing MongoDB with Docker
Database Transaction
Installing Elasticsearch, Kibana, and Cerebro
SQLite | Installing SQLite | Testing the SQLite Command-Line Tool
PostgreSQL | Installing PostgreSQL | PATH Settings
MySQL | Checking the Version
MySQL
SQL Basics | DDL: Data Definition Language
Local TiDB Installation - Building a Test Environment
Exploring SQL in TiDB
TiDB Scheduling
Designing Data-Intensive Applications | Chapter 03. Storage and Retrieval
Basic MongoDB Usage
Database Normalization
Elasticsearch CRUD Operations + Bulk API
SQLite | Installing SQLite | Downloading sqlite3.dll
PostgreSQL
PostgreSQL | Installing PostgreSQL | Start and Stop the Windows Service
MySQL | Create Tables and Add, Delete, or Modify Columns
SQL Basics | DDL: Data Definition Language | DATABASE
Installing TiDB with Docker - Building a Test Environment
This is how to install a TiDB test environment using Docker.
Exploring TiDB HTAP
Simulating Production TiDB Cluster Deployment on a Single Computer
TiDB Experimental Features
What Is Apache TinkerPop?
An overview of Apache TinkerPop
Designing Data-Intensive Applications | Chapter 04. Encoding and Evolution
How to Use the MongoDB mongo Command
Database Tuning
Elasticsearch Mapping Management + Templates
SQLite | Installing SQLite | Referencing the SQLite Documentation
SQLite
PostgreSQL | Installing PostgreSQL | Referencing PostgreSQL Documentation
MySQL | Table Creation Error Related to DEFAULT timestamp
SQL Basics | DDL: Data Definition Language | TABLE
Importing a TiDB Sample Database
Deploying a TiDB Cluster Using TiUP
This is the installation method used for real production environments.
Database Lock
Designing Data-Intensive Applications | Chapter 05. Replication
How to Apply Indexes in MongoDB
Elasticsearch Search API
SQLite | SQLite Basic Knowledge
PostgreSQL | Connecting to PostgreSQL with psql
MySQL | Strings
SQL Basics | DDL: Data Definition Language | VIEW
TiDB - MySQL Compatibility
Designing Data-Intensive Applications | Chapter 06. Partitioning
How to Apply Unique Constraints in MongoDB
Elasticsearch Analyzer (Sentence Analysis)
SQLite | SQLite Basic Knowledge | How to Enter SQL Statements and Commands in the Command-Line Tool
PostgreSQL | Connecting to PostgreSQL with psql | Connecting and Disconnecting from PostgreSQL
MySQL | Totals with WITH ROLLUP
SQL Basics | DDL: Data Definition Language | INDEX
TiDB Limitations
Designing Data-Intensive Applications | Chapter 07. Transactions
How to Extract and Delete Duplicate Data in MongoDB
Elasticsearch Aggregation (Aggregation and Classification)
SQLite | SQLite Basic Knowledge | Notes on Keywords Defined in SQLite
PostgreSQL | Connecting to PostgreSQL with psql | How to Use psql Options and Option List
MySQL | Change the Sort Order of NULL Values
SQL Basics | DDL: Data Definition Language | Primary Key
Designing Data-Intensive Applications | Chapter 08. The Trouble with Distributed Systems
How to Create an Auto-Increment Sequence in MongoDB
SQLite | SQLite Basic Knowledge | Writing Comments in SQL Statements
PostgreSQL | Connecting to PostgreSQL with psql | List of psql Meta-Commands and How to Execute Them
SQL Basics | DDL: Data Definition Language | Foreign Key
TiDB
TiDB is an open source distributed, scalable hybrid transactional and analytical processing database
Designing Data-Intensive Applications | Chapter 09. Consistency and Consensus
SQLite | Database
PostgreSQL | Connecting to PostgreSQL with psql | Executing SQL Commands in psql
SQL Basics | DCL: Data Control Language
About TiDB
Apache HBase Overview
Designing Data-Intensive Applications | Chapter 10. Batch Processing
SQLite | Database | Creating and Connecting to a Database
PostgreSQL | PostgreSQL Configuration Files
SQL Basics | DML: Data Manipulation Language
TiDB Installation
Apache HBase Architecture
Designing Data-Intensive Applications | Chapter 11. Stream Processing
SQLite | Database | Checking Connected Databases
PostgreSQL | PostgreSQL Configuration Files | How to Configure the postgresql.conf File
SQL Basics | DML: Data Manipulation Language | SELECT
Apache HBase Regions
Quick Start
SQLite | Database | Backing Up and Deleting a Database
PostgreSQL | PostgreSQL Configuration Files | How to Configure the pg_hba.conf File
SQL Basics | DML: Data Manipulation Language | DISTINCT
HBase Data Model
TiDB Operator - Automatic Failover
Preparing automatic failover
Cluster Architecture
SQLite | Database | Reclaiming Free Space (VACUUM)
PostgreSQL | PostgreSQL Configuration Files | How to Configure the pg_ident.conf File
SQL Basics | DML: Data Manipulation Language | WHERE
Installing HBase with Docker for Local Practice
Introduces Docker installation for local practice.
TiDB Automatic Failover
SQLite | Data Types
PostgreSQL | PostgreSQL Basic Syntax
SQL Basics | DML: Data Manipulation Language | AND, OR
SQLite | Data Type | Data Types Available in SQLite
PostgreSQL | PostgreSQL Basic Syntax | How to Enter String and Numeric Values
SQL Basics | DML: Data Manipulation Language | IN, NOT IN
SQLite | Data Types | Inspect the Data Type of Stored Values
PostgreSQL | PostgreSQL Basic Syntax | Identifiers and Keywords
SQL Basics | DML: Data Manipulation Language | BETWEEN
SQLite | Data Type | Escaping Strings
PostgreSQL | PostgreSQL Basic Syntax | Writing Comments
SQL Basics | DML: Data Manipulation Language | LIKE
SQLite | Table
PostgreSQL | PostgreSQL Basic Syntax | Using Logical Operators (AND, OR, NOT)
SQL Basics | DML: Data Manipulation Language | IS NULL, IS NOT NULL
SQLite | Tables | Creating a Table
PostgreSQL | PostgreSQL Basic Syntax | Using Comparison Operators (<, >, =, BETWEEN, IS NULL)
SQL Basics | DML: Data Manipulation Language | EXISTS
SQLite | Table | Inspecting a Table Schema
PostgreSQL | PostgreSQL Basic Syntax | Using Arithmetic Operators
SQL Basics | DML: Data Manipulation Language | ORDER BY
HBase General Shell Commands - status, version, whoami
SQLite | Tables | Rename a Table and Add or Remove Columns
PostgreSQL | Data Types
SQL Basics | DML: Data Manipulation Language | GROUP BY
HBase Table Management Commands - create, list, exists, disable/enable, describe, alter, drop
SQLite | Table | Dropping a Table
PostgreSQL | Data Types | Numeric Types (integer, decimal, double precision, etc.)
SQL Basics | DML: Data Manipulation Language | HAVING
HBase Data Manipulation Commands - put, get, delete, deleteall, scan, count, truncate
SQLite | Tables | PRIMARY KEY Constraint
PostgreSQL | Data Types | Auto-Incrementing Types (serial, etc.)
SQL Basics | DML: Data Manipulation Language | AS - Aliases
HBase Security Commands - grant, revoke, user_permission
SQLite | Tables | ROWID and INTEGER PRIMARY KEY
PostgreSQL | Data Types | String Types (varchar, char, text)
SQL Basics | DML: Data Manipulation Language | JOIN
SQLite | Tables | AUTOINCREMENT Allocation Rules
PostgreSQL | Data Types | Date and Time Types
SQL Basics | DML: Data Manipulation Language | Subquery
SQLite | Table | NOT NULL Constraint
PostgreSQL | Data Types | Boolean Data Type
SQL Basics | DML: Data Manipulation Language | UNION, UNION ALL
SQLite | Tables | UNIQUE Constraint
PostgreSQL | Data Types | Network Address Types (cidr, inet, macaddr)
SQL Basics | DML: Data Manipulation Language | INTERSECT
SQLite | Tables | DEFAULT Constraint
PostgreSQL | Database
SQL Basics | DML: Data Manipulation Language | MINUS
SQLite | Tables | CHECK Constraint
PostgreSQL | Database | Create a Database (CREATE DATABASE)
SQL Basics | DML: Data Manipulation Language | INSERT
SQLite | View
PostgreSQL | Database | List Created Databases
SQL Basics | DML: Data Manipulation Language | UPDATE
SQLite | Views | Create a View
PostgreSQL | Database | Connect to a Specified Database
SQL Basics | DML: Data Manipulation Language | DELETE
SQLite | View | Dropping a View
PostgreSQL | Database | Modify a Database (ALTER DATABASE)
SQL Basics | Functions
SQLite | Index
PostgreSQL | Database | Drop a Database (DROP DATABASE)
SQL Basics | Functions | AVG
SQLite | Index | What Indexes Are and Their Pros and Cons
PostgreSQL | Schema
SQL Basics | Functions | COUNT
SQLite | Indexes | Creating an Index
PostgreSQL | Schema | Relationship Between Databases, Schemas, and Tables
SQL Basics | Functions | MAX, MIN
SQLite | Indexes | Creating a UNIQUE Index
PostgreSQL | Schema | Create a Schema (CREATE SCHEMA)
SQL Basics | Functions | SUM
SQLite | Indexes | Viewing an Index Schema
PostgreSQL | Schema | List Created Schemas
SQL Basics | Functions | Substring
SQLite | Index | Dropping an Index
PostgreSQL | Schema | Configure the Schema Search Path
SQL Basics | Functions | Concatenate
SQLite | Trigger
PostgreSQL | Schema | Modify a Schema (ALTER SCHEMA)
SQL Basics | Functions | Trim
SQLite | Triggers | Creating Triggers
PostgreSQL | Schema | Drop a Schema (DROP SCHEMA)
SQL Basics | Functions | Replace
SQLite | Triggers | Referencing Values Before and After a Change
PostgreSQL | Creating Roles (Users)
SQLite | Trigger | Inspect a Trigger Schema
PostgreSQL | Role (User) ROLE Creation | Create a Role (CREATE ROLE)
SQLite | Triggers | Dropping a Trigger
PostgreSQL | Role (User) ROLE Creation | List Created Roles
SQLite | Adding, Updating, and Deleting Data
PostgreSQL | Role (User) ROLE Creation | Change Role Attributes and Name (ALTER ROLE)
SQLite | Modifying Data | Adding Data with INSERT
PostgreSQL | Role (User) ROLE Creation | Rename a Role (ALTER ROLE)
SQLite | Inserting, Updating, and Deleting Data | Inserting Data Selected from Another Table
PostgreSQL | Role (User) ROLE Creation | Set Role Password Expiration (ALTER ROLE)
SQLite | Insert, Update, and Delete Data | Update Data (UPDATE)
PostgreSQL | Role (User) ROLE Creation | Grant Privileges on Tables, Views, and Other Objects (GRANT)
SQLite | Adding, Updating, and Deleting Data | Deleting Data (DELETE)
PostgreSQL | Role (User) ROLE Creation | Remove Role Privileges (REVOKE)
SQLite | Querying Data
PostgreSQL | Role (User) ROLE Creation | Change Ownership of Objects Owned by a Specified Role to Another Role (REASSIGN OWNED)
SQLite | Query Data | Retrieve Data with SELECT
PostgreSQL | Terminal Command Collection
SQLite | Query Data | Sort Rows by Column Values (ORDER BY)
PostgreSQL | Terminal Command Collection | Initialize (initdb)
SQLite | Querying Data | Setting Query Conditions with WHERE
PostgreSQL | Terminal Command Collection | Backup (pg_dump)
SQLite | Query Data | Compare Against a Range of Values (BETWEEN Clause)
PostgreSQL | ALTER Constraints and Table Names
SQLite | Query Data | Compare Against a List of Values (IN Clause)
PostgreSQL | Using Sequences
SQLite | Querying Data | Pattern Matching with LIKE
PostgreSQL | Using ROWNUM with row_number()
SQLite | Querying Data | Pattern Matching with GLOB
PostgreSQL | Trigger Usage Example
SQLite | Query Data | Find Rows with NULL Values (IS NULL)
PostgreSQL | Functions
SQLite | Query Data | Assign Column Aliases (AS Clause)
PostgreSQL | Query Foreign Key Table and Column Lists
SQLite | Query Data | Remove Duplicate Rows with DISTINCT
SQLite | Querying Data | LIMIT and OFFSET
SQLite | Query Data | Calculate Arithmetic Expressions from Column Values
SQLite | Query Data | Return Conditional Results with CASE
SQLite | Querying Data | GROUP BY and HAVING
SQLite | Data Joins
SQLite | Joins | INNER JOIN
SQLite | Joining Data | Outer Joins (OUTER JOIN)
SQLite | Joining Data | Cross Join (CROSS JOIN)
SQLite | Joining Data | Natural Joins (NATURAL Keyword)
SQLite | Joins | Joining a Table to Itself (SELF JOIN)
SQLite | SQLite Commands
SQLite | SQLite Commands | Viewing Current Settings (.show Command)
SQLite | Commands | Changing Output Format with .mode
SQLite | SQLite Commands | Show Column Names in SELECT Results (.headers)
SQLite | SQLite Commands | Change the SELECT Result Separator (.separator)
SQLite | SQLite Commands | Set Column Widths in Column Mode (.width)
SQLite | SQLite Commands | Import CSV Data from a File (.import)
SQLite | SQLite Commands | Database Dump (.dump)
SQLite | SQLite Commands | Rebuilding a Database from a Dump (.read Command)
SQLite | Commands | Writing SELECT Results to a File with .output
HBase Compression, Compaction, and Data Block Encoding
SQLite | SQLite Commands | Back Up and Restore a Database (.backup/.restore)
HBase Data Versioning
SQLite | SQLite Functions
HBase BloomFilter
SQLite | SQLite Functions | Counting Rows in a Column or Table (count Function)
SQLite | SQLite Functions | Calculate Column Totals with sum and total
SQLite | SQLite Functions | Calculate an Average with avg
SQLite | SQLite Functions | Finding Maximum and Minimum Column Values (max and min Functions)
SQLite | SQLite Functions | Concatenating Column Values (group_concat Function)
SQLite | Functions | Date and Time Functions
SQLite | SQLite Functions | Returning the Number of Characters in a String (length Function)
SQLite | SQLite Functions | Converting Strings to Uppercase or Lowercase (lower and upper Functions)
SQLite | SQLite Functions | Replacing Part of a String (replace Function)
SQLite | SQLite Functions | Extracting Part of a String (substr Function)
SQLite | SQLite Functions | Removing Characters from the Start and End of a String (trim, rtrim, and ltrim Functions)
SQLite | SQLite Functions | Enclosing a String in Single Quotes (quote Function)
SQLite | SQLite Functions | Rounding Numbers (round Function)
SQLite | SQLite Functions | Calculating an Absolute Value (abs Function)
SQLite | SQLite Functions | Generating Random Numbers (random Function)
SQLite | SQLite Functions | Converting a BLOB Value to Hexadecimal (hex Function)
SQLite | SQLite Functions | Generate Random Numbers for BLOB Values (randomblob Function)
SQLite | SQLite Functions | Create a BLOB 0x00 Value of a Specified Number of Bytes (zeroblob Function)
VectorDB (Vector Database)
A database specialized for efficiently storing data in numeric vector form, or embeddings, and quickly finding similar data
InfluxDB
Open source time series database