Code Snippets

ActiveRecord Query Snippet

Ruby

Define a model and run a chained where/order query with ActiveRecord.

require 'active_record'

ActiveRecord::Base.establish_connection(
  adapter: 'sqlite3',
  database: 'app.sqlite3'
)

class User < ActiveRecord::Base; end

User.where(active: true).order(created_at: :desc).limit(10).each do |u|
  puts "#{u.id} #{u.email}"
end
Database ActiverecordOrmSql chris

More in Database

SQLite with the sqlite3 Stdlib Database Create a table, insert rows, and query with parameterized SQL. PDO MySQL Connection in PHP Database Connect to MySQL with PDO and run a prepared SELECT. Connect to PostgreSQL in Go Database Open a database/sql handle to Postgres and query rows. Connect to MySQL with DBI Database Open a DBI handle to MySQL, run a SELECT, and iterate rows.

Random picks

Date Arithmetic in Bash Utilities GNU date supports relative expressions — yesterday, +7 days, etc. Find and Replace with sed Strings & Text Edit a file in place with sed -i, replacing matches globally. Sort Array of Objects in JS Sorting & Data Structures Sort with Array.prototype.sort and a comparator function. SHA256 with the sha2 Crate Cryptography & Hashing Compute a SHA256 hex digest with the sha2 crate. Unit Tests with Minitest Utilities Stdlib Minitest spec — no extra gems needed.
Recently added
  • Background Jobs and wait
  • Loop SSH Across Hosts
  • Install a Cron Job from a Script
  • Compress a Directory with tar
  • Find Files Recursively
Categories
  • CLI & System 12
  • Concurrency 11
  • Cryptography & Hashing 8
  • Database 5
  • File I/O 21
  • Networking & HTTP 12
  • Sorting & Data Structures 10
  • Strings & Text 11
  • Utilities 16
  • Web Development 6
Tags
File 21 Io 13 Http 11 Json 8 Cli 8 Regex 8 Hash 7 Sort 7 Recursion 7 Serialization 7 Args 7 Concurrency Tag 6 Digest 6 Capture 6 Get 6 Web 6 Sha256 5 Async 5 Arrays 5 Sql 5 Loops 4 Functional 4 Threads 4 System 4 Encoding 3 Node 3 Errors 2 Server 2 Hashes 2 Find 2 Smtp 2 Walk 2 Glob 2 Routes 2 Curl 2 Email 2 Performance 2 Strings Tag 2 Url 2 Database Tag 2 Mysql 2 Password 1 Waitgroup 1 Promises 1 Portable 1 Requests 1 Optionparser 1 Websocket 1 Orm 1 Pdo 1
Languages
  • Bash 14
  • Go 14
  • JavaScript 14
  • Perl 14
  • PHP 14
  • Python 14
  • Ruby 14
  • Rust 14
© 2026 Code Snippets