Do your columns contain Unicode Characters?
Want to work out if any of your columns contain Unicode Characters?
Something.where('LENGTH(data) != CHAR_LENGTH(data)').first
Want to work out if any of your columns contain Unicode Characters?
Something.where('LENGTH(data) != CHAR_LENGTH(data)').first
But it is empty???
rails@snarf:~$ ls -la /var/www/robl.me/releases/20160323235726/tmp/cache/assets/sprockets/v3.0
total 40
drwxrwxr-x 2 rails rails 36864 Dec 16 15:11 .
drwxrwxr-x 3 rails rails 4096 Mar 23 2016 ..
rails@snarf:~$ rmdir /var/www/robl.me/releases/20160323235726/tmp/cache/assets/sprockets/v3.0
rmdir: failed to remove ‘/var/www/robl.me/releases/20160323235726/tmp/cache/assets/sprockets/v3.0’: Directory not empty
Just went hunting for Date and Time formats, found this.
activesupport-5.0.0.beta3/lib/active_support/locale/en.yml
en:
date:
formats:
# Use the strftime parameters for formats.
# When no format has been given, it uses default.
# You can provide other formats here if you like!
default: "%Y-%m-%d"
short: "%b %d"
long: "%B %d, %Y"
day_names: [Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday]
abbr_day_names: [Sun, Mon, Tue, Wed, Thu, Fri, Sat]
# Don't forget the nil at the beginning; there's no such thing as a 0th month
month_names: [~, January, February, March, April, May, June, July, August, September, October, November, December]
abbr_month_names: [~, Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec]
# Used in date_select and datetime_select.
order:
- year
- month
- day
time:
formats:
default: "%a, %d %b %Y %H:%M:%S %z"
short: "%d %b %H:%M"
long: "%B %d, %Y %H:%M"
am: "am"
pm: "pm"
# Used in array.to_sentence.
support:
array:
words_connector: ", "
two_words_connector: " and "
last_word_connector: ", and "
number:
# Used in NumberHelper.number_to_delimited()
# These are also the defaults for 'currency', 'percentage', 'precision', and 'human'
format:
# Sets the separator between the units, for more precision (e.g. 1.0 / 2.0 == 0.5)
separator: "."
# Delimits thousands (e.g. 1,000,000 is a million) (always in groups of three)
delimiter: ","
# Number of decimals, behind the separator (the number 1 with a precision of 2 gives: 1.00)
precision: 3
# If set to true, precision will mean the number of significant digits instead
# of the number of decimal digits (1234 with precision 2 becomes 1200, 1.23543 becomes 1.2)
significant: false
# If set, the zeros after the decimal separator will always be stripped (eg.: 1.200 will be 1.2)
strip_insignificant_zeros: false
# Used in NumberHelper.number_to_currency()
currency:
format:
# Where is the currency sign? %u is the currency unit, %n the number (default: $5.00)
format: "%u%n"
unit: "$"
# These five are to override number.format and are optional
separator: "."
delimiter: ","
precision: 2
significant: false
strip_insignificant_zeros: false
# Used in NumberHelper.number_to_percentage()
percentage:
format:
# These five are to override number.format and are optional
# separator:
delimiter: ""
# precision:
# significant: false
# strip_insignificant_zeros: false
format: "%n%"
# Used in NumberHelper.number_to_rounded()
precision:
format:
# These five are to override number.format and are optional
# separator:
delimiter: ""
# precision:
# significant: false
# strip_insignificant_zeros: false
# Used in NumberHelper.number_to_human_size() and NumberHelper.number_to_human()
human:
format:
# These five are to override number.format and are optional
# separator:
delimiter: ""
precision: 3
significant: true
strip_insignificant_zeros: true
# Used in number_to_human_size()
storage_units:
# Storage units output formatting.
# %u is the storage unit, %n is the number (default: 2 MB)
format: "%n %u"
units:
byte:
one: "Byte"
other: "Bytes"
kb: "KB"
mb: "MB"
gb: "GB"
tb: "TB"
pb: "PB"
eb: "EB"
# Used in NumberHelper.number_to_human()
decimal_units:
format: "%n %u"
# Decimal units output formatting
# By default we will only quantify some of the exponents
# but the commented ones might be defined or overridden
# by the user.
units:
# femto: Quadrillionth
# pico: Trillionth
# nano: Billionth
# micro: Millionth
# mili: Thousandth
# centi: Hundredth
# deci: Tenth
unit: ""
# ten:
# one: Ten
# other: Tens
# hundred: Hundred
thousand: Thousand
million: Million
billion: Billion
trillion: Trillion
quadrillion: Quadrillion
mysql> UPDATE logs LEFT JOIN ip_ranges ON logs.ip_int BETWEEN ip_ranges.start_ip AND ip_ranges.end_ip SET logs.country = ip_ranges.country_code WHERE logs.country IS NULL;
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
mysql> show open tables where in_use>0;
+-----------------------------------+---------------+--------+-------------+
| Database | Table | In_use | Name_locked |
+-----------------------------------+---------------+--------+-------------+
| production | logs | 2 | 0 |
| production | ip_ranges | 2 | 0 |
+-----------------------------------+---------------+--------+-------------+
2 rows in set (0.00 sec)
mysql> show processlist;
+----+------+-----------+-----------------------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+-----------+-----------------------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
| 1 | root | localhost |production | Sleep | 14 | | NULL |
| 4 | root | localhost | production | Query | 3857 | Sending data | SELECT COUNT(*) FROM `download_logs` JOIN ip_ranges ON ip_int BETWEEN ip_ranges.start_ip AND ip_rang |
| 5 | root | localhost | production | Query | 3563 | Sending data | UPDATE `logs` JOIN ip_ranges ON ip_int BETWEEN ip_ranges.start_ip AND ip_ranges.end_ip SET |
| 8 | root | localhost | production | Query | 0 | init | show processlist |
+----+------+-----------+-----------------------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
4 rows in set (0.00 sec)
mysql> kill 4;
Query OK, 0 rows affected (0.00 sec)
mysql> show processlist;
+----+------+-----------+-----------------------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+-----------+-----------------------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
| 1 | root | localhost | production | Sleep | 46 | | NULL |
| 5 | root | localhost | production | Query | 3595 | Sending data | UPDATE `download_logs` JOIN ip_ranges ON ip_int BETWEEN ip_ranges.start_ip AND ip_ranges.end_ip SET |
| 8 | root | localhost | production | Query | 0 | init | show processlist |
+----+------+-----------+-----------------------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
3 rows in set (0.00 sec)
mysql> kill 5;
Query OK, 0 rows affected (0.00 sec)
mysql> show processlist;
+----+------+-----------+-----------------------------------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+-----------+-----------------------------------+---------+------+-------+------------------+
| 1 | root | localhost | production | Sleep | 59 | | NULL |
| 8 | root | localhost | production | Query | 0 | init | show processlist |
+----+------+-----------+-----------------------------------+---------+------+-------+------------------+
2 rows in set (0.00 sec)
mysql> kill 1;
Query OK, 0 rows affected (0.00 sec)
mysql> show processlist;
+----+------+-----------+-----------------------------------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+-----------+-----------------------------------+---------+------+-------+------------------+
| 8 | root | localhost | production | Query | 0 | init | show processlist |
+----+------+-----------+-----------------------------------+---------+------+-------+------------------+
1 row in set (0.00 sec)
mysql> UPDATE logs LEFT JOIN ip_ranges ON logs.ip_int BETWEEN ip_ranges.start_ip AND ip_ranges.end_ip SET logs.country = ip_ranges.country_code WHERE logs.country IS NULL;
Robs-iMac:pledge_core roblacey$ gem install eventmachine -v 1.0.7
Building native extensions. This could take a while...
ERROR: Error installing eventmachine:
ERROR: Failed to build gem native extension.
/Users/roblacey/.rvm/rubies/ruby-2.2.2/bin/ruby -r ./siteconf20161214-75988-ryo2ti.rb extconf.rb
checking for rb_trap_immediate in ruby.h,rubysig.h... no
checking for rb_thread_blocking_region()... no
checking for ruby/thread.h... yes
checking for rb_thread_call_without_gvl() in ruby/thread.h... yes
checking for inotify_init() in sys/inotify.h... no
checking for __NR_inotify_init in sys/syscall.h... no
checking for writev() in sys/uio.h... yes
checking for rb_thread_fd_select()... yes
checking for rb_fdset_t in ruby/intern.h... yes
checking for rb_wait_for_single_fd()... yes
checking for rb_enable_interrupt()... no
checking for rb_time_new()... yes
checking for sys/event.h... yes
checking for sys/queue.h... yes
checking for clock_gettime()... yes
checking for CLOCK_MONOTONIC_RAW in time.h... yes
checking for CLOCK_MONOTONIC in time.h... yes
creating Makefile
make "DESTDIR=" clean
make "DESTDIR="
compiling binder.cpp
In file included from binder.cpp:20:
./project.h:116:10: fatal error: 'openssl/ssl.h' file not found
#include <openssl/ssl.h>
^
1 error generated.
make: *** [binder.o] Error 1
make failed, exit code 2
Gem files will remain installed in /Users/roblacey/.rvm/gems/ruby-2.2.2@rails41-trunk/gems/eventmachine-1.0.7 for inspection.
Results logged to /Users/roblacey/.rvm/gems/ruby-2.2.2@rails41-trunk/extensions/x86_64-darwin-14/2.2.0-static/eventmachine-1.0.7/gem_make.out
Robs-iMac:pledge_core roblacey$ cat /Users/roblacey/.rvm/gems/ruby-2.2.2@rails41-trunk/extensions/x86_64-darwin-14/2.2.0-static/eventmachine-1.0.7/gem_make.out
/Users/roblacey/.rvm/rubies/ruby-2.2.2/bin/ruby -r ./siteconf20161214-75988-ryo2ti.rb extconf.rb
checking for rb_trap_immediate in ruby.h,rubysig.h... no
checking for rb_thread_blocking_region()... no
checking for ruby/thread.h... yes
checking for rb_thread_call_without_gvl() in ruby/thread.h... yes
checking for inotify_init() in sys/inotify.h... no
checking for __NR_inotify_init in sys/syscall.h... no
checking for writev() in sys/uio.h... yes
checking for rb_thread_fd_select()... yes
checking for rb_fdset_t in ruby/intern.h... yes
checking for rb_wait_for_single_fd()... yes
checking for rb_enable_interrupt()... no
checking for rb_time_new()... yes
checking for sys/event.h... yes
checking for sys/queue.h... yes
checking for clock_gettime()... yes
checking for CLOCK_MONOTONIC_RAW in time.h... yes
checking for CLOCK_MONOTONIC in time.h... yes
creating Makefile
make "DESTDIR=" clean
make "DESTDIR="
compiling binder.cpp
In file included from binder.cpp:20:
./project.h:116:10: fatal error: 'openssl/ssl.h' file not found
#include <openssl/ssl.h>
^
1 error generated.
make: *** [binder.o] Error 1
make failed, exit code 2
Robs-iMac:pledge_core roblacey$ gem install eventmachine -v '1.0.7' -- --with-cppflags=-I/usr/local/opt/openssl/include
Building native extensions with: '--with-cppflags=-I/usr/local/opt/openssl/include'
This could take a while...
Successfully installed eventmachine-1.0.7
Parsing documentation for eventmachine-1.0.7
Installing ri documentation for eventmachine-1.0.7
Done installing documentation for eventmachine after 4 seconds
1 gem installed
Grrrr….. Faraday::SSLError: SSL_connect returned=1 errno=0 state=SSLv3 read server certificate B: certificate verify failed
https://github.com/google/google-api-ruby-client/issues/253
Robs-iMac:epic-invite roblacey$ brew update
Error: /usr/local is not writable. You should change the ownership
and permissions of /usr/local back to your user account:
sudo chown -R $(whoami) /usr/local
Robs-iMac:epic-invite roblacey$ brew updatesudo chown -R $(whoami) /usr/local
Robs-iMac:epic-invite roblacey$ sudo chown -R $(whoami) /usr/local
Password:
Robs-iMac:epic-invite roblacey$ brew update
Updated Homebrew from b77a695 to 34f08a9.
Updated 2 taps (homebrew/core, homebrew/services).
==> New Formulae
alot gitversion libngspice openssl@1.1 sslsplit
amqp-cpp gmic libosmium osmfilter svgcleaner
apache-zeppelin gofabric8 libsquish osrm-backend termbox
archi-steam-farm grafana libuninameslist p11-kit terraform-provisioner-ansible
armor gron linkerd pacparser terragrunt
borg hana liquigraph pdftoedn timewarrior
coffeescript hashcat loc piknik tldr
compose2kube hesiod locateme presto treefrog
consul-backinator hg-fast-export luaver pybind11 ttyd
csvtomd hopenpgp-tools metricbeat pyinvoke ttygif
dbhash hostess mfterm questdb twarc
direvent httpdiff micro rancher-cli typescript
dscanner httpstat mikutter rclone urbit
elvish jsonlint minimesos ripgrep vaulted
eventql jumanpp minio-mc rmlint wdc
feedgnuplot jxrlib modd shyaml wego
folly kube-aws mpage snap-telemetry willgit
fsevents-tools lean-cli nats-streaming-server sonar-scanner xcenv
git-remote-hg lego neatvi sql-translator yarn
git-series libbdplus nmh sqldiff zsh-git-prompt
gitless libdivecomputer nvc ssh-audit zstd
==> Updated Formulae
abcm2ps dropbear httping mksh rocksdb
abi-compliance-checker dropbox-uploader hub mkvtoolnix rolldice
abook dspdfviewer hugo mldonkey roswell
ace dtach hunspell mlogger rswift
acmetool dub hydra mlt rtags
acpica duplicity hyper mmix rtv
activemq dvm hyperscan mobile-shell ruby
advancecomp dwarfutils i2p mogenerator ruby-build
afflib dwdiff ibex monetdb runit
afl-fuzz dxpy ice mongo-c rush
agedu dynamodb-local icu4c mongodb rust
aha efl idris mongoose s-search
airspy eigen imagemagick ✔ monit s6
akka ejabberd imapsync monkeysphere saltstack
algernon ekg2 infer mono sane-backends
allegro elasticsearch influxdb moreutils sassc
amap elixir inspircd mosquitto sbcl
amazon-ecs-cli elixirscript internetarchive mozjpeg sbt
ammonite-repl emacs ios-deploy mpc scala
android-ndk emacs-clang-complete-async ios-sim mpd schismtracker
anjuta embulk ios-webkit-debug-proxy mpfr scons
ansible emp ipbt mpg123 scour
ansible-cmdb emscripten iperf3 mpich scriptcs
ansifilter enca ipfs mpop scw
ansiweather epic5 ironcli mpv sdcc
antigen eris irrlicht msitools sdcv
antlr erlang irssi msktutil sdl2
apache-flink esniper isc-dhcp msmtp sdl_image
apache-spark etcd iso-codes mtools selenium-server-standalone
apktool evince ispc mtr ser2net
app-engine-go-32 exercism jack mu serf
app-engine-go-64 exim jansson multimarkdown sf-pwgen
app-engine-java exploitdb jasper multirust sfcgal
app-engine-python fabio jbake mutt sflowtool
appscale-tools fabric jboss-forge mvtools sfml
apr fastd jemalloc mycli shadowsocks-libev
apr-util fdk-aac-encoder jena mypy shairport-sync
aqbanking fdroidserver jenkins mysql ✔ shared-mime-info
arangodb fdupes jenkins-job-builder mysql-sandbox shellcheck
argon2 ffind jetty mysqltuner shellinabox
argus-clients ffmbc jfrog-cli-go nanopb-generator shpotify
argyll-cms ffmpeg ✔ jlog nasm siege
aria2 ffmpegthumbnailer jmxtrans natalie sift
artifactory ffms2 joe ncdu signify-osx
asciidoc fftw jpegoptim ✔ ncmpc sile
asciinema2gif file-roller jq ncmpcpp simple-tiles
asciiquarium filebeat jruby ncrack sjk
asio fio jsdoc3 neo4j skinny
assh fish json-fortran neofetch sleuthkit
at-spi2-atk flake8 json-glib neon slimerjs
at-spi2-core flatbuffers jsoncpp netpbm smali
atk flatcc jsonnet nettle smartmontools
ats2-postiats fleetctl jsonpp newlisp smlnj
aubio flex jsonschema2pojo nexus sngrep
augeas flow kafka nghttp2 socat
aurora-cli flowgrind kapacitor nginx sops
autoconf-archive fluent-bit kawa nickle source-highlight
autoenv flvmeta kerl nifi sourcekitten
autojump fmt kes nim spatialite-gui
avro-c fobis kettle nmap spatialite-tools
awf fontconfig keybase node ✔ spdylay
aws-apigateway-importer fontforge khal node-build spidermonkey
aws-elasticbeanstalk fonttools khard nodeenv spring-loaded
aws-sdk-cpp ford kibana nomad sqlite
aws-shell format-udf kitchen-sync noti sqlite-analyzer
awscli freeipmi knot notmuch sqlmap
azure-cli freeling kobalt nsd ssdb
b2-tools freeradius-server konoha nspr sshguard
babl freetds kore nss sshuttle
bacula-fd freetype ✔ kotlin ntl ssllabs-scan
baobab fstar kpcli nvm sslscan
basex fswatch kubernetes-cli nzbget sslyze
bash fuseki kyua oauth2_proxy storm
bash-git-prompt fwup languagetool ocamlbuild stout
bash-preexec fzf latex2html offlineimap strongswan
bashdb galen latexml ola stunnel
bazel gammaray launch omega subliminal
bdw-gc gammu launch4j oniguruma subnetcalc
bear gauche lbdb ooniprobe supersonic
beecrypt gauge ldapvi open-babel supervisor
bfg gawk ldc open-mpi suricata
bgpq3 gcc ldns open-scene-graph svtplay-dl
bib-tool gcovr le opencc swagger-codegen
bibtexconv gd leaps openconnect swi-prolog
bind gdal ledger opencsg swift
binutils gdb legit opendbx swiftgen
binwalk gdk-pixbuf leiningen openhmd swiftlint
bitrise gdl lensfun openjpeg swig
blackbox gdm leveldb openrtsp syncthing
bmake geckodriver lfe openshift-cli syncthing-inotify
boost gedit libass openssl ✔ sysdig
boost-bcp gegl libatomic_ops openvdb szl
boost-build generate-json-schema libbluray openvpn taglib ✔
boost-python geoserver libbson ophcrack tailor
botan ghc libbtbb orc takt
brew-gem ghex libcddb oscats tarantool
brotli ginac libcdio osh tbb
bsdconv git libcdr osm-pbf tbox
buku git-annex libcec osm2pgrouting tccutil
c-ares git-archive-all libcouchbase osm2pgsql tcpkali
cabal-install git-cola libdap osmosis telegraf
cadaver git-credential-manager libdrawtext osquery terminal-notifier
caddy git-extras libebur128 owfs terraform
caf git-fixup libetonyek oysttyer texinfo
cake git-flow-avh libexosip packer texmath
calabash git-fresh libflowmanager paket tgui
calc git-imerge libfreenect pam_yubico the_platinum_searcher
carina git-lfs libftdi pandoc the_silver_searcher
carthage git-octopus libgaiagraphics pandoc-citeproc thefuck
cask git-secret libgcrypt pandoc-crossref tig
cassandra git-town libgda pango tile38
castxml git-when-merged libgee pangomm tin
cattle gitbucket libgeotiff paperkey tinc
cayley giter8 libgetdata parallel tinyproxy
ccache gitg libgit2 pass tippecanoe
ccextractor gitlab-ci-multi-runner libgit2-glib passenger titan-server
cconv gjs libgraphqlparser passpie tmux
cereal gjstest libgsf pazpar2 tmux-mem-cpu-load
cern-ndiff glade libicns pcap_dnsproxy todolist
certbot glib libiscsi pcb2gcode tomcat
certigo glib-networking libjson-rpc-cpp pce tor
ceylon glibmm libksba ✔ pdal torsocks
cfr-decompiler glide liblastfm pdf2htmlex trafficserver
cgal glm liblwgeom pdnsrec transcrypt
cgdb global libmagic pdsh translate-shell
cgrep globus-toolkit libmicrohttpd peco translate-toolkit
chaiscript glyr libmill peg typesafe-activator
chapel gnatsd libmongoclient percona-server uchardet
charm gnome-builder libmspub percona-toolkit uhd
charm-tools gnome-icon-theme libmtp pgbadger unbound
cheat gnome-themes-standard libnfs pgcli uncrustify
checkstyle gnu-apl libnotify pgroonga unrar
chisel gnu-complexity libosinfo pgrouting upscaledb
chromedriver ✔ gnu-smalltalk libosip pick urweb
citus gnu-tar libpeas picocom uwsgi
cjdns gnu-units libphonenumber pidcat vala
clang-format gnumeric libpng ✔ pillar valabind
clearlooks-phenix gnupg ✔ libpointing pius valgrind
cli53 gnupg2 libprotoident pkg-config ✔ vapoursynth
clib gnuplot libqalculate planck varnish
cliclick gnuradio librasterlite plantuml vault
clipper gnutls libraw platformio vc4asm
clisp go librdkafka plowshare vcdimager
clutter-gst goaccess libreadline-java pmd vdirsyncer
clutter-gtk gobject-introspection libressl pngcrush vegeta
cmake godep libsamplerate poco verilator
cmocka goffice libscrypt pod2man vert.x
coccinelle gollum libsigc++ ponyc vim
cocoapods google-benchmark libsoup poppler vmtouch
codequery googler libspatialite postgis vnstat
cogl gor libspiro postgres-xc voldemort
collectd gosu libssh2 postgresql voltdb
commandbox govendor libstrophe pre-commit voms
conan gpgme libswiften predictionio vowpal-wabbit
concurrencykit gphoto2 libtess2 premake vte3
consul gpm libtiff ✔ primesieve vultr
consul-template gprof2dot libtorrent-rasterbar privoxy wakatime-cli
convox gputils libu2f-host profanity wartremover
coq gqlplus libuv progress watch
corectl gradle libvirt proguard watchman
coturn grails libvisio proj watson
couchdb graphicsmagick libvpx prometheus webkitgtk
cppcheck graphite2 libxml++3 proof-general weboob
cpprestsdk graphviz libxmp protobuf wellington
creduce grib-api libxslt protobuf-c wgetpaste
cromwell gringo libyaml ✔ protobuf-swift whatmp3
cryptopp groonga liquibase psgrep wildfly-as
crystal-lang gsettings-desktop-schemas lldpd pulledpork wimlib
csfml gsl llnode purescript wine
cucumber-cpp gsoap llvm pushpin winetricks
curl gspell lmdb pwntools wireguard-tools
dar gssdp lnav pwsafe wireshark
darcs gssh logentries pyenv with-readline
darkice gst-editing-services logstash pyenv-virtualenv wolfssl
dash gst-libav logtalk pygobject3 wrangler
datetime-fortran gst-plugins-bad luajit pypy wxmac
datomic gst-plugins-base luaradio pyqt5 x264 ✔
davix gst-plugins-good lynis python x265
dbus gst-plugins-ugly m-cli python3 xapian
dc3dd gst-python macosvpn qbs xcproj
dcmtk gst-validate macvim qca xctool
dcraw gstreamer mailhog qemu xmake
ddar gstreamermm mailutils qjackctl xonsh
debianutils gtk+ makepkg qscintilla2 xorriso
deheader gtk+3 mapnik qt5 yadm
deis gtk-gnutella mapserver quantlib yafc
deisctl gtk-vnc mariadb quazip yank
deja-gnu gtkextra mas quilt yara
dependency-check gtkmm matlab2tikz qwt yash
depqbf gtkmm3 mawk qxmpp yaz
devd gtksourceview3 mbedtls radare2 yazpp
devhelp gucharmap mbelib rainbarf yle-dl
devtodo guile mdbtools rakudo-star you-get
dieharder gupnp mdds rancher-compose youtube-dl
diff-pdf gupnp-av mdk rapidjson yubico-piv-tool
diff-so-fancy gupnp-tools mdp rbenv-binstubs z3
digdag gwyddion mdv re2 zbackup
discount gx media-info readline ✔ zebra
distribution gx-go mediaconch reattach-to-user-namespace zenity
ditaa gxml memcached ✔ rebar zero-install
djview4 h2o mercurial redis ✔ zeromq
dmd hadolint meson redpen zile
dnscrypt-wrapper hadoop mesos remarshal zimg
docker harfbuzz metabase remctl znapzend
docker-cloud haskell-stack metaproxy renameutils zookeeper
docker-compose hbase metashell repo zorba
docker-machine hebcal mg reposurgeon zpaq
docker-machine-driver-xhyve heroku mg3a rethinkdb zplug
docker-machine-nfs hh micropython rfcmarkup zsh-autosuggestions
docker-swarm highlight midnight-commander rgxg zsh-completions
dockutil highlighting-kate mighttpd2 rhash zsh-navigation-tools
doctl hive miller rhino zsh-syntax-highlighting
dovecot hledger minio riemann zurl
doxygen homebank mitmproxy riemann-client
dpkg httpie mkdocs rlwrap
==> Renamed Formulae
geode -> apache-geode racket -> minimal-racket sonar -> sonarqube stash-cli -> atlassian-cli
==> Deleted Formulae
aeskeyfind curaengine fugu lftp pyqwt sgfutils treeline
aget cuty_capt geany libdbusmenu-qt pyside shiboken txt2man
apt-cacher-ng czmqpp gimp libechonest pyside-tools slony ucspi-tools
automoc4 dircproxy git-stree libmarisa qbzr sonar-runner valkyrie
box2d disco idcomments libnice qwtpolar sqliteman wyrd
bzr-explorer dwarf jing libqglviewer rbenv-readline sqsh yap
caudec elementary jless openlitespeed rcssserver swish-e
cfitsio evas-generic-loaders jsdoc-toolkit orpie rfcdiff tevent
class-dump ezlupdate kjell pgtap rsense tlassemble
coin frescobaldi lastfmlib puddletag samba trang
==> Migrating HOMEBREW_REPOSITORY (please wait)...
==> Migrated HOMEBREW_REPOSITORY to /usr/local/Homebrew!
Homebrew no longer needs to have ownership of /usr/local. If you wish you can
return /usr/local to its default ownership with:
sudo chown root:wheel /usr/local
Robs-iMac:epic-invite roblacey$ sudo chown root:wheel /usr/local
Robs-iMac:epic-invite roblacey$ brew upgrade openssl
==> Upgrading 1 outdated package, with result:
openssl 1.0.2j
==> Upgrading openssl
==> Downloading https://homebrew.bintray.com/bottles/openssl-1.0.2j.sierra.bottle.tar.gz
######################################################################## 100.0%
==> Pouring openssl-1.0.2j.sierra.bottle.tar.gz
==> Using the sandbox
==> Caveats
A CA file has been bootstrapped using certificates from the SystemRoots
keychain. To add additional certificates (e.g. the certificates added in
the System keychain), place .pem files in
/usr/local/etc/openssl/certs
and run
/usr/local/opt/openssl/bin/c_rehash
This formula is keg-only, which means it was not symlinked into /usr/local.
Apple has deprecated use of OpenSSL in favor of its own TLS and crypto libraries
Generally there are no consequences of this for you. If you build your
own software and it requires this formula, you'll need to add to your
build variables:
LDFLAGS: -L/usr/local/opt/openssl/lib
CPPFLAGS: -I/usr/local/opt/openssl/include
PKG_CONFIG_PATH: /usr/local/opt/openssl/lib/pkgconfig
==> Summary
/usr/local/Cellar/openssl/1.0.2j: 1,695 files, 12M
It’s sometimes quite annoying to have SQL queries clogging up the Rails console when you don’t need to see it. You Can turn it off by setting ActiveRecord’s logger to nil
old_logger = ActiveRecord::Base.logger
ActiveRecord::Base.logger = nil
You can of course turn it back on again.
ActiveRecord::Base.logger = old_logger
Of course I need to re-install Command Line Developer Tools without XCode, same after every upgrade.
Robs-MBP:themadkatter rl$ git pull orgin master
xcrun: error: invalid active developer path (/Library/Developer/CommandLineTools), missing xcrun at: /Library/Developer/CommandLineTools/usr/bin/xcrun
Robs-MBP:themadkatter rl$ xcode-select --install
xcode-select: note: install requested for command line developer tools
Found this rather nice Ardunio kit, which integrates nicely with LEGO compatible components.
https://comingsoon-tech.com/itty-bitty-city-by-microdunio-build-smart-legos
Quick and dirty hook to log long SQL queries and their caller.
ActiveSupport::Notifications.subscribe 'sql.active_record' do |name, start, finish, id, payload|
time = (finish - start) * 1000
if payload[:sql] && time > 500
time = (time * 1000).to_i / 1000.0
c = caller.select { |l| l =~ /something_(core|music|artists)/ }[0]
logger = Logger.new(Rails.root.join('log', 'active_record_slow_queries.log'))
logger.info("(#{time}s) #{payload[:sql]} - #{c}")
end
end