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.
Online PHP & SQL sandbox with ChatGPT support

Online PHP & SQL sandbox with ChatGPT support

41
Comments 5
2 min read
sql-export - create .md / .json files from database content

sql-export - create .md / .json files from database content

2
Comments
2 min read
Free Course - Learn: A Full Stack Application with Azure SQL and Prisma

Free Course - Learn: A Full Stack Application with Azure SQL and Prisma

37
Comments
2 min read
SQL Vs NoSQL

SQL Vs NoSQL

6
Comments
1 min read
ANALYSING & VISUALISING DATA With PostgreSQL and Arctype SQL CLIENT

ANALYSING & VISUALISING DATA With PostgreSQL and Arctype SQL CLIENT

8
Comments
4 min read
PostgreSQL and YugabyteDB partitioning and indexes

PostgreSQL and YugabyteDB partitioning and indexes

4
Comments
7 min read
ClickHouse Fundamentals: Part 2

ClickHouse Fundamentals: Part 2

5
Comments
4 min read
How We Reduced Online Serving Latency from 1.11s to 123.6ms on a Distributed SQL Database

How We Reduced Online Serving Latency from 1.11s to 123.6ms on a Distributed SQL Database

5
Comments
9 min read
Cloud Scheduler to stop a Cloud SQL database

Cloud Scheduler to stop a Cloud SQL database

4
Comments
4 min read
PostgreSQL do different equality predicates make a difference?

PostgreSQL do different equality predicates make a difference?

9
Comments 2
2 min read
NHOST: AN INTRODUCTION TO BACK-END AS A SERVICE.

NHOST: AN INTRODUCTION TO BACK-END AS A SERVICE.

2
Comments
5 min read
Create Upsert Yourself for Amazon Redshift Databases

Create Upsert Yourself for Amazon Redshift Databases

2
Comments
6 min read
How to Plan for Software Scalability and Building for Growth

How to Plan for Software Scalability and Building for Growth

4
Comments
5 min read
EF Core 7 is here - Welcome typed entity id 🍾

EF Core 7 is here - Welcome typed entity id 🍾

7
Comments 1
5 min read
Deja de escribir código SQL dentro de código Go, ¡la solución está aquí!

Deja de escribir código SQL dentro de código Go, ¡la solución está aquí!

5
Comments
2 min read
YugabyteDB auto-sharding (showing tablet size with Grafana)

YugabyteDB auto-sharding (showing tablet size with Grafana)

4
Comments
8 min read
Weather Observation Station 17 Hackerrank Solution

Weather Observation Station 17 Hackerrank Solution

3
Comments
1 min read
SQL vs NoSQL

SQL vs NoSQL

14
Comments
4 min read
Apache Spark SQL: CTAS USING CSV with specific delimiter

Apache Spark SQL: CTAS USING CSV with specific delimiter

3
Comments
1 min read
SQL and Table Relationships

SQL and Table Relationships

1
Comments 2
3 min read
Flashback query in YugabyteDB

Flashback query in YugabyteDB

1
Comments
6 min read
Weather Observation Station 15 Hackerrank Solution

Weather Observation Station 15 Hackerrank Solution

3
Comments
1 min read
使用 SQL 產生流水單號

使用 SQL 產生流水單號

3
Comments
2 min read
Typesafe Database Queries on the Edge

Typesafe Database Queries on the Edge

18
Comments 6
6 min read
How to create Stored Procedure in MySQL

How to create Stored Procedure in MySQL

2
Comments
1 min read
How to use delimiter in MySQL

How to use delimiter in MySQL

2
Comments
1 min read
Build a SQL GUI in 5 Steps with Budibase

Build a SQL GUI in 5 Steps with Budibase

3
Comments
14 min read
sqly - execute SQL against CSV / TSV / LTSV / JSON with shell

sqly - execute SQL against CSV / TSV / LTSV / JSON with shell

4
Comments 1
2 min read
Ideal Transformation Steps in dbt

Ideal Transformation Steps in dbt

2
Comments
3 min read
Effective Queries with Rails and PostgreSQL

Effective Queries with Rails and PostgreSQL

15
Comments
14 min read
MariaDB Xpand Distributed MySQL - Foreign key but no Serializable

MariaDB Xpand Distributed MySQL - Foreign key but no Serializable

3
Comments
8 min read
4 Step Strategy to Migrate SQL Server to Azure Cloud

4 Step Strategy to Migrate SQL Server to Azure Cloud

2
Comments
1 min read
Stop writing your SQL code inside your Go source files!

Stop writing your SQL code inside your Go source files!

42
Comments 6
2 min read
SQLAlchemy Expression Language - Just Enough

SQLAlchemy Expression Language - Just Enough

4
Comments 2
8 min read
Quick tip: Using SQLAlchemy with SingleStoreDB

Quick tip: Using SQLAlchemy with SingleStoreDB

2
Comments
5 min read
Command-line data analytics made easy with SPyQL

Command-line data analytics made easy with SPyQL

6
Comments
6 min read
Removendo registros duplicados de uma tabela no PostgreSQL

Removendo registros duplicados de uma tabela no PostgreSQL

2
Comments
2 min read
🚀 Autonomous Sharding in YugabyteDB (with automatic tablet splitting)

🚀 Autonomous Sharding in YugabyteDB (with automatic tablet splitting)

Comments
5 min read
PostgreSQL unit-11

PostgreSQL unit-11

Comments
1 min read
My Hacktober 2022 Contributions mostly SQL DDL uml extensions

My Hacktober 2022 Contributions mostly SQL DDL uml extensions

1
Comments
2 min read
How to set Read Committed in YugabyteDB

How to set Read Committed in YugabyteDB

3
Comments 2
2 min read
How to import json to SQL

How to import json to SQL

Comments
1 min read
DDL on SQLAlchemy Core API

DDL on SQLAlchemy Core API

8
Comments
4 min read
Geo Location Search with SQL Server

Geo Location Search with SQL Server

4
Comments 1
2 min read
plsql anonymous blocks

plsql anonymous blocks

2
Comments
1 min read
Statistics Cheat Sheet: Data Collection and Exploration

Statistics Cheat Sheet: Data Collection and Exploration

3
Comments
18 min read
Hibernate One to Many Example using Annotation

Hibernate One to Many Example using Annotation

3
Comments
3 min read
Creating an API using Go and sqlc

Creating an API using Go and sqlc

17
Comments 2
11 min read
How to build an Application with PHP and PostgreSQL

How to build an Application with PHP and PostgreSQL

15
Comments 3
4 min read
Product Scalability In Startups And How To Choose A Database As A Lead Engineer.

Product Scalability In Startups And How To Choose A Database As A Lead Engineer.

22
Comments
10 min read
SQL + Python + Spark for Data Science

SQL + Python + Spark for Data Science

6
Comments
38 min read
We launched an open source ClickHouse Knowledge Base

We launched an open source ClickHouse Knowledge Base

2
Comments
2 min read
Postgres Views in Supabase Have Only One Problem

Postgres Views in Supabase Have Only One Problem

2
Comments 2
3 min read
SQL 101

SQL 101

3
Comments
1 min read
Dolt - SQL database for Git

Dolt - SQL database for Git

6
Comments 4
1 min read
PostgreSQL unit-10

PostgreSQL unit-10

Comments
1 min read
PostgreSQL unit-9

PostgreSQL unit-9

Comments
1 min read
Laravel Query nested JSON Column without case sensitivity

Laravel Query nested JSON Column without case sensitivity

3
Comments 1
1 min read
PostgreSQL unit-7

PostgreSQL unit-7

Comments
1 min read
PostgreSQL unit-8

PostgreSQL unit-8

Comments
1 min read
loading...