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.
Uncovering Hidden Gems: PostgreSQL Window Functions You May Not Know About

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

3
Comments
2 min read
Polars for Analytics an Introduction

Polars for Analytics an Introduction

3
Comments 2
3 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
CITEXT vs LOWER

CITEXT vs LOWER

1
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)

4
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?

4
Comments
1 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

1
Comments
6 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

30
Comments
3 min read
Scalable sequences in PostgreSQL / YugabyteDB

Scalable sequences in PostgreSQL / YugabyteDB

Comments
3 min read
Columns to Rows in Oracle SQL

Columns to Rows in Oracle SQL

Comments
4 min read
Free AWS BootCamp WEEK 4: SQL Databases

Free AWS BootCamp WEEK 4: SQL Databases

1
Comments
5 min read
Sum ActiveStorage::Blob byte_size

Sum ActiveStorage::Blob byte_size

1
Comments
1 min read
Essential SQL Commands for Data Science Tasks

Essential SQL Commands for Data Science Tasks

2
Comments
7 min read
Granting Access to Read-Only Users and Refreshing Permissions Automatically: A Function-Based Solution

Granting Access to Read-Only Users and Refreshing Permissions Automatically: A Function-Based Solution

2
Comments 1
3 min read
Mastering PostgreSQL Views and CTEs for Rails Developers: A Comprehensive Guide

Mastering PostgreSQL Views and CTEs for Rails Developers: A Comprehensive Guide

6
Comments
5 min read
Essential SQL Commands for Data Science

Essential SQL Commands for Data Science

Comments
4 min read
Code a bus schedule CLI with Node.js and Python [ + Sqlite3 ]

Code a bus schedule CLI with Node.js and Python [ + Sqlite3 ]

13
Comments
4 min read
Don't Break the Bank on SQL Queries: BigQuery On-Demand vs Flat-Rate prices. Which Saves You More? 💰😎

Don't Break the Bank on SQL Queries: BigQuery On-Demand vs Flat-Rate prices. Which Saves You More? 💰😎

5
Comments 3
5 min read
GPT Query: the AI tool that can write SQL queries for you

GPT Query: the AI tool that can write SQL queries for you

3
Comments
3 min read
Essential SQL Commands For Data Science

Essential SQL Commands For Data Science

3
Comments
8 min read
Essential SQL Commands for Data Science

Essential SQL Commands for Data Science

4
Comments 1
9 min read
HackerRank SQL Basic Select

HackerRank SQL Basic Select

6
Comments
3 min read
PostgreSQL parameter log_statement

PostgreSQL parameter log_statement

1
Comments
4 min read
SQLite type system is the wooorst

SQLite type system is the wooorst

9
Comments
4 min read
Learnings from a slow query analysis in PostgreSQL

Learnings from a slow query analysis in PostgreSQL

4
Comments 1
5 min read
Essential SQL Commands for Data Science

Essential SQL Commands for Data Science

Comments
3 min read
PostgreSQL parameter log_min_duration_statement

PostgreSQL parameter log_min_duration_statement

Comments 1
2 min read
PostgreSQL parameter statement_timeout

PostgreSQL parameter statement_timeout

Comments
2 min read
Google Analytics 4 (GA4) - querying raw data with SQL

Google Analytics 4 (GA4) - querying raw data with SQL

1
Comments 1
3 min read
Essential SQL Commands for Data Science

Essential SQL Commands for Data Science

1
Comments
3 min read
Using Multiple EF Core DbContexts In a Single Application

Using Multiple EF Core DbContexts In a Single Application

Comments
4 min read
SQL: The Language of Relational Databases

SQL: The Language of Relational Databases

2
Comments
2 min read
sqlite / sqlx + async

sqlite / sqlx + async

2
Comments
2 min read
INTRODUCTION TO SQL FOR DATA ANALYSIS

INTRODUCTION TO SQL FOR DATA ANALYSIS

2
Comments
4 min read
SQL Basics: An Introduction to Structured Query Language

SQL Basics: An Introduction to Structured Query Language

Comments
8 min read
How to Transform SQL Queries to Crosstabs in PostgreSQL

How to Transform SQL Queries to Crosstabs in PostgreSQL

Comments
6 min read
Improving Prisma raw queries typing.

Improving Prisma raw queries typing.

Comments
3 min read
Four Pitfalls of SQL Processing with Null Values

Four Pitfalls of SQL Processing with Null Values

Comments
7 min read
Distributed SQL Databases

Distributed SQL Databases

2
Comments 1
3 min read
Essential SQL Commands for Data Science

Essential SQL Commands for Data Science

Comments
2 min read
Interactive SQL Examples in JavaScript

Interactive SQL Examples in JavaScript

1
Comments 1
3 min read
Data Business Logic In Java: jOOQ VS SPL

Data Business Logic In Java: jOOQ VS SPL

3
Comments
4 min read
Practicing String Manipulation in SQL

Practicing String Manipulation in SQL

2
Comments
7 min read
Disable SQLModel foreign key constraint

Disable SQLModel foreign key constraint

2
Comments
1 min read
A Practical Guide to SQL Dates with DuckDB.

A Practical Guide to SQL Dates with DuckDB.

Comments 2
9 min read
ShortId Factory

ShortId Factory

3
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
Arel and Ruby on Rails

Arel and Ruby on Rails

9
Comments
3 min read
Full-text search com PostgreSQL

Full-text search com PostgreSQL

3
Comments
9 min read
Embed hard-coded SQL into binaries for a cleaner look!

Embed hard-coded SQL into binaries for a cleaner look!

Comments
3 min read
Correct way of adding filter to Laravel 10

Correct way of adding filter to Laravel 10

14
Comments
2 min read
loading...