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.
База Данных

База Данных

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
Cover image for 🧠 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
Cover image for 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
Cover image for Detecting Sales Anomalies with ML.NET — Razor Dashboard + SQL Integration

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

1
Comments
3 min read
SQL as Contract vs. Python as Procedure — a Short Note on Atlas vs. Alembic
Cover image for 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
Cover image for 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
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
Cover image for 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
Cover image for 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)
Cover image for 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
🏦 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
🐬 MySQL — The Complete Guide for Developers (2025 Edition)
Cover image for 🐬 MySQL — The Complete Guide for Developers (2025 Edition)

🐬 MySQL — The Complete Guide for Developers (2025 Edition)

Comments
4 min read
Database Normalization: From 1NF to 3NF

Database Normalization: From 1NF to 3NF

Comments
2 min read
Cursor +Trigger

Cursor +Trigger

Comments
2 min read
loading...