Calgarypuck Forums - The Unofficial Calgary Flames Fan Community
Old 03-23-2010, 01:26 PM   #21
GreenTeaFrapp
Lifetime Suspension
 
Join Date: Aug 2005
Location: CP House of Ill Repute
Exp:
Default

Quote:
Originally Posted by photon View Post
OSX is a *nix OS, it's built on Darwin, if you know unix you'll be at home at the command prompt in OSX.
Thus it is impossible for it to run better!
GreenTeaFrapp is offline   Reply With Quote
Old 03-23-2010, 01:28 PM   #22
photon
The new goggles also do nothing.
 
photon's Avatar
 
Join Date: Oct 2001
Location: Calgary
Exp:
Default

But it will LOOK better, so it will run better because everyone who's put speed holes in their car knows looks are worth at least 10hp or 10MHz in this case.
__________________
Uncertainty is an uncomfortable position.
But certainty is an absurd one.
photon is offline   Reply With Quote
Old 03-23-2010, 01:32 PM   #23
FanIn80
GOAT!
 
FanIn80's Avatar
 
Join Date: Jun 2006
Exp:
Default

Exactly why I paint my Macs red. Red Macs are FASTER.
FanIn80 is offline   Reply With Quote
Old 03-23-2010, 01:35 PM   #24
Bobblehead
Franchise Player
 
Bobblehead's Avatar
 
Join Date: Jul 2005
Location: in your blind spot.
Exp:
Default

Oh, and the SQL Server vs Oracle battles are about as strong as the MS v Apple battles.
__________________
"The problem with any ideology is that it gives the answer before you look at the evidence."
—Bill Clinton
"The greatest obstacle to discovery is not ignorance--it is the illusion of knowledge."
—Daniel J. Boorstin, historian, former Librarian of Congress
"But the Senator, while insisting he was not intoxicated, could not explain his nudity"
—WKRP in Cincinatti
Bobblehead is offline   Reply With Quote
Old 03-23-2010, 02:02 PM   #25
Shazam
Franchise Player
 
Shazam's Avatar
 
Join Date: Aug 2005
Location: Memento Mori
Exp:
Default

Quote:
Originally Posted by Bobblehead View Post
Oh, and the SQL Server vs Oracle battles are about as strong as the MS v Apple battles.
I've never met a DBA that was a database fanboy, but if they were, they're worthless.
__________________
If you don't pass this sig to ten of your friends, you will become an Oilers fan.
Shazam is offline   Reply With Quote
Old 03-23-2010, 02:09 PM   #26
photon
The new goggles also do nothing.
 
photon's Avatar
 
Join Date: Oct 2001
Location: Calgary
Exp:
Default

Oh I don't know, I've seen some pretty epic DBAs that were definite fanboys, and there were definite wars over.. well usually over anything vs. MSSQL. Think mac vs. PC commercials where anything can be mac but only MSSQL can be PC.

EDIT: And for the record I enjoyed working with MSSQL.
__________________
Uncertainty is an uncomfortable position.
But certainty is an absurd one.
photon is offline   Reply With Quote
Old 03-23-2010, 02:23 PM   #27
Shazam
Franchise Player
 
Shazam's Avatar
 
Join Date: Aug 2005
Location: Memento Mori
Exp:
Default

Oracle for the longest time had superior transactional support (it's so very easy to deadlock SQL Server), but these days the differences are mostly implementation and not really apparent from a developer POV.

Whenever I deal with with an Oracle doofus, I just ask them to explain VARCHAR2. That usually gets them blushing.
__________________
If you don't pass this sig to ten of your friends, you will become an Oilers fan.
Shazam is offline   Reply With Quote
Old 03-23-2010, 02:25 PM   #28
Bobblehead
Franchise Player
 
Bobblehead's Avatar
 
Join Date: Jul 2005
Location: in your blind spot.
Exp:
Default

Quote:
Originally Posted by Shazam View Post
I've never met a DBA that was a database fanboy, but if they were, they're worthless.
Seriously? There are some pretty heated debates, and some fairly different mechanisms in some areas (how Null is handled being a fairly common example).
__________________
"The problem with any ideology is that it gives the answer before you look at the evidence."
—Bill Clinton
"The greatest obstacle to discovery is not ignorance--it is the illusion of knowledge."
—Daniel J. Boorstin, historian, former Librarian of Congress
"But the Senator, while insisting he was not intoxicated, could not explain his nudity"
—WKRP in Cincinatti
Bobblehead is offline   Reply With Quote
Old 03-23-2010, 02:38 PM   #29
MelBridgeman
Lifetime Suspension
 
Join Date: Mar 2007
Location: Calgary
Exp:
Default

I manage a copy of the entire MLS database for Calgary/Edmonton/Fraser Valley/Greater Vancouver/Chilliwack/Kamloops/Red Deer/Lethbridge/Fort Mac on MYSQL!
MelBridgeman is offline   Reply With Quote
Old 03-23-2010, 02:58 PM   #30
FanIn80
GOAT!
 
FanIn80's Avatar
 
Join Date: Jun 2006
Exp:
Default

Of course my exposure to the different DB environments is minimal at best, but for what it's worth MySQL is the one I like the best so far.

Just yesterday in class, we were running some basic select queries in Oracle, and I started jumping ahead a bit into some other areas... Which lasted until I got to the part where I wanted to incorporate other tables in my queries. That's when I discovered how much I'd been taking for granted the "show tables" command from MySQL.
FanIn80 is offline   Reply With Quote
Old 03-23-2010, 03:11 PM   #31
Bobblehead
Franchise Player
 
Bobblehead's Avatar
 
Join Date: Jul 2005
Location: in your blind spot.
Exp:
Default

select *
from user_objects
where object_type = 'TABLE';
__________________
"The problem with any ideology is that it gives the answer before you look at the evidence."
—Bill Clinton
"The greatest obstacle to discovery is not ignorance--it is the illusion of knowledge."
—Daniel J. Boorstin, historian, former Librarian of Congress
"But the Senator, while insisting he was not intoxicated, could not explain his nudity"
—WKRP in Cincinatti
Bobblehead is offline   Reply With Quote
The Following User Says Thank You to Bobblehead For This Useful Post:
Old 03-23-2010, 03:16 PM   #32
photon
The new goggles also do nothing.
 
photon's Avatar
 
Join Date: Oct 2001
Location: Calgary
Exp:
Default

Quote:
Originally Posted by MelBridgeman View Post
I manage a copy of the entire MLS database for Calgary/Edmonton/Fraser Valley/Greater Vancouver/Chilliwack/Kamloops/Red Deer/Lethbridge/Fort Mac on MYSQL!
Neat! That must be some pretty substantial hardware.

I may become a real estate agent just for you.

*Enters first house on MLS*

Agent Name: "photon'); drop table Listings;"

Mwahahaha...
__________________
Uncertainty is an uncomfortable position.
But certainty is an absurd one.
photon is offline   Reply With Quote
Old 03-23-2010, 03:31 PM   #33
BlackEleven
Redundant Minister of Redundancy
 
BlackEleven's Avatar
 
Join Date: Apr 2004
Location: Montreal
Exp:
Default

Quote:
Originally Posted by photon View Post

Agent Name: "photon'); drop table Listings;"

Mwahahaha...
BlackEleven is offline   Reply With Quote
Old 03-23-2010, 03:44 PM   #34
FanIn80
GOAT!
 
FanIn80's Avatar
 
Join Date: Jun 2006
Exp:
Default

Haha little Bobby Tables. So awesome.
FanIn80 is offline   Reply With Quote
Old 03-23-2010, 03:53 PM   #35
MelBridgeman
Lifetime Suspension
 
Join Date: Mar 2007
Location: Calgary
Exp:
Default

Quote:
Originally Posted by photon View Post
Neat! That must be some pretty substantial hardware.

I may become a real estate agent just for you.

*Enters first house on MLS*

Agent Name: "photon'); drop table Listings;"

Mwahahaha...
Not sure you fit in with that crowd, no offense to most realtors out there but here is an example of crap I have to deal with.

select redblud_desc from redblud where instr(redblud_desc,'fort')

will pull up this


FORT MCMURRAY
FORT MCMUURAY
FORT MCMURRAY, AB
FORT MCMCURRAY
FORT MCMMURRAY
FORT MCMURRAY
FORT MCMURARY
FORT MCMURRRAY
FORT MCMURAY
FORT MCMURRAQY
FORT MCURRAY

The many ways a fort mac realtor enters in the name of the city they work in.

And shame on the MLS company for providing third parties with this crap

Last edited by MelBridgeman; 03-23-2010 at 03:56 PM.
MelBridgeman is offline   Reply With Quote
Old 03-23-2010, 03:54 PM   #36
photon
The new goggles also do nothing.
 
photon's Avatar
 
Join Date: Oct 2001
Location: Calgary
Exp:
Default

Heh, yeah that's the comic I had in mind when posting that.

Or these:



__________________
Uncertainty is an uncomfortable position.
But certainty is an absurd one.
photon is offline   Reply With Quote
Old 03-23-2010, 03:55 PM   #37
photon
The new goggles also do nothing.
 
photon's Avatar
 
Join Date: Oct 2001
Location: Calgary
Exp:
Default

Quote:
Originally Posted by MelBridgeman View Post
The many ways at fort mac realtor enters in the name of the city they work in.
Lol awesome!
__________________
Uncertainty is an uncomfortable position.
But certainty is an absurd one.
photon is offline   Reply With Quote
Old 03-23-2010, 03:59 PM   #38
FanIn80
GOAT!
 
FanIn80's Avatar
 
Join Date: Jun 2006
Exp:
Default

I've always been an advocate of pre-populated drop-downs on data entry forms. Text fields are the devil.
FanIn80 is offline   Reply With Quote
Old 03-23-2010, 04:01 PM   #39
Mad Mel
First Line Centre
 
Mad Mel's Avatar
 
Join Date: Mar 2009
Location: Brisbane, Australia
Exp:
Default

I think the other smart Mel guy nailed it, working for an outfit where you can do both is a great way to build up your chops on both sides. That's what I've done, and I'm quite happy with how much I've been allowed to learn over the years.

Having very solid database understanding is fundamental to becoming a great application developer. With that, you can work WITH the database developer to come up with really effective solutions. Without it, you frequently get application developers building in too much functionality that should be handled within the database platform.

Within what is usually referred to as a DBA role are actually two roles: true DBA work, and database developer. It sound to me like you're most interested in database development. Designing databases (some think this is DBA work, I don't), creating data loading packages, reporting services, etc. Basically, the bits that your applications might interact with.

One thing to consider is that DBA's (and particularly Oracle DBAs) usually get paid scads of cash.
Mad Mel is offline   Reply With Quote
Old 03-23-2010, 04:07 PM   #40
Mad Mel
First Line Centre
 
Mad Mel's Avatar
 
Join Date: Mar 2009
Location: Brisbane, Australia
Exp:
Default

Quote:
Originally Posted by FanIn80 View Post
I've always been an advocate of pre-populated drop-downs on data entry forms. Text fields are the devil.
Huh. I'm an advocate of implementing constraints on the database so my data integrity isn't dependent on an application.
Mad Mel is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -6. The time now is 08:23 AM.

Calgary Flames
2024-25




Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright Calgarypuck 2021 | See Our Privacy Policy