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 do I make paging with ordering by different columns ?

How do I make paging with ordering by different columns ?

6
Comments
1 min read
Why Dashboards are the fast food of Data Analysis

Why Dashboards are the fast food of Data Analysis

59
Comments 6
3 min read
How to make APIs fast & secure, plus tips for REST APIs

How to make APIs fast & secure, plus tips for REST APIs

62
Comments
2 min read
Having trouble understanding wide column stores like Cassandra. Can someone explain?

Having trouble understanding wide column stores like Cassandra. Can someone explain?

3
Comments
1 min read
What’s the Best PostgreSQL High Availability Framework? PAF vs. repmgr vs. Patroni Infographic

What’s the Best PostgreSQL High Availability Framework? PAF vs. repmgr vs. Patroni Infographic

6
Comments
3 min read
How to migrate Database and Collections Efficiently with Studio 3T

How to migrate Database and Collections Efficiently with Studio 3T

5
Comments
5 min read
Postgres Is Underrated—It Handles More than You Think

Postgres Is Underrated—It Handles More than You Think

950
Comments 46
9 min read
Fine Tuning Full Text Search with PostgreSQL 12

Fine Tuning Full Text Search with PostgreSQL 12

9
Comments
14 min read
SPARQL - An Absolute Beginner's Guide

SPARQL - An Absolute Beginner's Guide

13
Comments
3 min read
Learning multiple programming language at the same time

Learning multiple programming language at the same time

5
Comments 1
1 min read
Quickly Installing And Running Neo4j Using Ansible On AWS Cloud

Quickly Installing And Running Neo4j Using Ansible On AWS Cloud

7
Comments
7 min read
Using PostgreSQL and pgAdmin4 in docker

Using PostgreSQL and pgAdmin4 in docker

8
Comments
1 min read
A Critical Look on Relational Databases and SQL

A Critical Look on Relational Databases and SQL

20
Comments 2
7 min read
11 Of The Best Engineering Blogs To Inspire You

11 Of The Best Engineering Blogs To Inspire You

545
Comments 13
4 min read
Performance Review: AWS RDS Postgres vs Digital Ocean Postgres

Performance Review: AWS RDS Postgres vs Digital Ocean Postgres

8
Comments
3 min read
The True Guide to True and False in PostgreSQL

The True Guide to True and False in PostgreSQL

10
Comments
2 min read
Announcing react-native-sqlite-2@3.0.1!

Announcing react-native-sqlite-2@3.0.1!

9
Comments 1
2 min read
Working with BigQuery Analytic Functions

Working with BigQuery Analytic Functions

6
Comments
5 min read
Setting up distributed database architecture with postgresql

Setting up distributed database architecture with postgresql

39
Comments 1
6 min read
Martilla - A simple backup tool for simple everyday use

Martilla - A simple backup tool for simple everyday use

9
Comments 2
3 min read
Rediseen: start REST-like API service for Redis database without writing a single line of code

Rediseen: start REST-like API service for Redis database without writing a single line of code

5
Comments
1 min read
Spin up a PostGres Docker Container on the Raspberry Pi in 2 minutes! 🐳

Spin up a PostGres Docker Container on the Raspberry Pi in 2 minutes! 🐳

12
Comments
2 min read
AWS: Redshift – quick start and SQL-workbench connection configuration

AWS: Redshift – quick start and SQL-workbench connection configuration

13
Comments
4 min read
PostgreSQL Connection Pooling: Part 1 – Pros & Cons

PostgreSQL Connection Pooling: Part 1 – Pros & Cons

51
Comments
6 min read
Big Data and Hadoop Framework Tutorial for Beginners

Big Data and Hadoop Framework Tutorial for Beginners

20
Comments
1 min read
Using Tableau with Kafka: How to Build a Real-Time SQL Dashboard on Streaming Data

Using Tableau with Kafka: How to Build a Real-Time SQL Dashboard on Streaming Data

9
Comments
6 min read
An Introduction to Oracle SQL

An Introduction to Oracle SQL

3
Comments
1 min read
Redis 101: Foundation and Core Concepts

Redis 101: Foundation and Core Concepts

67
Comments 4
6 min read
How to query with PostgreSQL wildcards like a Pro

How to query with PostgreSQL wildcards like a Pro

37
Comments 4
10 min read
Migrating Apache Flume Flows to Apache NiFi: Any Relational Database To/From Anywhere

Migrating Apache Flume Flows to Apache NiFi: Any Relational Database To/From Anywhere

6
Comments
6 min read
When it comes to Data, the customer is always wrong - The Four Horsemen of the Assumption Apocalypse

When it comes to Data, the customer is always wrong - The Four Horsemen of the Assumption Apocalypse

25
Comments 3
2 min read
#SQL30 Day 12: Greatest Discount

#SQL30 Day 12: Greatest Discount

6
Comments
3 min read
#SQL30 Day 11: Soft Deletes

#SQL30 Day 11: Soft Deletes

8
Comments
3 min read
Designing Data Intensive Applications - Book Review

Designing Data Intensive Applications - Book Review

4
Comments
1 min read
Manipulating arrays with PostgreSQL

Manipulating arrays with PostgreSQL

13
Comments 2
3 min read
#SQL30 Day 10: Random Sampling

#SQL30 Day 10: Random Sampling

7
Comments 1
3 min read
Mongoose: Como find() funciona

Mongoose: Como find() funciona

8
Comments
6 min read
Generate dummy data with Postgres

Generate dummy data with Postgres

6
Comments 2
2 min read
Le comportement particulier des autoincrement dans les tables MySQL InnoDB

Le comportement particulier des autoincrement dans les tables MySQL InnoDB

5
Comments
3 min read
Mongoose e Padrões de Design: Armazene o que você consulta

Mongoose e Padrões de Design: Armazene o que você consulta

10
Comments 1
5 min read
Accessing Amazon RDS From AWS EKS

Accessing Amazon RDS From AWS EKS

80
Comments 15
9 min read
Database Loadtest using JMeter

Database Loadtest using JMeter

7
Comments
1 min read
Import data from S3 to Redshift in minutes using Dataform

Import data from S3 to Redshift in minutes using Dataform

7
Comments
4 min read
Vertica: a simple cluster set up and configuration on AWS EC2

Vertica: a simple cluster set up and configuration on AWS EC2

5
Comments
7 min read
#SQL30 Day 8: Deleting Duplicates

#SQL30 Day 8: Deleting Duplicates

9
Comments
3 min read
How to Transfer MySQL Databases

How to Transfer MySQL Databases

5
Comments
1 min read
Relational Database - How to locate candidate keys in a table

Relational Database - How to locate candidate keys in a table

5
Comments
3 min read
Embed Data Studio Report on a webpage

Embed Data Studio Report on a webpage

5
Comments
1 min read
Scaling Postgres DB for better performance - per aspera ad Citus

Scaling Postgres DB for better performance - per aspera ad Citus

13
Comments 1
8 min read
#SQL30 Day 6: Supermarket Sales

#SQL30 Day 6: Supermarket Sales

6
Comments 1
3 min read
Graph DB in Serverless Flavor: Hacking DynamoDB

Graph DB in Serverless Flavor: Hacking DynamoDB

18
Comments 11
7 min read
A quick starter for Bookshelf.js

A quick starter for Bookshelf.js

17
Comments 2
4 min read
PostgreSQL Trends: Most Popular Cloud Providers, Languages, VACUUM, Query Management Strategies & Deployment Types in Enterprise

PostgreSQL Trends: Most Popular Cloud Providers, Languages, VACUUM, Query Management Strategies & Deployment Types in Enterprise

7
Comments
11 min read
#SQL30 Day 5: Hierarchies

#SQL30 Day 5: Hierarchies

6
Comments 1
3 min read
Our 25 Favorite Data Science Courses From Harvard To Udemy

Our 25 Favorite Data Science Courses From Harvard To Udemy

63
Comments
15 min read
10 Amazing Articles On Python Programming And Machine Learning

10 Amazing Articles On Python Programming And Machine Learning

60
Comments
4 min read
#SQL30 Day 3: Weather Data

#SQL30 Day 3: Weather Data

20
Comments 4
5 min read
#SQL30 Day 1: Wildfires

#SQL30 Day 1: Wildfires

46
Comments 8
2 min read
#SQL30 Day 2: Stock Price Variance

#SQL30 Day 2: Stock Price Variance

8
Comments 5
3 min read
What you should know about DB types, DB design, and successful software projects

What you should know about DB types, DB design, and successful software projects

47
Comments
2 min read
loading...