Skip to content

DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Aditya Pratap Bhuyan

Apr 8

SQL vs NoSQL for Large Tables: Choosing the Right Database for Big Data Applications

#bigdata #largetables #sql #nosql

6 min read

Apr 7

Building Weekly Historical Insights with SQL Server, Python, SQLite, and Power BI

#python #sql #sqlite #powerfuldevs

1 min read

Vahid Yousefzadeh

Apr 7

Oracle 23ai — Automatic SQL Transpiler Feature

#sql #oracle #database #linux

1 min read

orlando ramirez

Apr 7

Building an ELT Pipeline with Python and SQL Server: A Netflix Dataset Walkthrough

#python #sql #elt

6 min read

Matthias

Apr 6

Basics of Animal Tracking Databases: Crafting the Schema

#animaltracking #gps #sql #postgres

4 min read

Vasiliy Zakharchenko

Apr 6

Pagination with COUNT(*) OVER() in Atlassian Forge SQL: How to avoid double queries — and stay secure in TypeScript

#atlassian #forge #drizzle #sql

2 min read

Judy

Apr 7

Deduplicate between an uncertain number of columns：SQL VS SPL #15

#sql #programming #devops #esproc

2 min read

Apr 6

I Made a Detective Game That Teaches You SQL

#sql #beginners #webdev #gamedev

2 min read

Khushii

Apr 5

SQL vs. NoSQL: Key Differences Explained

#techtalks #sql #nosql #database

1 min read

Meghana N

Apr 4

Hacker rank's Median SQL Solution

#sql #hackerrank #tircky #programming

3 min read

Mike Houngbadji

Apr 4

DuckDB 🦆 : Libérez le puissant moteur de Requêtes

#french #sql #database #analytics

8 min read

Benedetto Proietti

Apr 3

(Beyond) The Art of Database Indexing

#schema #nosql #sql #bigdata

3 min read

Benedetto Proietti

Apr 3

Desire for Structure (read “SQL”)

#schema #nosql #sql #bigdata

10 min read

Apr 3

SQL Temporary Tables: A Quick and Practical Guide

#sql

2 min read

Matt Luo for Convex Champions

Apr 7

Beyond SQL: How Convex Reimagines the Modern Database — A ClarityText Startup Story

#typescript #database #sql #webdev

7 min read

Mike Houngbadji

Apr 4

DuckDB 🦆: Unleashing the Powerhouse Query Engine Within

#duckdb #sql #database #performance

6 min read

Elayaraj C

Apr 2

DAY-8 PSQL, Difference Function vs. Procedure

#sql

2 min read

Apr 6

A case where SQL joins struggle but MongoDB documents shine

#mongodb #postgres #sql #database

8 min read

Apr 2

How Indexes Really Work

#database #sql #webdev #programming

5 min read

Ayra Jett for Bytebase

Apr 2

Postgres 🐘 vs. SQL Server: a Complete Comparison ⚖️ in 2025

#postgres #sqlserver #database #sql

7 min read

Elayaraj C

Apr 1

DAY-7 PRIMARY KEY,FOREIGN KEY,INDEX,TRANSACTION

#sql

2 min read

João Gabriel Zó

Mar 31

Como bancos de dados realmente salvam os dados

#database #computerscience #programming #sql

3 min read

Mar 31

Why I Built USPL: Helping GPT Understand Multi-Table SQL

#chatgpt #llm #sql #opensource

2 min read

arno kiru

Mar 31

INTRODUCTION TO DATA ANALYTICS

#python #dataanalytics #sql #tooling

2 min read

Judith-Data-Processing-Hacks

Apr 2

Calculate all the year/months included in the year/month interval — From SQL to SPL #15

#programming #datascience #sql #esprocspl

2 min read

loading...