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.
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
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
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
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
Webtabellen Converteren naar SQL INSERT-Statements
circobit profile

Webtabellen Converteren naar SQL INSERT-Statements

#javascript #sql #webdev #database
Comments
5 min read
I Thought MSSQL and MySQL Were the Same. I Was Wrong.
satyamgupta1495 profile

I Thought MSSQL and MySQL Were the Same. I Was Wrong.

#mysql #sql #database #programming
Comments
20 min read
Closing the Tax Gap with a Data Model: Invoice Traceability in SQL
ricardo_demelo_2a17a8dd9 profile

Closing the Tax Gap with a Data Model: Invoice Traceability in SQL

#sql #database #datamodeling #fintech
Comments
4 min read
Speed Up Your Queries: A Plain-English Guide to Database Indexing
saurav_tb_pandey profile

Speed Up Your Queries: A Plain-English Guide to Database Indexing

#databaseindexing #database #sql #performance
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.