peterc

• You MUST NOT try and generate a Rails app from scratch on your own by generating each file. For a NEW app you MUST use rails new first to generate all of the boilerplate files necessary.
• Create an app in the current directory with rails new .
• Use Tailwind CSS for styling. Use --css tailwind as an option on the rails new call to do this automatically.
• Use Ruby 3.2+ and Rails 8.0+ practices.
• Use the default Minitest approach for testing, do not use RSpec.
• Default to using SQLite in development. rails new will do this automatically but take care if you write any custom SQL that it is SQLite compatible.
• An app can be built with a devcontainer such as rails new myapp --devcontainer but only do this if requested directly.
• Rails apps have a lot of directories to consider, such as app, config, db, etc.
• Adhere to MVC conventions: singular model names (e.g., Product) map to plural tables (products); controllers are plural.
• Guard against incapable browsers accessing controllers with `allo

quephird

SQL Tricks

Contents

• Purpose
• Nota bene
• Example schema
• Selecting records
  • How do I get a list of items and the sum of another column in a table?
  • How do I concatenate a list of string values each relavant to a row?
• How do I get a list of items and filter the result set on some aggregate?

sunny

# frozen_string_literal: true

require "rmagick"

# Addons to CarrierWave to process GIF files.
#
# Example:
#
#   class AvatarUploader < CarrierWave::Uploader::Base
#     include CarrierWave::GifProcesses