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.
Database 101: Data Consistency for Beginners

Database 101: Data Consistency for Beginners

467
Comments 44
7 min read
A Guide to Memoization in Ruby

A Guide to Memoization in Ruby

Comments
7 min read
SQL doesn't need the "Single Table Design" but Composite Primary Keys

SQL doesn't need the "Single Table Design" but Composite Primary Keys

13
Comments
13 min read
How to JSON in PostgreSQL®

How to JSON in PostgreSQL®

1
Comments 2
2 min read
The Benefits of Using a Graph Database Instead of SQL

The Benefits of Using a Graph Database Instead of SQL

Comments
10 min read
Why a SQL Statement Often Consists of Hundreds of Lines, Measured by KBs?

Why a SQL Statement Often Consists of Hundreds of Lines, Measured by KBs?

Comments
13 min read
🚀Batched Nested Loop to reduce read requests to the distributed storage

🚀Batched Nested Loop to reduce read requests to the distributed storage

2
Comments
8 min read
Scalable Sequence for PostgreSQL

Scalable Sequence for PostgreSQL

4
Comments
6 min read
Real-world Chrome extensions for web developers

Real-world Chrome extensions for web developers

5
Comments
2 min read
SQL Commands Cheat Sheet

SQL Commands Cheat Sheet

3
Comments
11 min read
Map x flatMap, entendendo a diferença na prática

Map x flatMap, entendendo a diferença na prática

Comments
2 min read
如何使用 JavaScript 下载文件

如何使用 JavaScript 下载文件

4
Comments
2 min read
Boost Your Query Performance with Function-Based Indexes in PostgreSQL

Boost Your Query Performance with Function-Based Indexes in PostgreSQL

3
Comments
1 min read
Dev Retro 2022: Journey in review

Dev Retro 2022: Journey in review

5
Comments
5 min read
Kubernetes - With Mongo & Express App

Kubernetes - With Mongo & Express App

15
Comments
7 min read
Using NebulaGraph Importer to Import Data into NebulaGraph Database

Using NebulaGraph Importer to Import Data into NebulaGraph Database

Comments
5 min read
Promises vs Observables

Promises vs Observables

2
Comments
3 min read
Calling C native code from Java using JNI

Calling C native code from Java using JNI

3
Comments
4 min read
Open-source SPL that can execute SQL without RDB

Open-source SPL that can execute SQL without RDB

Comments
11 min read
Building Streaming Applications with Cloudera SQL StreamBuilder and Apache Pulsar

Building Streaming Applications with Cloudera SQL StreamBuilder and Apache Pulsar

5
Comments
5 min read
A very short demo on updates in YugabyteDB

A very short demo on updates in YugabyteDB

1
Comments
3 min read
truncate vs delete

truncate vs delete

Comments
3 min read
IvorySQL - I've tested some Oracle-PostgreSQL compatibility of version 2.1

IvorySQL - I've tested some Oracle-PostgreSQL compatibility of version 2.1

1
Comments
10 min read
SQL 基礎 Part 03 -- docker-compose で立てたコンテナで立ち上げ時に DB と全権力ユーザーを作成して、外部からログインする

SQL 基礎 Part 03 -- docker-compose で立てたコンテナで立ち上げ時に DB と全権力ユーザーを作成して、外部からログインする

Comments
2 min read
'; SQL_Injection ( ) ;--

'; SQL_Injection ( ) ;--

6
Comments 2
7 min read
loading...