Forem

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.
SchemaSpy vs SchemaCrawler - Which Database Documentation Tool is Right for You?
sualeh profile

SchemaSpy vs SchemaCrawler - Which Database Documentation Tool is Right for You?

#database #devops #sql #opensource
5
Comments 2
3 min read
SQLite Internals, PostgreSQL Performance & Multi-Tenancy Patterns
soytuber profile
soy

SQLite Internals, PostgreSQL Performance & Multi-Tenancy Patterns

#database #sql #sqlite
Comments
3 min read
How I Built an End-to-End HR Attrition Dashboard Using MySQL & Power BI
Cover image for How I Built an End-to-End HR Attrition Dashboard Using MySQL & Power BI
wgatusso profile

How I Built an End-to-End HR Attrition Dashboard Using MySQL & Power BI

#businessintelligence #sql #powerbi #dataanalytics
Comments
2 min read
From parser combinators to hand-written TDOP: adopting sqlparser-rs at Readyset
readyset profile

From parser combinators to hand-written TDOP: adopting sqlparser-rs at Readyset

#database #performance #rust #sql
Comments
1 min read
Introducing Oracle Support in Dory
Cover image for Introducing Oracle Support in Dory
doryfinn profile
Finn

Introducing Oracle Support in Dory

#ai #database #sql #oracle
Comments
4 min read
DuckDB Delta, PostgreSQL 17 Migration, & SQLite Optimization Deep Dives
soytuber profile
soy

DuckDB Delta, PostgreSQL 17 Migration, & SQLite Optimization Deep Dives

#database #sql #sqlite
Comments
3 min read
Safer NL2SQL with Select AI and AI Profiles
mark_nelson_oracle profile

Safer NL2SQL with Select AI and AI Profiles

#ai #database #security #sql
Comments
10 min read
What Actually Helped Our Talk-to-DB Agent Stop Relearning the Same SQL
Cover image for What Actually Helped Our Talk-to-DB Agent Stop Relearning the Same SQL
zeeshan_ghazanfar_97 profile

What Actually Helped Our Talk-to-DB Agent Stop Relearning the Same SQL

#agents #llm #rag #sql
Comments
1 min read
How to Use EXPLAIN ANALYZE in PostgreSQL: A Visual Guide
leoj profile
LeoJ

How to Use EXPLAIN ANALYZE in PostgreSQL: A Visual Guide

#postgres #sql #database #performance
Comments
5 min read
How I Built a Live SQL Workshop Where Students Can't Break Anything
hedi22 profile

How I Built a Live SQL Workshop Where Students Can't Break Anything

#sql #development #database #devtool
Comments
6 min read
SQLite Optimization, PostgreSQL Async Queries, & DuckLake Dataframe Spec
soytuber profile
soy

SQLite Optimization, PostgreSQL Async Queries, & DuckLake Dataframe Spec

#database #sql #sqlite
Comments
3 min read
Infinite recursion in Postgres RLS: a SECURITY DEFINER gotcha
bairescodeai profile

Infinite recursion in Postgres RLS: a SECURITY DEFINER gotcha

#postgres #supabase #webdev #sql
Comments
2 min read
Chai aur SQL — A Beginner's Journey into Databases
abdulrdeveloper profile

Chai aur SQL — A Beginner's Journey into Databases

#sql #postgres #database #backend
Comments
7 min read
Why Enterprises Should Not Let LLMs Execute SQL Directly?
_706015150500ca0399b12 profile

Why Enterprises Should Not Let LLMs Execute SQL Directly?

#architecture #llm #security #sql
Comments
1 min read
DuckDB 1.5.2 Release, DuckLake v1.0 & PostgRESTxn for Atomic PG Transactions
soytuber profile
soy

DuckDB 1.5.2 Release, DuckLake v1.0 & PostgRESTxn for Atomic PG Transactions

#database #sql #sqlite
Comments
4 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.