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

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

Exterminate! 🤖 (or Destroying Associated Records in Rails)

24
Comments 5
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
Working with JSON in an RDBMS – Part 2, PostgreSQL

Working with JSON in an RDBMS – Part 2, PostgreSQL

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

15
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

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

Using Python to create Hive tables with random schema

8
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
Fastsandra: Faster Python Cassandra Driver

Fastsandra: Faster Python Cassandra Driver

8
Comments 2
5 min read
MySQL DB backup using Bash script

MySQL DB backup using Bash script

14
Comments 3
1 min read
Web Scraper & Data Extraction with Python | Upwork Series #1

Web Scraper & Data Extraction with Python | Upwork Series #1

181
Comments 12
7 min read
Database normalization may be harmful to efficiency on large scale analytics projects.

Database normalization may be harmful to efficiency on large scale analytics projects.

12
Comments 2
2 min read
I made a Hack Quiz in 48 hours.

I made a Hack Quiz in 48 hours.

8
Comments 2
1 min read
How to Monitor MySQL Deployments with Prometheus & Grafana at ScaleGrid

How to Monitor MySQL Deployments with Prometheus & Grafana at ScaleGrid

8
Comments
12 min read
A Crystal app adventure!

A Crystal app adventure!

25
Comments 8
4 min read
Using Python to create Teradata tables with random schema

Using Python to create Teradata tables with random schema

6
Comments 1
1 min read
Full Stack GraphQL - Part 1 Building a Prisma Data Model

Full Stack GraphQL - Part 1 Building a Prisma Data Model

17
Comments
4 min read
Using Python to create Oracle tables with random schema

Using Python to create Oracle tables with random schema

8
Comments 1
1 min read
Using Python to create SqlServer tables with random schema

Using Python to create SqlServer tables with random schema

6
Comments
1 min read
Using Python to create MySQL tables with random schema

Using Python to create MySQL tables with random schema

5
Comments
1 min read
Quickly set up an Oracle environment on GCP

Quickly set up an Oracle environment on GCP

16
Comments 1
3 min read
loading...