Forem

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.
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
Automate PostgreSQL & MySQL Database Management on Linux Servers
Cover image for 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
Cover image for 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
Cover image for 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
5
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
A Complete Guide to MariaDB: Architecture, Features, Installation, and Best Practices
Cover image for A Complete Guide to MariaDB: Architecture, Features, Installation, and Best Practices
farhadrahimiklie profile

A Complete Guide to MariaDB: Architecture, Features, Installation, and Best Practices

#sql #tutorial #database #opensource
Comments
4 min read
Pandas Task:
ashok_kumar_564581944e3ef profile

Pandas Task:

#python #pandas #sql #programming
3
Comments
1 min read
MyScaleDB: Why Vector Databases Need SQL (The 2025 Reality Check)
Cover image for 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
I Built a Tool to Turn Any SQL Dump File into a Live Database in Seconds
admin_desql profile

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

#database #sql #webdev #productivity
Comments
2 min read
How did I learn about Transaction Log, Redo Log, and Undo Log as a developer?
arifbasri profile

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

#learning #sql #database #performance
Comments
1 min read
Building a FHIR Vector Repository with InterSystems IRIS and Python through the IRIStool module
intersystemsdev profile

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

#fhir #python #sql #vectordatabase
Comments
5 min read
GoREST is dead...
nicolasbonnici profile

GoREST is dead...

#go #sql
1
Comments
4 min read
The Future of Data-Native & Grounded AI with MindsDB: Moving Data to Models No Longer Makes Sense
Cover image for The Future of Data-Native & Grounded AI with MindsDB: Moving Data to Models No Longer Makes Sense
mindsdbteam profile

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

#sql #datascience #ai #development
5
Comments
8 min read
Entenda os JOINS no SQL e como aplicar certo tipo para cada cenário
ryanmarinho profile

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

#database #sql #tutorial
Comments
1 min read
Leveraging Service Stored Procedures (SSPs) in Uniface 10.4
petercode profile

Leveraging Service Stored Procedures (SSPs) in Uniface 10.4

#uniface #sql #legacy #performance
Comments
3 min read
Commenting in MySQL: Syntax, Hints, and Practical Examples
Cover image for Commenting in MySQL: Syntax, Hints, and Practical Examples
dbvismarketing profile

Commenting in MySQL: Syntax, Hints, and Practical Examples

#sql #mysql
Comments
2 min read
Data Locality vs. Independence (NoSQL vs. SQL)
Cover image for Data Locality vs. Independence (NoSQL vs. SQL)
franckpachot profile

Data Locality vs. Independence (NoSQL vs. SQL)

#mongodb #database #sql #nosql
1
Comments
10 min read
Nested Loop and Hash Join for MongoDB $lookup
Cover image for Nested Loop and Hash Join for MongoDB $lookup
franckpachot profile

Nested Loop and Hash Join for MongoDB $lookup

#mongodb #document #sql #database
17
Comments 1
10 min read
🧠 SQL for Beginners: The 10 Most Common Queries Explained
Cover image for 🧠 SQL for Beginners: The 10 Most Common Queries Explained
bantu_ngxola profile

🧠 SQL for Beginners: The 10 Most Common Queries Explained

#sql #sqlserver #mariadb #database
Comments
3 min read
PL/SQL Program Data: Naming, Declaring, and Best Practices
ayako_yk profile

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

#beginners #learning #database #sql
Comments
3 min read
INNER JOIN and LEFT OUTER JOIN in MongoDB (with $lookup and $unwind)
Cover image for INNER JOIN and LEFT OUTER JOIN in MongoDB (with $lookup and $unwind)
franckpachot profile

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

#mongodb #database #sql #join
2
Comments 2
8 min read
The Offline Data Engineer: Building Resilient API Pipelines that Work on an Airplane
Cover image for The Offline Data Engineer: Building Resilient API Pipelines that Work on an Airplane
markolekic profile

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

#python #dataengineering #api #sql
4
Comments
5 min read
Advanced Query Capabilities 👉🏻 aggregation pipelines
franckpachot profile

Advanced Query Capabilities 👉🏻 aggregation pipelines

#database #mongodb #sql
Comments
4 min read
😱 Stop Writing Useless SQL Queries! Discover the Secret Powers of Window Functions
Cover image for 😱 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
loading...