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
Wait, I changed my mind.

Wait, I changed my mind.

14
Comments 3
5 min read
Just Finished my 1st #100daysOfCode Challenge

Just Finished my 1st #100daysOfCode Challenge

7
Comments 7
1 min read
Database Reindexing (MSSQL)

Database Reindexing (MSSQL)

5
Comments
2 min read
Updating the Collation of an Existing MSSQL Database

Updating the Collation of an Existing MSSQL Database

6
Comments
7 min read
Get data from Cloud SQL with Python

Get data from Cloud SQL with Python

9
Comments
6 min read
4Bn rows/sec query benchmark: Clickhouse vs QuestDB vs Timescale

4Bn rows/sec query benchmark: Clickhouse vs QuestDB vs Timescale

7
Comments
10 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
Heterogeneous migration: reducing Dangdang’s customer system RTO 60x and increasing speed by 20%

Heterogeneous migration: reducing Dangdang’s customer system RTO 60x and increasing speed by 20%

6
Comments
6 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
Building TypeScript ORM

Building TypeScript ORM

14
Comments
2 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
How To Access PostgreSQL Globally in Windows

How To Access PostgreSQL Globally in Windows

6
Comments
2 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
Koa Js : Part 4 - Connect a Relational SQL database to your Koa server

Koa Js : Part 4 - Connect a Relational SQL database to your Koa server

8
Comments
8 min read
How to find useless foreign keys in a database

How to find useless foreign keys in a database

9
Comments 2
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
QL to query convert chrome time stamp to epoch milliseconds

QL to query convert chrome time stamp to epoch milliseconds

6
Comments
1 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
loading...