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.
What Is SQL Injection? How User Input Can Become a Database Command
aditya_d_sharma profile

What Is SQL Injection? How User Input Can Become a Database Command

#database #programming #security #sql
1
Comments
4 min read
Speeding Up a Slow PL/SQL Routine with BULK COLLECT and FORALL
zahid23saim profile

Speeding Up a Slow PL/SQL Routine with BULK COLLECT and FORALL

#database #performance #sql #tutorial
Comments
3 min read
iris-agentic-dev -- Give Your AI a Live Connection to IRIS, Part 1: The Problem, the Tool, and Getting Started
intersystemsdev profile

iris-agentic-dev -- Give Your AI a Live Connection to IRIS, Part 1: The Problem, the Tool, and Getting Started

#sql #ai #coding #tooling
Comments 1
8 min read
Choose the Reporting Grain Before You Choose the Chart
datplan profile

Choose the Reporting Grain Before You Choose the Chart

#accounting #dataengineering #businessintelligence #sql
Comments 1
3 min read
Postgres Array Column vs Junction Table: What Each One Does to Your ERD
tbson87 profile

Postgres Array Column vs Junction Table: What Each One Does to Your ERD

#database #postgres #sql #architecture
Comments 1
10 min read
Learn SQL by Typing It: Three Browser Database Terminals Compared
devopsdaily profile

Learn SQL by Typing It: Three Browser Database Terminals Compared

#sql #postgres #mongodb #database
17
Comments
5 min read
How to write a cohort retention query in SQL (that actually runs)
sofrito profile

How to write a cohort retention query in SQL (that actually runs)

#sql #analytics #database #datascience
Comments
3 min read
The Gap Between College SQL and Industry Reality When I was in college, I thought I knew databases.
rahmanfrr profile
Rahman

The Gap Between College SQL and Industry Reality When I was in college, I thought I knew databases.

#career #database #interview #sql
Comments
3 min read
Four traps in querying 1.79M Overture Maps records with DuckDB
azorkai profile

Four traps in querying 1.79M Overture Maps records with DuckDB

#duckdb #sql #opendata #dotnet
Comments
4 min read
How I made SQL run inside a single, offline HTML file (no WASM)
aurelionakamura profile

How I made SQL run inside a single, offline HTML file (no WASM)

#javascript #sql #opensource #webdev
Comments 4
3 min read
Why Even Advanced AI Breaks Stock Registers: 12 Years of Snapshot Log Evolution and RDBMS Physics
alexcrazy74 profile

Why Even Advanced AI Breaks Stock Registers: 12 Years of Snapshot Log Evolution and RDBMS Physics

#ai #sql #programming #rdbms
Comments 1
4 min read
Tracking Tableau Server Storage Over Time with PostgreSQL
jungalung profile

Tracking Tableau Server Storage Over Time with PostgreSQL

#postgres #sql #tableau #datavisualiszation
Comments
2 min read
Window Functions Demystified: ROW_NUMBER vs RANK vs DENSE_RANK (Execution Internals)
arpitmbangre profile

Window Functions Demystified: ROW_NUMBER vs RANK vs DENSE_RANK (Execution Internals)

#sql #database #dataengineering #career
Comments 1
2 min read
That VARCHAR(255) Was Never a Decision. It Was a Default.
speccoding profile

That VARCHAR(255) Was Never a Decision. It Was a Default.

#database #sql #postgres #programming
Comments 1
4 min read
Solon Data SQL: Three Layers of Data Access Without the Bloat
solonjava profile

Solon Data SQL: Three Layers of Data Access Without the Bloat

#architecture #database #java #sql
Comments 3
5 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.