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.
7 Postgres Tools Every AI Engineer Should Know
statewave profile

7 Postgres Tools Every AI Engineer Should Know

#ai #database #postgres #sql
1
Comments
5 min read
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
How to run generative AI on SQL tables with Snowflake Cortex
laura_cristinachicovisd profile

How to run generative AI on SQL tables with Snowflake Cortex

#snowflake #sql #ai #dataengineering
Comments 1
5 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
Pg-Java v1.0 Debuts as New PostgreSQL Driver — Plus SQLite Fix & DuckCon #7
soytuber profile
soy

Pg-Java v1.0 Debuts as New PostgreSQL Driver — Plus SQLite Fix & DuckCon #7

#database #sql #sqlite #opensource
Comments
4 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
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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.