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.
Mastering Postgres Window Functions for Data Analysis in Supabase
timothy_malche_56945869fc profile

Mastering Postgres Window Functions for Data Analysis in Supabase

#webdev #database #sql #backend
8
Comments
16 min read
SQL GROUP BY Explained with Examples
roxana_haidiner profile

SQL GROUP BY Explained with Examples

#sql #database #mysql #postgres
6
Comments
4 min read
Building Self-Correcting LLM Systems: The Evaluator-Optimizer Pattern
clayroach profile

Building Self-Correcting LLM Systems: The Evaluator-Optimizer Pattern

#ai #llm #sql #observability
1
Comments 1
6 min read
Data Integrity First: Mastering Transactions in Supabase SQL for Reliable Applications
damasosanoja profile

Data Integrity First: Mastering Transactions in Supabase SQL for Reliable Applications

#supabase #postgressql #database #sql
11
Comments 1
19 min read
Why I Ditched SSMS for VS Code's MSSQL Extension (And Never Looked Back)
shiva_shanker_k profile

Why I Ditched SSMS for VS Code's MSSQL Extension (And Never Looked Back)

#vscode #sqlserver #sql #database
31
Comments
4 min read
Beyond Functional: Writing Professional and Performant SQL Queries
gregory42266270 profile

Beyond Functional: Writing Professional and Performant SQL Queries

#database #performance #sql
3
Comments
2 min read
Database Security Patterns for Web Applications
vanessamadison profile

Database Security Patterns for Web Applications

#database #security #sql #backend
Comments
2 min read
SQLite dot commands: Output mode separator command
mr_destructive profile

SQLite dot commands: Output mode separator command

#sql #sqlite #database #programming
2
Comments
2 min read
The main tasks of a Database Administrator (DBA) by 2025
leandro_nnz profile

The main tasks of a Database Administrator (DBA) by 2025

#database #dba #sql
5
Comments
27 min read
SQLite dot commands: Output mode
mr_destructive profile

SQLite dot commands: Output mode

#sql #sqlite #database #programming
2
Comments
9 min read
How to Migrate Your On-Premise Database to Google Cloud SQL? A Detailed Guide
mehul_budasana profile

How to Migrate Your On-Premise Database to Google Cloud SQL? A Detailed Guide

#googlecloud #gcp #sql #database
6
Comments
5 min read
Associações polimórficas no Rails: como fazer, prós e contras
pedroleo profile

Associações polimórficas no Rails: como fazer, prós e contras

#ruby #rails #sql #development
17
Comments 3
4 min read
Why I Built an "Awesome List" for Data Analysis (And How It Can Help You)
pavelgrigoryev profile

Why I Built an "Awesome List" for Data Analysis (And How It Can Help You)

#datascience #beginners #sql #python
5
Comments
2 min read
Building SW: Lessons from the Backend
ryansgi profile

Building SW: Lessons from the Backend

#go #opensource #webdev #sql
4
Comments
8 min read
Automating Old Partition Cleanup in Oracle with PL/SQL
mrcaption49 profile

Automating Old Partition Cleanup in Oracle with PL/SQL

#automation #database #sql
6
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.