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

SHA256 Hash in Python Cryptography & Hashing Use hashlib to compute a SHA256 hex digest. Write Lines to a File File I/O Open a file for writing and emit a few lines. Debounce Function in JS Utilities Classic debounce — delay invoking fn until X ms after the last call. Read a File with fs/promises (Node) File I/O Node.js stdlib async file read with fs/promises. Wrap and Unwrap Errors in Go Utilities Wrap errors with fmt.Errorf %w and inspect with errors.Is / As.
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