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.
SQL Case Files: A Free, Story Driven way to practice SQL
sqlcasefiles profile

SQL Case Files: A Free, Story Driven way to practice SQL

#sql #database #learning #webdev
12
Comments 1
2 min read
Understanding Primary Keys in Relational Databases: A Key to Data Integrity and Fast Lookups
pdobadb profile

Understanding Primary Keys in Relational Databases: A Key to Data Integrity and Fast Lookups

#beginners #database #sql
2
Comments
3 min read
🗄️ SQLite3 in Python
codeneuron profile

🗄️ SQLite3 in Python

#tutorial #beginners #python #sql
Comments
4 min read
Stop Waiting for the Cloud: Building a Hybrid SQL+Python Data Pipeline Locally with DuckDB
markolekic profile

Stop Waiting for the Cloud: Building a Hybrid SQL+Python Data Pipeline Locally with DuckDB

#python #sql #dataengineering #tooling
Comments
5 min read
LLMSQL&Arabic WikiTableQA&Payment-SQL：SQL Dataset(202510)
rebooter_s profile

LLMSQL&Arabic WikiTableQA&Payment-SQL：SQL Dataset(202510)

#sql #llm #machinelearning #datascience
1
Comments
5 min read
How We Reduced 98.9% Load Time for a Tableau Dashboard: Optimizing OR Conditions with the IN Function
thedatageek profile

How We Reduced 98.9% Load Time for a Tableau Dashboard: Optimizing OR Conditions with the IN Function

#analytics #tutorial #performance #sql
5
Comments
7 min read
Run Your AI Agent with InterSystems IRIS and Local Models using Ollama
intersystemsdev profile

Run Your AI Agent with InterSystems IRIS and Local Models using Ollama

#ai #python #sql #webdev
1
Comments
3 min read
When Your Database Became a Library: Guide to PostgreSQL Indexes
igornosatov_15 profile

When Your Database Became a Library: Guide to PostgreSQL Indexes

#postgres #sql #database #performance
1
Comments
13 min read
Automate PostgreSQL & MySQL Database Management on Linux Servers
anshikaila profile

Automate PostgreSQL & MySQL Database Management on Linux Servers

#n8n #database #linux #sql
1
Comments
2 min read
Database Indexing Done Right: Why Your "Optimized" Queries Might Be Slower Than Before
sizan_mahmud0_e7c3fd0cb68 profile

Database Indexing Done Right: Why Your "Optimized" Queries Might Be Slower Than Before

#postgres #mysql #indexing #sql
1
Comments
6 min read
Unlocking Salesforce CRM Intelligence with MindsDB’s AI Powered Knowledge Bases
mindsdbteam profile

Unlocking Salesforce CRM Intelligence with MindsDB’s AI Powered Knowledge Bases

#ai #sql #datascience #opensource
Comments 1
14 min read
Level Up Your SQL Skills: 8 Interactive Games That Make Learning Fun
nldr profile

Level Up Your SQL Skills: 8 Interactive Games That Make Learning Fun

#sql #learning
6
Comments
4 min read
Why I am Building an alternative to PostgREST
kabir_narain_dd0e1ad29336 profile

Why I am Building an alternative to PostgREST

#webdev #sql #opensource #database
1
Comments
5 min read
Announcing Cloud SQL free trial instances: Experience the power of a fully managed database
shenoy profile

Announcing Cloud SQL free trial instances: Experience the power of a fully managed database

#sql #postgres #database #cloud
137
Comments
3 min read
MariaDB Database — Complete Technical Guide (Architecture, Internals, Advanced Usage)
farhadrahimiklie profile

MariaDB Database — Complete Technical Guide (Architecture, Internals, Advanced Usage)

#sql #tutorial #database #mariadb
1
Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.