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.

Jan 20

SQL Nulls Finally Made Sense: COALESCE, NULLIF, and Safer Calculations

#sql #postgres #database #beginners

3 min read

Kajiru

Jan 20

Simple Ranking with SQLite3

#python #tutorial #database #sql

5 min read

Jan 20

Make Your Technical Tutorials Interactive with SQLize Embed

#sql #documentation #mariadb #postgressql

2 min read

Lucas Pereira de Souza

Jan 20

PostgreSQL como busca vetorial (pgvector)

#ai #database #postgres #sql

8 min read

Shamil Suraweera

Jan 19

SQL Cheat Sheet

#sql

9 min read

SQLFlash

Jan 20

SQL Optimization Unlocked: Achieve 80% Calculation Reduction with CROSS APPLY

#sql #mysql

5 min read

Jan 19

Querying & Filtering in Oracle Databases: What Actually Clicked for Me As a Beginner

#oracle #sql #database #beginners

4 min read

Judy

Jan 19

Are Wide Tables Fast or Slow?

#database #dataengineering #performance #sql

4 min read

Jan 19

Fixing sqlalchemy.exc.MissingGreenlet in FastAPI and Async SQLAlchemy 2.0

#help #python #fastapi #sql

2 min read

fosres

Jan 18

Week 5 Scripting Challenge: Secure Password Authentication

#challenge #security #python #sql

15 min read

Chatboq

Jan 19

How to Create a Chatbot That Generates SQL Queries" published

#ai #sql #machinelearning #programming

9 min read

InterSystems Developer for InterSystems

Jan 18

Supply Chain Orchestration for dummies

#api #database #iot #sql

61 min read

Amar Abaz

Jan 18

Modular Approach to Database Performance and Maintainability

#sqlserver #filegroups #tutorial #sql

4 min read

Jan 18

Found a Really Nice Way to Visualize SQLite Databases

#sqlite #devtools #webdev #sql

1 min read

Judy

Jan 16

Tired of ETL Bottlenecks? Build a Logical Data Warehouse with SPL

#architecture #database #dataengineering #sql

11 min read

SQLFlash

Jan 16

SARGable Condition Rewriting: Practical Solutions for Date Filtering Optimization

#sql #mysql

9 min read

codecraft

Jan 15

Stop treating MongoDB like just another Database

#mongodb #sql #database #databasemanagement

3 min read

Jan 15

I built a SQL-to-Google Sheets bridge because existing tools were slow as hell (No-signup demo)

#showdev #database #sql #tooling

1 min read

Alexander Alten

Jan 14

SQL on Kafka Data Does Not Require a Streaming Engine

#kafka #sql #dataengineering #eventdriven

4 min read

Jan 13

Data Inconsistency Due to Missing Constraints (Odoo)

#backend #database #python #sql

2 min read

osman uygar köse

Jan 12

Prompt Engineering a Barista: How SQLatte's Personality Transforms SQL into Conversations

#promptengineering #ai #sql #python

4 min read

Jan 13

SQL vs MongoDB(noSQL)! How to decide between databases

#sql #nosql #mongodb #mongoose

4 min read

Jan 13

SQL - Basics

#programming #sql #database #week1

2 min read

SQLFlash

Jan 12

Beyond Nested Queries: A Practical Guide to SQL Subquery Flattening

#sql #mysql #ai #programming

5 min read

Jan 12

SQL vs NoSQL: The Ultimate Interview Guide to Choosing the Right Database (Simple Checklist Included)

#interview #sql #nosql #programming

4 min read

loading...