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.
MariaDB Quick-tip #3 - Prepending zeros

MariaDB Quick-tip #3 - Prepending zeros

7
Comments
1 min read
Database Mesh 2.0: Database Governance in a Cloud Native Environment

Database Mesh 2.0: Database Governance in a Cloud Native Environment

3
Comments
9 min read
Optimizing Nested Loop joins on YugabyteDB with jOOQ

Optimizing Nested Loop joins on YugabyteDB with jOOQ

8
Comments
4 min read
OWASP Vulnerability: SQL Injection | iFour Technolab

OWASP Vulnerability: SQL Injection | iFour Technolab

7
Comments
7 min read
Filter database records without SQL

Filter database records without SQL

13
Comments
1 min read
MariaDB Quick-tip #1 - Range of int

MariaDB Quick-tip #1 - Range of int

8
Comments 2
1 min read
How To Install SQL Server on Ubuntu

How To Install SQL Server on Ubuntu

6
Comments
2 min read
Quiz: SQL query

Quiz: SQL query

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

2
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

4
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
Manually creating your first Hyperlambda endpoint

Manually creating your first Hyperlambda endpoint

25
Comments 4
3 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

16
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

10
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 🎙

31
Comments 5
1 min read
How To Access PostgreSQL Globally in Windows

How To Access PostgreSQL Globally in Windows

7
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

14
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

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

How to find useless foreign keys in a database

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

Resolvendo problema de performance no PostgreSQL com CTE

41
Comments 5
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

8
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

7
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
loading...