Masakazu Matsushita matsukaz

What Is a Good Developer Experience

Vratislav Kalenda: The only way how to have happy & productive developers [DevFest CZ 2018]

プロダクトに合ったアーキテクチャ

シンプルに寄せるか、複雑に寄せるか、度合いの問題
- シンプルに寄せるとあとから痛みが来る
- 複雑に寄せるとすぐに痛みが来る
アーキテクチャを決める際は制約を考慮する

sysctlで設定可能な項目について調査した内容。

進め方

こまめに話しながらコミュニケーションを取る
やった作業はSlackで共有
全体構成など整理しやすいように、ホワイトボードを活用

当日やること

課題の理解

This query is to find geolocation of an IP address including latitude, longitude, city and country.

Legacy SQL doesn't support range conditions such as BETWEEN when using JOIN, so we need to filter data by WHERE. This means if IP address does not match any of the data inside geolite_city_bq_b2b, records will not be able to receive.

Use Standard SQL if you want to receive records no matter you succeed to find geolocation or not.

Please refer to the following post for more detail.

https://cloudplatform.googleblog.com/2014/03/geoip-geolocation-with-google-bigquery.html

	module xxx
	class Application < Rails::Application

	#（中略）

	config.middleware.swap ActiveRecord::ConnectionAdapters::ConnectionManagement,
	'ActiveRecord::ConnectionAdapters::ReconnectOnErrorManagement'
	end
	end

	### Keybase proof

	I hereby claim:

	* I am matsukaz on github.
	* I am matsukaz (https://keybase.io/matsukaz) on keybase.
	* I have a public key ASCBEp_cERws8a9bgyJk6TWOlgQlpLEPq8atcv--G9Ynwwo

	To claim this, I am signing this object:

	// see) https://github.com/rufuspollock/s3-bucket-listing

	if (typeof S3BL_IGNORE_PATH == 'undefined' \|\| S3BL_IGNORE_PATH!=true) {
	var S3BL_IGNORE_PATH = false;
	}

	if (typeof BUCKET_URL == 'undefined') {
	var BUCKET_URL = location.protocol + '//' + location.hostname;
	}

	module Annotations
	@@__last_annotation__ = nil

	def annotations(meth=nil)
	return @@__annotations__[meth] if meth
	@@__annotations__
	end

	private

	protobuf
	protobuf-2.6.0
	protobuf-2.6.1
	protobuf-master

	XCODE_UUID=`defaults read /Applications/Xcode.app/Contents/Info.plist DVTPlugInCompatibilityUUID`
	find ~/Library/Application\ Support/Developer/Shared/Xcode/Plug-ins -name Info.plist \| xargs -IFILE defaults write FILE DVTPlugInCompatibilityUUIDs -array-add ${XCODE_UUID}