rdeguzman

# postgres mgmt funcitons

## show total_bytes, index_bytes

  SELECT c.oid,
		  nspname AS table_schema, 
		  relname AS TABLE_NAME, 
		  c.reltuples AS row_estimate,
		  pg_size_pretty(pg_total_relation_size(c.oid)) AS total_bytes,
		  pg_size_pretty(pg_indexes_size(c.oid)) AS index_bytes

rdeguzman

TLDR;
----------------------------------------------------
 st_transform(
    st_buffer(
      st_transform(st_geomFromText('POINT(145.228914 -37.92674)', 4326), 900913),
      50 --radius in meters
    ),
    4326
  )
----------------------------------------------------

rdeguzman

/*
Taken and cribbed from blog.datalicious.com/free-download-all-australian-postcodes-geocod

May contain errors where latitude and longitude are off. Use at own non-validated risk.
*/

SET NAMES utf8;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS postcodes_geo;

rdeguzman

=Navigating=
    visit('/projects')
    visit(post_comments_path(post))

=Clicking links and buttons=
    click_link('id-of-link')
    click_link('Link Text')
    click_button('Save')
    click('Link Text') # Click either a link or a button
    click('Button Value')

rdeguzman

Android Developer (Freelance)

• This is project based + remote telecommute/work from home.
• Port existing MyTravelPhilippines iTunes app (https://itunes.apple.com/ph/app/mytravel-philippines/id376830684?mt=8) to Android
• Use AndroidStudio or IntellJ Idea (Community Edition).
• Native Android. No PhoneGap, Appcelerator Titanium, etc. No it won't turn into embedded development! :P
• You should at least know how to parse JSON from http.
• Maps and Location experience in Google Android Maps v2, obtaining a GPS fix, etc.
• You will build the activities, layouts and UI in Android.
• UI should cater to mobile phones and tablets. Dynamic Layouts?

rdeguzman

# Virtual host for our Blog, derivative of wordpress based on php.
<VirtualHost 192.168.4.11:80>
   ServerAdmin rupert@datalinktech.com.au
   ServerName blog.datalink.loc
   ServerAlias blog.datalink.loc

   DocumentRoot "/usr/local/datalink/blog"
   <Directory "/usr/local/datalink/blog">
     Options FollowSymLinks Includes ExecCGI
     AllowOverride All

rdeguzman

(eval):1: [BUG] Segmentation fault
ruby 1.9.3p0 (2011-10-30 revision 33570) [x86_64-darwin12.4.0]

-- Control frame information -----------------------------------------------
c:0130 p:---- s:0439 b:0439 l:000438 d:000438 CFUNC  :public_instance_methods
c:0129 p:0009 s:0436 b:0436 l:000411 d:000435 EVAL   (eval):1
c:0128 p:---- s:0434 b:0434 l:000433 d:000433 FINISH
c:0127 p:---- s:0432 b:0432 l:000431 d:000431 CFUNC  :class_eval
c:0126 p:0063 s:0428 b:0428 l:000411 d:000427 BLOCK  /Users/rupert/.rvm/gems/ruby-1.9.3-p0@dfms/gems/highline-1.6.19/lib/highline/string_extensions.rb:53
c:0125 p:---- s:0425 b:0425 l:000424 d:000424 FINISH

rdeguzman

When I set wal_level = 'archive' on master and hot_standby = 'off' in slave. 
The slave won't start, replication user seem to authenticate, however the postgres 
startup process seems to keep on trying.. why?

# master
wal_level = 'archive'
archive_mode = on
archive_command = '../pgscripts/archive.sh %p %f'

# - Streaming Replication -

rdeguzman

 109 def getGames(n, t):
 110     teams = n
 111     table = t[:]
 112     if n % 2 == 0:
 113         games = [[] for i in range(0, (2*(n-1)))]
 114     elif n % 2 != 0:
 115         games = [[] for i in range(0, (2*n))]
 116     for y in range(0, n):
 117         a = table[y]
 118         for x in range(0, n):

rdeguzman

https://github.com/rdeguzman/dotfiles/blob/master/zsh/aliases

# cd
alias ..='cd ..'

# ls
alias ls="ls -F"
alias l="ls -lAh"
alias ll="ls -l"
alias la='ls -A'