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.
How to Build an agent using coral
tejaswahinduja profile

How to Build an agent using coral

#agents #ai #sql #tutorial
Comments 1
7 min read
I didn't have a PC for my database class, so I built my own T-SQL Sandbox in the browser
abdiel_ortega_5866744e706 profile

I didn't have a PC for my database class, so I built my own T-SQL Sandbox in the browser

#showdev #sql #webdev #productivity
1
Comments
2 min read
SiteRows example #1:
michael_ozersky_9624310ec profile

SiteRows example #1:

#showdev #python #sql #webscraping
Comments
1 min read
Building a Denim Collection API: A Practical Guide to Handling Product Variants
dylan_parker123 profile

Building a Denim Collection API: A Practical Guide to Handling Product Variants

#api #database #sql #tutorial
2
Comments 2
2 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
SQL-like Queries in FSRS Plugin for Obsidian
evgenekopylov profile

SQL-like Queries in FSRS Plugin for Obsidian

#showdev #productivity #sql #rust
Comments
4 min read
Pandas vs SQL, when to use each
iwtlp profile

Pandas vs SQL, when to use each

#pandas #sql #dataanalysis
Comments
2 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
How to Query Your Database in Plain English (No SQL Required)
abda_net profile

How to Query Your Database in Plain English (No SQL Required)

#ai #sql #database #devops
3
Comments
4 min read
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 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
SQL + AI: Real-World Database Solutions You Can Use Today
andrecarbajal profile

SQL + AI: Real-World Database Solutions You Can Use Today

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