The W
Views: 99157085
Main | FAQ | Search: Y! / G | Calendar | Color chart | Log in for more!
23.9.14 0539
The W - the-w.com Site Feedback - The following wieners are total losers (Page 2)
This thread has 20 referrals leading to it
Register and log in to post!
Thread rated: 6.40
Pages: Prev 1 2
(865 newer) Next thread | Previous thread
User
Post (32 total)
thecubsfan
Scrapple
Moderator








Since: 10.12.01
From: Aurora, IL

Since last post: 2 days
Last activity: 7 hours
#21 Posted on | Instant Rating: 10.00
It's possible to do both. But it's not something you really want to do.

I got it, but I think what's endearing about Guru is how he lays the down the tech talk that presumbably flies over many people's heads.
Zeruel
Thirty Millionth Hit
Moderator








Since: 2.1.02
From: The Silver Spring in the Land of Mary.

Since last post: 9 days
Last activity: 4 hours
#22 Posted on | Instant Rating: 4.05
    Originally posted by Guru Zim
    Might be a side effect of the rating code - I'll have to look into that if I get a chance. Odds are that we don't have a Primary Key on the id field of the users table with a Foreign Key on the ratings table. Because we did it wrong the children aren't being deleted with the parent.

    I don't even know if the version of MySQL we are running supports PK/FK.


When I took SQL and PL/SQL back in '00, I thought that was standard to the language, but I may be wrong.




Almost finished my 2002-2003 College Football raitings. Watch this space!!!

Guru Zim
SQL Dejection
Administrator








Since: 9.12.01
From: Bay City, OR

Since last post: 11 days
Last activity: 7 hours
AIM:  
#23 Posted on | Instant Rating: 9.41
Well, see, Oracle and PL/SQL definitely support primary and foreign keys - so does MS-SQL. MySQL has some limitations - and I'm not sure if this is one of those "you need 4.x" to get it things.

I didn't design this table structure from the ground up - so I have kind of just left it as it was. I think I've added a few indexes here and there, but really, we've mainly left the DB stuff alone.

I doubt SQL is that arcane I bet at least 5% of people here know what I'm talking about.

//edit: And for those that don't...

SQL is sometimes referred to as Structured Query Language. Some people say it "Ess Queue Ell" and some say "Sequel". Others say "Squirrel" apparently, but I think that's awfully silly. I say sequel 'cause that's what the job placement guy from Robert Half Technologies says, so who am I to argue?

Anyway, there is ANSI standard SQL, and then there is the other stuff. PL/SQL is the language that Oracle uses. Transact SQL (T-SQL) is what Microsoft uses for MS-SQL.

Lots of stuff is standard in ANSI SQL, and a lot is added (and supported in the nonstandard SQL - like UNION statements, etc).

MySQL gets a lot of bad press because initially it lacked a lot of features of the big boys - like ACID (transactions basically). You can get this with InnoDB table type, but it wasn't originally built into MySQL.

Anyway. MySQL is missing other stuff in the 3.x branch (I don't think I can use nested queries or UNION) that is added in 4.x. We're currently on 3.x, which is kinda teh suck, but really it's the more stable version so we should be using it. I want 4.x but I haven't been nice to Adam recently and I need to probably send him a late birthday present before he moves to Australia,

Where was I going again?

(edited by Guru Zim on 24.9.03 2229)


Willful ignorance of science is not commendable. Refusing to learn the difference between a credible source and a shill is criminally stupid.
CRZ
Big Brother
Administrator








Since: 9.12.01
From: ミネアポリス

Since last post: 1 day
Last activity: 4 hours
AIM:  
ICQ:  
Y!:
#24 Posted on | Instant Rating: 8.65
    Originally posted by Jaguar
    Interesting. ImpeachBush and Left is Right are two trolls (or one troll?) who I gave 0's to the last time they were here under different names. I assume that they became 'No Longer Registered' because their names disappeared of the ratings list, and it just showed 0 for . But now those two blanks are filled with ImpeachBush and Left is Right, and they've got automatic zeros.

    So I guess they re-registered with the same IP or something?

    -Jag
I usually try to delete ratings given to people I end up deleting - sometimes I'm good about it and sometimes I'm not. Ratings are stored as an array with the id of the rater, id of the rated, and rating making up a row. I heartily encourage a rerating if you find a mysterious previous rating applied to a new user, but this should very rarely happen.

Also, users who end up banned or disabled shouldn't end up in the big list of users sorted by rating, though you could probably still look up their ratings in their profiles if you're insanely bored (unless I coded it differently - I'm too lazy to check).



CRZ
tarnish
Frankfurter








Since: 13.2.02
From: Back in the Heart of Hali

Since last post: 470 days
Last activity: 1 day
AIM:  
Y!:
#25 Posted on | Instant Rating: 7.03

    Originally posted by Guru Zim

    MySQL gets a lot of bad press because initially it lacked a lot of features of the big boys - like ACID (transactions basically). You can get this with InnoDB table type, but it wasn't originally built into MySQL.



The people who were complaining about that stuff generally weren't the target audience for MySQL. There are plenty of times when you want a fast, low-overhead DB but you don't need a lot of extra features (foreign keys, transactions, triggers, etc.). Like a web board f'rinstance; well, a basic web board anyway...

On the other hand, I've recently discovered the joys of PostgreSQL. I probably won't go back to MySQL now, but that's more a case of "picking one and sticking with it" than any bias against MySQL.




/tarnish...

It is what it is.
You are what you it.
There are no mistakes.
--Tom Robbins
vsp
Andouille








Since: 3.1.02
From: Philly

Since last post: 3003 days
Last activity: 217 days
#26 Posted on | Instant Rating: 0.00
    Originally posted by Guru Zim
    And for those that don't...

    SQL is sometimes referred to as Structured Query Language. Some people say it "Ess Queue Ell" and some say "Sequel". Others say "Squirrel" apparently, but I think that's awfully silly.


A friend of mine who used to code in it swore that it stood for "Sucks Quite Loudly."




"When WCW tries to be racy, it's generally about as light-heartedly entertaining as watching a man rape a woman in a chicken yard." -- Dark Cheetah
Jaguar
Knackwurst








Since: 23.1.02
From: Phoenix, AZ

Since last post: 168 days
Last activity: 168 days
#27 Posted on | Instant Rating: 4.82
    Originally posted by CRZ
    I heartily encourage a rerating if you find a mysterious previous rating applied to a new user, but this should very rarely happen.


Well seeing as how StacyFanToo (a nonposter so far) appeared with a zero in my ratings list today, I deleted that rating. Maybe I should start rating people other than trolls, and this sort of thing wouldn't happen...

-Jag



Cybernetic Robotic Zombie
Notorious F.A.B.
Pepperoni








Since: 4.2.02
From: Dudleyville's Gay Ghetto

Since last post: 3996 days
Last activity: 3982 days
AIM:  
#28 Posted on | Instant Rating: 6.99
    Originally posted by tarnish
    PostgreSQL.


I've always wondered how you pronounce that one.



I hope HHH gets you fired.
Big G
Potato korv








Since: 21.8.03
From: the people who brought you Steel Magnolias....

Since last post: 2 days
Last activity: 23 hours
#29 Posted on
    Originally posted by Notorious F.A.B.
      Originally posted by tarnish
      PostgreSQL.


    I've always wondered how you pronounce that one.


Yeah it's not bad. Not quite ANSI+ yet but close, and its FREE!!

Most people I know who have used it pronounce it "post-gres"

G



Warrior Quote: "Presuming initial consensualness, where exactly do we draw the lines of our judgment pinning down the responsibility and accountability inextricably attached to each human life? "

Umm Indeed!
tarnish
Frankfurter








Since: 13.2.02
From: Back in the Heart of Hali

Since last post: 470 days
Last activity: 1 day
AIM:  
Y!:
#30 Posted on | Instant Rating: 7.03

    Originally posted by Notorious F.A.B.

    I've always wondered how you pronounce that one.



Around here, where they've used it for quite a while now (my predecessor here at work is apparently on the "development team"), they generally pronounce it somewhere between post-gress and post-grez.

The only real trick in a small to medium installation is remembering to run VACUUM regularly.




/tarnish...

It is what it is.
You are what you it.
There are no mistakes.
--Tom Robbins
DrHogie
Cotechino








Since: 2.1.02
From: Starkville, MS

Since last post: 515 days
Last activity: 514 days
AIM:  
ICQ:  
#31 Posted on | Instant Rating: 2.00
Anyone else see the irony in a thread that started off talking about losers has de-railed into SQL talk?

Hey -- don't look at me, I understood all the SQL talk perfectly!



--DrH
Think of It As a Funnel
Cotto








Since: 22.9.03
From: Strongbadia

Since last post: 3919 days
Last activity: 3917 days
#32 Posted on | Instant Rating: 0.00
I understood "array." The rest of it is technobabble to me. :)



oh
Pages: Prev 1 2
Thread rated: 6.40
Pages: Prev 1 2
Thread ahead: Satire
Next thread: Why can't I...
Previous thread: Helping out.
(865 newer) Next thread | Previous thread
Although I found the near hysteria it seemed some people were in after CRZ left a bit odd, I'm sure that if I went to Yahoo tomorrow to check my fantasy baseball team and found the same *good night* screen I'd be like, "What the hell?
- Derek Burgan, OK, so what happened? (2002)
The W - the-w.com Site Feedback - The following wieners are total losers (Page 2)Register and log in to post!

The W™ message board

ZimBoard
©2001-2014 Brothers Zim

This old hunk of junk rendered your page in 0.147 seconds.