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