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.
My "Last Hour" Query Returned 1,252 Rows. The Real Answer Was 68.
ai_changewatch profile

My "Last Hour" Query Returned 1,252 Rows. The Real Answer Was 68.

#webdev #javascript #sql #sqlite
Comments 1
5 min read
Getting into SQL For Beginners:
ian_munene profile

Getting into SQL For Beginners:

#sql #database #beginners
1
Comments 1
4 min read
Circular Foreign Keys: Why the First Row Cannot Be Inserted
tbson87 profile

Circular Foreign Keys: Why the First Row Cannot Be Inserted

#database #sql #postgres #mysql
Comments
10 min read
PostgreSQL timestamp vs timestamptz: Which to Use and How to Find the Wrong Ones
tbson87 profile

PostgreSQL timestamp vs timestamptz: Which to Use and How to Find the Wrong Ones

#database #postgres #sql #orm
Comments
8 min read
Tattoo data taught me to delete every third-party script — and build analytics from a SQLite table
sike_ren_f38951df83469817 profile

Tattoo data taught me to delete every third-party script — and build analytics from a SQLite table

#privacy #nextjs #webdev #sql
Comments
4 min read
Taba est devenue une ligne SQL, et ça explique mieux la POO que n'importe quel cours
souleyman_thiao_5e9e61267 profile

Taba est devenue une ligne SQL, et ça explique mieux la POO que n'importe quel cours

#sql #poo #webdev #french
Comments
4 min read
How I made SQL run inside a single, offline HTML file (no WASM)
aurelionakamura profile

How I made SQL run inside a single, offline HTML file (no WASM)

#javascript #sql #opensource #webdev
Comments 3
3 min read
A missing ORDER BY cost us Thousands in API calls
mathorde profile

A missing ORDER BY cost us Thousands in API calls

#sql #api
Comments
2 min read
SQL DEFINITIONS:
bhu_kalki profile

SQL DEFINITIONS:

#database #interview #sql
Comments
4 min read
Five SQL Bugs That Never Threw an Error
kiplangat_brian profile

Five SQL Bugs That Never Threw an Error

#sql #postgres #dataengineering #analytics
Comments
5 min read
A Generated SQL Query Got Faster by Returning Fewer Rows. Test That Before You Merge It
codepy_1473 profile

A Generated SQL Query Got Faster by Returning Fewer Rows. Test That Before You Merge It

#sql #testing #ai #database
Comments
5 min read
Directus Basics Part 2 — Understanding Relationships (M2O, O2M, M2M)
wadethomastt profile

Directus Basics Part 2 — Understanding Relationships (M2O, O2M, M2M)

#directus #sql #webdev #headlesscms
Comments
3 min read
Your Database Is Making 4 Promises. Here's What ACID Means.
aditya_d_sharma profile

Your Database Is Making 4 Promises. Here's What ACID Means.

#backend #database #softwareengineering #sql
1
Comments
10 min read
Database Development Without ORM: A Pragmatic Approach to SQL-First Workflows
raiyanu profile

Database Development Without ORM: A Pragmatic Approach to SQL-First Workflows

#sql #kysely #database #typescript
Comments
2 min read
Six Tables Out of 260
ashish_sinha_5241c7673d93 profile

Six Tables Out of 260

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