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

2
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

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

How to build an Application with PHP and PostgreSQL

13
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-8

PostgreSQL unit-8

Comments
1 min read
PostgreSQL unit-7

PostgreSQL unit-7

Comments
1 min read
PostgresSQL unit-6

PostgresSQL unit-6

Comments
1 min read
Event triggers on MS SQL Server database

Event triggers on MS SQL Server database

3
Comments
4 min read
YugabyteDB Skip Scan aka Loose Index Scan on compound index

YugabyteDB Skip Scan aka Loose Index Scan on compound index

2
Comments
5 min read
Database Interaction with SQLAlchemy - Raw DML & DQL

Database Interaction with SQLAlchemy - Raw DML & DQL

6
Comments
6 min read
SQL vs NoSQL: Choosing a database for your next project

SQL vs NoSQL: Choosing a database for your next project

48
Comments 2
11 min read
How to re-sync auto-increment in PostgreSQL

How to re-sync auto-increment in PostgreSQL

7
Comments
1 min read
Exact match search deeply nested objects - PostgreSQL

Exact match search deeply nested objects - PostgreSQL

2
Comments
2 min read
Is CosmosDB a new SQL database? Is CitusDB a distributed SQL database? Has Hyperscale vanished in the Hyperspace?

Is CosmosDB a new SQL database? Is CitusDB a distributed SQL database? Has Hyperscale vanished in the Hyperspace?

5
Comments
6 min read
Database Interaction with SQLAlchemy - Raw DDL Tour

Database Interaction with SQLAlchemy - Raw DDL Tour

2
Comments
7 min read
How does ShardingSphere’s Show processlist & Kill Work?

How does ShardingSphere’s Show processlist & Kill Work?

Comments
9 min read
Importing 3m rows/sec with io_uring

Importing 3m rows/sec with io_uring

Comments
11 min read
Kaplan Meier Estimator in Python

Kaplan Meier Estimator in Python

3
Comments
5 min read
Laravel: Alter a foreign key constraint

Laravel: Alter a foreign key constraint

2
Comments
2 min read
Indexes in SQL {Using Rails}

Indexes in SQL {Using Rails}

2
Comments
2 min read
An Introduction To Databases

An Introduction To Databases

Comments
5 min read
SingleStore - is there a workaround for unsupported Foreign Key?

SingleStore - is there a workaround for unsupported Foreign Key?

2
Comments
6 min read
Uso de sp_helptext nameprocedure en SQLSERVER

Uso de sp_helptext nameprocedure en SQLSERVER

Comments
1 min read
Alterar tabla de base de datos y agregar llaves foraneas.

Alterar tabla de base de datos y agregar llaves foraneas.

2
Comments
1 min read
PostgresSQL unit-1

PostgresSQL unit-1

Comments
1 min read
SQL Server Recovery Model

SQL Server Recovery Model

1
Comments
2 min read
This SQL solution is GENIUS!!🤩

This SQL solution is GENIUS!!🤩

1
Comments
2 min read
loading...