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.
0sql: How a Semantic-to-SQL Engine Adds Determinism and Security to Agent-Driven Queries

0sql: How a Semantic-to-SQL Engine Adds Determinism and Security to Agent-Driven Queries

1
Comments
5 min read
Design a key-value store: the system design interview walkthrough

Design a key-value store: the system design interview walkthrough

Comments
17 min read
Design Uber: the ride-sharing system design interview walkthrough

Design Uber: the ride-sharing system design interview walkthrough

Comments
16 min read
Design a distributed message queue: the system design interview walkthrough

Design a distributed message queue: the system design interview walkthrough

Comments
15 min read
Building Branded, Scheduled Reports on InterSystems IRIS with InterSystems Reports: An End-to-End Field Report

Building Branded, Scheduled Reports on InterSystems IRIS with InterSystems Reports: An End-to-End Field Report

Comments
12 min read
Where Does Your Data Actually Go When AI Queries Your Database?

Where Does Your Data Actually Go When AI Queries Your Database?

Comments
6 min read
Design a news feed: the social media feed design interview walkthrough

Design a news feed: the social media feed design interview walkthrough

Comments
15 min read
Design a web crawler: the system design interview walkthrough

Design a web crawler: the system design interview walkthrough

Comments
15 min read
Design Netflix: the video streaming system design interview walkthrough

Design Netflix: the video streaming system design interview walkthrough

Comments
15 min read
Design a distributed cache: the system design interview guide

Design a distributed cache: the system design interview guide

Comments 1
16 min read
Treat product assortment as a data problem, not a catalog spreadsheet

Treat product assortment as a data problem, not a catalog spreadsheet

Comments
5 min read
Web Development or Data Analysis: Which Path Should You Choose?

Web Development or Data Analysis: Which Path Should You Choose?

Comments
8 min read
How to change a primary key that foreign keys already point at

How to change a primary key that foreign keys already point at

Comments
6 min read
Testing a Free AI SQL Assistant Against a Real Schema: A Practical Workflow

Testing a Free AI SQL Assistant Against a Real Schema: A Practical Workflow

4
Comments
4 min read
Your lowest-rated product list may contain highly rated items

Your lowest-rated product list may contain highly rated items

1
Comments 7
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.