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.
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
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
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
👋 Sign in for the ability to sort posts by relevant, latest, or top.