bensheldon

In my application every time I send a newsletter to a User, I create a NewsletterDelivery record. I frequently want to be able to query, for each user, what is the most recent newsletter delivery record. This is called a "last n per group" query and a LATERAL JOIN is the best way to do it imo. But the query I've been using (and I've told people to use, and seen blogged about) is not very good, because the conditions don't get pushed down into the subselect which means that the query ends-up lateral-joining all the records before it applies the conditions for the association.

Instead of doing subselect_table.* the better query does association.id AS assocation_id, subselect_table.id, subselect_table.title, .... and enumerates over all of the columns. This allows the association query, which Active Record tacks on at the end as WHERE association_id = $1 or WHERE association_id IN ($1, $2, $3, ...) to be pushed down c

joeldrapper

[
	{
		"context": "Editor",
		"bindings": {
			"alt-up": "editor::SelectLargerSyntaxNode",
			"alt-down": "editor::SelectSmallerSyntaxNode",
			"ctrl-cmd-up": "editor::MoveLineUp",
			"ctrl-cmd-down": "editor::MoveLineDown"
		}
	}

julianrubisch

<div data-controller="search">
  <div data-search-target="button">
    <div role="button" data-action="click->search#open keydown.meta+k@document->search#open keydown.ctrl+k@document->search#open" class="outline secondary search">
      <%= heroicon "magnifying-glass" %>
      <span>Search</span>
      <kbd>Cmd/Ctrl+K</kbd>
    </div>

    <dialog data-search-target="dialog">
      <article>

dhh

#!/usr/bin/env bash

# Abort sign off on any error
set -e

# Start the benchmark timer
SECONDS=0

# Repository introspection
OWNER=$(gh repo view --json owner --jq .owner.login)

kaspth

require "bundler/inline"

gemfile do
  gem "rails"
  gem "sqlite3"
end

require "active_record"
require "action_controller"
require "rails"

mediafinger

# filename: single_page_rails_app.ru
# RUN via: `rackup single_page_rails_app.ru`

require "bundler/inline"

gemfile(true) do
  source "https://rubygems.org"

  gem "rack", "2.2.9"
  gem "rails", "~> 7.1"

AliOsm

KAMAL_REGISTRY_PASSWORD=dckr_pat_xXXxx_x0xXxXx-xX-XXX0xX0x-x
RAILS_MASTER_KEY=00x00xxx000xxx000000xx0x000x0x00
POSTGRES_PASSWORD=xXxxx0xXXx0
MEILI_MASTER_KEY=xXxxx0xXXx0
BLAZER_DATABASE_URL=postgres://service:{POSTGRES_PASSWORD}@service-name-postgres:5432/service_production

bradgessler

class OAuth::GoogleAuthorizationsController < ApplicationController
  CLIENT_ID = Rails.application.credentials.google.client_id
  CLIENT_SECRET = Rails.application.credentials.google.client_secret
  SCOPE = "openid email profile"

  AUTHORIZATION_URL = URI("https://accounts.google.com/o/oauth2/v2/auth")
  TOKEN_URL = URI("https://www.googleapis.com/oauth2/v4/token")
  USER_INFO_URL = URI("https://www.googleapis.com/oauth2/v3/userinfo")

  before_action :validate_state_token, only: :show

zakariaf

Rails 7 new features. Before and After

• Add ComparisonValidator
• PostgreSQL generated columns
• PostgreSQL custom enum types
• Add tracking of belongs_to association
• association_previously_changed? method
• Add invert_where method
• Add associated method
• Add missing method
• Active Record Encryption

Envek

# spec/system/support/login_helpers.rb
# See this blog post for setup guide: https://evilmartians.com/chronicles/system-of-a-test-setting-up-end-to-end-rails-testing

module LoginHelpers
  def login_as(user)
    # Craft session cookie to make request authenticated (to pass even routing constraints)
    # Compilation of these:
    #  - https://dev.to/nejremeslnici/migrating-selenium-system-tests-to-cuprite-42ah#faster-signin-in-tests
    #  - https://turriate.com/articles/2011/feb/how-to-generate-signed-rails-session-cookie
    #  - https://github.com/rails/rails/blob/43e29f0f5d54294ed61c31ddecdf76c2e1a474f7/actionpack/test/dispatch/cookies_test.rb#L350