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.
😱 Stop Writing Useless SQL Queries! Discover the Secret Powers of Window Functions
ekwoster profile

😱 Stop Writing Useless SQL Queries! Discover the Secret Powers of Window Functions

#sql #webdev #performance #database
Comments
3 min read
База Данных
erlan_akbar profile

База Данных

#beginners #tutorial #database #sql
Comments
4 min read
Why Couchbase Is the NoSQL Solution for Demanding Applications
jumptotech profile

Why Couchbase Is the NoSQL Solution for Demanding Applications

#distributedsystems #database #sql #performance
2
Comments
5 min read
🧠 ClickHouse LEFT JOINs: Why join_use_nulls Matters
ranjbaryshahab profile

🧠 ClickHouse LEFT JOINs: Why join_use_nulls Matters

#clickhouse #sql #dataengineering #join
5
Comments
2 min read
Getting Started Building a Data Platform
jorinvo profile

Getting Started Building a Data Platform

#dataengineering #database #sql
Comments
3 min read
База Данных 2 Практика
erlan_akbar profile

База Данных 2 Практика

#sql #database #tutorial #beginners
Comments
2 min read
Beyond Text: Building an AI-Powered Color Matcher in Oracle FreeSQL
smyekh profile

Beyond Text: Building an AI-Powered Color Matcher in Oracle FreeSQL

#oracle #ai #sql #tutorial
3
Comments
14 min read
Detecting Sales Anomalies with ML.NET — Razor Dashboard + SQL Integration
reshma_p_f93cbf8b077366c6 profile

Detecting Sales Anomalies with ML.NET — Razor Dashboard + SQL Integration

#dotnet #sql #tutorial #machinelearning
Comments
3 min read
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
Understanding Oracle Datetime Datatypes: DATE, TIMESTAMP, and INTERVAL
ayako_yk profile

Understanding Oracle Datetime Datatypes: DATE, TIMESTAMP, and INTERVAL

#beginners #database #learning #sql
3
Comments
3 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
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
18
Comments
10 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
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
Implementing Hierarchical Data Structures in PostgreSQL: LTREE vs Adjacency List vs Closure Table
dowerdev profile

Implementing Hierarchical Data Structures in PostgreSQL: LTREE vs Adjacency List vs Closure Table

#database #postgres #sql
Comments
18 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
Your ORM is Lying to You About SQL (CTEs Explained)
pascal_cescato_692b7a8a20 profile

Your ORM is Lying to You About SQL (CTEs Explained)

#sql #database #performance #productivity
5
Comments
8 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
Stop Blaming Doctrine - Start Understanding It
jszutkowski profile

Stop Blaming Doctrine - Start Understanding It

#php #doctrine #performance #sql
3
Comments 3
6 min read
loading...