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

Online PHP & SQL sandbox

Reactions 2 Comments 4
2 min read
ClickHouse Fundamentals: Part 2

ClickHouse Fundamentals: Part 2

Reactions 2 Comments
4 min read
SQL Vs NoSQL

SQL Vs NoSQL

Reactions 4 Comments
1 min read
PostgreSQL and YugabyteDB partitioning and indexes

PostgreSQL and YugabyteDB partitioning and indexes

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

Reactions 3 Comments
9 min read
Weather Observation Station 17 Hackerrank Solution

Weather Observation Station 17 Hackerrank Solution

Reactions 3 Comments
1 min read
Create Upsert Yourself for Amazon Redshift Databases

Create Upsert Yourself for Amazon Redshift Databases

Reactions 2 Comments
6 min read
Weather Observation Station 15 Hackerrank Solution

Weather Observation Station 15 Hackerrank Solution

Reactions 3 Comments
1 min read
YugabyteDB cloud/region/zone

YugabyteDB cloud/region/zone

Reactions 3 Comments
4 min read
5 ways to store market data: CSV, SQLite, Postgres, Mongo, Arctic

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

Reactions 3 Comments
5 min read
MariaDB Xpand Distributed MySQL

MariaDB Xpand Distributed MySQL

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

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

Reactions 2 Comments
5 min read
SQLAlchemy Expression Language - Just Enough

SQLAlchemy Expression Language - Just Enough

Reactions 2 Comments
8 min read
Transitioning from NoSQL to also implementing SQL

Transitioning from NoSQL to also implementing SQL

Reactions 3 Comments
1 min read
Flashback query in YugabyteDB

Flashback query in YugabyteDB

Reactions 1 Comments
6 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

Reactions 33 Comments
2 min read
To SQL or NoSQL?

To SQL or NoSQL?

Reactions 9 Comments
5 min read
sqly - execute SQL against CSV / TSV / LTSV / JSON with shell

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

Reactions 5 Comments 1
2 min read
Cloud Scheduler to stop a Cloud SQL database

Cloud Scheduler to stop a Cloud SQL database

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

PostgreSQL do different equality predicates make a difference?

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

Quick tip: Using SQLAlchemy with SingleStoreDB

Reactions 2 Comments
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í!

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

EF Core 7 is here - Welcome typed entity id 🍾

Reactions 6 Comments 1
5 min read
If you want to master SQL, then you've to practice it in the right way.

If you want to master SQL, then you've to practice it in the right way.

Reactions 4 Comments
2 min read
YugabyteDB auto-sharding

YugabyteDB auto-sharding

Reactions 4 Comments
8 min read
Eğlenceli SQL Kaynakları 🙂

Eğlenceli SQL Kaynakları 🙂

Reactions 3 Comments
1 min read
Command-line data analytics made easy with SPyQL

Command-line data analytics made easy with SPyQL

Reactions 5 Comments
6 min read
Basics of PostgreSQL

Basics of PostgreSQL

Reactions 9 Comments
2 min read
SQL vs NoSQL

SQL vs NoSQL

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

Apache Spark SQL: CTAS USING CSV with specific delimiter

Reactions 3 Comments
1 min read
plsql anonymous blocks

plsql anonymous blocks

Reactions 2 Comments
1 min read
SQL and Table Relationships

SQL and Table Relationships

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

使用 SQL 產生流水單號

Reactions 2 Comments
2 min read
How to create Stored Procedure in MySQL

How to create Stored Procedure in MySQL

Reactions 2 Comments
1 min read
Removendo registros duplicados de uma tabela no PostgreSQL

Removendo registros duplicados de uma tabela no PostgreSQL

Reactions 1 Comments
2 min read
Typesafe Database Queries on the Edge

Typesafe Database Queries on the Edge

Reactions 11 Comments
6 min read
How to create function in MySQL

How to create function in MySQL

Reactions 3 Comments
1 min read
How to use delimiter in MySQL

How to use delimiter in MySQL

Reactions 2 Comments
1 min read
How to import json to SQL

How to import json to SQL

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

Build a SQL GUI in 5 Steps with Budibase

Reactions 3 Comments
14 min read
Ideal Transformation Steps in dbt

Ideal Transformation Steps in dbt

Reactions 2 Comments
3 min read
Effective Queries with Rails and PostgreSQL

Effective Queries with Rails and PostgreSQL

Reactions 13 Comments
14 min read
4 Step Strategy to Migrate SQL Server to Azure Cloud

4 Step Strategy to Migrate SQL Server to Azure Cloud

Reactions 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!

Reactions 39 Comments 6
2 min read
Anyone using Supabase?

Anyone using Supabase?

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

Exact match search deeply nested objects - PostgreSQL

Reactions 2 Comments
2 min read
Hibernate One to Many Example using Annotation

Hibernate One to Many Example using Annotation

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

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

How to set Read Committed in YugabyteDB

Reactions 2 Comments 2
2 min read
DDL on SQLAlchemy Core API

DDL on SQLAlchemy Core API

Reactions 3 Comments
4 min read
Geo Location Search with SQL Server

Geo Location Search with SQL Server

Reactions 1 Comments
2 min read
How to re-sync auto-increment in PostgreSQL

How to re-sync auto-increment in PostgreSQL

Reactions 5 Comments
1 min read
SQL Server Recovery Model

SQL Server Recovery Model

Reactions 1 Comments
2 min read
Strategies to Build Your Backend with Hasura and PostgreSQL

Strategies to Build Your Backend with Hasura and PostgreSQL

Reactions 11 Comments 2
10 min read
Eliminar todos los procedimientos almacendos con un sentencia SQL Server.

Eliminar todos los procedimientos almacendos con un sentencia SQL Server.

Reactions 1 Comments
1 min read
Creating an API using Go and sqlc

Creating an API using Go and sqlc

Reactions 10 Comments
11 min read
How to build an Application with PHP and PostgreSQL

How to build an Application with PHP and PostgreSQL

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

Reactions 20 Comments
10 min read
loading...