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.
Inside SQL Joins

Inside SQL Joins

2
Comments
4 min read
Building a Retrieval-Augmented Generation Chatbot with SvelteKit and Xata Vector Search

Building a Retrieval-Augmented Generation Chatbot with SvelteKit and Xata Vector Search

3
Comments
10 min read
Choose the right database for your needs: BASE vs ACID model

Choose the right database for your needs: BASE vs ACID model

2
Comments
3 min read
Building Dynamic Forms with PHP: A Comprehensive Tutorial

Building Dynamic Forms with PHP: A Comprehensive Tutorial

4
Comments 2
5 min read
How the presence of indexes and the size of tables affect the choice of execution plan when joining tables in PostgreSQL?

How the presence of indexes and the size of tables affect the choice of execution plan when joining tables in PostgreSQL?

2
Comments
7 min read
GIS software development dive-in, the essentials

GIS software development dive-in, the essentials

13
Comments
4 min read
Populating a table in PostgreSQL with one million records of random data.

Populating a table in PostgreSQL with one million records of random data.

2
Comments
1 min read
Supabase Alternative: Self-hosted

Supabase Alternative: Self-hosted

9
Comments 7
2 min read
Python. Automating creation backups of MySQL database.

Python. Automating creation backups of MySQL database.

3
Comments
4 min read
How do you check a distribution of values that PostgreSQL has collected on some column of a table?

How do you check a distribution of values that PostgreSQL has collected on some column of a table?

5
Comments
2 min read
The main methods of joining tables in PostgreSQL.

The main methods of joining tables in PostgreSQL.

Comments
3 min read
The ARRAY_TO_STRING() function in PostgreSQL

The ARRAY_TO_STRING() function in PostgreSQL

Comments
2 min read
Python code that inserts a large number of records into a MySQL table.

Python code that inserts a large number of records into a MySQL table.

Comments
2 min read
The ORM vs. ODM Debate: A Node.js Backend Perspective

The ORM vs. ODM Debate: A Node.js Backend Perspective

7
Comments 3
3 min read
Migrating MySQL database to SQL Server Using Radzen Blazor Studio.

Migrating MySQL database to SQL Server Using Radzen Blazor Studio.

Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.