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.
Shadow-Gate Your LLM-Generated SQL: A Replay Test Against a Frozen Fixture Database
dataio_4921 profile

Shadow-Gate Your LLM-Generated SQL: A Replay Test Against a Frozen Fixture Database

#sql #testing #ai #tutorial
Comments
6 min read
LeetCode Problem Statements Be Testing My English More Than SQL
saamiabbaskhan profile

LeetCode Problem Statements Be Testing My English More Than SQL

#discuss #leetcode #sql #programming
7
Comments 1
1 min read
Spider 2.0 deleted a claim I made this morning
ashish_sinha_5241c7673d93 profile

Spider 2.0 deleted a claim I made this morning

#sql #ai #database #python
Comments 3
5 min read
Database Scaling, Explained by Breaking Things: Indexing, Replication, Caching

Interactive simulators let you break systems first
devopsdaily profile

Database Scaling, Explained by Breaking Things: Indexing, Replication, Caching

#database #systemdesign #sql #caching
15
Comments 5
5 min read
A New Model Dropped. Is It Actually Good at Your SQL? A 30-Minute Smoke Test
dataio_4921 profile

A New Model Dropped. Is It Actually Good at Your SQL? A 30-Minute Smoke Test

#ai #sql #testing #opensource
Comments
4 min read
The text-to-SQL demo takes an afternoon. The other 90% is why you should buy it.
omer_hochman profile

The text-to-SQL demo takes an afternoon. The other 90% is why you should buy it.

#sql #database #ai #webdev
Comments 1
3 min read
MariaDB 12 Broke Our Concurrent Updates: Debugging ERROR 1020 After an Upgrade
dkelxldk profile

MariaDB 12 Broke Our Concurrent Updates: Debugging ERROR 1020 After an Upgrade

#database #debugging #sql
Comments 2
2 min read
Running the same SQL checks in a browser, CLI and pull request
milekv profile

Running the same SQL checks in a browser, CLI and pull request

#sql #github #typescript #opensource
1
Comments
3 min read
Your companies table is lying to you about when things happened
corpdigest profile

Your companies table is lying to you about when things happened

#database #sql #datascience
Comments
2 min read
SEQUENCE vs IDENTITY in SQL Server: Choosing the Right Auto-Increment
tygryso profile

SEQUENCE vs IDENTITY in SQL Server: Choosing the Right Auto-Increment

#sqlserver #database #sql #olap
1
Comments
6 min read
Getting into SQL For Beginners:
ian_munene profile

Getting into SQL For Beginners:

#sql #database #beginners
1
Comments 1
4 min read
# 🔬 PostgreSQL Internals: What Is Actually Inside an 8 KB Page?
ahmedraza_fyntune profile

# 🔬 PostgreSQL Internals: What Is Actually Inside an 8 KB Page?

#database #webdev #postgres #sql
Comments
5 min read
From Raw Tables to Business Insights: A SQL Workflow Every SaaS Team Can Use
vivekdraxlr profile

From Raw Tables to Business Insights: A SQL Workflow Every SaaS Team Can Use

#sql #database #analytics #tutorial
Comments
5 min read
How to Comment in SQL: -- and /* */, and the Two Traps That Break a Query
michaelnocito profile

How to Comment in SQL: -- and /* */, and the Two Traps That Break a Query

#sql #database #tutorial #beginners
Comments
9 min read
SQL for Beginners: Window Functions vs GROUP BY
mysticg profile

SQL for Beginners: Window Functions vs GROUP BY

#beginners #database #sql #tutorial
1
Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.