DEV Community

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
DBMS For Application Development: Relational Model & Relational Database

DBMS For Application Development: Relational Model & Relational Database

9
Comments
2 min read
SQL: Copy Tables and Massive Update

SQL: Copy Tables and Massive Update

7
Comments 2
2 min read
Differences Between SQL And NoSQL Databases

Differences Between SQL And NoSQL Databases

90
Comments 2
4 min read
How to debug SQL Databases

How to debug SQL Databases

5
Comments
3 min read
How To Merge Multiple SQL Tables Into One MongoDB Collection

How To Merge Multiple SQL Tables Into One MongoDB Collection

7
Comments
9 min read
MySQL/MariaDB: like a Petya ransomware for MySQL and ‘root’@’%’ access

MySQL/MariaDB: like a Petya ransomware for MySQL and ‘root’@’%’ access

9
Comments 2
3 min read
2019 PostgreSQL Trends Report: Private vs. Public Cloud, Migrations, Database Combinations & Top Reasons Used

2019 PostgreSQL Trends Report: Private vs. Public Cloud, Migrations, Database Combinations & Top Reasons Used

8
Comments
11 min read
Redis: replication, part 3 - redis-py and work with Redis Sentinel from Python

Redis: replication, part 3 - redis-py and work with Redis Sentinel from Python

8
Comments
7 min read
How to organize SQL legacy Databases

How to organize SQL legacy Databases

6
Comments
4 min read
How Database Internally Works

How Database Internally Works

23
Comments
5 min read
How to versioning SQL databases architecture using GitHub and Visual Studio

How to versioning SQL databases architecture using GitHub and Visual Studio

2
Comments 2
4 min read
In Praise of Multiple DB setups and Rails 6

In Praise of Multiple DB setups and Rails 6

38
Comments 9
3 min read
Experimenting Flyway with SQL Server

Experimenting Flyway with SQL Server

7
Comments
2 min read
Welcome to SQL 3: Building Relationships and Combining Data Sets

Welcome to SQL 3: Building Relationships and Combining Data Sets

11
Comments 1
10 min read
Managing High Availability in PostgreSQL – Part II

Managing High Availability in PostgreSQL – Part II

11
Comments
11 min read
Database Management Systems For Application Development: Introduction

Database Management Systems For Application Development: Introduction

9
Comments
2 min read
Simple Tips for PostgreSQL Query Optimization

Simple Tips for PostgreSQL Query Optimization

20
Comments
5 min read
Laravel 5: Use Query Caching to make your App really fast

Laravel 5: Use Query Caching to make your App really fast

36
Comments 1
3 min read
Documenting the DB: Data dictionaries

Documenting the DB: Data dictionaries

35
Comments
3 min read
Welcome to SQL 2: Working With Data Values

Welcome to SQL 2: Working With Data Values

12
Comments
7 min read
Welcome to SQL: Modifying Databases and Tables

Welcome to SQL: Modifying Databases and Tables

6
Comments
10 min read
Database Normalization for Object Oriented Programmers

Database Normalization for Object Oriented Programmers

16
Comments
5 min read
Using Sqlite in Go Programming.

Using Sqlite in Go Programming.

17
Comments 2
2 min read
SQL concepts from A to Z

SQL concepts from A to Z

864
Comments 20
14 min read
An Introduction to Queries in PostgreSQL

An Introduction to Queries in PostgreSQL

86
Comments 1
17 min read
Installing WordPress 5 on ZEIT Now with MySQL Hosting

Installing WordPress 5 on ZEIT Now with MySQL Hosting

17
Comments 9
9 min read
How far can Prisma take you? (in February 2019)

How far can Prisma take you? (in February 2019)

26
Comments 4
4 min read
Intro to Redis Cluster Sharding – Advantages, Limitations, Deploying & Client Connections

Intro to Redis Cluster Sharding – Advantages, Limitations, Deploying & Client Connections

12
Comments
10 min read
How to simplest Turing Machine works on postgreSQL

How to simplest Turing Machine works on postgreSQL

7
Comments
5 min read
Database models and ERDs for Newbs Part: 5

Database models and ERDs for Newbs Part: 5

5
Comments
3 min read
All DEFINITION list of "Transactional Information Systems"

All DEFINITION list of "Transactional Information Systems"

4
Comments
3 min read
Database models and ERDs for Newbs Part: 4

Database models and ERDs for Newbs Part: 4

9
Comments
3 min read
Write A Simple Toy Database in Python within Minutes!

Write A Simple Toy Database in Python within Minutes!

21
Comments 3
4 min read
MySQL Tutorial – Understanding The Seconds Behind Master Value

MySQL Tutorial – Understanding The Seconds Behind Master Value

7
Comments
5 min read
Sorting by Created Date with GraphQL and Prisma

Sorting by Created Date with GraphQL and Prisma

5
Comments 1
1 min read
Database models and ERDs for Newbs Part: 3

Database models and ERDs for Newbs Part: 3

4
Comments
2 min read
Why does PostgreSQL have pg_locks

Why does PostgreSQL have pg_locks

5
Comments 8
1 min read
Everything you need to know about (Relational) Databases

Everything you need to know about (Relational) Databases

320
Comments 7
16 min read
Developer's Life January 2019

Developer's Life January 2019

4
Comments
3 min read
Running Fast SQL on DynamoDB Tables

Running Fast SQL on DynamoDB Tables

7
Comments
4 min read
How I reduced storage cost of ElasticSearch by 60x

How I reduced storage cost of ElasticSearch by 60x

9
Comments
6 min read
The best and easy way to handle database migrations (version control)

The best and easy way to handle database migrations (version control)

19
Comments
2 min read
Database models and ERDs for Newbs Part: 2

Database models and ERDs for Newbs Part: 2

5
Comments
2 min read
Packages For Databases

Packages For Databases

5
Comments
5 min read
History Tables

History Tables

8
Comments
7 min read
Explicit Entity State

Explicit Entity State

4
Comments
2 min read
Starting With SQL

Starting With SQL

54
Comments 4
4 min read
A better way to check big amount of data against database in Node.js

A better way to check big amount of data against database in Node.js

12
Comments
2 min read
db in c#— how does I do again?

db in c#— how does I do again?

10
Comments 4
4 min read
I saved 7x from storage cost of MongDB

I saved 7x from storage cost of MongDB

5
Comments
5 min read
Database models and ERDs for Newbs Part: 1

Database models and ERDs for Newbs Part: 1

4
Comments
2 min read
SQLite is Not a Server

SQLite is Not a Server

17
Comments 2
2 min read
SQLite 3.25 Adds Window Functions and Improves ALTER TABLE

SQLite 3.25 Adds Window Functions and Improves ALTER TABLE

7
Comments
2 min read
USING DATABASE TRIGGERS IN POSTGRESQL

USING DATABASE TRIGGERS IN POSTGRESQL

21
Comments 2
5 min read
MySQL High Availability Framework Explained – Part II

MySQL High Availability Framework Explained – Part II

4
Comments
7 min read
Find a Specific Column In An Unknown SQL Table

Find a Specific Column In An Unknown SQL Table

12
Comments 4
2 min read
A PRIMER ON POSTGRESQL STORED FUNCTIONS (PL/pgSQL)

A PRIMER ON POSTGRESQL STORED FUNCTIONS (PL/pgSQL)

21
Comments
5 min read
How DevOps Should Use DBaaS (Database-as-a-Service) To Optimize Their Application Development​

How DevOps Should Use DBaaS (Database-as-a-Service) To Optimize Their Application Development​

9
Comments
7 min read
Incorrect string value issue during migration database in Jira.

Incorrect string value issue during migration database in Jira.

5
Comments
2 min read
Importance of Configuring Go sql.DB Connections

Importance of Configuring Go sql.DB Connections

9
Comments
2 min read
loading...