DEV Community

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.
Semantic Search with PostgreSQL: Pragmatism Beats Hype - Most of the Time
ben-witt profile

Semantic Search with PostgreSQL: Pragmatism Beats Hype - Most of the Time

#ai #database #postgres #sql
5
Comments
8 min read
HOW DO YOU FEEL??
srinaadd_pemmasani_28999b profile

HOW DO YOU FEEL??

#discuss #sql
Comments
2 min read
Preventing double-bookings with PostgreSQL exclusion constraints
ripazocom profile

Preventing double-bookings with PostgreSQL exclusion constraints

#postgres #sql #supabase #database
Comments
6 min read
SQLite Journaling on SMB, TypeGraph for SQL Graphs, Cross-Engine Migrations
soytuber profile
soy

SQLite Journaling on SMB, TypeGraph for SQL Graphs, Cross-Engine Migrations

#database #sql #sqlite
Comments
3 min read
I built a tool that lets you query websites using SQL
michael_ozersky_9624310ec profile

I built a tool that lets you query websites using SQL

#ai #webdev #programming #sql
Comments
1 min read
Learning SQL As If You Built It Yourself
edriso profile

Learning SQL As If You Built It Yourself

#learning #database #sql
1
Comments
12 min read
Building a Simple Java JDBC Project with MySQL: Displaying Cricket Players and Scores
jayashree_a84b6eff7bc414e profile

Building a Simple Java JDBC Project with MySQL: Displaying Cricket Players and Scores

#database #java #sql #tutorial
3
Comments
2 min read
T-SQL on Microsoft Fabric - Episode 1: Mastering Data Retrieval with SELECT, WHERE, and ORDER BY
lamkhac profile

T-SQL on Microsoft Fabric - Episode 1: Mastering Data Retrieval with SELECT, WHERE, and ORDER BY

#microsoft #sql #fabric #dataengineering
Comments
3 min read
PostgreSQL: New Time-Series Extension & Replication Monitor; DuckDB in Production
soytuber profile
soy

PostgreSQL: New Time-Series Extension & Replication Monitor; DuckDB in Production

#database #sql #sqlite
Comments
3 min read
Come estrarre una singola tabella da un file dump MySQL
minnogit profile

Come estrarre una singola tabella da un file dump MySQL

#mysql #sql
Comments
1 min read
Cleaning Messy Phone Numbers in PostgreSQL Using REGEXP_REPLACE
sharonnyabuto profile

Cleaning Messy Phone Numbers in PostgreSQL Using REGEXP_REPLACE

#sql #postgres #beginners
Comments
6 min read
Eight window-function tricks beyond LAG and ROW_NUMBER
fixelsmith profile

Eight window-function tricks beyond LAG and ROW_NUMBER

#sql #analytics #frauddetection #database
Comments
6 min read
DuckDB EC2 Optimization, Postgres FDW Pushdown, SQLite NetBeans Connectivity
soytuber profile
soy

DuckDB EC2 Optimization, Postgres FDW Pushdown, SQLite NetBeans Connectivity

#database #sql #sqlite
1
Comments
4 min read
Turso: A Rust Rewrite of SQLite. Setup Guide and Whether It's Worth Your Time
arshtechpro profile

Turso: A Rust Rewrite of SQLite. Setup Guide and Whether It's Worth Your Time

#ai #sql #database #programming
11
Comments 2
5 min read
Data Analyst Interviews in 2026: How to Clear SQL, Case Studies, and Behavioral in the Same Loop
manyoffer_career profile

Data Analyst Interviews in 2026: How to Clear SQL, Case Studies, and Behavioral in the Same Loop

#career #interview #dataanalysis #sql
Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.