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.
The Data Engineering Take-Home Assessment: How to Turn a 4-Hour Test Into a Job Offer
de_clerke profile

The Data Engineering Take-Home Assessment: How to Turn a 4-Hour Test Into a Job Offer

#dataengineering #career #sql #beginners
1
Comments
14 min read
PostgreSQL for Data Engineers: Indexes, Bulk Loads, and the Patterns That Actually Matter
de_clerke profile

PostgreSQL for Data Engineers: Indexes, Bulk Loads, and the Patterns That Actually Matter

#postgres #database #sql #psycopg2
1
Comments
13 min read
Aggregations: Counting, Summing, and Averaging Your Data
yakhilesh profile

Aggregations: Counting, Summing, and Averaging Your Data

#sql #ai #beginners #python
Comments
7 min read
PostgreSQL Subquery and CTE Optimization
philip_mcclarence_2ef9475 profile

PostgreSQL Subquery and CTE Optimization

#database #performance #postgres #sql
1
Comments
8 min read
Database Indexing Mistakes That Kill SaaS Performance at Scale
outworktech profile

Database Indexing Mistakes That Kill SaaS Performance at Scale

#database #performance #saas #sql
1
Comments 1
6 min read
5 SQL queries developers always have to look up (with copy-paste answers)
forglydev profile
Cheng

5 SQL queries developers always have to look up (with copy-paste answers)

#sql #database #webdev #productivity
1
Comments
2 min read
SQL Pattern Series #2: The Match Pattern
baldwin_apps profile

SQL Pattern Series #2: The Match Pattern

#sql #database #datascience #programming
Comments
3 min read
SQL Basics: Talking to a Database for the First Time
yakhilesh profile

SQL Basics: Talking to a Database for the First Time

#beginners #database #sql #ai
Comments
7 min read
Transitioning to Data Engineering: My Top 4 Essential Tools So Far
mkhasanov profile

Transitioning to Data Engineering: My Top 4 Essential Tools So Far

#dataengineering #python #sql #cloud
2
Comments
1 min read
PostgreSQL Extension for Row Padding, pgBackRest EOL, and SQLite Windows XP Support
soytuber profile
soy

PostgreSQL Extension for Row Padding, pgBackRest EOL, and SQLite Windows XP Support

#database #sql #sqlite
Comments
3 min read
Our API Was Successfully Hacked. Here's What We Fixed Before the Regulator Showed Up
guy_gontar_7dca4bc5499c48 profile

Our API Was Successfully Hacked. Here's What We Fixed Before the Regulator Showed Up

#security #api #sql #backend
Comments
4 min read
PostgreSQL Join Optimization: Nested Loop, Hash, and Merge
philip_mcclarence_2ef9475 profile

PostgreSQL Join Optimization: Nested Loop, Hash, and Merge

#database #performance #postgres #sql
Comments
11 min read
Your Test Data Is Type-Correct and Still Invalid: 6 Postgres Schema Features Generators Skip
mikh-shytsko profile

Your Test Data Is Type-Correct and Still Invalid: 6 Postgres Schema Features Generators Skip

#postgres #database #supabase #sql
2
Comments
9 min read
How I Exported 1 Million+ Oracle Records to CSV in Under 30 Seconds Using Node.js
prashanthm07 profile

How I Exported 1 Million+ Oracle Records to CSV in Under 30 Seconds Using Node.js

#oracle #sql #node
2
Comments
3 min read
Pivotal: A better syntax for data analysis in Python
nealbob profile

Pivotal: A better syntax for data analysis in Python

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