Skip to content

DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Nov 24 '25

MyScaleDB: Why Vector Databases Need SQL (The 2025 Reality Check)

#database #vectordatabase #sql #architecture

10 min read

Oct 21 '25

I Built a Tool to Turn Any SQL Dump File into a Live Database in Seconds

#database #sql #webdev #productivity

2 min read

Arif Basri

Oct 20 '25

How did I learn about Transaction Log, Redo Log, and Undo Log as a developer?

#learning #sql #database #performance

1 min read

InterSystems Developer for InterSystems

Oct 21 '25

Building a FHIR Vector Repository with InterSystems IRIS and Python through the IRIStool module

#fhir #python #sql #vectordatabase

5 min read

Nicolas Bonnici

Nov 12 '25

GoREST is dead...

#go #sql

4 min read

MindsDB Team for MindsDB

Oct 20 '25

The Future of Data-Native & Grounded AI with MindsDB: Moving Data to Models No Longer Makes Sense

#sql #datascience #ai #development

8 min read

Oct 20 '25

Entenda os JOINS no SQL e como aplicar certo tipo para cada cenário

#database #sql #tutorial

1 min read

Peter + AI

Nov 23 '25

Leveraging Service Stored Procedures (SSPs) in Uniface 10.4

#uniface #sql #legacy #performance

3 min read

Oct 20 '25

Commenting in MySQL: Syntax, Hints, and Practical Examples

#sql #mysql

2 min read

Nov 23 '25

Data Locality vs. Independence (NoSQL vs. SQL)

#mongodb #database #sql #nosql

10 min read

Nov 23 '25

The SQL Concept You Probably Missed: Materialized Views

#sql #webdev #programming

4 min read

Franck Pachot for MongoDB

Nov 17 '25

Nested Loop and Hash Join for MongoDB $lookup

#mongodb #document #sql #database

10 min read

Oct 19 '25

🧠 SQL for Beginners: The 10 Most Common Queries Explained

#sql #sqlserver #mariadb #database

3 min read

Ayako yk

Oct 18 '25

PL/SQL Program Data: Naming, Declaring, and Best Practices

#beginners #learning #database #sql

3 min read

Franck Pachot for MongoDB

Nov 21 '25

INNER JOIN and LEFT OUTER JOIN in MongoDB (with $lookup and $unwind)

#mongodb #database #sql #join

8 min read

Marko

Nov 21 '25

The Offline Data Engineer: Building Resilient API Pipelines that Work on an Airplane

#python #dataengineering #api #sql

5 min read

Oct 22 '25

Advanced Query Capabilities 👉🏻 aggregation pipelines

#database #mongodb #sql

4 min read

Yevhen Kozachenko 🇺🇦

Oct 17 '25

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

#sql #webdev #performance #database

3 min read

Erlan Akbaraliev

Nov 10 '25

База Данных

#beginners #tutorial #database #sql

4 min read

Aisalkyn Aidarova

Nov 20 '25

Why Couchbase Is the NoSQL Solution for Demanding Applications

#distributedsystems #database #sql #performance

5 min read

Shahab Ranjbary

Oct 30 '25

🧠 ClickHouse LEFT JOINs: Why join_use_nulls Matters

#clickhouse #sql #dataengineering #join

2 min read

jorin

Oct 17 '25

Getting Started Building a Data Platform

#dataengineering #database #sql

3 min read

Erlan Akbaraliev

Nov 21 '25

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

#sql #database #tutorial #beginners

2 min read

Smyekh David-West

Oct 28 '25

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

#oracle #ai #sql #tutorial

14 min read

reshma p

Oct 16 '25

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

#dotnet #sql #tutorial #machinelearning

3 min read

loading...