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.
Second Highest Salary in SQL: 4 Ways, and Which Ones Quietly Break
k_hunnurjirao_7ea28e971f profile

Second Highest Salary in SQL: 4 Ways, and Which Ones Quietly Break

#sql #beginners #database #career
1
Comments
5 min read
Postgres full-text search is enough for most side projects
wired_carter profile

Postgres full-text search is enough for most side projects

#postgres #sql #search
Comments
1 min read
Postgres full-text search is enough for most side projects
wired_carter profile

Postgres full-text search is enough for most side projects

#postgres #sql #search
Comments
1 min read
Sequill: A Free, Private SQLite Editor & Schema Designer That Runs in Your Browser
aditya_ku profile

Sequill: A Free, Private SQLite Editor & Schema Designer That Runs in Your Browser

#webdev #database #sql #nextjs
Comments
5 min read
Building GTA6 Grid: React, PostgreSQL Search, and SEO Beyond Meta Tags
rohan_arora_d57b2eb634f98 profile

Building GTA6 Grid: React, PostgreSQL Search, and SEO Beyond Meta Tags

#react #postgres #seo #sql
Comments
6 min read
SQL Server Blocking: How to Find the Head Blocker and Fix It
lingamsuyambu profile

SQL Server Blocking: How to Find the Head Blocker and Fix It

#sql #sqlserver #database #performance
Comments
3 min read
WJb Persistent Storage Benchmark: SQLite vs SQL Server
ukrguru profile

WJb Persistent Storage Benchmark: SQLite vs SQL Server

#ai #sql #csharp #dotnet
Comments
3 min read
TypeSQL: type-safe plain SQL in TypeScript
ismailkarsli profile

TypeSQL: type-safe plain SQL in TypeScript

#sql #postgres #typescript #webdev
Comments
4 min read
Don't DROP COLUMN while old app code still reads it
labyrinthlab profile

Don't DROP COLUMN while old app code still reads it

#postgres #database #devops #sql
1
Comments
3 min read
Your SUM() isn't wrong, your grain is: debugging JOIN fan-out in 6 rows
alapha888 profile

Your SUM() isn't wrong, your grain is: debugging JOIN fan-out in 6 rows

#sql #database #dataengineering #tutorial
1
Comments 2
3 min read
Why COUNT(*) Is So Slow in PostgreSQL (And How to Fix It)
ihssmaheel profile

Why COUNT(*) Is So Slow in PostgreSQL (And How to Fix It)

#postgres #database #performance #sql
6
Comments
3 min read
Measuring realized Cardano staking yield from cardano-db-sync: epoch rewards over epoch stake, split by pool size
elliotagent profile

Measuring realized Cardano staking yield from cardano-db-sync: epoch rewards over epoch stake, split by pool size

#cardano #postgres #sql #datascience
Comments
4 min read
Reading Complex XML in SQL Server — Shredding a Thousand Attributes Generically Instead of Looping for Hours
marcus1968 profile

Reading Complex XML in SQL Server — Shredding a Thousand Attributes Generically Instead of Looping for Hours

#sql #sqlserver #xml #database
Comments
41 min read
Put the Workspace Check Inside the Database Write
smtasker profile

Put the Workspace Check Inside the Database Write

#mcp #security #sql #testing
1
Comments 1
6 min read
How to Fix SQL Server Deadlocks: Causes, Detection and Real Fixes
lingamsuyambu profile

How to Fix SQL Server Deadlocks: Causes, Detection and Real Fixes

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