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.

Michael

May 1

GBase 8a Full-Text Index: Features, Queries, and Configuration

#backend #database #sql #tutorial

2 min read

Missak Boyajian

Apr 25

I built a PostgreSQL learning platform with labs & quizzes — would love feedback

#database #postgressql #sql #product

1 min read

hiyoyo

May 1

Using SQLite to Track Sync State in Rust — Simple, Reliable, Zero Dependencies

#tauri #rust #sql #programming

2 min read

ahmeddeelhassan

Apr 26

Top 5 Data Engineering Tools for 2026: Why Python and SQL remain Kings

#webdev #python #sql #dataengineering

2 min read

soy

Apr 25

DuckDB Single-Node Analytics, PostgreSQL Bloom Filters, SQLite Compression

#database #sql #sqlite

4 min read

Apr 29

Review the Logic, Not Whether the Junior Used AI

#ai #sql #hiring #career

5 min read

Michael

Apr 30

GBase 8a Operations Cheat Sheet: Essential Commands for DBAs

#cli #database #sql #tutorial

2 min read

Mark

Apr 24

The Five Most Important Columns to Add to Every Database Table

#database #sql #beginners #webdev

5 min read

soy

Apr 24

SQLite Compression Discussions, Real-time Vector Search, & PostgreSQL Scaling Patterns

#database #sql #sqlite

3 min read

Odilon HUGONNOT

Apr 24

PostgreSQL: debugging a slow query and optimizing it

#postgres #performance #sql #index

9 min read

qodors

Apr 24

SQL Server Running Slow? Here's What Actually Fixes It.

#database #performance #sql

5 min read

Deepak Sen (Web Developer)

Apr 24

SQLite Database & Expo SQLite A much easy to use docs.

#database #mobile #reactnative #sql

2 min read

Apr 24

SQL LIKE and Wildcards: Pattern Matching Made Simple

#sql #database #beginners #tutorial

6 min read

Francisco Simões

Apr 24

How to prevent Foreign Key crashes with Stripe Webhooks in .NET 10.

#dotnet #saas #sql #aspdotnet

2 min read

Apr 23

Querier: Type Safe Java SQL Query Builder

#java #sql #backend #programming

2 min read

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