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.
Brincando com Ecto.Query

Brincando com Ecto.Query

6
Comments 2
4 min read
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
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
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
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
👋 Sign in for the ability to sort posts by relevant, latest, or top.