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.
The main methods of joining tables in PostgreSQL.
dm8ry profile

The main methods of joining tables in PostgreSQL.

#database #postgres #sql #tutorial
Comments
3 min read
How to avoid N+1 query using SQL views (materialized) in Rails application
jetthoughts-dev profile

How to avoid N+1 query using SQL views (materialized) in Rails application

#ruby #rails #tutorial #sql
Comments
3 min read
Oracle SQL vs MySQL: A Comprehensive Comparison
nikhilxd profile

Oracle SQL vs MySQL: A Comprehensive Comparison

#sql #database #mysql #learning
2
Comments
3 min read
Mastering Oracle SQL Interview Questions: Tips and Answers
nikhilxd profile

Mastering Oracle SQL Interview Questions: Tips and Answers

#sql #oracle #plsql #interview
2
Comments
2 min read
Multi-Tenant SaaS Architecture - Database Per Tenant
developerpartners profile

Multi-Tenant SaaS Architecture - Database Per Tenant

#dotnet #saas #csharp #sql
3
Comments 1
6 min read
Visualização automática de esquemas de databases do Sqlite
msc2020 profile

Visualização automática de esquemas de databases do Sqlite

#sql #tutorial #beginners #braziliandevs
Comments
7 min read
Crash on clock skew: performance vs availability
franckpachot profile

Crash on clock skew: performance vs availability

#yugabytedb #distributed #sql #database
2
Comments
7 min read
Fetching Data (Next.js)
samuellubliner profile

Fetching Data (Next.js)

#webdev #javascript #sql #nextjs
1
Comments
2 min read
Foreign-key pre-join
esproc_spl profile
Judy

Foreign-key pre-join

#sql #join #development #lauguage
6
Comments
5 min read
⚡️ Gowebly CLI now supports the PocketBase framework
koddr profile

⚡️ Gowebly CLI now supports the PocketBase framework

#news #go #webdev #sql
7
Comments 1
2 min read
Introdução aos Princípios do SQL: Fundamentos Teóricos e Práticos
brunopizol profile

Introdução aos Princípios do SQL: Fundamentos Teóricos e Práticos

#sql #braziliandevs #dotnet #mysql
7
Comments
17 min read
OLAP: CUBE, ROLLUP, AND GROUPING SETS
marklouisalter profile

OLAP: CUBE, ROLLUP, AND GROUPING SETS

#database #sql #mysql #postgres
2
Comments 1
4 min read
Advisory/Custom/Application Lock with YugabyteDB
franckpachot profile

Advisory/Custom/Application Lock with YugabyteDB

#yugqbytedb #distributed #sql #database
Comments
5 min read
Journey to modern databases
adammetis profile

Journey to modern databases

#sql #database #monitoring #observability
Comments
9 min read
DynamoDB Query Evaluation Order Differs from SQL
siddhantkcode profile

DynamoDB Query Evaluation Order Differs from SQL

#database #learning #sql #aws
4
Comments
2 min read
SQL Join Types Explained: Inner, Outer, and More in 2024
nikhilxd profile

SQL Join Types Explained: Inner, Outer, and More in 2024

#sql #programming #computerscience #database
1
Comments
2 min read
Streamlining Node Property Data Retrieval in Umbraco: A Quick Guide
shekhartarare profile

Streamlining Node Property Data Retrieval in Umbraco: A Quick Guide

#umbraco #sql #tutorial
Comments
2 min read
SQL's LIKE, ILIKE, and NOT LIKE: Beginner's Breakdown
marklouisalter profile

SQL's LIKE, ILIKE, and NOT LIKE: Beginner's Breakdown

#sql #mysql #database #postgres
5
Comments
2 min read
A lightweight YugabyteDB docker image for CI/CD
franckpachot profile

A lightweight YugabyteDB docker image for CI/CD

#yugabyteb #docker #distributed #sql
Comments
2 min read
Dimension alignment
esproc_spl profile
Judy

Dimension alignment

#sql #development #join #programming
5
Comments 1
4 min read
Top 10 most asked SQL interview questions along with their answers
nikhilxd profile

Top 10 most asked SQL interview questions along with their answers

#sql #database #computerscience #career
1
Comments 2
3 min read
How does Wave Analytics handle data from external databases in PostgreSQL?
shiviyer profile

How does Wave Analytics handle data from external databases in PostgreSQL?

#postgres #sql #dba
Comments
3 min read
Using T-SQL To Generate Large Amounts Of Test Data
jzuerlein profile

Using T-SQL To Generate Large Amounts Of Test Data

#sql #testing
Comments
1 min read
Understanding JDBC Three-Tier Architecture: A Detailed Overview
nikhilxd profile

Understanding JDBC Three-Tier Architecture: A Detailed Overview

#java #jdbc #springboot #sql
1
Comments
3 min read
Complete Guide To Transaction Isolation Levels in SQL
antonmartyniuk profile

Complete Guide To Transaction Isolation Levels in SQL

#programming #database #sql
Comments
7 min read
Common Table Expressions (CTEs) in SQL
johnkyalo profile

Common Table Expressions (CTEs) in SQL

#database #datascience #sql #analytics
3
Comments
1 min read
Flask and APIs
whoamivoyager profile

Flask and APIs

#webdev #flask #sql #python
Comments
3 min read
Exploring SQL Functions: Harnessing the Power of Built-in Functions
tinapyp profile

Exploring SQL Functions: Harnessing the Power of Built-in Functions

#datascience #database #sql #beginners
Comments
3 min read
Are There “Queries over Trillion-Row Tables in Seconds”? Is “N-Times Faster Than ORACLE” an Exaggeration?
jbx1279 profile

Are There “Queries over Trillion-Row Tables in Seconds”? Is “N-Times Faster Than ORACLE” an Exaggeration?

#sql #performance #bigdata #database
Comments
4 min read
Scheduling a BigQuery SQL script, using Apache Airflow, with an example
rajun profile

Scheduling a BigQuery SQL script, using Apache Airflow, with an example

#airflow #bigquery #dataengineering #sql
8
Comments 1
2 min read
HackerRank SQL preparation; Revising the Select Query II(MySQL)
christianpaez profile

HackerRank SQL preparation; Revising the Select Query II(MySQL)

#sql #writeups #hackerrank
1
Comments
1 min read
Exploring Advanced SQL Techniques: Aggregation Methods for Structured Data Retrieval
emtiajium profile

Exploring Advanced SQL Techniques: Aggregation Methods for Structured Data Retrieval

#postgres #sql #database
33
Comments 1
4 min read
SQL Server Basics
quyit profile

SQL Server Basics

#sql #sqlserver #nqdev
Comments
6 min read
How I migrated from Firebase to Supabase
ja profile

How I migrated from Firebase to Supabase

#postgres #sql #firebase #webdev
21
Comments 2
5 min read
Using Temporary Tables in MariaDB
alejandro_du profile

Using Temporary Tables in MariaDB

#mariadb #sql #database #tips
3
Comments
2 min read
A tale of TimescaleDB, SQLx and testing in Rust
exein profile
Exein

A tale of TimescaleDB, SQLx and testing in Rust

#security #rust #sql #testing
2
Comments 1
18 min read
The Essential Guide to Database Backup: Tips & Strategies
adammetis profile

The Essential Guide to Database Backup: Tips & Strategies

#sql #database #backup
1
Comments
11 min read
Quick SQL guide and cheat sheet: Essential Commands
dbvismarketing profile

Quick SQL guide and cheat sheet: Essential Commands

#sql
Comments
1 min read
Find increases, latest values, and cumulative sums in SQL (postgres)
jasonstitt profile

Find increases, latest values, and cumulative sums in SQL (postgres)

#sql #postgres #database #tutorial
Comments
7 min read
INTRODUCTION TO SQL
marklouisalter profile

INTRODUCTION TO SQL

#sql #mysql #postgres #database
1
Comments 2
4 min read
Tracking Personal Finances with SQL: Learn As You Manage Your Money!
yisakt profile

Tracking Personal Finances with SQL: Learn As You Manage Your Money!

#sql #database #personalfinance
7
Comments
2 min read
SQL | DDL, DQL, DML, DCL and TCL Commands
rakeshvngowda profile

SQL | DDL, DQL, DML, DCL and TCL Commands

#sql #database
6
Comments
2 min read
A Software Engineer's Tips and Tricks #1: Drizzle
alisdairbr profile

A Software Engineer's Tips and Tricks #1: Drizzle

#webdev #sql #orm #tutorial
2
Comments 1
2 min read
Tutorial Duckdb
fsimoes profile

Tutorial Duckdb

#duckdb #sql #python
1
Comments 1
6 min read
Widget Dashboards via Wizard's Toolkit
alecbsherman profile
Alec

Widget Dashboards via Wizard's Toolkit

#webdev #lowcode #php #sql
Comments
3 min read
What is SQL in pictures. Diving deeper (Part 2)
onumaku_bobby profile

What is SQL in pictures. Diving deeper (Part 2)

#sql #datascience
1
Comments
2 min read
Optimizing ClickHouse Performance: Strategies for Identifying and Reducing Over-fetching in SELECT Queries
shiviyer profile

Optimizing ClickHouse Performance: Strategies for Identifying and Reducing Over-fetching in SELECT Queries

#clickhouse #sql #dba #olap
2
Comments
3 min read
SQL DATA MANIPULATION
marklouisalter profile

SQL DATA MANIPULATION

#sql #database #mysql #postgressql
2
Comments
3 min read
5 Best SQL IDEs [EXPERT RANKING]
domfive profile

5 Best SQL IDEs [EXPERT RANKING]

#sql #sqlserver #learning #review
Comments
13 min read
JOINS IN SQL
johnkyalo profile

JOINS IN SQL

#datascience #database #sql #data
2
Comments
2 min read
How to Back Up and Restore Azure SQL Databases
alex_tray profile

How to Back Up and Restore Azure SQL Databases

#azure #sql #database #backup
1
Comments
8 min read
How to calculate the distance between Kyoto and Tokyo using a PostgreSQL database?
dm8ry profile

How to calculate the distance between Kyoto and Tokyo using a PostgreSQL database?

#postgres #database #sql #howto
3
Comments 1
2 min read
Configuring Statement Timeout in PostgreSQL for Optimal Performance Management
shiviyer profile

Configuring Statement Timeout in PostgreSQL for Optimal Performance Management

#postgres #sql #dbatips #dba
17
Comments
2 min read
Optimizing SQL Performance: Best Practices for Efficient Database Operations
tinapyp profile

Optimizing SQL Performance: Best Practices for Efficient Database Operations

#sql #database #beginners #datascience
Comments
3 min read
About transaction identifier (transaction_id) in PostgreSQL.
dm8ry profile

About transaction identifier (transaction_id) in PostgreSQL.

#postgres #devops #database #sql
9
Comments
2 min read
Platform Engineers Must Change Developers and Databases - And Here Is How
adammetis profile

Platform Engineers Must Change Developers and Databases - And Here Is How

#sql #database #monitoring #platformengineering
Comments
9 min read
Statistical information about tables in a PostgreSQL Database.
dm8ry profile

Statistical information about tables in a PostgreSQL Database.

#postgres #database #sql #devops
3
Comments
2 min read
Understanding of NULL in PostgreSQL database.
dm8ry profile

Understanding of NULL in PostgreSQL database.

#postgressql #database #sql #howto
3
Comments
2 min read
PostgreSQL: Deleting all records from a table, except for the first and last ones.
dm8ry profile

PostgreSQL: Deleting all records from a table, except for the first and last ones.

#postgres #database #sql #data
3
Comments
2 min read
How to find the third and fifth-highest values in a PostgreSQL table?
dm8ry profile

How to find the third and fifth-highest values in a PostgreSQL table?

#postgres #database #howto #sql
2
Comments
2 min read
loading...