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.
Just Finished my 1st #100daysOfCode Challenge

Just Finished my 1st #100daysOfCode Challenge

7
Comments 7
1 min read
Wait, I changed my mind.

Wait, I changed my mind.

14
Comments 3
5 min read
Database Reindexing (MSSQL)

Database Reindexing (MSSQL)

5
Comments
2 min read
🚀 hash+hash partitioning+sharding

🚀 hash+hash partitioning+sharding

11
Comments
6 min read
How We Made Data Aggregation Better and Faster on PostgreSQL With TimescaleDB 2.7

How We Made Data Aggregation Better and Faster on PostgreSQL With TimescaleDB 2.7

7
Comments
16 min read
Deep Insight Into Open Source Databases

Deep Insight Into Open Source Databases

16
Comments
5 min read
Keeping track of database schema changes

Keeping track of database schema changes

19
Comments 3
5 min read
SQL Has Evolved a Lot In Order To Meet New Challenges — But The Fundamentals Have Remained 🎙

SQL Has Evolved a Lot In Order To Meet New Challenges — But The Fundamentals Have Remained 🎙

30
Comments 5
1 min read
Notes on PostgreSQL: Common Table Expressions

Notes on PostgreSQL: Common Table Expressions

8
Comments
7 min read
SQL meet Data Science (Pandas) cheat sheet

SQL meet Data Science (Pandas) cheat sheet

13
Comments 2
1 min read
Spring Boot Performance Workshop with Vlad Mihalcea

Spring Boot Performance Workshop with Vlad Mihalcea

14
Comments
11 min read
Setup a Testing Environment with Docker and Pytest-Django: PostreSQL schema issue

Setup a Testing Environment with Docker and Pytest-Django: PostreSQL schema issue

15
Comments
2 min read
Resolvendo problema de performance no PostgreSQL com CTE

Resolvendo problema de performance no PostgreSQL com CTE

76
Comments 6
4 min read
Dev Discussions: SQL vs NoSQL with James Quick of PlanetScale

Dev Discussions: SQL vs NoSQL with James Quick of PlanetScale

8
Comments
4 min read
SQL Server Database Partitioning

SQL Server Database Partitioning

10
Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.