Database Geek Blog

A few good posts for MySQL and Postgres

Lewi — Thu, 29 Jul 2010 13:37:16 +0000

Thought I would share a few links that I read this morning. I don’t do a lot of link posts but these three came off my RSS, one after the other, and all three are worth sharing.

The first is Will Oracle kill MySQL? Come on people! I can’t believe people are still stuck on this FUD. Ronald gives some good reasons why that is not likely. The only thing this kind of FUD… Read the rest!

Agility and Analysis

Lewi — Tue, 20 Jul 2010 12:35:56 +0000

As developers, analysts, adminstrators, etc, I think most of us tend towards perfectionism. We want to do the job right and we want to do the job right the first time around.

Agility means being able to move forward with less than perfect information. Sometimes it means moving forward with information that is known to incomplete or even potentially inaccurate.

So what does that mean for analysis? Analysis, by definition, is the separation of individual… Read the rest!

Twitter Weekly Updates for 2010-07-13

Lewi — Tue, 13 Jul 2010 20:23:00 +0000

Got my OCP card in the mail today. http://twitpic.com/230ilr #
DB Geek says: Twitter Weekly Updates for 2010-07-06:
Blogged "ODTUG Kaleidoscope 2010 – The Journey So Far" htt… http://bit.ly/bVYwF2 #
Cloud Comments: Comment on A quick overview of PuTTY and SSH for AWS Newbies by Installing a headless GeoServer on… http://bit.ly/d1jO66 #
Interesting. Oracle Adds Support for Open-source R (the language) http://bit.ly/bpA7mh #
I slept right through the bi 11g webcast. Didn't even

… Read the rest!

Twitter Weekly Updates for 2010-07-06

Lewi — Tue, 06 Jul 2010 20:23:00 +0000

Blogged "ODTUG Kaleidoscope 2010 – The Journey So Far" http://it.toolbox.com/trd/46/2/39672/3 #
#odtug #
ODTUG Kaleidoscope 2010 – The Journey So Far http://it.toolbox.com/trd/73/2/39672/3/twitter #
#odtug265 pigs, chickens and agile development with Maggie Tompkins. Maggie has made 14 consecutive kaleidoscopes. Wow! #
I'm not a chicken or a pig. I'm more like a bacon flavored poultry product. #odtug295 #
#odtug295 a scrum master can also be a pig. I didn't know that. #
Maggie Tompkins

… Read the rest!

Twitter Weekly Updates for 2010-06-29

Lewi — Tue, 29 Jun 2010 20:23:00 +0000

Blog Talk: Comment by Christopher Hamilton on Yahoo Sucks! Google wins. http://bit.ly/cb7OVe #
@datachick I always thought waterboarding sounded like fun. Like dragging you around behind a boat on board. Wheeee! in reply to datachick #
DB Geek says: Twitter Weekly Updates for 2010-06-22:
Blogged "Stupid Proc Tricks -The Weird and Wonderful Overl… http://bit.ly/bdSH3i #
Blog Talk: Comment by jonesr on Yahoo Sucks! Google wins. http://bit.ly/daOfcG #
Oracle's iRecruitment.com gives me an error

… Read the rest!

Twitter Weekly Updates for 2010-06-22

Lewi — Tue, 22 Jun 2010 20:23:00 +0000

Blogged "Stupid Proc Tricks -The Weird and Wonderful Overload" http://it.toolbox.com/trd/46/2/39311/3 #
My 2 year old turned off the refrigerator and unscrewed the light bulb. I fear what he will do when he discovers the screw driver. #
DB Geek says: Stupid Proc Tricks -The Weird and Wonderful Overload: <!–
google_ad_client = "pub-4372398370642959"… http://bit.ly/bPVMI2 #
Blog Talk: Comment by harishkumar on Learn Oracle – What is Oracle? http://bit.ly/8ZSrvx #
Blog Talk: Comment by

… Read the rest!

Yahoo, you are dead to me.

Lewi — Sat, 19 Jun 2010 13:16:40 +0000

Yea, I know. Quite the dramatic title. Work with me for a sec.

I’m pissed. Really pissed. Advance warning: I will rant now.

I forget the exact year but in the early 90s (I think 1993 or 94), I signed up for a novel service. Online email. Remember this is the early 90s. I was an early adopter even back then.

The internet was mostly character based and mostly used by universities, some larger companies… Read the rest!

We’ve had problems with that!

Lewi — Wed, 16 Jun 2010 20:23:30 +0000

So what can I say? One of the phrases I hate most is “We’ve had problems with that.” I have seen that, or some form of that, question used as an excuse to not try new features, to not use best practices, keep a head in the sand, stick to Oracle7 features, etc.

As an example, in my early days with data modeling, I once created a new schema. It wasn’t a very big schema;… Read the rest!

Twitter Updates for 2010-06-15

Lewi — Tue, 15 Jun 2010 05:23:00 +0000

Blogged "Stupid Proc Tricks -The Weird and Wonderful Overload" http://it.toolbox.com/trd/46/2/39311/3 #
My 2 year old turned off the refrigerator and unscrewed the light bulb. I fear what he will do when he discovers the screw driver. #
DB Geek says: Stupid Proc Tricks -The Weird and Wonderful Overload: <!–
google_ad_client = "pub-4372398370642959"… http://bit.ly/bPVMI2 #

Stupid Proc Tricks -The Weird and Wonderful Overload

Lewi — Tue, 15 Jun 2010 00:19:59 +0000

When overloading a procedure or function it is the calling parameters that make the difference. The return type does not make a difference as far as the ability to overload. Generally, when talking about overloaded procedures, you will hear or read something like “You must change at least one of the parameter data types to overload it.” But that’s not really true.

Read more about Stupid Proc Tricks -The Weird and Wonderful Overload

Twitter Weekly Updates for 2010-06-07

Lewi — Mon, 07 Jun 2010 06:23:00 +0000

DB Geek says: Twitter Weekly Updates for 2010-05-31: <!–
google_ad_client = "pub-4372398370642959";
/* 468×60, cr… http://bit.ly/975olU #
Gergen: Mr. President, take command http://www.cnn.com/2010/OPINION/05/30/gergen.oil.spill/index.html?hpt=C2 #
Blogged "My PHP Online References" http://it.toolbox.com/trd/46/2/39030/3 #
Deal Breakers: 10 Traits & Practices Ruin Your Promotability & Success! http://bit.ly/8Z7iOW #
Training workers to leave. Interesting concept. http://money.cnn.com/2010/06/01/smallbusiness/staff_training/index.htm?hpt=T3 #
Updated the links on my PHP for PL/SQL Developers presentation. http://bit.ly/aRtkY5 #
Anyone successful getting hprof working in sqldev

… Read the rest!

Twitter Weekly Updates for 2010-05-31

Lewi — Mon, 31 May 2010 06:23:00 +0000

DB Geek says: Twitter Weekly Updates for 2010-05-24: <!–
google_ad_client = "pub-4372398370642959";
/* 468×60, cr… http://bit.ly/cjrA0b #
Blogged "PHP for PL/SQL Developers: More Include Files, Inserting Data and Must See Sites" http://it.toolbox.com/trd/46/2/38892/3 #
I've been Tweeting since July 28, 2007 (1031 days). How about you? – http://HowLongOnTwitter.com #
My life writ dilbertian http://bit.ly/cw6qfo #
@dtseiler @dtseiler I still double space. I'm oldskool, yo. in reply to dtseiler #
Interesting webinar coming

… Read the rest!

Twitter Weekly Updates for 2010-05-24

Lewi — Mon, 24 May 2010 06:23:00 +0000

DB Geek says: Twitter Weekly Updates for 2010-05-17: <!–
google_ad_client = "pub-4372398370642959";
/* 468×60, cr… http://bit.ly/aXWadD #
Blog Comments: Comment on uCertify Oracle Certification Software Review by LewisC: Just a year late but Congrats o… http://bit.ly/d3E1Mf #
Blogged "PHP for PL/SQL Developers: Include Files, Connecting to Oracle and Selecting Data" http://it.toolbox.com/trd/46/2/38739/3 #
Updated my PHP for PL/SQL Developers post with links to all the posts so far: http://bit.ly/php_ora #
RT @orana

… Read the rest!

Twitter Weekly Updates for 2010-05-17

Lewi — Mon, 17 May 2010 06:23:00 +0000

DB Geek says: Twitter Weekly Updates for 2010-05-09: <!–
google_ad_client = "pub-4372398370642959";
/* 468×60, cr… http://bit.ly/cpeb6i #
Blogged "PHP for PL/SQL Developers: Finally, some real code" http://it.toolbox.com/trd/46/2/38612/3 #
Blogged "MySQL Track at ODTUG Kaleidoscope" http://it.toolbox.com/trd/46/2/38656/3 #
SAP buys Sybase for 5.8 billion http://bit.ly/chxieC #
rt @oracletechnet A full Oracle Database App Development stack in a VirtualBox appliance: Can I haz? Yes I can http://bit.ly/dACvjB #
Blogged "Know Thy Audience – Lessons

… Read the rest!

Twitter Weekly Updates for 2010-05-09

Lewi — Mon, 10 May 2010 00:23:00 +0000

DB Geek says: Twitter Weekly Updates for 2010-05-02: <!–
google_ad_client = "pub-4372398370642959";
/* 468×60, cr… http://bit.ly/buvM60 #
Blogged "PHP for PL/SQL Developers: A First Look" http://it.toolbox.com/trd/46/2/38432/3 #
"PHP for PL/SQL Developers: A First Look" http://it.toolbox.com/trd/73/2/38432/3/twitter #
Finally tossed the dlink 615. Fast router but the dropped connections were driving me nuts. Don't buy it. #
Blogged "ProjectManager.com – A Review" http://it.toolbox.com/trd/46/2/38443/3 #
Blog Talk: Comment by Balvant on Oracle Collections: A

… Read the rest!