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.
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

10
Comments
2 min read
Indexing Databases – A Postgres Example

Indexing Databases – A Postgres Example

8
Comments
2 min read
10 Best Startups in Cloud - 2018 (ScaleGrid DBaaS)

10 Best Startups in Cloud - 2018 (ScaleGrid DBaaS)

6
Comments
9 min read
How to build a PostgreSQL database to store tweets

How to build a PostgreSQL database to store tweets

5
Comments
9 min read
Back Up and Restore Your SQL Database

Back Up and Restore Your SQL Database

8
Comments 1
4 min read
Build a Simple Persistent Key-Value Store in Elixir, using Logs - Part 1

Build a Simple Persistent Key-Value Store in Elixir, using Logs - Part 1

6
Comments
1 min read
Authentication Hashing in SQLAlchemy

Authentication Hashing in SQLAlchemy

17
Comments
4 min read
Storing data in Go

Storing data in Go

66
Comments 5
4 min read
Effective Database Design: Part 1

Effective Database Design: Part 1

186
Comments 5
3 min read
Effective Database Design: Part 4

Effective Database Design: Part 4

83
Comments 6
3 min read
Effective Database Design: Part 3

Effective Database Design: Part 3

79
Comments 10
2 min read
Effective Database Design: Part 2

Effective Database Design: Part 2

64
Comments 8
3 min read
Slow MySQL Start Time in GTID? Binary Log File Size May Be The Issue

Slow MySQL Start Time in GTID? Binary Log File Size May Be The Issue

6
Comments
7 min read
Best way to store password in DB

Best way to store password in DB

7
Comments 12
1 min read
MySQL High Availability Framework - Part I

MySQL High Availability Framework - Part I

8
Comments
6 min read
Fast Knowledge: Kubernetes port forwarding

Fast Knowledge: Kubernetes port forwarding

9
Comments 1
1 min read
DynamoDB transactions

DynamoDB transactions

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

Managing High Availability in PostgreSQL – Part I

9
Comments
10 min read
MySQL: Client and Server Model Databases

MySQL: Client and Server Model Databases

4
Comments
2 min read
Combining SQL queries with UNION

Combining SQL queries with UNION

11
Comments
5 min read
Purify code with data integrity. Part 1: defaults and not-nulls

Purify code with data integrity. Part 1: defaults and not-nulls

45
Comments 3
5 min read
Graph databases 101

Graph databases 101

36
Comments 1
2 min read
From monolith to cloud: Auto Increment to UUID

From monolith to cloud: Auto Increment to UUID

20
Comments 6
5 min read
Storing user customisations and settings. How do you do it?

Storing user customisations and settings. How do you do it?

39
Comments 15
4 min read
Every SQL Join You’ll Ever Need

Every SQL Join You’ll Ever Need

162
Comments 2
20 min read
Build a frontend to backend web application (Windows 95 style)

Build a frontend to backend web application (Windows 95 style)

10
Comments
3 min read
SQL:How to compare with NULL without "IS NULL" operator

SQL:How to compare with NULL without "IS NULL" operator

4
Comments 1
2 min read
MySQL Hosting on Azure, Fully Managed Cloud Database Service Launches at ScaleGrid

MySQL Hosting on Azure, Fully Managed Cloud Database Service Launches at ScaleGrid

4
Comments
3 min read
Step by step React, NodejS and MySQL Simple Full Stack Application 2018 (part: 3)

Step by step React, NodejS and MySQL Simple Full Stack Application 2018 (part: 3)

41
Comments 6
3 min read
managing db users in postgres & mysql

managing db users in postgres & mysql

10
Comments 2
6 min read
Top 5 Benefits of Shared MongoDB Hosting

Top 5 Benefits of Shared MongoDB Hosting

6
Comments
6 min read
Why and How Should I Learn PL/SQL (or T-SQL or PL/pgSQL)?

Why and How Should I Learn PL/SQL (or T-SQL or PL/pgSQL)?

23
Comments 1
6 min read
Step by step React, NodejS and MySQL Simple Full Stack Application 2018 (part: 2)

Step by step React, NodejS and MySQL Simple Full Stack Application 2018 (part: 2)

22
Comments 2
2 min read
Step by step React, NodejS and MySQL Simple Full Stack Application 2018 (part: 1)

Step by step React, NodejS and MySQL Simple Full Stack Application 2018 (part: 1)

37
Comments
2 min read
Latest PostgreSQL Trends: Most Time-Consuming Tasks & Important Metrics to Track

Latest PostgreSQL Trends: Most Time-Consuming Tasks & Important Metrics to Track

13
Comments
6 min read
Speed up your PostgreSQL unit tests with one weird trick!

Speed up your PostgreSQL unit tests with one weird trick!

23
Comments 3
2 min read
How banks handle our balance, technically?

How banks handle our balance, technically?

55
Comments 9
1 min read
Build a RESTful API using hapijs and mongoose

Build a RESTful API using hapijs and mongoose

12
Comments
4 min read
How to do a zero downtime database (DB) migration (schema change) with a practical example

How to do a zero downtime database (DB) migration (schema change) with a practical example

32
Comments 2
3 min read
Implementing Model Class Inheritance in SQLAlchemy

Implementing Model Class Inheritance in SQLAlchemy

11
Comments 1
2 min read
DynamoDB-CRI: DynamoDB model wrapper to enhance DynamoDB access

DynamoDB-CRI: DynamoDB model wrapper to enhance DynamoDB access

20
Comments 2
5 min read
PostgreSQL 10.3 on OpenBSD 6.3: Install

PostgreSQL 10.3 on OpenBSD 6.3: Install

10
Comments 6
2 min read
New Course: Database Fundamentals

New Course: Database Fundamentals

18
Comments
1 min read
Remove and modify nested documents in MongoDB

Remove and modify nested documents in MongoDB

11
Comments 3
2 min read
Updating a Django queryset with annotation and subquery

Updating a Django queryset with annotation and subquery

29
Comments
3 min read
Worst things you can do, with database architecture

Worst things you can do, with database architecture

12
Comments 1
1 min read
MongoDB: Databases Made Simple

MongoDB: Databases Made Simple

20
Comments
2 min read
Storing images in database in 2018

Storing images in database in 2018

9
Comments 1
1 min read
BeckDesignRules for Database Developers: Reveals intention – Naming

BeckDesignRules for Database Developers: Reveals intention – Naming

9
Comments
7 min read
Tips to Improve MongoDB Security

Tips to Improve MongoDB Security

13
Comments
3 min read
Take Database Development to the Enterprise Level with dbForge Studio for Oracle

Take Database Development to the Enterprise Level with dbForge Studio for Oracle

6
Comments
2 min read
Azure Data Studio: Initial thoughts and walk-through

Azure Data Studio: Initial thoughts and walk-through

12
Comments
4 min read
Towards Atomic File Modifications

Towards Atomic File Modifications

14
Comments
6 min read
SQL Server: cuáles son las diferencias entre @@identity y Scope_identity

SQL Server: cuáles son las diferencias entre @@identity y Scope_identity

12
Comments
3 min read
Any NoSQL true believers out there?

Any NoSQL true believers out there?

63
Comments 62
1 min read
loading...