DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Yet Another PostgreSQL-REGEX Article đŸ€ș

Yet Another PostgreSQL-REGEX Article đŸ€ș

6
Comments
4 min read
A Deep Dive into Django Foreign Keys

A Deep Dive into Django Foreign Keys

Comments
2 min read
Data Engineering For Beginners: A Step-By-Step Guide

Data Engineering For Beginners: A Step-By-Step Guide

19
Comments
8 min read
Cosa sono e come gestire le transazioni su SQL Server

Cosa sono e come gestire le transazioni su SQL Server

Comments
4 min read
Uncovering Inventory Insights:Mintclassics (Coursera)

Uncovering Inventory Insights:Mintclassics (Coursera)

Comments
2 min read
Unveiling the Architecture of Apache AGE: Enhancing PostgreSQL with Graph Capabilities

Unveiling the Architecture of Apache AGE: Enhancing PostgreSQL with Graph Capabilities

Comments
4 min read
Group By, Grouping Sets, Cube, and Rollup Queries in SQL

Group By, Grouping Sets, Cube, and Rollup Queries in SQL

Comments
5 min read
@DynamicUpdate with column-level locking in YugabyteDB and how to avoid write skew anomalies

@DynamicUpdate with column-level locking in YugabyteDB and how to avoid write skew anomalies

1
Comments
4 min read
MASTERING MYSQL

MASTERING MYSQL

4
Comments
2 min read
Foreign Key validation in YugabyteDB when created in NOT VALID

Foreign Key validation in YugabyteDB when created in NOT VALID

Comments
4 min read
Recommendation Engines with Graph Databases using Apache AGE

Recommendation Engines with Graph Databases using Apache AGE

Comments
3 min read
My Takeaways from "How Query Engines Work"

My Takeaways from "How Query Engines Work"

Comments
1 min read
Postgres Order By: the resultset is sorted differently

Postgres Order By: the resultset is sorted differently

1
Comments
1 min read
Docker Image for YugabyteDB Developers

Docker Image for YugabyteDB Developers

3
Comments
3 min read
Key DevOps Metrics To Measure Impact in 2023

Key DevOps Metrics To Measure Impact in 2023

Comments
8 min read
Understanding WHERE and ORDER BY

Understanding WHERE and ORDER BY

1
Comments
2 min read
Deleting a Column in SQL: Everything You Need to Know

Deleting a Column in SQL: Everything You Need to Know

1
Comments
7 min read
SQL - Use Views for Simplified and Reusable Queries

SQL - Use Views for Simplified and Reusable Queries

1
Comments
2 min read
Can writes be blocked by reads in YugabyteDB?

Can writes be blocked by reads in YugabyteDB?

Comments
6 min read
How to Optimize SQL Queries With ChatGPT and Metis

How to Optimize SQL Queries With ChatGPT and Metis

1
Comments
6 min read
Which Scenarios Does ClickHouse Applies to?

Which Scenarios Does ClickHouse Applies to?

5
Comments 1
9 min read
Dirty Writes, INSERT ... ON CONFLICT DO UPDATE, Read Committed Isolation Level and Lost Update

Dirty Writes, INSERT ... ON CONFLICT DO UPDATE, Read Committed Isolation Level and Lost Update

4
Comments 4
6 min read
Preventing Empty Updates In PostgreSQL Tables Using A Simple Trigger Function

Preventing Empty Updates In PostgreSQL Tables Using A Simple Trigger Function

2
Comments
2 min read
How to check Postgres VACUUM process progress?

How to check Postgres VACUUM process progress?

6
Comments
1 min read
Inner Inverted Join in YugabyteDB & PostgreSQL

Inner Inverted Join in YugabyteDB & PostgreSQL

Comments
6 min read
How to Choose a Streaming Database Service in the Cloud? A Detailed Comparison

How to Choose a Streaming Database Service in the Cloud? A Detailed Comparison

Comments
7 min read
Handbook To Becoming A Data Scientist In 2023

Handbook To Becoming A Data Scientist In 2023

2
Comments 3
2 min read
Understanding join strategies in PostgreSQL

Understanding join strategies in PostgreSQL

4
Comments
6 min read
SQL - Optimize Your SQL Data Types

SQL - Optimize Your SQL Data Types

3
Comments
2 min read
Introduction to ODBC and OLE DB for SQL Server

Introduction to ODBC and OLE DB for SQL Server

Comments
3 min read
SQL JOINS; Identifying The Left And Right Table

SQL JOINS; Identifying The Left And Right Table

10
Comments
2 min read
Fast SELECT COUNT(*) WHERE in YugabyteDB

Fast SELECT COUNT(*) WHERE in YugabyteDB

Comments
5 min read
SQLite AND Operator: Understanding Logical Operators in SQLite

SQLite AND Operator: Understanding Logical Operators in SQLite

1
Comments
3 min read
How to Connect Java Applications to Databases with JDBC

How to Connect Java Applications to Databases with JDBC

Comments
1 min read
SQLite Expressions: A Complete Guide

SQLite Expressions: A Complete Guide

Comments
4 min read
The RETURNING clause in SQL

The RETURNING clause in SQL

24
Comments 2
2 min read
Exploring Ways of Performance Tuning Your Postgresql Database

Exploring Ways of Performance Tuning Your Postgresql Database

3
Comments
6 min read
Schemas em SQL: Indexes e B+ trees

Schemas em SQL: Indexes e B+ trees

5
Comments 2
4 min read
A Guide to Understanding and Debugging SQL Execution Plans in Spring Boot

A Guide to Understanding and Debugging SQL Execution Plans in Spring Boot

10
Comments
4 min read
Sql Service Broker

Sql Service Broker

Comments
19 min read
Exporting a large PostgreSQL table using Python

Exporting a large PostgreSQL table using Python

35
Comments 3
2 min read
FileMaker vs. Access: A Comparison of Two Popular Database Solutions

FileMaker vs. Access: A Comparison of Two Popular Database Solutions

Comments
15 min read
Automate Database Processes: Supabase Triggers

Automate Database Processes: Supabase Triggers

4
Comments
4 min read
Xata's JSON Column Type

Xata's JSON Column Type

2
Comments
5 min read
5 useful SQL functions to take your SQL skills to the next level

5 useful SQL functions to take your SQL skills to the next level

14
Comments
6 min read
How Does Partitioning Work in PostgreSQL and Why Should You Care?

How Does Partitioning Work in PostgreSQL and Why Should You Care?

1
Comments
6 min read
POSTGRESQL PSEUDOCOLUMNS: CTID

POSTGRESQL PSEUDOCOLUMNS: CTID

7
Comments
6 min read
Neo4j, A Database on Crack 🚬

Neo4j, A Database on Crack 🚬

2
Comments
1 min read
Top 10 Tools For SQL Writing For Students

Top 10 Tools For SQL Writing For Students

Comments
2 min read
ACID and Transactions in SQL

ACID and Transactions in SQL

6
Comments
6 min read
Introduction to SQL for Absolute Beginners!

Introduction to SQL for Absolute Beginners!

60
Comments 11
4 min read
SQL - Stored Procedures for Reusable and Secure SQL Code

SQL - Stored Procedures for Reusable and Secure SQL Code

1
Comments
2 min read
SQLite Create Table If Not Exists: Conditional Table Creation

SQLite Create Table If Not Exists: Conditional Table Creation

Comments
2 min read
Should you use an enum column or a table to store allowed values in SQL?

Should you use an enum column or a table to store allowed values in SQL?

14
Comments 1
5 min read
CRUD Operations in SQL

CRUD Operations in SQL

2
Comments 1
14 min read
Your Free and Offline SQL console in a few steps

Your Free and Offline SQL console in a few steps

1
Comments
5 min read
Exploring the Power of pgvector as an Open Source Vector Database

Exploring the Power of pgvector as an Open Source Vector Database

1
Comments
12 min read
Are you curious about DATABASES?

Are you curious about DATABASES?

Comments
2 min read
Scalable range sharding to avoid hotspots on indexes

Scalable range sharding to avoid hotspots on indexes

6
Comments
13 min read
Quickest way to dump data to the database using .Net

Quickest way to dump data to the database using .Net

1
Comments
2 min read
loading...