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.
geo-distribution with 🚀 YugabyteDB tablespaces

geo-distribution with 🚀 YugabyteDB tablespaces

9
Comments
4 min read
How To Restore A PostgreSQL Database Using Command Line

How To Restore A PostgreSQL Database Using Command Line

5
Comments
3 min read
The best way to learn SQL?

The best way to learn SQL?

3
Comments 9
1 min read
How to import JSON file into SQL Server Database

How to import JSON file into SQL Server Database

5
Comments 1
3 min read
MariaDB Quick-tip #2 - Randomize rows

MariaDB Quick-tip #2 - Randomize rows

3
Comments
1 min read
2 steps to display cache tables data on the web by using jquery datatable and embedded python

2 steps to display cache tables data on the web by using jquery datatable and embedded python

5
Comments
2 min read
MindsDB: Predicting Supply Chain Demand with Machine Learning using SQL

MindsDB: Predicting Supply Chain Demand with Machine Learning using SQL

8
Comments
7 min read
Local reads from 🚀YugabyteDB raft followers

Local reads from 🚀YugabyteDB raft followers

11
Comments 1
6 min read
Local reads from 🚀YugabyteDB Read Replicas

Local reads from 🚀YugabyteDB Read Replicas

8
Comments
7 min read
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
loading...