Archive for April, 2012

Things I Learned in March

April 5, 2012 Leave a comment
  1. sqlite can support multiple databases attached to a single master, thus simulating schemas
    1. sqlite3 master
    2. attach database schema1 as a; (previously existing sqlite db)
    3. attach database schema2 as b; (previously existing sqlite db)
    4. .databases
    5. select * from a.table1; select * from b.table1;
  2. select DBMS_METADATA.GET_DDL(‘TABLE’, ‘USERS’) from dual;
  3. ADP Inc. has an iPhone App for viewing pay statements.
  5. PHP will print true as 1 and false as ”.  false apparently doesn’t cast to an integer value unless you do (int)false.
  6. Implemented my first set of insertable/updatable Oracle views.
  7. INSTEAD OF triggers can be used on complex views to INSERT, UPDATE, DELETE underlying data.
  8. Introduced to the Ruby looksee gem.
  9. PHP 5.4 Features: Traits, shortened array syntax, built in webserver.
    1. Swift_Plugins_LoggerPlugin
  10. Learned how to use a flash light (and no other light) to find and fix bumps/grooves while dry wallling.
    1. Learned there’s a fruit called Durian
    2. Learned how to shoot a Glock 19 (9 mm) and experience my first shooting range.
  11. Japan’s bullet train is shaped after a hummingbird’s beak to avoid a sonic boom when exiting tunnels at 200 MPH.
    1. Tyndal was executed for his English translation of the Bible
  12. sendmail and SMTP have a 5 minute timeout.  Swift opens a single connection and re-uses it for each message.  If you wait longer than 5 min between messages it’ll error out.
    1. All user crontabs are stored under /var/spool/cron/crontabs
  13. Finally learned how to do a case-insensitive search in vim: /\csearch
  14. grep -c, –count : Suppress normal output; instead print a count of matching lines for each input file.
    1. Government takes up 23% of the current GDP on it’s way to 25%.
    2. Government is the largest it’s been since WWII.
  16. grep -P, –perl-regexp : Interpret PATTERN as a Perl regular expression. (experimental)
  18. Learned how to make a roux with clarified butter that was my starter to make sausage gravy to put on top of homemade buttermilk biscuits.
  19. Just learned about FireFox’s new “Inspect Element” right menu option.
  20. You can view BLOB’s in SQL Developer (table view) and choose to view them as Text or Image.
  21. SQLPlus commands ACCEPT and HIDE
    1. ( echo Subject: My Subject; cat body.txt) | sendmail -F “GLaDOS” -f “”
    2. Ruby’s Kernel Module Conversion methods
    3. RSpec 2.5 Exclusion Filter
  23. vim *Test.php — :bd – close buffer, :wn – write and move to next buffer, :rew – rewind to first file opened
  24. First time at Ben’s Chili Bowl in DC
  25. Learned a couple logical arguments for the existance of hell and why God allows evil to happen.
    1. Learned how to make Red Velvet Cake.
  26. A WHEN clause can be used in a trigger as a pre-condition to execution.
    1. BEFORE INSERT ON table FOR EACH ROW WHEN(new.pkey_id IS NULL) BEGIN SELECT pkey_id_seq.NEXTVAL INTO :new.pkey_id FROM dual; END;
  27. – Replaces MacFuse
  28. Watched the movie: Warrior
  29. Read file using bash:   cat file_paths | while read line; do echo $line; done;
    1. To get capistrano to put something into the background you need to redirect output to /dev/null.  (command; command) > /dev/null &
  30. Ruby’s GEM_PATH env variable can mess things up when using two different applications that use Gem Bundler.
    1. Used Ruby’s FasterCSV library.
  31. grant select_catalog_role to schema;  – In order to use DBMS_METADATA.GET_DDL for a schema object that you do not own.
    1. This only role only works in anonymous blocks, it will throw ORA-31603 if used inside a procedure.