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.
SQL as Contract vs. Python as Procedure — a Short Note on Atlas vs. Alembic
unauthorized profile

SQL as Contract vs. Python as Procedure — a Short Note on Atlas vs. Alembic

#database #sql #architecture #python
Comments 1
2 min read
Beginner-Friendly PL/SQL and JavaScript MLE Examples for Oracle 26ai
rajesh_vohra_e75f579b7888 profile

Beginner-Friendly PL/SQL and JavaScript MLE Examples for Oracle 26ai

#javascript #beginners #database #sql
10
Comments 1
2 min read
Strategies to Analyze Any Size Dataset with LLMs Beyond its Context Limit
exson_joseph profile

Strategies to Analyze Any Size Dataset with LLMs Beyond its Context Limit

#ai #llm #mcp #sql
2
Comments
2 min read
Using CTEs When Your ORM Says No (The Lazy Developer's Survival Guide)
pascal_cescato_692b7a8a20 profile

Using CTEs When Your ORM Says No (The Lazy Developer's Survival Guide)

#sql #database #architecture #performance
4
Comments
14 min read
ChatGPT Alternative for SQL Query Optimization
drupaladmin profile

ChatGPT Alternative for SQL Query Optimization

#webdev #programming #sql #devops
5
Comments
2 min read
Trying to start using graphql and psql using pytthon to start a website
vatsalya_rabari_2ad492f38 profile

Trying to start using graphql and psql using pytthon to start a website

#python #webdev #graphql #sql
2
Comments
1 min read
The Six Failures of Text-to-SQL (And How to Fix Them with Agents)
kweinmeister profile

The Six Failures of Text-to-SQL (And How to Fix Them with Agents)

#googleadk #relationaldatabases #sql #agents
19
Comments
10 min read
Making SQL Queries Clearer with Aliases
dbvismarketing profile

Making SQL Queries Clearer with Aliases

#sql #alias
Comments
2 min read
Undo Redo Database Queries
mohammed-al-ameen profile

Undo Redo Database Queries

#database #postgres #sql #tutorial
Comments
25 min read
MySQL COUNT Scalar Subquery Optimization: The Complete Guide
rebooter_s profile

MySQL COUNT Scalar Subquery Optimization: The Complete Guide

#sql #database #mysql #ai
Comments
4 min read
Query Anything with SQL: Your Developer's Deep Dive into Apache Drill
jennythomas498 profile

Query Anything with SQL: Your Developer's Deep Dive into Apache Drill

#sql #bigdata #database
Comments
8 min read
SQL is King, But is it Your Only Ruler? A Developer's Guide to NoSQL
kallileiser profile

SQL is King, But is it Your Only Ruler? A Developer's Guide to NoSQL

#database #nosql #sql
1
Comments
7 min read
SQL Transactions — The Complete Guide (Internals, ACID, Isolation, Locks, Logs, and Real-World Code)
farhadrahimiklie profile

SQL Transactions — The Complete Guide (Internals, ACID, Isolation, Locks, Logs, and Real-World Code)

#sql #database #transactions #programming
Comments
4 min read
🏦 Database Magic: Automating Tasks with Cursor and Trigger ✨
prabavathy_balagurusamy_2 profile

🏦 Database Magic: Automating Tasks with Cursor and Trigger ✨

#database #sql #data #tutorial
Comments
3 min read
py schema
query_filter_591122b53770 profile

py schema

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