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 the goto Statement in Uniface 10.4 ProcScript

🚀 Understanding the goto Statement in Uniface 10.4 ProcScript

Comments
2 min read
🔄 Mastering the forentity Loop in Uniface 10.4: A Developer's Guide

🔄 Mastering the forentity Loop in Uniface 10.4: A Developer's Guide

Comments
2 min read
Did you know the two powerful ways in Python to interact with databases?

Did you know the two powerful ways in Python to interact with databases?

Comments
3 min read
I wish I knew this before: Python's ORM vs Raw SQL in SQLAlchemy Explained!

I wish I knew this before: Python's ORM vs Raw SQL in SQLAlchemy Explained!

Comments
3 min read
I wish I knew this before approaching Database Access in Python with SQLAlchemy

I wish I knew this before approaching Database Access in Python with SQLAlchemy

Comments
3 min read
Two Approaches to Database Interaction with SQLAlchemy in Python

Two Approaches to Database Interaction with SQLAlchemy in Python

Comments
1 min read
Integrating BM25 in Hybrid Search and Reranking Pipelines: Strategies and Applications

Integrating BM25 in Hybrid Search and Reranking Pipelines: Strategies and Applications

Comments
4 min read
SpannerDB Reading Capabilities and Transaction Specifications

SpannerDB Reading Capabilities and Transaction Specifications

Comments
1 min read
Did you know you can optimize database access with ORM and raw SQL?

Did you know you can optimize database access with ORM and raw SQL?

Comments
2 min read
Integrating BM25 in Hybrid Search and Reranking Pipelines: Strategies and Applications

Integrating BM25 in Hybrid Search and Reranking Pipelines: Strategies and Applications

Comments
3 min read
The Importance of Choosing the Right Data Types for Database Optimization

The Importance of Choosing the Right Data Types for Database Optimization

6
Comments
5 min read
Esse elefante a gente permite continuar na sala

Esse elefante a gente permite continuar na sala

1
Comments
2 min read
Apache Iceberg Table Optimization #10: The Endgame — Building an Autonomous Optimization Pipeline for Apache Iceberg

Apache Iceberg Table Optimization #10: The Endgame — Building an Autonomous Optimization Pipeline for Apache Iceberg

Comments
3 min read
Apache Iceberg Table Optimization #9: Managing Large-Scale Optimizations — Parallelism, Checkpointing, and Fail Recovery

Apache Iceberg Table Optimization #9: Managing Large-Scale Optimizations — Parallelism, Checkpointing, and Fail Recovery

Comments
3 min read
Apache Iceberg Table Optimization #8: Hidden Pitfalls — Compaction and Partition Evolution in Apache Iceberg

Apache Iceberg Table Optimization #8: Hidden Pitfalls — Compaction and Partition Evolution in Apache Iceberg

Comments
3 min read
Apache Iceberg Table Optimization #2: The Basics of Compaction — Bin Packing Your Data for Efficiency

Apache Iceberg Table Optimization #2: The Basics of Compaction — Bin Packing Your Data for Efficiency

Comments
3 min read
How to Duplicate a Laravel Model

How to Duplicate a Laravel Model

1
Comments
1 min read
Apache Iceberg Table Optimization #7: Using Iceberg Metadata Tables to Determine When Compaction Is Needed

Apache Iceberg Table Optimization #7: Using Iceberg Metadata Tables to Determine When Compaction Is Needed

Comments
3 min read
Apache Iceberg Table Optimization #5: Avoiding Metadata Bloat with Snapshot Expiration and Rewriting Manifests

Apache Iceberg Table Optimization #5: Avoiding Metadata Bloat with Snapshot Expiration and Rewriting Manifests

Comments
3 min read
Apache Iceberg Table Optimization #4: Smarter Data Layout — Sorting and Clustering Iceberg Tables

Apache Iceberg Table Optimization #4: Smarter Data Layout — Sorting and Clustering Iceberg Tables

1
Comments
3 min read
How Indexes Work in Databases: Deep Dive into MongoDB & PostgreSQL

How Indexes Work in Databases: Deep Dive into MongoDB & PostgreSQL

2
Comments
3 min read
Apache Iceberg Table Optimization #3: Optimizing Compaction for Streaming Workloads in Apache Iceberg

Apache Iceberg Table Optimization #3: Optimizing Compaction for Streaming Workloads in Apache Iceberg

Comments
3 min read
Database latency with PostgreSQL and MongoDB: it's the data model that makes it fast

Database latency with PostgreSQL and MongoDB: it's the data model that makes it fast

2
Comments 1
14 min read
Data modeling And Error Handling in Mongoose/Node.js

Data modeling And Error Handling in Mongoose/Node.js

Comments
7 min read
Database Design Errors to Avoid & How To Fix Them

Database Design Errors to Avoid & How To Fix Them

11
Comments 1
5 min read
loading...