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.
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
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
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
7
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
56
Comments
3 min read
What is Cyber Resilience Act, and what cybersecurity requirements does it impose?
pvsdev profile

What is Cyber Resilience Act, and what cybersecurity requirements does it impose?

#security #programming #cybersecurity #sql
1
Comments
7 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
Pandas Task:
ashok_kumar_564581944e3ef profile

Pandas Task:

#python #pandas #sql #programming
2
Comments
1 min read
Database Transactions and ACID Properties: Guaranteeing Data Consistency
outdated-dev profile

Database Transactions and ACID Properties: Guaranteeing Data Consistency

#database #sql #softwareengineering #acid
Comments
8 min read
Amazon Cloud Solutions Architect Shows You How to Migrate Data to Amazon Aurora DSQL Using Apache SeaTunnel
seatunnel profile

Amazon Cloud Solutions Architect Shows You How to Migrate Data to Amazon Aurora DSQL Using Apache SeaTunnel

#programming #apacheseatunnel #auroradsql #sql
Comments
4 min read
MyScaleDB: Why Vector Databases Need SQL (The 2025 Reality Check)
pascal_cescato_692b7a8a20 profile

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

#database #vectordatabase #sql #architecture
9
Comments 2
10 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.