close

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.
Six SQL patterns I use to catch transaction fraud
fixelsmith profile

Six SQL patterns I use to catch transaction fraud

#sql #analytics #frauddetection #database
Comments
8 min read
PostgreSQL Benchmarking Tool & SQLite Internals: API Error Handling, Join Optimization
soytuber profile
soy

PostgreSQL Benchmarking Tool & SQLite Internals: API Error Handling, Join Optimization

#database #sql #sqlite
Comments
3 min read
Oracle AI Database 26ai: Relational Integrity, Vector Search, and AI-Ready Financial Workflows
yurii_dobrytsia profile

Oracle AI Database 26ai: Relational Integrity, Vector Search, and AI-Ready Financial Workflows

#ai #oracle #sql #database
Comments
10 min read
Refreshing PostgreSQL Materialized Views Without Downtime
data_with_jelimo profile

Refreshing PostgreSQL Materialized Views Without Downtime

#database #performance #postgres #sql
Comments
7 min read
JDBC vs JPA: Which Should You Use?
chi25 profile

JDBC vs JPA: Which Should You Use?

#java #software #sql #programming
Comments
4 min read
Your AI database agent does not know what revenue means
mads_hansen_27b33ebfee4c9 profile

Your AI database agent does not know what revenue means

#mcp #database #ai #sql
Comments
2 min read
Design review: Live SQL queries on PostgreSQL
oxharris profile

Design review: Live SQL queries on PostgreSQL

#postgres #sql #database #javascript
Comments
2 min read
We built an enterprise integration stack for .NET from scratch: EAV + DSL + runtime
rinat_kozin_d0a2ef43e7824 profile

We built an enterprise integration stack for .NET from scratch: EAV + DSL + runtime

#dotnet #sql #postgres #architecture
Comments
5 min read
Multi-Tenant SQL Reporting: How to Show Each Customer Only Their Own Data
vivekdraxlr profile

Multi-Tenant SQL Reporting: How to Show Each Customer Only Their Own Data

#sql #database #postgres #webdev
Comments 1
5 min read
AI agents know SQL. Oracle Database Skills teach them Oracle
mark_nelson_oracle profile

AI agents know SQL. Oracle Database Skills teach them Oracle

#agents #ai #database #sql
Comments 1
8 min read
Understanding SQL query structure
weenaithdev profile

Understanding SQL query structure

#beginners #database #sql #tutorial
Comments
1 min read
ClickHouse JOINs Aren't Slow Anymore (You're Reading 2020's Docs)
aman_puri_115f49d5ad3612d profile

ClickHouse JOINs Aren't Slow Anymore (You're Reading 2020's Docs)

#clickhouse #database #performance #sql
Comments
6 min read
SQLite Corruption in Sandboxes, PostgreSQL Caching, & Rust DB Proxy Architecture
soytuber profile
soy

SQLite Corruption in Sandboxes, PostgreSQL Caching, & Rust DB Proxy Architecture

#database #sql #sqlite
Comments
3 min read
Broadcast Joins vs. Sort-Merge Joins: Choosing the Right Join Strategy in Apache Spark
hvardhan28 profile

Broadcast Joins vs. Sort-Merge Joins: Choosing the Right Join Strategy in Apache Spark

#apachespark #sql #joins
Comments
3 min read
Database AI Agents: A Paradigm Shift in Proactive Database Management
pranith_m_05c4bc7561a6ffd profile

Database AI Agents: A Paradigm Shift in Proactive Database Management

#ai #sql #mysql #agentskills
Comments
20 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.