IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New MySQL has table locking.
But you have to use version 4. And it is a scalable robust system: did you know it is the database behind Slashdot and (IIRC) Kuro5hin.

OTOH, it doesn't have stored procedures yet, no.

Wade.

"Ah. One of the difficult questions."

New Re: MySQL has table locking.
Oh good, table locking. NOT.

Table locking is not for serious business use at all. *serious* businesses need row-level locking, which is Somewhere Out There for MySQL.

Postgress seems to have good features/benefits. Free and so forth.

Of course, you could always use IBM DB2. Probably not less expensive than Oracle, though. Other vendors? Informix was absorbed by IBM. Not a bad product, but you gotta be suspicious of its future. IBM or Oracle or Microsoft, that's the choices with the pay databases.

Anyone have other databases to suggest? SQL, while decent, if not great, is OK, alas Microsoft "standard" ODBC is in several varieties, and not fully supported by many databases or ODBC interfaces or even Microsoft itself (see Visual Basic for a glaring example.)

Try to find a standard definition of SQL on the Web. When I went looking a few years back, I never did find a real definition of this ANSI SQL.
The lawyers would mostly rather be what they are than get out of the way even if the cost was Hammerfall. - Jerry Pournelle
New Thans for the info
I would go with IBM DB2; however, IBM does not seem to have made up its mind on the pricing yet last time I checked. At one point it cost more than SQL Server, at another it cost less, and I got a "We'll get back to you" when I asked them how much 20 client licneses would cost. IBM just isn't the same company that it once was. Someone should either put it out of its misery, or buy the f*cker out and get rid of all the pinheaded brain-dead MBA managers and marketers than ruin the company and replace them with computer geeks/nerds like us.

[link|http://games.speakeasy.net/data/files/khan.jpg|"Khan!!!" -Kirk]
New DB2
IBM is actually in the process of REDUCING the price of DB2 for smaller companies.

Current pricing:

User-based licensing model
$995 per server, plus $253 per user.
(User-based licensing works up to 4 processors on Microsoft Windows and 2 processors in Unix. User licensing is concurrent-use based, rather than Microsoft's per-seat, meaning you don't have to buy as many licenses.)
We run several IBM DB2 servers on 10 user licenses for less than $4K per server.

Processor-based licensing model (unlimited users, workgroup edition)
$15,000 per CPU for DB2 Version 7.2, and $7500 per CPU for DB2 Version 8. The price per CPU is actually GOING DOWN! Perhaps you can even work a deal to buy Version 8, but get version 7.2 until Version 8 is out of Beta.

The GUI's on DB2 aren't as nice as SQL Server, but we write our own Delphi programs, and the Delphi programs really don't care if the database is DB2 or SQL Server.

Where you lose out is in the available tools for SQL Server. But, the core database is so much better than SQL Server, and I think, with a little trickery, you could probably use the MS Access GUI tools with DB2 (using ODBC) if you had to.

I would really take a hard look at DB2, especially with the Version 8.0 price reductions.

It's 4X (or more) cheaper than Oracle on the Workgroup Edition, and it's a solid relational database.


Post back if you're interested and I can send you some information to get you started. You can download a free 90 day evaluation from IBM, but I'll have to get the specific URL for you if you're interested.

Glen Austin
New More Info...
If you're not getting clear information about pricing, then I would recommend two courses of action:

1. Call IBM 1-800-426-2255 and ask for the Summer 2002 Catalog US Version. They will send you one for free.

2. Ask for another account representative. I agree that it's confusing with all the different versions and licensing options and stuff, but the account reps at IBM are SUPPOSED to be there to explain it to you. If you want some help, I'll be happy to spend a little time explaining the choices and options.

3. Buy, DB2 Fundamentals Certification for Dummies from amazon.com (or your favorite bookstore). The first chapter of the book goes through all the different options for DB2.

4. Download the DB2 Enterprise Edition trial version: for free.
[link|http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=db2udbdl&S_TACT=&S_CMP=|Here]

5. Download some of the free DB2 courses from the IBM Website.
[link|http://www-3.ibm.com/cgi-bin/software/track3.cgi?file=/software/data/db2/selfstudy/index.html&S_TACT=__S_TACT__&S_CMP=__S_CMP__|Here]

That should get you started, Norm. Let me know if you need more.

Glen Austin
IBM Certified Solution Expert: DB2 UDB Version 7.1 Database Administration for Unix, Linux, Windows, and OS/2
(and I don't even work for IBM, but maybe I should?)
New Revision
News on Slashdot today has it that there is now a MySQL add-in or something that *does* add row-level locking. Iff it's like previous locking annoncements it might be kludgy, but I haven't seen enough to verify/non-verify it.
New Do you know
that because MySQL runs Slashdot and Kuro5hin, my coworkers have two good reasons not to go with it because they use Slashdot and Kuro5hin as bad examples of how to run a database and how to run an almost anarchic forum with little to no security where script-kiddies, trolls, and spammers have multiple accounts and basically run the f*cking place? Where are the moderators? If the moderators won't do their job, f*ck, I'll volunteer and clear the whole house up and disable the accounts of the script-kiddies, trolls, and spammers. Then with the remaining 10% of the users left, the database performance should be a lot better with 90% of the "noise" gone.

Trolls/Spammers like "RobotSlave" run Kuro5hin from his Adequacy.org website because Rusty and company are too much of whimps to do anything about it. Give me access and "RobotSlave" and his 300 Adequacy.org accounts that originate from the same IP will be "Inactive" by blocking the damn IP! I'm getting tired of seeing him promote Adequacy.org on every other post that he makes. I'll write up the damn TOS agreement if K5 won't, but chances are that RS and his 300+ accounts will vote it down.

[link|http://games.speakeasy.net/data/files/khan.jpg|"Khan!!!" -Kirk]
New First off...
Slashdot and Kuro5hin have META-Moderation... and user imposed relationships...

It does not tell you HOW the DB is run... the DB is secure, the forum is Open. If you don't understand HOW those kinds of things run... don't make these kinds of statements...

MySQL does NOT RUN those sites... HOW can a DB RUN a CONTENT DRIVEN system???

No, the System uses MySQL to STORE THAT DATA! There IS a Significant DISTINCTION there sir... Please DO NOT confuse what you believe with what is factual...

I for one, am getting to the point, where I shall combat your un-mistakenly wrong comments until you understand the real situation and retract your "implications"... you are asking for Help, then when "help" is offered, all you do is blow smoke up our asses...

Please refrain from making incorrect assumptions and/or statements until you KNOW the real facts of the matter.

For the record, Slashdot has evolved from a "no-mderation" to Iron fisted moderation, till that became to time-consuming, to moderation by a selct group (10 IIRC), then the select 400 came along, which became a fiasco as "factions" started to appear... it then has gone through multiple interpretations of Moderation, until the "Meta-Moderation" Moderation of Moderation came along... it sorta kinda allows the trolls to post, they then get mod-ed down, by "Moderators", then the "Moderators" moderations get "mod-ed" on how they did... based on how "fair" a moderator is determines wether or not the stay a moderator... It also promotes "proper" moderation to happen... "Proper" being a relative term... so as you see you do not really have a handle on how Slashdot works... Flame-wars become a controlled burn, where as "me-toos" get quelled, even Good posts rise to the surface... against or for the topic...

As far as Kuro5hin... Pete knows all to well how that moderation system works... Donchya Pete? and as far as RobotSlave... well things like that only last So long...

You forget the days of usenet's cross-posting wars... NOW that got old after the first 2-3 Million messages... eventually it calmed down, when everyone put in a twit-filter for it... ON THE SERVERS... it'll happen sooner or later either through admins or the users themselves...

As far as I can see, if MySQL can handle the LOAD of Slashdot and Kuro5shin... I do believe it *CAN* handle most anything YOU can throw at it... barring Stored-Procedures...

I'd like to see *ANYTHING* Microsoft's DB apps do that... actually I'd like to see the OS even come close to running Slashdot or Kuro5hin on the same hardware they currently run...

One last thing, you say you are tired of RobotSlave... well we are getting tired of your posts like this... a lot of words but nothing said, just blather... Now if you get real meat into these posts, we can talk... till then, well... this is what you'll get. It always seems as though you only see the negative things of OpenSouce programs... and only hte good of Microsoft's, except the price... if you can't help out with coding, at least help-out with DETAILED bug-reports...

Nuff said... Flames go to the hand...

greg - Grand-Master Artist in IT,
curley95@attbi.com -- [link|http://www.iwethey.org/ed_curry/|REMEMBER ED CURRY!!!]

Your friendly Homeland Security Officer reminds:
Hold Thumbprint to Screen for 5 seconds, we'll take the imprint, or
Just continue to type on your keyboard, and we'll just sample your DNA.
New Re: First off...
Where the fuck did I say that I want to use Microsoft? If so, why the fuck am I asking for alternatives?

When I assign some asshole who deserves a "0" on K5 for trolling or spamming, he assigns "1"'s to all my comments so that I cannot assign him any more "0"'s. Thus removing my ability to moderate posts that violate guidelines. Then when I fight back and assign "1"'s to his comments that are obvious trolls or spammings, I get called a crapflooder? Is it K5 or the WWE, I am confused?

Yes I know that K5 or /. are not databases; however, they do have a DB engine behind them. I am not confused over that fact. I didn't bring them up, my coworkers did. I'd use fucking mySQL right now, except that I have two coworkers standing in my way bitching at me because there is no stored procedures, etc. I could show them a working Linux system; however, I find myself unable to get one working except a vary old copy from 1995 or 1997 when I did Linux for that small company that I listed on my resume that I had started in 1995 to 1997 with my business partner who still owes me $9000USD in stock because I sold the business over to him and he still owes me for it. Yes thank you I know how to fucking read a man page, yes thank you I know how to get Linux working and I am fucking rusty a bit from not running a working Linux box for a few years. If I keep getting treated like a newbie every time I have an issue and ask for help, I'll fucking respond in this way. I am fucking tired of being a nice guy, I want to be Mr. Hyde for a while because Dr. Jeckle does not appear to be getting results.

[link|http://games.speakeasy.net/data/files/khan.jpg|"Khan!!!" -Kirk]
New Okay.... Now comes the tough part...
Now that we have *THAT* out of the way... where you understand why we bitch about you not posting specifics...

Like WHAT the hardware is... What the error is exactly... or the particular issue is... WITH AS much (what you may feel is unneeded) DETAIL as possible... I mean you have read some of my posts on my problems when I actually have a problem and I am not trying to tweak a few people... They read like a Bloody Novel.

That's is what we are asking for when it comes to the hardware issues...

Also, as far as a MySQL Database... You tell me *WHAT* you are running and I'll send you a Tarball compiled for *YOUR* version of linux... with all the Client and libraries needed... you may need to make sure a few things are installed on the "SYSTEM" so they'll run...

If you use Windows, I'll still put it somewhere you can get it... OK?

So, understand, I *AM* and *ALWAYS HAVE* been trying to help... you are just not letting *ME* help you... by not giving me (or anyone else) the information needed to help you fix your problems... Hell, I'll even build and Ship you a machine fully config'd and installed with MySQL on it... That is unless you want to send me a machine and I'll build it and send it back... I ALWAYS have time to do that... SO... either way we fix you up...

There is another option, but, I'd really be surprised if *THAT* ever was approved... *ROAD - TRIP*... But that'd have to be a couple weeks off...

And are stored Procedures *THAT* important? From your descriptions... doesn't sound as though you've got hugely transactional system...

And to address, Kuro5hin's moderation system... yeah it bites... but sooner or later it's gotta get fixed... and it will... change takes time...

Also, helping people see the light by cramming it down their throat is not the best way... let the look for themselves... let THEM see the bad in the current software... show them serious cost saving by giving up one "minor" feature... one THAT can be lived with... help them see a wireless X-Term solution... an Xterm with touch panel can be a little as $700... r better yet, use a "PC104" spec computer... Small... modular... expandable... reasonable cost... reasonable performance... standard feature set complete $1K w/o OS... and durable...

Help them make the decision to choose the journey rather than draggin them to that direction...

greg - Grand-Master Artist in IT,
curley95@attbi.com -- [link|http://www.iwethey.org/ed_curry/|REMEMBER ED CURRY!!!]

Your friendly Homeland Security Officer reminds:
Hold Thumbprint to Screen for 5 seconds, we'll take the imprint, or
Just continue to type on your keyboard, and we'll just sample your DNA.
New Excuse me
for not giving out more details and being psychic enough to know that you wanted my MAC address, the DNS servers, CPU ID of my chip, serial number, social security number, mother's maidnen name, blood type, astrological sign, date of birth, right tumb print, Iris Scan, sperm sample, urine sample, notory public seal of aproval on a loyalty oath to the Open Sourced Community, and $15 sent to your Paypal account before you could help me? :)

I apeciate your help. When you guys yell and scream at me instead of saying "Norm, I need the details of your hardware. Video card, motherboard, CPU, etc." it really hurts my feelings. My feelings have been hurt a lot in many areas of my life, so I am learning how to fight back again.

If and when K5's moderation system gets fixed, I will go back. If you guys are nicer to me, I might go back sooner. :)

Thanks for the offer of sending and shipping a machine to me, when I talked to Peter about that I was called a whiner.

Details of my test system:

System Name: ADAMA

CPU: Pentum MMX 200Mhz

Motherboard chipset: Intel i430VX

BIOS: AWARD 4.51 11/10/97

RAM: 64M

Video: S3 VirgeDX aka 86C375/86C385 BIOS 1.01

Hard Drive: Western Digital 6G IDE Hard Drive.

Monitor: Generic EMC 17" model 772 (KVM Switch for four systems, same monitor, same serial muse, same keyboard)

Linux: Red Hat 7.3

What else do you wish to know, friend? It has a 24X IDE CD-ROM drive, 3.5" floppy, Realtek 8029 PCI Ethernet 10Mbit card, no audio card, nothing else I can think of. Someone sent me the Red Hat 7.3 CD because the CDR images that I burned kept complaining about a "Media Error" even at 2X or 1X burn speeds. So this is the original Red Hat 7.3 Evaluation CD. Supposed to work right out of the box.

Problems: "X Windows" software aka XFree86 is unable to load. Reports "Missing Fixed Width Font" and sometimes a "Missing Screen" and then exits back to the command prompt. I'd give you the whole screen text, if I hadn't gotten fustrated by getting called a whiner and low level formatted the hard drive and installed NT 4.0 Server instead. Yeah GRUB would not go away, so I commited a sin by low level formatting the hard drive, and not learning why GRUB all of a sudden was a Freddy Kruger or Jason Vorhees that I could not get rid of and kept getting up every time I thought I had killed him.

Version of MySQL used: 3.32.51 someone mentioned a 4.0, I assume that I need to go grab me a new tarball? I will be running it both on Windows and Linux, if possible.

Stored Procedures, oh heck yeah, so much easier to just call "sp_getemployees" than building your own SQL String with 16 tables, 32 indexes, and 48 selectable columns. Can't imagine why anyone would want to run "sp_getemployees" instead of about 6 pages of SQL Code in their SQL Queries? My job with the Lawyers required me to do that, they bought [link|http://www.cmsopen.com|CMSOpen] a database that just loves to have as many tables as they can in one database. Then they wonder why SQL Server 6.X is bitching at me that I cannot add any more tables to my queries? Oh come on Norm, it is only one more table, why can't SQL Server handle it? Then I have to talk to my boss about what a view is, and why I need access to create one to get around the table limits, etc. By the way, does MySQL have Views now? Sort of like a big virtual table that you can link smaller tables into, so that it is accessed like one big virtual table instead of 16 or less of them?

My coworkers tell me that "MySQL is good for web pages, but not Enterprise Level apps that need the extra features that MySQL lacks." So how am I supposed to respond to that? Ok, now we have table locks with 4.0, what else? I'm downloading a new copy, after all what is the point of DSL when you can't use it and a CDR burner? ;)




[link|http://games.speakeasy.net/data/files/khan.jpg|"Khan!!!" -Kirk]
Expand Edited by orion Sept. 22, 2002, 08:36:35 PM EDT
New Pardon...
Norm... please stop biting my hand...

My wife just asked me how you are doing. I let her read for herself...

She wants me to go and help you with anything you may need... including support of a more personal kind... she sees you going through alot of the sames things I have in my "Colorful" employment history, as well as the family things going on now... I have some very big things going on now... but those can wait...

You need someone to help you come back from this edge you have precariously stepped out onto... just think about the GOOD you can do... don't focus on the bad... Call and really talk to someone... Big Norm maybe?? Me?? anyone... calling me collect is a good thing... anytime... you have the number...

greg - Grand-Master Artist in IT,
curley95@attbi.com -- [link|http://www.iwethey.org/ed_curry/|REMEMBER ED CURRY!!!]

Your friendly Homeland Security Officer reminds:
Hold Thumbprint to Screen for 5 seconds, we'll take the imprint, or
Just continue to type on your keyboard, and we'll just sample your DNA.
New Getting better now
my coworker stopped putting on the pressue and cut down on the control. Things are starting to get back to normal. Finally I can sleep a little bit more.

[link|http://games.speakeasy.net/data/files/khan.jpg|"Khan!!!" -Kirk]
New Re: Way-Way-Cool
I can see that *JUST* in your postings... I am liking your personality this way again...

BTW, I just put 2-n-2 together today.... Orion == Norm King == Cable (on IWE original)

Lots... of Cogs fell into sync... explains alot of things AND helps me understand things a bit better...

as we all know... I still have all the IWE forum postings... *CLICK* *CLICK* cept a couple...

HMMM... I have pretty powerful webserver a MySQL DB, PHP.... hmmmmm.... MAYBE....

Lemme do a feasability on that...

greg - Grand-Master Artist in IT,
curley95@attbi.com -- [link|http://www.iwethey.org/ed_curry/|REMEMBER ED CURRY!!!]

Your friendly Homeland Security Officer reminds:
Hold Thumbprint to Screen for 5 seconds, we'll take the imprint, or
Just continue to type on your keyboard, and we'll just sample your DNA.
New Wow you figured it out?
Not like I was keeping it a secret from you guys. I just followed the rest of you here from the InfoWorld Forums. I expect a lot of you already have my psychological profile and can predict the next time my depression kicks out a cycle or two. :)

Cable on IWE, to Cable4096 on Ezboard. Then Nking on Ezboard, then Orion Blastar, then couldn't make up my mind, accidentally logged in as one of my older accounts, was Nking again. Orion, etc. The got to ZIwe and here I am now. Just don't ask me about my IWETHEYTWiki acounts. :) Right now the only one that works is NormanKing, and it is the only one I use. Of course on some areas of the Internet or BBSes, they think that my real name is a handle. Go figure!

[link|http://games.speakeasy.net/data/files/khan.jpg|"Khan!!!" -Kirk]
New Greg, Greg, Greg...K5 moderation...
...may be something Peter's familiar with, but let's not forgot who actually designed it.

/me hopes he doesn't have to take the credit all over again....

...and FWIW, I don't have trusted status there either.

Moderation abuse is something that can be reported and dealt with. I've gone a few rounds of that myself. I'd suggest people not blow this out of proportion -- it's just a freakin' website.

Otherwise -- Greg, points well (and largely coherently ;-) made.
--
Karsten M. Self [link|mailto:kmself@ix.netcom.com|kmself@ix.netcom.com]
[link|http://kmself.home.netcom.com/|[link|http://kmself.home.netcom.com/|http://kmself.home.netcom.com/]]
What part of "gestalt" don't you understand?
[link|http://twiki.iwethey.org/twiki/bin/view/Main/|TWikIWETHEY] -- an experiment in collective intelligence. Stupidity. Whatever.

   Keep software free.     Oppose the CBDTPA.     Kill S.2048 dead.
[link|http://www.eff.org/alerts/20020322_eff_cbdtpa_alert.html|[link|http://www.eff.org/alerts/20020322_eff_cbdtpa_alert.html|http://www.eff.org/...a_alert.html]]
New Uh... Are ewe crit\ufffdi\ufffdciz\ufffding my Englih? or my wait?
I knew it... no-one likes me here...

DAAAD! Make'em be nice... they're being MEAN!!!!

greg - Grand-Master Artist in IT,
curley95@attbi.com -- [link|http://www.iwethey.org/ed_curry/|REMEMBER ED CURRY!!!]

Your friendly Homeland Security Officer reminds:
Hold Thumbprint to Screen for 5 seconds, we'll take the imprint, or
Just continue to type on your keyboard, and we'll just sample your DNA.
     Alternatives to SQL Server 2000 - (orion) - (38)
         MySQL has table locking. - (static) - (16)
             Re: MySQL has table locking. - (wharris2) - (4)
                 Thans for the info - (orion) - (3)
                     DB2 - (gdaustin) - (1)
                         More Info... - (gdaustin)
                     Revision - (wharris2)
             Do you know - (orion) - (10)
                 First off... - (folkert) - (9)
                     Re: First off... - (orion) - (6)
                         Okay.... Now comes the tough part... - (folkert) - (5)
                             Excuse me - (orion) - (4)
                                 Pardon... - (folkert) - (3)
                                     Getting better now - (orion) - (2)
                                         Re: Way-Way-Cool - (folkert) - (1)
                                             Wow you figured it out? - (orion)
                     Greg, Greg, Greg...K5 moderation... - (kmself) - (1)
                         Uh... Are ewe crit\ufffdi\ufffdciz\ufffding my Englih? or my wait? - (folkert)
         Idea: - (CRConrad) - (14)
             Thanks for the idea - (orion) - (13)
                 FWIW - (tseliot) - (12)
                     Thank you! - (orion) - (5)
                         Oh, yeah. Great plan. Good luck with that. - (altmann) - (4)
                             Better link for that script... - (folkert) - (3)
                                 Thank you guys - (orion) - (2)
                                     Then do that - (drewk) - (1)
                                         I am doing that - (orion)
                     Please remove the returns in your post - (ben_tilly) - (2)
                         Wish I could. zIWE parser put them in for me. -NT - (tseliot) - (1)
                             You _can_ - (ben_tilly)
                     Table re-done, all purty like... only removed breaks - (folkert)
                     Whoop---Whooop---Whooooop!!! - (folkert) - (1)
                         Ya NUT! - (tseliot)
         Oops, disregard -- double posting! -NT - (CRConrad)
         Re: Alternatives to SQL Server 2000 - (broomberg) - (4)
             Believe me, I do not insist on it - (orion) - (3)
                 I might be smoking rope. - (mmoffitt) - (2)
                     Uh yeah - (orion) - (1)
                         Depends on how you write it. - (mmoffitt)

Yeah! Coterminous!
288 ms