close
The Wayback Machine - https://web.archive.org/web/20221208142901/https://dev.to/t/sql

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.
MySQL 8: short syntax for select all

MySQL 8: short syntax for select all

Reactions 3 Comments 1
1 min read
Why do SQL Server views need refreshing?

Why do SQL Server views need refreshing?

Reactions 6 Comments 1
2 min read
How join works internally in SQL

How join works internally in SQL

Reactions 18 Comments 4
2 min read
What is SQL Injection and How to prevent it?

What is SQL Injection and How to prevent it?

Reactions 9 Comments
10 min read
Using Postgres as a task queue for rowdy Gophers

Using Postgres as a task queue for rowdy Gophers

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

Weather Observation Station 17 Hackerrank Solution

Reactions 3 Comments
1 min read
Advent of Code - Day 4

Advent of Code - Day 4

Reactions 5 Comments
3 min read
Advent of Code - Day 3

Advent of Code - Day 3

Reactions 4 Comments
6 min read
Advent of Code - Day 1

Advent of Code - Day 1

Reactions 9 Comments
4 min read
SQL Join explained!

SQL Join explained!

Reactions 7 Comments
2 min read
Online PHP & SQL sandbox

Online PHP & SQL sandbox

Reactions 6 Comments 4
2 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
Scalable Job Queue in SQL (YugabyteDB)

Scalable Job Queue in SQL (YugabyteDB)

Reactions 21 Comments 3
5 min read
OpenAI SQL Query generator with GPT-3 and Nextjs

OpenAI SQL Query generator with GPT-3 and Nextjs

Reactions 8 Comments 1
6 min read
Advent of Code - Day 2

Advent of Code - Day 2

Reactions 5 Comments
4 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
The best indexes for an execution plan that never gets (too) wrong

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

Reactions 2 Comments
15 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 34 Comments
2 min read
To SQL or NoSQL?

To SQL or NoSQL?

Reactions 9 Comments
5 min read
SQL Vs NoSQL

SQL Vs NoSQL

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

PostgreSQL and YugabyteDB partitioning and indexes

Reactions 4 Comments
7 min read
ClickHouse Fundamentals: Part 2

ClickHouse Fundamentals: Part 2

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

Reactions 5 Comments
9 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 10 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 40 Comments 6
2 min read
Anyone using Supabase?

Anyone using Supabase?

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