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.

Rodrino Adolfo Kupessala

Jan 11

SQL INJECTION

#beginners #sql #security #webdev

1 min read

Jan 4

XML External Entity (XXE) Injection: A Complete Guide for Developers

#xmlexternalentity #sql #xxe #programming

18 min read

Jan 16

Learning Databases Beyond SQL: My First Day with Oracle Tables

#sql #oracle #beginners #database

3 min read

Blackwatch

Jan 4

QUICK SQL REVISION

#sql #database #webdev #programming

14 min read

Amar Abaz

Jan 4

Track Blocking and Deadlocks in MSSQL with my custom script

#sqlserver #sql #database #deadlock

4 min read

Dan Shalev

Jan 5

Text2SQL on xxxx's of tables?

#sql #falkordb #opensource

1 min read

Jan 4

Wait, what? PK is not needed for HABTM?

#database #rails #ruby #sql

2 min read

Juan Rueda

Jan 6

Simple vs Complex: When to Level Up Your Solutions

#architecture #complexity #engineering #sql

5 min read

Jan 5

Streaming SQL Engine: Lightweight Cross-Data Source Integration for Resource-Constrained Environments.

#architecture #dataengineering #python #sql

1 min read

Christian Wagner

Jan 2

Stop Manually Tracing Azure Synapse Dependencies

#database #sql #opensource #dataengineering

1 min read

Jan 8

TailwindSQL: The Weirdest, and Maybe Nicest, Developer Trend You’ll See Today

#tailwindcss #database #sql #programming

4 min read

Nithyalakshmi Kamalakkannan

Jan 2

Part 8: Databricks Pipeline & Dashboard

#analytics #dataengineering #tutorial #sql

2 min read

Nithyalakshmi Kamalakkannan

Jan 2

Part 4: Building the Bronze Layer with Auto Loader and Delta Lake

#architecture #dataengineering #tutorial #sql

2 min read

samurai-techlead

Jan 6

Building a Secure E-Commerce Chat Agent with Stored Procedures

#ai #agents #sql #llm

3 min read

Amar Abaz

Jan 3

Linked Server vs OPENQUERY vs OPENROWSET vs OPENDATASOURCE

#sqlserver #database #sql #remotequery

4 min read

Charlie Barajas

Jan 1

UNION in SQL Postgre

#sql #postgres #database #union

1 min read

dss99911

Dec 31 '25

MySQL 고급 기능 - GROUP BY, Window Function, Stored Procedure

#backend #database #mysql #sql

2 min read

dss99911

Dec 31 '25

MySQL 함수 가이드 - 문자열, 날짜, CASE 구문

#backend #database #mysql #sql

1 min read

InterSystems Developer for InterSystems

Dec 30 '25

Understanding SQL Window Functions (Part 2)

#performance #sql #programming #analytics

8 min read

MindsDB Team for MindsDB

Dec 30 '25

MySQL & MindsDB Unlocks Intelligent Content Discovery For Web CMS with Knowledge Bases and Cursor

#mysql #mcp #ai #sql

11 min read

fmzquant

Dec 30 '25

Crypto Spot-Futures Arbitrage in Practice: Lessons Learned from Theory to Reality

#node #devrel #sql #web3

12 min read

Chandrashekhar Kachawa

Dec 31 '25

A Practical Guide to Backing Up Your Linux Server: PostgreSQL, Jenkins, and More

#sql #backup #ubuntu #beginners

4 min read

dss99911

Dec 31 '25

MySQL 기초 - 명령어, DDL, 테이블 관리

#backend #database #mysql #sql

1 min read

dss99911

Dec 31 '25

MySQL 쿼리 완벽 가이드 - SELECT, INSERT, UPDATE, JOIN

#backend #database #mysql #sql

1 min read

Dec 29 '25

How to Build a Text-to-SQL Agent With RAG, LLMs, and SQL Guards

#sql #rag #llm #texttosql

7 min read

loading...