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

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

Comments
3 min read
База Данных

База Данных

Comments
4 min read
Why Couchbase Is the NoSQL Solution for Demanding Applications

Why Couchbase Is the NoSQL Solution for Demanding Applications

2
Comments
5 min read
🧠 ClickHouse LEFT JOINs: Why join_use_nulls Matters

🧠 ClickHouse LEFT JOINs: Why join_use_nulls Matters

5
Comments
2 min read
Getting Started Building a Data Platform

Getting Started Building a Data Platform

Comments
3 min read
База Данных 2 Практика

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

Comments
2 min read
Beyond Text: Building an AI-Powered Color Matcher in Oracle FreeSQL

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

3
Comments
14 min read
Detecting Sales Anomalies with ML.NET — Razor Dashboard + SQL Integration

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

Comments
3 min read
SQL as Contract vs. Python as Procedure — a Short Note on Atlas vs. Alembic

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

Comments 1
2 min read
Beginner-Friendly PL/SQL and JavaScript MLE Examples for Oracle 26ai

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

10
Comments 1
2 min read
Strategies to Analyze Any Size Dataset with LLMs Beyond its Context Limit

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

2
Comments
2 min read
Understanding Oracle Datetime Datatypes: DATE, TIMESTAMP, and INTERVAL

Understanding Oracle Datetime Datatypes: DATE, TIMESTAMP, and INTERVAL

3
Comments
3 min read
ChatGPT Alternative for SQL Query Optimization

ChatGPT Alternative for SQL Query Optimization

5
Comments
2 min read
The Six Failures of Text-to-SQL (And How to Fix Them with Agents)

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

18
Comments
10 min read
Trying to start using graphql and psql using pytthon to start a website

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

2
Comments
1 min read
Making SQL Queries Clearer with Aliases

Making SQL Queries Clearer with Aliases

Comments
2 min read
Undo Redo Database Queries

Undo Redo Database Queries

Comments
25 min read
Implementing Hierarchical Data Structures in PostgreSQL: LTREE vs Adjacency List vs Closure Table

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

Comments
18 min read
Query Anything with SQL: Your Developer's Deep Dive into Apache Drill

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

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

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

1
Comments
7 min read
Your ORM is Lying to You About SQL (CTEs Explained)

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

5
Comments
8 min read
SQL Transactions — The Complete Guide (Internals, ACID, Isolation, Locks, Logs, and Real-World Code)

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

Comments
4 min read
🏦 Database Magic: Automating Tasks with Cursor and Trigger ✨

🏦 Database Magic: Automating Tasks with Cursor and Trigger ✨

Comments
3 min read
py schema

py schema

Comments
2 min read
Stop Blaming Doctrine - Start Understanding It

Stop Blaming Doctrine - Start Understanding It

3
Comments 3
6 min read
loading...