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.
🤔 How to create a MySQL connection and run queries with Python3

🤔 How to create a MySQL connection and run queries with Python3

13
Comments 1
1 min read
Good sources (courses, books, sites) on database design and data modeling?

Good sources (courses, books, sites) on database design and data modeling?

14
Comments 2
1 min read
The Beginner's Guide To MongoDB Aggregation Pipeline Part 1

The Beginner's Guide To MongoDB Aggregation Pipeline Part 1

14
Comments
2 min read
Database generic way of achieving Query Result Change Notification

Database generic way of achieving Query Result Change Notification

7
Comments 1
1 min read
SMSS -'Connect to Server' Hell

SMSS -'Connect to Server' Hell

6
Comments
1 min read
Data Fingerprinting in JavaScript

Data Fingerprinting in JavaScript

58
Comments 1
6 min read
Basic DB Using SQL Server (Part 3) - retrieve data using SQL

Basic DB Using SQL Server (Part 3) - retrieve data using SQL

11
Comments
6 min read
Basic DB Using SQL Server (Part 2) - modify columns and learn some constraints

Basic DB Using SQL Server (Part 2) - modify columns and learn some constraints

8
Comments
8 min read
Secure Data Lake with AWS Lake Formation Tutorial

Secure Data Lake with AWS Lake Formation Tutorial

7
Comments 1
4 min read
Eager Loading: Fetching Associated Data with Sequelize

Eager Loading: Fetching Associated Data with Sequelize

13
Comments 1
4 min read
From 15,000 database connections to under 100: DigitalOcean's tale of tech debt

From 15,000 database connections to under 100: DigitalOcean's tale of tech debt

220
Comments 20
7 min read
PostgreSQL Tutorial for beginners to Advance level.

PostgreSQL Tutorial for beginners to Advance level.

95
Comments 2
18 min read
[PT-BR] Conhecendo o DBeaver

[PT-BR] Conhecendo o DBeaver

64
Comments 9
2 min read
Perform Direct and Reverse image search like Google Images with AquilaDB

Perform Direct and Reverse image search like Google Images with AquilaDB

5
Comments
15 min read
Building .Net Core API for easy database switch

Building .Net Core API for easy database switch

33
Comments 3
8 min read
RocksDB Is Eating the Database World

RocksDB Is Eating the Database World

21
Comments
8 min read
Postgresql com Backup Incremental — parte 1 — Configurando o registro de Logs (Wal)

Postgresql com Backup Incremental — parte 1 — Configurando o registro de Logs (Wal)

11
Comments
1 min read
Index Overview

Index Overview

17
Comments
4 min read
Postgresql com Backup Incremental — parte 4— Restore da base de dados

Postgresql com Backup Incremental — parte 4— Restore da base de dados

8
Comments
2 min read
MySQL Schema Change Without Downtime

MySQL Schema Change Without Downtime

7
Comments
2 min read
Pros and Cons of Using structure.sql in Your Ruby on Rails Application

Pros and Cons of Using structure.sql in Your Ruby on Rails Application

7
Comments
9 min read
RDBMS or NoSQL: The question that pops up with every new project!

RDBMS or NoSQL: The question that pops up with every new project!

13
Comments 8
2 min read
How To Use Postgres With Knex On Your Node API

How To Use Postgres With Knex On Your Node API

13
Comments
2 min read
Database Migration Plan

Database Migration Plan

2
Comments
1 min read
Follower Clusters – 3 Major Use Cases for Syncing SQL & NoSQL Deployments

Follower Clusters – 3 Major Use Cases for Syncing SQL & NoSQL Deployments

3
Comments
6 min read
SQL API for Real-Time Kafka Analytics in 3 Steps

SQL API for Real-Time Kafka Analytics in 3 Steps

6
Comments
8 min read
Need #help regarding MongoDB? #HELP

Need #help regarding MongoDB? #HELP

3
Comments 7
1 min read
Design a Query Language Client for Pythonistas and Data Scientists

Design a Query Language Client for Pythonistas and Data Scientists

5
Comments
3 min read
Data Analyst? TIME TO LEARN PYTHON!!!🐍🐼

Data Analyst? TIME TO LEARN PYTHON!!!🐍🐼

49
Comments 11
5 min read
Create table in Rails only if it does not exist already

Create table in Rails only if it does not exist already

43
Comments 4
2 min read
⏱ 5 min chrono FREE admin panel with ForestAdmin

⏱ 5 min chrono FREE admin panel with ForestAdmin

45
Comments 2
3 min read
Design a Table to Keep Historical Changes in Database

Design a Table to Keep Historical Changes in Database

82
Comments 12
5 min read
Exterminate! 🤖 (or Destroying Associated Records in Rails)

Exterminate! 🤖 (or Destroying Associated Records in Rails)

24
Comments 4
4 min read
The best free courses to learn about Databases and SQL for Beginners

The best free courses to learn about Databases and SQL for Beginners

38
Comments
4 min read
♻️🐘 Disposable local Postgres databases (without containers!)

♻️🐘 Disposable local Postgres databases (without containers!)

22
Comments
6 min read
Writing SQL for humans with Literate SQL

Writing SQL for humans with Literate SQL

46
Comments 4
7 min read
Are you supporting the right politician?

Are you supporting the right politician?

6
Comments
10 min read
SQL Indexes 101

SQL Indexes 101

19
Comments
3 min read
Multiple SQL Inserts and Transactions with Objection Js

Multiple SQL Inserts and Transactions with Objection Js

12
Comments
4 min read
Scraping data with Selenium (Python) | Upwork Series #2

Scraping data with Selenium (Python) | Upwork Series #2

85
Comments 1
11 min read
Export DynamoDB table into CSV

Export DynamoDB table into CSV

4
Comments
4 min read
How to Setup MySQL 5.7 Replication on Ubuntu 16.04

How to Setup MySQL 5.7 Replication on Ubuntu 16.04

18
Comments
4 min read
How to safely drop a deprecated database table

How to safely drop a deprecated database table

12
Comments 2
3 min read
Company data using Wikidata

Company data using Wikidata

7
Comments
5 min read
PostgreSQL Pro Tip: Beware of BETWEEN

PostgreSQL Pro Tip: Beware of BETWEEN

12
Comments 2
1 min read
8 New SQL Tools That Will Change How You Work in 2020

8 New SQL Tools That Will Change How You Work in 2020

163
Comments 7
6 min read
Would you like to have better XML support in SQL Server?

Would you like to have better XML support in SQL Server?

5
Comments
1 min read
How we store protobufs in MongoDB

How we store protobufs in MongoDB

5
Comments
3 min read
How to migrate a database schema at scale

How to migrate a database schema at scale

16
Comments
7 min read
Getting Started with Graph Databases in Azure Cosmos DB

Getting Started with Graph Databases in Azure Cosmos DB

14
Comments
6 min read
Why your software should use UUIDs in 2020s

Why your software should use UUIDs in 2020s

5
Comments
1 min read
Salesforce Spring '20 Community Guest User Apocalypse

Salesforce Spring '20 Community Guest User Apocalypse

6
Comments 1
10 min read
Building Dynamic React Apps with Database Data

Building Dynamic React Apps with Database Data

23
Comments
9 min read
Working with JSON in an RDBMS – Part 1, MS SQL Server

Working with JSON in an RDBMS – Part 1, MS SQL Server

11
Comments 2
12 min read
Quickly set up a Hive environment on GCP

Quickly set up a Hive environment on GCP

6
Comments
2 min read
Understanding Consistency Levels in Azure Cosmos DB

Understanding Consistency Levels in Azure Cosmos DB

7
Comments
4 min read
Using Python to create Hive tables with random schema

Using Python to create Hive tables with random schema

7
Comments
1 min read
How to Reset MySql Root password on MacOS 10.13

How to Reset MySql Root password on MacOS 10.13

6
Comments
2 min read
3 approaches to scroll through data in Elasticsearch

3 approaches to scroll through data in Elasticsearch

17
Comments 1
4 min read
Bash Script: Knex Database Refresh

Bash Script: Knex Database Refresh

11
Comments 5
1 min read
loading...