View 01-iterm.scpt
on run {input, parameters}
tell application "iTerm"
create window with default profile
end tell
return input
end run

$ heroku buildpacks:add --index 2 -a zundan-mastodon-experiment
Buildpack added. Next release on zundan-mastodon-experiment will use:
  1. heroku/metrics
  4. heroku/nodejs
  5. heroku/ruby
View Rollbar.txt
ArgumentError: invalid %-encoding (%)
78 non-project frames
1 File "/app/vendor/ruby-2.4.2/lib/ruby/2.4.0/uri/common.rb" line 387 in decode_www_form_component
2 File "/app/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/utils.rb" line 51 in unescape
3 File "/app/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/query_parser.rb" line 150 in unescape
4 File "/app/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/query_parser.rb" line 65 in block (2 levels) in parse_nested_query
5 File "/app/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/query_parser.rb" line 65 in map!
6 File "/app/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/query_parser.rb" line 65 in block in parse_nested_query
7 File "/app/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/query_parser.rb" line 64 in each

Mastodonのrake specを走らせられるようにする



git clone ~/.rbenv
cd ~/.rbenv && src/configure && make -C src
cat << _END > ~/.bashrc
View dmesg.txt
usb 4-2: new full-speed USB device number 3 using ohci-pci
usb 4-2: New USB device found, idVendor=1209, idProduct=2301
usb 4-2: New USB device strings: Mfr=1, Product=2, SerialNumber=3
usb 4-2: Product: Model 01
usb 4-2: Manufacturer: Keyboardio
usb 4-2: SerialNumber: ********
input: Keyboardio Model 01 as /devices/pci0000:00/0000:00:12.1/usb4/4-2/4-2:1.2/0003:1209:2301.0005/input/input16
hid-generic 0003:1209:2301.0005: input,hidraw4: USB HID v1.01 Mouse [Keyboardio Model 01] on usb-0000:00:12.1-2/input2
input: Keyboardio Model 01 as /devices/pci0000:00/0000:00:12.1/usb4/4-2/4-2:1.3/0003:1209:2301.0006/input/input17
hid-generic 0003:1209:2301.0006: input,hidraw5: USB HID v1.01 Mouse [Keyboardio Model 01] on usb-0000:00:12.1-2/input3



SELECT "statuses"."id", "statuses"."updated_at" FROM "statuses"
LEFT OUTER JOIN "accounts" ON "accounts"."id" = "statuses"."account_id"
WHERE ("statuses"."local" = TRUE OR "statuses"."uri" IS NULL)
AND "statuses"."visibility" = 0
$ git clone mastodon-pr515
$ cd mastodon-pr5158
$ git remote add Kjwon15
$ git fetch Kjwon15
$ git merge Kjwon15/streaming
$ heroku create
Creating app... done, ⬢ stark-sands-75673 |
$ heroku buildpacks:add
$ heroku buildpacks:add heroku/nodejs
View ltl.sql
> EXPLAIN ANALYSE SELECT, statuses.updated_at FROM statuses LEFT OUTER JOIN accounts a ON = account_id WHERE (local = true OR statuses.uri IS NULL) AND visibility = 0 AND (reblog_of_id IS NULL) AND (not reply OR in_reply_to_account_id = account_id) AND not silenced ORDER BY DESC LIMIT 40;
Limit (cost=0.14..323.77 rows=40 width=16) (actual time=4862.449..8725.201 rows=40 loops=1)
-> Nested Loop (cost=0.14..20947.19 rows=2589 width=16) (actual time=4862.448..8725.184 rows=40 loops=1)
-> Index Scan Backward using statuses_pkey on statuses (cost=0.08..17682.20 rows=2589 width=24) (actual time=4862.429..8724.707 rows=40 loops=1)
Filter: ((local OR (uri IS NULL)) AND (reblog_of_id IS NULL) AND ((NOT reply) OR (in_rep
View with_reblog_is_null.sql
> EXPLAIN ANALYZE SELECT "reblog_of_id" FROM "statuses" WHERE ("reblog_of_id" = 11 OR "reblog_of_id" IS NULL) AND "account_id" = 1 ORDER BY "id" DESC;
Sort (cost=5391.51..5393.22 rows=3402 width=16) (actual time=49741.632..49741.844 rows=2716 loops=1)
Sort Key: id DESC
Sort Method: quicksort Memory: 224kB
-> Bitmap Heap Scan on statuses (cost=38.43..5351.60 rows=3402 width=16) (actual time=3130.508..49736.730 rows=2716 loops=1)
Recheck Cond: (account_id = 1)
Filter: ((reblog_of_id = 11) OR (reblog_of_id IS NULL))
Rows Removed by Filter: 1167
View 00-faillog.txt
remote: Gem::Ext::BuildError: ERROR: Failed to build gem native extension.
remote: current directory:
remote: /tmp/build_0a3b28f1eec68065064b0713c9d97b3a/vendor/bundle/ruby/2.4.0/gems/charlock_holmes-0.7.5/ext/charlock_holmes
remote: /tmp/build_0a3b28f1eec68065064b0713c9d97b3a/vendor/ruby-2.4.1/bin/ruby -r
remote: ./siteconf20170913-2062-1bdbmp7.rb extconf.rb
remote: checking for -licui18n... yes
remote: checking for -licui18n... yes
remote: checking for unicode/ucnv.h... yes
remote: checking for -lz... yes