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
Updating the Collation of an Existing MSSQL Database

Updating the Collation of an Existing MSSQL Database

5
Comments
7 min read
Database Reindexing (MSSQL)

Database Reindexing (MSSQL)

3
Comments
2 min read
Get data from Cloud SQL with Python

Get data from Cloud SQL with Python

8
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

10
Comments
6 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

18
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

13
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

7
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

72
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
Nested Loop performance in YugabyteDB

Nested Loop performance in YugabyteDB

10
Comments
12 min read
SQL-Quick tip #15 - Random dates

SQL-Quick tip #15 - Random dates

7
Comments
2 min read
With Dynamic SQL Queries on TypeScript & NodeJS

With Dynamic SQL Queries on TypeScript & NodeJS

8
Comments 1
1 min read
SQLite vs PostgreSQL

SQLite vs PostgreSQL

6
Comments
1 min read
Predictable plans with pg_hint_plan full hinting

Predictable plans with pg_hint_plan full hinting

10
Comments
10 min read
How to use SQL Server T-SQL function CHARINDEX in SQL queries

How to use SQL Server T-SQL function CHARINDEX in SQL queries

6
Comments
6 min read
Generating nicely parsed schema files with pg_dump_schema_parser

Generating nicely parsed schema files with pg_dump_schema_parser

8
Comments
2 min read
Working With JSON Objects Using SQL

Working With JSON Objects Using SQL

8
Comments
3 min read
Quickly get short stack from a YugabyteDB tserver

Quickly get short stack from a YugabyteDB tserver

7
Comments
2 min read
Lessons learnt from the 8 week sql challenge: string_agg

Lessons learnt from the 8 week sql challenge: string_agg

7
Comments
1 min read
YugabyteDB range sharding: ASC or DESC? (Backward Scan in🚀)

YugabyteDB range sharding: ASC or DESC? (Backward Scan in🚀)

8
Comments
5 min read
SQL-Quick tip #13 - Index usage

SQL-Quick tip #13 - Index usage

5
Comments
1 min read
Recreating MYSQL's LPAD Function in SQL Server

Recreating MYSQL's LPAD Function in SQL Server

7
Comments 2
4 min read
Hack The Box Writeup: Cronos

Hack The Box Writeup: Cronos

7
Comments
10 min read
status 22003 no banco de dados

status 22003 no banco de dados

9
Comments
3 min read
ORMs in JavaScript

ORMs in JavaScript

17
Comments
5 min read
SQL-Quick tip #14 - Server information

SQL-Quick tip #14 - Server information

9
Comments
1 min read
Your Guide to DistSQL Cluster Governance Capability——Apache ShardingSphere Feature Update

Your Guide to DistSQL Cluster Governance Capability——Apache ShardingSphere Feature Update

9
Comments
9 min read
Mental Model For SQL Joins

Mental Model For SQL Joins

10
Comments 3
1 min read
ERROR: Timed out: BackfillIndex RPC

ERROR: Timed out: BackfillIndex RPC

8
Comments
3 min read
Some Teradata SQL Fun with Dates Differing by Months

Some Teradata SQL Fun with Dates Differing by Months

5
Comments 1
15 min read
Howto handle index key specification without a key length and key was too long

Howto handle index key specification without a key length and key was too long

7
Comments
4 min read
Query compressed logs that are stored in S3 using AWS Athena

Query compressed logs that are stored in S3 using AWS Athena

9
Comments
5 min read
Build a PostgreSQL Docker image with pg_hint_plan and pg_stat_statements

Build a PostgreSQL Docker image with pg_hint_plan and pg_stat_statements

10
Comments
2 min read
Improving performance in a hierarchical SQL table structure with column propagation

Improving performance in a hierarchical SQL table structure with column propagation

5
Comments
9 min read
YugabyteDB Predicate Push Down

YugabyteDB Predicate Push Down

6
Comments
6 min read
Como criar um banco de dados mariaDb com docker

Como criar um banco de dados mariaDb com docker

7
Comments
3 min read
loading...