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.
Understanding PostgreSQL Scan Types

Understanding PostgreSQL Scan Types

Comments
6 min read
Frequent Re-Connections improved by Connection Manager

Frequent Re-Connections improved by Connection Manager

Comments
4 min read
Introducing Ivee in Beta or the story of databases UX

Introducing Ivee in Beta or the story of databases UX

14
Comments
2 min read
Text to IRIS SQL with LangChain

Text to IRIS SQL with LangChain

Comments
18 min read
Advanced Grouping Query in GBase 8s: Introduction to GROUP BY ROLLUP

Advanced Grouping Query in GBase 8s: Introduction to GROUP BY ROLLUP

Comments
4 min read
Introduction to Constants in GBase 8a MPP Cluster

Introduction to Constants in GBase 8a MPP Cluster

Comments
3 min read
Database Interactions in Go: From SQL to NoSQL

Database Interactions in Go: From SQL to NoSQL

2
Comments
5 min read
Introduction to GBase 8c Performance Tuning Based on the TPCH Model

Introduction to GBase 8c Performance Tuning Based on the TPCH Model

Comments
9 min read
Helpful Tools for Quant丨Efficiently Calculate Transaction Costs from Tick Data

Helpful Tools for Quant丨Efficiently Calculate Transaction Costs from Tick Data

Comments
2 min read
G Suite Vs. CompanionLink: Which One is The Best?

G Suite Vs. CompanionLink: Which One is The Best?

Comments
5 min read
Secure Your Data with Entity Framework Core Encryption

Secure Your Data with Entity Framework Core Encryption

3
Comments 1
5 min read
Maintaining Throughput With Less Physical Connections

Maintaining Throughput With Less Physical Connections

Comments
6 min read
Clickhouse for Embedded Analytics: First Impressions and Unexpected Challenges

Clickhouse for Embedded Analytics: First Impressions and Unexpected Challenges

2
Comments 1
5 min read
Mastering Pairwise Correlations Calculation of Securities Through Coding

Mastering Pairwise Correlations Calculation of Securities Through Coding

Comments
3 min read
GBase 8s Database Data Compression Strategies

GBase 8s Database Data Compression Strategies

Comments
3 min read
YugabyteDB Connection Manager: a Database Resident Connection Pool with Shared Processes

YugabyteDB Connection Manager: a Database Resident Connection Pool with Shared Processes

Comments
7 min read
Amazon DynamoDB adds support for attribute-based access control

Amazon DynamoDB adds support for attribute-based access control

3
Comments
2 min read
Mastering Data Import in Neo4j

Mastering Data Import in Neo4j

Comments
3 min read
Evolution of Data Sharding Towards Automation and Flexibility

Evolution of Data Sharding Towards Automation and Flexibility

Comments
15 min read
GBase 8a MPP Cluster Supported Data Types

GBase 8a MPP Cluster Supported Data Types

Comments
7 min read
Performance Optimization of GBase 8c Based on TPCC Testing

Performance Optimization of GBase 8c Based on TPCC Testing

Comments
5 min read
Guide to Seamlessly Connecting ODBC with GBase 8s Database on Linux

Guide to Seamlessly Connecting ODBC with GBase 8s Database on Linux

1
Comments
3 min read
Data Showdown: OLAP vs. OLTP – The Battle of Real-Time and Analytics Titans

Data Showdown: OLAP vs. OLTP – The Battle of Real-Time and Analytics Titans

Comments
5 min read
Developing with Postgres

Developing with Postgres

3
Comments
4 min read
SQL 101: Introduction to Structured Query Language

SQL 101: Introduction to Structured Query Language

1
Comments
4 min read
Don't forget to flush! — Ensuring Data Integrity in Spring Data JPA

Don't forget to flush! — Ensuring Data Integrity in Spring Data JPA

Comments
4 min read
Accelerating Data Analysis: Embracing the Efficient Query and Aggregation Calculations

Accelerating Data Analysis: Embracing the Efficient Query and Aggregation Calculations

Comments
4 min read
BULK COLLECT in PL/SQL

BULK COLLECT in PL/SQL

1
Comments
5 min read
Effective Strategies for Testing Databases in FastAPI Applications

Effective Strategies for Testing Databases in FastAPI Applications

Comments
4 min read
What is Vector Quantization?

What is Vector Quantization?

29
Comments 2
13 min read
Trigger in PL/SQL with Example - Part 2 | AFTER Trigger

Trigger in PL/SQL with Example - Part 2 | AFTER Trigger

7
Comments
2 min read
Trigger in PL/SQL with Example - Part 1 | BEFORE Trigger

Trigger in PL/SQL with Example - Part 1 | BEFORE Trigger

3
Comments
2 min read
SQL - Sub Queries

SQL - Sub Queries

2
Comments
3 min read
Cursor in PLSQL

Cursor in PLSQL

7
Comments
5 min read
Developing a Script for Incremental Database Backup

Developing a Script for Incremental Database Backup

3
Comments
5 min read
Visualizing the Apache Cassandra Token Ring with Plotly

Visualizing the Apache Cassandra Token Ring with Plotly

3
Comments
7 min read
Write raw SQL easier with pgx and sqlc in Go

Write raw SQL easier with pgx and sqlc in Go

2
Comments
5 min read
Associer une Base de Données PostgreSQL à un Projet Laravel 11 sous Linux et Windows

Associer une Base de Données PostgreSQL à un Projet Laravel 11 sous Linux et Windows

1
Comments
1 min read
Identity Inserts in Databases: The Debate Between Control and Flexibility (And What Benjamin Franklin Has to Do With It)

Identity Inserts in Databases: The Debate Between Control and Flexibility (And What Benjamin Franklin Has to Do With It)

3
Comments
4 min read
Why should you upgrade your PostgreSQL today?

Why should you upgrade your PostgreSQL today?

1
Comments 1
3 min read
React Native with WatermelonDB: A Lightweight and Reactive Database for Scalable Apps

React Native with WatermelonDB: A Lightweight and Reactive Database for Scalable Apps

4
Comments
4 min read
Java, perform COUNT on each group of a large csv file #eg33

Java, perform COUNT on each group of a large csv file #eg33

6
Comments
2 min read
Airtable Overview: The Modern Database Tool for All Your Needs

Airtable Overview: The Modern Database Tool for All Your Needs

1
Comments
3 min read
Open sourcing our new Text-to-SQL LLM app starter template

Open sourcing our new Text-to-SQL LLM app starter template

1
Comments
6 min read
How to solve "Unknown table 'COLUMN_STATISTICS'"

How to solve "Unknown table 'COLUMN_STATISTICS'"

Comments
1 min read
How to Delete Duplicate Data from a MySQL Database

How to Delete Duplicate Data from a MySQL Database

Comments
4 min read
Common Table Expression (CTE) in PLSQL | Part 1

Common Table Expression (CTE) in PLSQL | Part 1

4
Comments
6 min read
Postgresql query tuning

Postgresql query tuning

Comments
1 min read
Hacktoberfest: The Couchbase Quest Awaits—Are You Ready?

Hacktoberfest: The Couchbase Quest Awaits—Are You Ready?

4
Comments
7 min read
High Frequency Data Analysis: Converting High-frequency Signals to Discrete Buy/Sell Signals

High Frequency Data Analysis: Converting High-frequency Signals to Discrete Buy/Sell Signals

Comments
3 min read
Why You Need (More Than) Locks: Ensuring Consistency with Transactions in Your No-Code Applications

Why You Need (More Than) Locks: Ensuring Consistency with Transactions in Your No-Code Applications

42
Comments
5 min read
Understanding and Configuring Oracle Access Control Lists (ACLs) for Email Sending Using UTL_MAIL

Understanding and Configuring Oracle Access Control Lists (ACLs) for Email Sending Using UTL_MAIL

19
Comments
7 min read
Insert data into tables - SQL

Insert data into tables - SQL

5
Comments
2 min read
Aggregate Functions vs Window Functions in SQL

Aggregate Functions vs Window Functions in SQL

5
Comments
2 min read
Create a secure AWS RDS instance with CDK

Create a secure AWS RDS instance with CDK

1
Comments
4 min read
Boosting PostgreSQL Performance: Optimising Queries with the != Operator

Boosting PostgreSQL Performance: Optimising Queries with the != Operator

3
Comments
8 min read
How to create a table with SQL code?

How to create a table with SQL code?

3
Comments
6 min read
7 types of Database - which one you should pick?

7 types of Database - which one you should pick?

1
Comments
4 min read
Multi-condition filtering #eg48

Multi-condition filtering #eg48

6
Comments
1 min read
How to Downsample Your Data Efficiently

How to Downsample Your Data Efficiently

Comments
2 min read
loading...