Development Archives - Page 12 of 22

Oracle instead of triggers

Post author:jonathansblog
Post published:May 11, 2014
Post category:Development Methodology SQL
Post comments:0 Comments

Oracle instead of triggers, and why you need them: You cant update a view if it contains:group byorder byanalytical /aggregate functionssubqueriesjoins You then need an 'instead of' trigger CREATE TRIGGER…

Oracle logical structures

Post author:jonathansblog
Post published:May 8, 2014
Post category:Development Methodology SQL
Post comments:0 Comments

Oracle logical structures Oracle logical structures can be summarised by the following: Schema. Tablespace. Datablock. Redo log. Schema collection of objects (table, view, etc) owned by db user name is…

Oracle control file

Post author:jonathansblog
Post published:May 8, 2014
Post category:Development Methodology SQL
Post comments:0 Comments

Oracle control file: binary file start of instance, file is checked database has 1 control file each modifiable only by oracle editing prohibited, even by DBA Keeps track of: datafile…

A year in SVN with gource

Post author:jonathansblog
Post published:April 18, 2014
Post category:Development
Post comments:0 Comments

A year in SVN with gource visualisation for a project at work

Updating to php 5.4 and mysql 5.5 in centos 6

Post author:jonathansblog
Post published:March 25, 2014
Post category:Development Php SQL
Post comments:0 Comments

To update to php 5.4 and mysql 5.5 in centos 6: 1) install the epel, remi and rpm-forge repos rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm rpm -Uvh http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.3-1.el6.rf.x86_64.rpm 2) edit…

Photo by Kevin Ku on Pexels.com

Set a featured image on all wordpress posts

Post author:jonathansblog
Post published:February 23, 2014
Post category:SQL Wordpress
Post comments:0 Comments

If you want to set a featured image on all wordpress posts that don't already have a featured image set, then this mysql query can help: INSERT INTO wp_postmeta (post_id,meta_key,meta_value)…

The build process for multiloquent theme

Post author:jonathansblog
Post published:February 5, 2014
Post category:Methodology Multiloquent
Post comments:0 Comments

Since I released my first public wordpress theme (I have made lots of themes over the years, but have never released any as open-source) I decided I would share the…

Multiloquent theme now available to the public :)

Post author:jonathansblog
Post published:February 5, 2014
Post category:Wordpress
Post comments:4 Comments

I have released multiloquent - the theme I use for jonathansblog to the public: you can get it here: http://wordpress.org/themes/multiloquent I have a github if you want a cutting-edge version…

Investment appraisal evaluation

Post author:jonathansblog
Post published:January 13, 2014
Post category:Development Methodology
Post comments:0 Comments

Investment appraisal evaluationSCOTLAB TC COP Savings AchievedCost of investmentOpportunity costTime-value of moneyLife of investmentAvailable financeBenefits of investmentTiming of incomeCompound Interest using the above factors you can calculate:Cash flowOpportunity costProfitability