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.
Full-text search com PostgreSQL

Full-text search com PostgreSQL

Comments
9 min read
Updating timestamps automatically in Supabase

Updating timestamps automatically in Supabase

5
Comments
1 min read
SQL for data analysis

SQL for data analysis

1
Comments
3 min read
Everything you wanted to know about Auto Increment but were afraid to ask

Everything you wanted to know about Auto Increment but were afraid to ask

1
Comments
6 min read
UPSERT some columns in YugabyteDB (ON CONFLICT DO UPDATE)

UPSERT some columns in YugabyteDB (ON CONFLICT DO UPDATE)

2
Comments
6 min read
SQL Indexes Basics in Rails

SQL Indexes Basics in Rails

2
Comments
4 min read
Filtering on DENSE_RANK() optimized as pushed-down DISTINCT in YugabyteDB

Filtering on DENSE_RANK() optimized as pushed-down DISTINCT in YugabyteDB

1
Comments
4 min read
🏺Database Architecture - History Over State

🏺Database Architecture - History Over State

8
Comments 1
8 min read
Jazz up a CLI project with color and sound!

Jazz up a CLI project with color and sound!

1
Comments
4 min read
SQL fundamentals: understanding Join Tables

SQL fundamentals: understanding Join Tables

1
Comments
6 min read
Python to SQL and back again... an Object-Relational Mapping tale.

Python to SQL and back again... an Object-Relational Mapping tale.

Comments
3 min read
How to convert CSV to SQL insert statements?

How to convert CSV to SQL insert statements?

3
Comments
2 min read
ULTIMATE GUIDE TO EXPLORATORY DATA ANALYSIS

ULTIMATE GUIDE TO EXPLORATORY DATA ANALYSIS

Comments
6 min read
SQL 101:INTRODUCTION TO SQL FOR DATA ANALYSIS

SQL 101:INTRODUCTION TO SQL FOR DATA ANALYSIS

1
Comments 1
7 min read
How to compose SQL queries based on values from CSV file?

How to compose SQL queries based on values from CSV file?

Comments
2 min read
IN Subquery Optimization

IN Subquery Optimization

Comments
5 min read
Make your Ruby on Rails app 80x faster with SQL

Make your Ruby on Rails app 80x faster with SQL

1
Comments
9 min read
Problem solving with SQL: Case Study #1 — Danny’s Diner

Problem solving with SQL: Case Study #1 — Danny’s Diner

Comments 2
10 min read
How to delete large records in batches

How to delete large records in batches

Comments
3 min read
Securely connect to an Amazon RDS via PrivateLink using SQL

Securely connect to an Amazon RDS via PrivateLink using SQL

Comments
3 min read
Essential SQL Commands for Data Science

Essential SQL Commands for Data Science

Comments
3 min read
Insight Findings from A Case Study of Customers Leaving Credit Card Services

Insight Findings from A Case Study of Customers Leaving Credit Card Services

Comments
10 min read
Simple query for remove duplicates from table

Simple query for remove duplicates from table

2
Comments
2 min read
CITEXT vs LOWER

CITEXT vs LOWER

Comments
4 min read
SQL Server Performance Tuning

SQL Server Performance Tuning

2
Comments
2 min read
Cypher on PostgreSQL: A Reason to Use Apache AGE

Cypher on PostgreSQL: A Reason to Use Apache AGE

1
Comments
2 min read
Creating a SQL generator app with ChatGPT, PostgreSQL, and ToolJet

Creating a SQL generator app with ChatGPT, PostgreSQL, and ToolJet

78
Comments 17
7 min read
How to validate your prisma raw query results

How to validate your prisma raw query results

2
Comments
2 min read
Como obtener el tamaño de las todas las tablas de una base de datos SQL Server

Como obtener el tamaño de las todas las tablas de una base de datos SQL Server

Comments
2 min read
SQL Concepts

SQL Concepts

1
Comments
11 min read
SQL Concepts

SQL Concepts

1
Comments
6 min read
[GDB] Debugging session PostgreSQL & AGE

[GDB] Debugging session PostgreSQL & AGE

7
Comments
1 min read
Hacking 101: Common Attacks and How to Stop Them

Hacking 101: Common Attacks and How to Stop Them

1
Comments
5 min read
Essential SQL Commands for Data Science

Essential SQL Commands for Data Science

1
Comments
8 min read
Structure Query Language

Structure Query Language

6
Comments
2 min read
Millions record query - with and without index

Millions record query - with and without index

Comments
2 min read
How to use sequel.ai to convert natural language queries into SQL queries

How to use sequel.ai to convert natural language queries into SQL queries

Comments
3 min read
Save $ on public S3 buckets using VPC endpoints via SQL

Save $ on public S3 buckets using VPC endpoints via SQL

Comments
6 min read
Query Real Time Data in Kafka Using SQL

Query Real Time Data in Kafka Using SQL

7
Comments
9 min read
DELETE CASCADE AND UPDATE CASCADE rules in SQL Server foreign key

DELETE CASCADE AND UPDATE CASCADE rules in SQL Server foreign key

Comments
2 min read
General Questions

General Questions

1
Comments
5 min read
Uncovering Hidden Gems: PostgreSQL Window Functions You May Not Know About

Uncovering Hidden Gems: PostgreSQL Window Functions You May Not Know About

1
Comments
2 min read
SQL JOIN explained

SQL JOIN explained

71
Comments 4
13 min read
Polars for Analytics an Introduction

Polars for Analytics an Introduction

3
Comments 2
3 min read
Deploy SQL Server on Amazon RDS: A Step-by-Step Guide

Deploy SQL Server on Amazon RDS: A Step-by-Step Guide

1
Comments
6 min read
YugabyteDB column-level locking for UPDATE

YugabyteDB column-level locking for UPDATE

1
Comments
2 min read
A Tutorial on SQL Window Functions.

A Tutorial on SQL Window Functions.

1
Comments
15 min read
Getting Started With SQL

Getting Started With SQL

5
Comments
4 min read
Record Insert with Relational Validation in One SQL Statement

Record Insert with Relational Validation in One SQL Statement

3
Comments
7 min read
Retype a column in YugabyteDB (and PostgreSQL)

Retype a column in YugabyteDB (and PostgreSQL)

3
Comments
5 min read
Optimizing Database Performance: Exploring Indexing Techniques in DBMS

Optimizing Database Performance: Exploring Indexing Techniques in DBMS

11
Comments
16 min read
How to choose the right streaming database

How to choose the right streaming database

12
Comments
7 min read
How to limit the number of connections per DB in the PostgreSQL?

How to limit the number of connections per DB in the PostgreSQL?

Comments
1 min read
Essential SQL Commands for Data Science

Essential SQL Commands for Data Science

1
Comments
6 min read
Essential SQL Commands For Data Science

Essential SQL Commands For Data Science

Comments
3 min read
Essential SQL Commands for Data Science

Essential SQL Commands for Data Science

Comments
6 min read
Free AWS BootCamp WEEK 4 PART 2: PostgreSQL Databases in AWS

Free AWS BootCamp WEEK 4 PART 2: PostgreSQL Databases in AWS

1
Comments
7 min read
PostgreSQL SELECT STATEMENT.

PostgreSQL SELECT STATEMENT.

Comments
1 min read
View Generated Queries From EF Core

View Generated Queries From EF Core

3
Comments
3 min read
Scalable sequences in PostgreSQL / YugabyteDB

Scalable sequences in PostgreSQL / YugabyteDB

Comments
3 min read
loading...