Skip to content

Instantly share code, notes, and snippets.

Avatar

Janko Marohnić janko

View GitHub Profile
@janko
janko / benchmark.rb
Last active Sep 16, 2018
Benchmarking different ways of filtering by the associated dataset in SQL
View benchmark.rb
require "sequel"
require "benchmark"
system "createdb testing"
DB = Sequel.postgres("testing")
at_exit do
DB.disconnect
system "dropdb testing"
end
@janko
janko / Gemfile
Created May 31, 2018
Memory profiling of http.rb and other popular Ruby HTTP client libraries
View Gemfile
source "https://rubygems.org"
gem "roda"
gem "http", "~> 3.3"
gem "rest-client"
gem "httparty"
@janko
janko / shrine-uppy-checksum.md
Last active May 4, 2018
Short guide showing how to use checksums when doing direct (S3) uploads using Uppy and Shrine
@janko
janko / walkthrough-resumable.md
Last active May 4, 2018
Simple walkthrough for adding resumable uploads to a Roda & Sequel app with Shrine
@janko
janko / walkthrough-app.md
Last active May 13, 2018
Simple walkthrough for adding direct (S3) uploads to a Roda & Sequel app with Shrine
@janko
janko / concatenation.rb
Last active Sep 8, 2016
Concatenation plugin for Shrine
View concatenation.rb
class Shrine
module Plugins
# The `concatenation` plugin allows you to assign to the attacher a
# cached file which is composed of multiple uploaded parts. The plugin
# will then call `#concat` on the storage, which is expected to
# concatenate the given parts into a single file. The assigned
# attachment will then be a complete cached file.
#
# plugin :concatenation
#
@janko
janko / 0-gemfile.rb
Created Jul 31, 2016
Using Shrine with ROM and dry-rb
View 0-gemfile.rb
source "https://rubygems.org"
gem "shrine", github: "janko-m/shrine"
gem "rom-repository"
gem "rom-sql"
gem "sqlite3"
gem "dry-validation"
gem "roda"
gem "sucker_punch", "~> 2.0"
@janko
janko / activerecord.md
Last active May 7, 2016
Response to http://bikeshed.fm/56 regarding "ActiveRecord is Reinventing Sequel"
View activerecord.md

Hey Sean,

I just encountered your "The Bike Shed" podcast, concretely number #56 where you were talking about the "ActiveRecord is Reinventing Sequel" post I wrote. I'm sorry that this post struck you as negative, and that it made you feel like I was attacking you. I admit that I did feel some negative energy while I was writing it, but I still felt like I needed to say it.

Firstly, you said in the podcast that you would like to read an article which shows parts where Sequel is better than ActiveRecord. However, I did link my previous "Ode to Sequel" post in the first paragraph of my post, and soon after added two more. So I think it's a bit unfair that I was pr

View sequel.rb
require "sequel"
DB = Sequel.postgres("arel")
DB.create_table!(:movies) { primary_key :id }
class Movie < Sequel::Model
end
# Asterisk (I agree this one isn't ideal)
Movie.select{count{}.*} # SELECT count(*) FROM "movies"
@janko
janko / 1-activerecord.rb
Last active Sep 25, 2020
INSERTing 50,000 records into a database in ActiveRecord, Arel, SQL, activerecord-import and Sequel.
View 1-activerecord.rb
require "active_record"
ActiveRecord::Base.establish_connection(adapter: "sqlite3", database: ":memory:")
ActiveRecord::Migration.class_eval do
create_table(:records) do |t|
t.string :column
end
end
data = 50_000.times.map { |i| Hash[column: "Column #{i}"] }