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.
12 Postgres schemas every B2B SaaS re-implements (and gets wrong the first time)
founderprompts profile

12 Postgres schemas every B2B SaaS re-implements (and gets wrong the first time)

#postgres #sql #database #webdev
Comments
3 min read
Oracle ORA-00069 오류 원인과 해결 방법 완벽 가이드
dbmserror profile

Oracle ORA-00069 오류 원인과 해결 방법 완벽 가이드

#oracle #database #dba #sql
Comments
2 min read
PostgreSQL 08004 오류 원인과 해결 방법 완벽 가이드
dbmserror profile

PostgreSQL 08004 오류 원인과 해결 방법 완벽 가이드

#postgres #database #dba #sql
Comments
2 min read
SQLite Bug 3.52.0, DuckDB Conference Program, & PostgreSQL Logical Replication Deep Dive
soytuber profile
soy

SQLite Bug 3.52.0, DuckDB Conference Program, & PostgreSQL Logical Replication Deep Dive

#database #sql #sqlite
Comments
3 min read
SQL Formatting: Why It Matters More Than You Think (and How to Do It Right)
snappy_tools profile

SQL Formatting: Why It Matters More Than You Think (and How to Do It Right)

#sql #webdev #productivity #beginners
1
Comments
3 min read
# How I Cut SQL Query Time from 45 Seconds to 8 Seconds
danielnnadi profile

# How I Cut SQL Query Time from 45 Seconds to 8 Seconds

#sql #database #performance #dataengineering
Comments
1 min read
Data Engineer LeetCode: What to Grind and What to Skip
datadriven profile

Data Engineer LeetCode: What to Grind and What to Skip

#dataengineering #interview #sql #career
1
Comments
7 min read
PostgreSQL 08001 오류 원인과 해결 방법 완벽 가이드
dbmserror profile

PostgreSQL 08001 오류 원인과 해결 방법 완벽 가이드

#postgres #database #dba #sql
Comments
2 min read
PostgreSQL 08006 오류 원인과 해결 방법 완벽 가이드
dbmserror profile

PostgreSQL 08006 오류 원인과 해결 방법 완벽 가이드

#postgres #database #dba #sql
Comments
2 min read
Oracle ORA-00060 오류 원인과 해결 방법 완벽 가이드
dbmserror profile

Oracle ORA-00060 오류 원인과 해결 방법 완벽 가이드

#oracle #database #dba #sql
Comments
3 min read
How I Migrated 10,000+ Records with Zero Downtime
danielnnadi profile

How I Migrated 10,000+ Records with Zero Downtime

#database #sql #dataengineering #goverment
Comments
1 min read
Oracle ORA-00057 오류 원인과 해결 방법 완벽 가이드
dbmserror profile

Oracle ORA-00057 오류 원인과 해결 방법 완벽 가이드

#oracle #database #dba #sql
Comments
3 min read
PostgreSQL 08003 오류 원인과 해결 방법 완벽 가이드
dbmserror profile

PostgreSQL 08003 오류 원인과 해결 방법 완벽 가이드

#postgres #database #dba #sql
Comments
2 min read
MP3 - SQLi, XSS, and CSRF WriteUp
acchanli profile

MP3 - SQLi, XSS, and CSRF WriteUp

#python #security #sql #webdev
Comments
7 min read
Why most MySQL to PostgreSQL converters break — and how real engines fix it
hamidi_rasim_695ebc2f47a5 profile

Why most MySQL to PostgreSQL converters break — and how real engines fix it

#showdev #database #postgres #sql
1
Comments
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.