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.
Polymorphic joins in Active Record

Polymorphic joins in Active Record

31
Comments 4
3 min read
Crack the top 40 SQL interview questions

Crack the top 40 SQL interview questions

19
Comments 3
14 min read
Programmatic inspection of databases in Go using Atlas

Programmatic inspection of databases in Go using Atlas

7
Comments
8 min read
Most recent record (of many items) with YugabyteDB 🚀

Most recent record (of many items) with YugabyteDB 🚀

9
Comments
11 min read
YBDemo: simple 💻 demo lab for YugabyteDB with Java client and Docker🚀☕🐳🐘

YBDemo: simple 💻 demo lab for YugabyteDB with Java client and Docker🚀☕🐳🐘

4
Comments
1 min read
Supabase Date Protection on PostgreSQL

Supabase Date Protection on PostgreSQL

18
Comments
3 min read
REST Data Service on YugabyteDB / PostgreSQL with PostgREST

REST Data Service on YugabyteDB / PostgreSQL with PostgREST

12
Comments
3 min read
Coding Unmanaged and Managed Transactions with NodeJS, Express and Sequelize

Coding Unmanaged and Managed Transactions with NodeJS, Express and Sequelize

8
Comments
2 min read
How to shape sample data with PostgreSQL generate_series() and SQL

How to shape sample data with PostgreSQL generate_series() and SQL

7
Comments
21 min read
#SQL na unha: manipulando dados

#SQL na unha: manipulando dados

7
Comments
6 min read
PostgreSQL WAL activities

PostgreSQL WAL activities

7
Comments 2
5 min read
Quick start with Postgres ⚡

Quick start with Postgres ⚡

12
Comments 1
3 min read
Database concurrency as simple as possible

Database concurrency as simple as possible

11
Comments
5 min read
PostgreSQL temp files usage

PostgreSQL temp files usage

27
Comments 20
6 min read
SQL Beginner Friendly Cheatsheet

SQL Beginner Friendly Cheatsheet

16
Comments 1
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.