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
Saving Game Data in Unity — Part 4: SQLite
rahul_barate_e965377330fe profile

Saving Game Data in Unity — Part 4: SQLite

#gamedev #unity3d #sql #programming
1
Comments
3 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
The Missing Layer Between Data and AI Agents
hoshang_mehta profile

The Missing Layer Between Data and AI Agents

#ai #database #sql
1
Comments
13 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
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
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
Comments
1 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.