1. Add the test db and users table: https://railsdrop.com/2025/04/25/rails-8-app-postgresql-heap-vs-mysql-innodb-b-tree-indexing/ 2. Add fake data into the table: https://railsdrop.com/2025/04/29/rails-8-app-postgresql-faker-extensions-for-rails/ Start Learn (Premium): https://railsdrop.com/sql-postgresql-queries-bitmap-seq-index-scan-db-clustering/ 📌 Summary of all queries Check: https://railsdrop.com/postgresql-queries-a-summary/ Read – Composite vs Individual indexes (Premium): https://railsdrop.com/sql-postgres-understanding-current-composite-index/ Read Create 1 million sample users: https://railsdrop.com/sql-postgresql-create-1-million-sample-users-data/ 👉 1. SELECT – Basic Query 🔹 1. Select all columns: This … Continue reading Rails 8 App: Setup Test DB in PostgreSQL | Write SQL Queries