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.
Upgrading PostgreSQL from version 10 to 11 on Ubuntu 19.04 (Disco Dingo)

Upgrading PostgreSQL from version 10 to 11 on Ubuntu 19.04 (Disco Dingo)

6
Comments
3 min read
Django Migrations: A Primer

Django Migrations: A Primer

11
Comments
5 min read
Microsoft SQL Server Client 2017 on Debian 9

Microsoft SQL Server Client 2017 on Debian 9

16
Comments 5
2 min read
sqlcmd failed due to "locale::facet::_S_create_c_locale name not valid"

sqlcmd failed due to "locale::facet::_S_create_c_locale name not valid"

6
Comments 3
1 min read
Microsoft SQL Server 2017 on Debian 9

Microsoft SQL Server 2017 on Debian 9

17
Comments
2 min read
Demystifying normalization and denormalization

Demystifying normalization and denormalization

10
Comments
6 min read
Import MySQL to MongoDB in 5 Steps (Plus SQL Server, PostgreSQL, Oracle)

Import MySQL to MongoDB in 5 Steps (Plus SQL Server, PostgreSQL, Oracle)

8
Comments 1
3 min read
A Basic Introduction to APIs

A Basic Introduction to APIs

40
Comments
3 min read
Saving dates on database saves your day

Saving dates on database saves your day

3
Comments
2 min read
How To Set Up WordPress with MySQL on Kubernetes Using Helm

How To Set Up WordPress with MySQL on Kubernetes Using Helm

56
Comments 5
11 min read
Managing MySQL Server Logs: Rotate, Compress, Retain & Delete

Managing MySQL Server Logs: Rotate, Compress, Retain & Delete

5
Comments
4 min read
Complete REST API with diskdb, Node, and Express in 5 minutes

Complete REST API with diskdb, Node, and Express in 5 minutes

30
Comments 6
5 min read
What do you think of the ObjectBox database for Python

What do you think of the ObjectBox database for Python

6
Comments 2
1 min read
Toggle NOT NULL constraint with Rails migration

Toggle NOT NULL constraint with Rails migration

10
Comments 1
1 min read
PostgreSQL 11.2 on OpenBSD 6.5: Install

PostgreSQL 11.2 on OpenBSD 6.5: Install

8
Comments 2
2 min read
CTO advice: A checklist for using cloud databases securely

CTO advice: A checklist for using cloud databases securely

8
Comments
4 min read
Writing JOINS in SQL

Writing JOINS in SQL

9
Comments 1
3 min read
PyMongo Tutorial: Testing MongoDB Failover in Your Python App

PyMongo Tutorial: Testing MongoDB Failover in Your Python App

7
Comments
11 min read
Understanding Managed Databases

Understanding Managed Databases

75
Comments
8 min read
How to make your Database FAST with little effort!

How to make your Database FAST with little effort!

34
Comments 2
4 min read
Azure Search with SQL Server

Azure Search with SQL Server

13
Comments
4 min read
Using a database + gRPC with Rust

Using a database + gRPC with Rust

18
Comments
13 min read
Making the Change From SQLite3 to PostgreSQL - Ruby on Rails

Making the Change From SQLite3 to PostgreSQL - Ruby on Rails

40
Comments
3 min read
How to use Sequelize ORM in your Express application

How to use Sequelize ORM in your Express application

19
Comments
8 min read
Migrating data from Cosmos DB to local JSON files

Migrating data from Cosmos DB to local JSON files

15
Comments 1
2 min read
How to manage a huge database schema with Liquibase

How to manage a huge database schema with Liquibase

11
Comments
3 min read
Updating a Table with the Values of a Different One

Updating a Table with the Values of a Different One

5
Comments 1
2 min read
MySQL High Availability Framework Explained – Part III: Failover Scenarios

MySQL High Availability Framework Explained – Part III: Failover Scenarios

11
Comments
5 min read
Redis: replication, part 4 – writing an Ansible role fore the Master-Slave replication with Redis Sentinel provisioning

Redis: replication, part 4 – writing an Ansible role fore the Master-Slave replication with Redis Sentinel provisioning

10
Comments
9 min read
Pitfalls of the MINUS-comparison

Pitfalls of the MINUS-comparison

6
Comments
3 min read
Non-profit projects: how to work with little to no finance?

Non-profit projects: how to work with little to no finance?

6
Comments 4
1 min read
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

8
Comments 2
2 min read
Attaching actions to rollbacks in Spring

Attaching actions to rollbacks in Spring

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

11
Comments
7 min read
Version control, not just for code anymore!

Version control, not just for code anymore!

6
Comments
5 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

10
Comments
2 min read
Simple Tips for PostgreSQL Query Optimization

Simple Tips for PostgreSQL Query Optimization

20
Comments
5 min read
PostgreSQL Tools for the Visually Inclined

PostgreSQL Tools for the Visually Inclined

11
Comments 1
12 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
An Introduction to Queries in PostgreSQL

An Introduction to Queries in PostgreSQL

86
Comments 1
17 min read
Database Normalization for Object Oriented Programmers

Database Normalization for Object Oriented Programmers

17
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

865
Comments 20
14 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
loading...