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.
PostgreSQL parameter log_statement

PostgreSQL parameter log_statement

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
SQLite type system is the wooorst

SQLite type system is the wooorst

7
Comments
4 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
Four Pitfalls of SQL Processing with Null Values

Four Pitfalls of SQL Processing with Null Values

Comments
7 min read
Improving Prisma raw queries typing.

Improving Prisma raw queries typing.

Comments
3 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
Data Business Logic In Java: jOOQ VS SPL

Data Business Logic In Java: jOOQ VS SPL

2
Comments
4 min read
Interactive SQL Examples in JavaScript

Interactive SQL Examples in JavaScript

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

Arel and Ruby on Rails

3
Comments
3 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

8
Comments
2 min read
ChatGPT - Complex Coding Challenges: 7 KYU

ChatGPT - Complex Coding Challenges: 7 KYU

2
Comments
2 min read
A Brief Introduction to SQL for Data Science

A Brief Introduction to SQL for Data Science

1
Comments
4 min read
Guide to bitwise operators in CrateDB

Guide to bitwise operators in CrateDB

Comments
5 min read
ChatGPT - Complex Coding Challenges: 8 KYU

ChatGPT - Complex Coding Challenges: 8 KYU

3
Comments 2
4 min read
Stored Procedures in SQL: A Complete Tutorial

Stored Procedures in SQL: A Complete Tutorial

1
Comments 1
9 min read
An Introduction to Go Ast - Generating SQL Queries Based on Structs

An Introduction to Go Ast - Generating SQL Queries Based on Structs

5
Comments
4 min read
The Five Best Online Database Builders 2023

The Five Best Online Database Builders 2023

1
Comments
12 min read
Reading and Writing Files in SQLite

Reading and Writing Files in SQLite

1
Comments
4 min read
The Secret Ingredient for Transactional Consistency

The Secret Ingredient for Transactional Consistency

3
Comments 3
3 min read
SQL: Soft Deleting and Unique Constraint

SQL: Soft Deleting and Unique Constraint

1
Comments
4 min read
ERD Lab - Free Database Design & Modeling Tool

ERD Lab - Free Database Design & Modeling Tool

6
Comments 2
2 min read
Selecting duplicate records

Selecting duplicate records

1
Comments 1
1 min read
Understanding MySQL EXPLAIN output

Understanding MySQL EXPLAIN output

12
Comments
4 min read
How To Convert a SQL Query Into C# LINQ

How To Convert a SQL Query Into C# LINQ

2
Comments
8 min read
ClickHouse is fast, esProc SPL is faster

ClickHouse is fast, esProc SPL is faster

1
Comments
10 min read
Deploy and connect Azure Function to SQL in Azure

Deploy and connect Azure Function to SQL in Azure

1
Comments
5 min read
Computed columns with the find_by_sql method in a Rails application

Computed columns with the find_by_sql method in a Rails application

Comments
4 min read
Principles of Database Index Design

Principles of Database Index Design

10
Comments
11 min read
SQL Server 2022 - GENERATE_SERIES

SQL Server 2022 - GENERATE_SERIES

2
Comments
2 min read
SQL query to find second highest salary using dens_rank function ?

SQL query to find second highest salary using dens_rank function ?

1
Comments
1 min read
Writing Reusable SQL Queries For Your Application with DbVisualizer Scripts

Writing Reusable SQL Queries For Your Application with DbVisualizer Scripts

1
Comments
6 min read
Find the latest reported values with ease. Introducing max_by and min_by aggregations in CrateDB 5.2

Find the latest reported values with ease. Introducing max_by and min_by aggregations in CrateDB 5.2

Comments
4 min read
How I Turned My Coffee Addiction into a Ruby and Postgres Adventure

How I Turned My Coffee Addiction into a Ruby and Postgres Adventure

8
Comments 4
4 min read
Type-safe S3 Select queries with Kysely

Type-safe S3 Select queries with Kysely

21
Comments 1
5 min read
SQL Concepts

SQL Concepts

2
Comments 1
8 min read
Infra as SQL is in beta

Infra as SQL is in beta

1
Comments
4 min read
Introduction to SQL Timestamp, Date and Time Data Types.

Introduction to SQL Timestamp, Date and Time Data Types.

1
Comments
5 min read
Essential SQL Concepts

Essential SQL Concepts

Comments 2
12 min read
SQL101: Introduction to SQL for Data Analysis

SQL101: Introduction to SQL for Data Analysis

3
Comments 1
6 min read
SQL Concepts

SQL Concepts

1
Comments
14 min read
Querying InfluxDB IOx Using the New Flight SQL Plugin for Grafana

Querying InfluxDB IOx Using the New Flight SQL Plugin for Grafana

1
Comments
6 min read
SQL 101: Introduction to SQL for Data Analysis

SQL 101: Introduction to SQL for Data Analysis

6
Comments
5 min read
Supabase: count and discount raws from the likes table

Supabase: count and discount raws from the likes table

4
Comments
2 min read
loading...