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.
What is SQL Injection and How to prevent it?

What is SQL Injection and How to prevent it?

11
Comments 1
10 min read
5 ways to store market data: CSV, SQLite, Postgres, Mongo, Arctic

5 ways to store market data: CSV, SQLite, Postgres, Mongo, Arctic

3
Comments
5 min read
The best indexes for an execution plan that never gets (too) wrong

The best indexes for an execution plan that never gets (too) wrong

2
Comments
15 min read
Using Postgres as a task queue for rowdy Gophers

Using Postgres as a task queue for rowdy Gophers

4
Comments
13 min read
Online PHP & SQL sandbox with ChatGPT support

Online PHP & SQL sandbox with ChatGPT support

47
Comments 6
2 min read
How to configure WordPress in Nextjs using REST API

How to configure WordPress in Nextjs using REST API

1
Comments
4 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
PostgreSQL and YugabyteDB partitioning and indexes

PostgreSQL and YugabyteDB partitioning and indexes

4
Comments
7 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
Matching search Text become small like google suggestions in Js

Matching search Text become small like google suggestions in Js

4
Comments
1 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
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

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

EF Core 7 is here - Welcome typed entity id 🍾

8
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
[MSSQL] 使用 SQL 產生流水單號

[MSSQL] 使用 SQL 產生流水單號

3
Comments
1 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

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