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

31
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!

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

How banks handle our balance, technically?

53
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
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
How to compare two databases, identify the diferences and generate the necessary SQL to update the structure of one of them

How to compare two databases, identify the diferences and generate the necessary SQL to update the structure of one of them

10
Comments 1
1 min read
Laravel BackupManager

Laravel BackupManager

8
Comments
1 min read
5 ways to make your database better

5 ways to make your database better

41
Comments 1
4 min read
Getting Started with PostgreSQL Streaming Replication

Getting Started with PostgreSQL Streaming Replication

17
Comments
8 min read
Database Transactions Like You're Five

Database Transactions Like You're Five

61
Comments 7
7 min read
Auto backup of Databases in Postgres Container.

Auto backup of Databases in Postgres Container.

18
Comments 1
1 min read
Storing Database Backups

Storing Database Backups

17
Comments
2 min read
Concurrency and Automatic Conflict Resolution

Concurrency and Automatic Conflict Resolution

47
Comments 4
9 min read
How to build a docker image which can restore databases whenever a new container is created from it

How to build a docker image which can restore databases whenever a new container is created from it

14
Comments 2
2 min read
Replicate your PostgreSQL database into another server using just one command.

Replicate your PostgreSQL database into another server using just one command.

62
Comments 4
1 min read
DynamoDB PrimaryKey, HashKey, SortKey (RangeKey)

DynamoDB PrimaryKey, HashKey, SortKey (RangeKey)

17
Comments 1
3 min read
Database Views Don't Really Exist

Database Views Don't Really Exist

34
Comments 4
5 min read
Introduction to Redis: Installation, CLI Commands, and Data Types

Introduction to Redis: Installation, CLI Commands, and Data Types

13
Comments 3
1 min read
Help me decide: Embed subdocument or have a new document collection?

Help me decide: Embed subdocument or have a new document collection?

7
Comments 5
3 min read
Summer 2018: Massive, Twice Over

Summer 2018: Massive, Twice Over

19
Comments
1 min read
Using Materialized Views as Models in Lucky

Using Materialized Views as Models in Lucky

9
Comments 4
4 min read
Centralize Your Query Logic!

Centralize Your Query Logic!

34
Comments 4
3 min read
Mapping Database Queries to Crystal Classes With crystal-db and Lucky

Mapping Database Queries to Crystal Classes With crystal-db and Lucky

13
Comments 4
4 min read
Query Fun

Query Fun

11
Comments
2 min read
They Watched Us With Webcams And Rewrote Our Code! 13:39

They Watched Us With Webcams And Rewrote Our Code!

66
Comments 12
1 min read
Stream & Go: News Feeds for Over 300+ Million End Users

Stream & Go: News Feeds for Over 300+ Million End Users

97
Comments 4
10 min read
How ASTs power the GraphQL schema handling

How ASTs power the GraphQL schema handling

28
Comments 1
8 min read
It’s Hard To Keep A New Team Doing Continuous Delivery 07:55

It’s Hard To Keep A New Team Doing Continuous Delivery

39
Comments
1 min read
BeckDesignRules for Database Developers Part 1: Passes the tests

BeckDesignRules for Database Developers Part 1: Passes the tests

13
Comments 4
11 min read
Speeding up our Webhooks System 60x

Speeding up our Webhooks System 60x

32
Comments
7 min read
Database testing with Citrus

Database testing with Citrus

11
Comments
8 min read
Creating a Vuejs Plugin

Creating a Vuejs Plugin

13
Comments
2 min read
Building RESTful Web APIs with Dart, Aqueduct, and PostgreSQL — Bonus content

Building RESTful Web APIs with Dart, Aqueduct, and PostgreSQL — Bonus content

36
Comments
6 min read
loading...