| # Unnecessary indexes slows down writes and consumes additional storage and memory. | |
| # Just paste this snippet in your Rails console (bundle exec rails c). | |
| # And it will print all redundant indexes that are already covered by another index on the table: | |
| # Table `pages`: index `site_idx` (site_id) already covered by `site_slug_idx` (site_id,slug) | |
| # Table `optins`: index `list_idx` (list_id) already covered by `list_active_idx` (list_id,active) | |
| ActiveRecord::Base.connection.tables.map do |table| | |
| indexes = ActiveRecord::Base.connection.indexes(table).select(&:valid).reject(&:where) |
| #!/usr/bin/env bash | |
| # https://developers.supportbee.com/blog/setting-up-cucumber-to-run-with-Chrome-on-Linux/ | |
| # https://gist.github.com/curtismcmullan/7be1a8c1c841a9d8db2c | |
| # https://stackoverflow.com/questions/10792403/how-do-i-get-chrome-working-with-selenium-using-php-webdriver | |
| # https://stackoverflow.com/questions/26133486/how-to-specify-binary-path-for-remote-chromedriver-in-codeception | |
| # https://stackoverflow.com/questions/40262682/how-to-run-selenium-3-x-with-chrome-driver-through-terminal | |
| # https://askubuntu.com/questions/760085/how-do-you-install-google-chrome-on-ubuntu-16-04 | |
| # Versions | |
| CHROME_DRIVER_VERSION=`curl -sS https://chromedriver.storage.googleapis.com/LATEST_RELEASE` |
This gist will no longer be updated as the changelog will be on the official website.
Converted via https://domchristie.github.io/turndown
| $ git clone [email protected]:xxxxx/xxxx.git my-awesome-proj | |
| Cloning into 'my-awesome-proj'... | |
| ssh: connect to host github.com port 22: Connection timed out | |
| fatal: Could not read from remote repository. | |
| $ # This should also timeout | |
| $ ssh -T [email protected] | |
| ssh: connect to host github.com port 22: Connection timed out | |
| $ # but this might work |
| -- | |
| -- Read only | |
| -- | |
| -- Create a group | |
| CREATE ROLE postgres_ro_group; | |
| -- Grant access to existing tables | |
| GRANT USAGE ON SCHEMA public TO postgres_ro_group; | |
| GRANT SELECT ON ALL TABLES IN SCHEMA public TO postgres_ro_group; |
| #!/bin/bash -e | |
| ## | |
| # Use this annotated script a base for launching an interactive console task on Amazon ECS | |
| # | |
| # more info: https://engineering.loyaltylion.com/running-an-interactive-console-on-amazon-ecs-c692f321b14d | |
| # | |
| # Requirements: | |
| # - `jq` must be installed on both the client and server | |
| ## |
This fast tutorial will teach you how to install redis-clion AWS EC2 without having to install the whole Redis Server. Firstly, SSH into your EC2 instance and run the following command:
$ sudo yum install gcc
This may return an "already installed" message, but that's OK. After that, just run:
$ wget http://download.redis.io/redis-stable.tar.gz && tar xvzf redis-stable.tar.gz && cd redis-stable && make && sudo cp src/redis-cli /usr/local/bin/ && sudo chmod 755 /usr/local/bin/redis-cli
| # Redis Cheatsheet | |
| # All the commands you need to know | |
| redis-server /path/redis.conf # start redis with the related configuration file | |
| redis-cli # opens a redis prompt | |
| # Strings. |
| FROM rails:4.2.3 | |
| MAINTAINER Renato Filho <[email protected]> | |
| ENV HOME /home/app | |
| ENV RAILS_ENV development | |
| RUN useradd -m -s /bin/bash app | |
| RUN gem install -N bundler |
