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.
Microsoft SQL Server Client 2017 on Debian 9

Microsoft SQL Server Client 2017 on Debian 9

17
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

9
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

12
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
Documenting the DB: Data dictionaries

Documenting the DB: Data dictionaries

36
Comments
3 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
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
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
loading...