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.
HarperDB vs. MongoDB vs. PostgreSQL

HarperDB vs. MongoDB vs. PostgreSQL

85
Comments 7
6 min read
Rails SQL Injections

Rails SQL Injections

9
Comments
5 min read
DynamoDB PartiQL - part II: SELECT

DynamoDB PartiQL - part II: SELECT

8
Comments
9 min read
Enabling pgAudit, pgcrypto and scram-SHA-256 in Distributed SQL

Enabling pgAudit, pgcrypto and scram-SHA-256 in Distributed SQL

12
Comments
7 min read
SQL101 SQL Basics (NoSQL to SQL) all on Oracle Autonomous Database 49:36

SQL101 SQL Basics (NoSQL to SQL) all on Oracle Autonomous Database

3
Comments
1 min read
DynamoDB PartiQL – part I: INSERT

DynamoDB PartiQL – part I: INSERT

12
Comments
7 min read
Re-Wheel series part 1 - How does Rails' find_each work?

Re-Wheel series part 1 - How does Rails' find_each work?

14
Comments
4 min read
Ultimate face-off between SQL and NoSQL :

Ultimate face-off between SQL and NoSQL :

7
Comments 3
4 min read
SQL Join vs Subquery: The Game Changer

SQL Join vs Subquery: The Game Changer

36
Comments 2
3 min read
What is time-series data, and why are we building a time-series database (TSDB)?

What is time-series data, and why are we building a time-series database (TSDB)?

17
Comments
7 min read
What are SQL Joins? Types of SQL joins explained

What are SQL Joins? Types of SQL joins explained

66
Comments 1
6 min read
Write complex SQL with sub query easily in Rails

Write complex SQL with sub query easily in Rails

10
Comments 3
1 min read
4 Quick Facts About dbt Testing

4 Quick Facts About dbt Testing

10
Comments
4 min read
Basics SQL - CREATE Database

Basics SQL - CREATE Database

12
Comments
1 min read
How To Integrate HoneySQL with PostgreSQL

How To Integrate HoneySQL with PostgreSQL

4
Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.