unnitallman

NeetoCI build speed: improvement opportunities

Reference build: neeto-auth-web, wall-clock 274s. Tests take 74s. The other 200s is infrastructure overhead.

Timing breakdown

Step	Time	Category
Cache restore	53.5s	S3 download
bundle exec rake setup	45.1s	Unknown — needs investigation

unnitallman

unnitallman

• Integrate neeto_sso gem
• Drop organization_neeto_applications table from client application and remove associated test cases and references throughout the application
• Verify organization enabling/disabling API is working for client application
• Verify that favicon when updated in neetoAuth is being updated and in use in the client application as well
• Verify if the user name and profile image urls when updated in neetoAuth is being updated and in use in the client application as well
• Verify if User activation/deactivation is being handled properly, i.e. A concern which blocks access
• Verify User Invitation API
• Make sure profile settings page and organization settings page open correctly. (neetoForm has done this correctly)

unnitallman

sudo -u postgres psql
postgres=# create database mydb;
postgres=# create user myuser with encrypted password 'mypass';
postgres=# grant all privileges on database mydb to myuser;

unnitallman

• https://mailtrap.io/
• https://www.getpostman.com/apps
• https://www.sublimetext.com/3
• https://sendgrid.com/

unnitallman

Alternatively, in the Amazon interface, you can select a directory or file, and click on the action "Mark as public"

unnitallman

Rake::Task["assets:precompile"].clear
namespace :assets do
  task 'precompile' do
      puts "Not pre-compiling assets..."
  end
end

unnitallman

Backup MySQL to Amazon S3

This is a simple way to backup your MySQL tables to Amazon S3 for a nightly backup - this is all to be done on your server :-)

Sister Document - Restore MySQL from Amazon S3 - read that next

1 - Install s3cmd

this is for Centos 5.6, see http://s3tools.org/repositories for other systems like ubuntu etc

unnitallman

Randwick - 1 year - site wide - traffic graph

SELECT COUNT(DISTINCT user_id, user_type) as count, DATE( FROM_UNIXTIME(date)) as created_on FROM `beta_reports_user_session_types` WHERE `beta_reports_user_session_types`.`site_id` = 224 AND `beta_reports_user_session_types`.`project_id` IN (2788, 2804, 2797, 2816, 2800, 5060, 7397, 2822, 7611, 6445, 6617, 4217, 2808, 6731, 2813, 6744, 5046, 2792, 6953, 2809, 2805, 2823, 2799, 2810, 2827, 2795, 2794, 2791, 2825, 2819, 2821, 2824, 2978, 2798, 6619, 2811, 2787, 2801, 2807, 2989, 2826, 8019, 2786, 2814, 2790, 2818, 2820, 5690, 2806, 2796, 2793, 2803, 2789, 2785, 2815, 6298, 2817, 2802, 2812, 2828) AND (`beta_reports_user_session_types`.`date` BETWEEN 1387426750 AND 1417492931) GROUP BY created_on ORDER BY created_on

On demo server

|   110 | 2014-11-15 |
|   157 | 2014-11-16 |
+-------+------------+
332 rows in set (16.82 sec)

unnitallman

# Usage: FileSplitter.new('/usr/share/dict/words').split_into 10

class FileSplitter
  def initialize(path)
    @file = File.open path
  end

  def split_into(n)
    i = 1
    m = slice_size(n)