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.

Mar 4

SQLite as an MCP context saver: stop cramming raw API data into your LLM

#ai #mcp #sql

9 min read

Mar 8

Understanding `GROUP BY` in SQL

#sql

6 min read

Mar 10

SQL Injection – querying the database type and version | PortSwigger Lab Note #6

#database #security #sql #tutorial

1 min read

Ajit Kumar

Feb 4

From Zero to Cached: Building a High-Performance Housing Portal with Django, Next.js, and Redis - Part 4 : Optimization Pillars

#django #python #sql #redis

17 min read

Mar 10

DuckDB 1.5.0 Released: New Features and Tools Enhance Performance and Functionality

#duckdb #sql #variant #geometry

9 min read

Severin Neumann for Causely

Feb 4

How to Turn Slow Queries into Actionable Reliability Metrics with OpenTelemetry

#opentelemetry #sql #postgres

11 min read

Mar 10

Guide to Connecting Power BI to SQL Databases: Local & Cloud Workflows

#database #microsoft #sql #tutorial

5 min read

Marcin Parśniak

Mar 10

Liquibase in Spring Boot – Developer's Guide

#tutorial #programming #java #sql

3 min read

Rebooter.S

Feb 4

GeoSQL-Eval: Finally, a PostGIS Benchmark That Doesn’t Make Me Scream

#llm #postgres #sql #testing

2 min read

Mar 9

SQL Injection – Login Bypass | PortSwigger Lab Note #2

#cybersecurity #security #sql #tutorial

1 min read

Mar 9

ADVANCED SQL FOR DATA ANALYTICS:ADVANCED TECHNIQUES EVERY DATA ANALYST SHOULD KNOW.

#sql #learning #datascience #beginners

7 min read

Mar 10

SQL Injection – UNION attack, retrieving multiple values in a single column | PortSwigger Lab Note #5

#cybersecurity #security #sql #tutorial

1 min read

CodeBase Journal

Mar 8

Log 01: The Legacy Break | Switching to Docker for Data Science

#datascience #docker #sql #buildinpublic

2 min read

Philip McClarence

Mar 9

INSERT Performance Tuning for TimescaleDB

#database #performance #postgres #sql

4 min read

Mar 9

SQL Window Functions Don't Have to Be Scary 🪟

#sql #dataengineering #beginners #programming

3 min read

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