Computer SW Database - Berkeley CSUA MOTD
Berkeley CSUA MOTD:Computer:SW:Database:
Results 1 - 150 of 239   < 1 2 >
Berkeley CSUA MOTD
 
WIKI | FAQ | Tech FAQ
http://csua.com/feed/
2017/10/19 [General] UID:1000 Activity:popular
10/19   

2004/11/8-9 [Computer/SW/Database] UID:34768 Activity:nil
11/8    Hello, new 500 list: http://www.top500.org/lists/plists.php?Y=2004&M=11
2004/10/28-29 [Computer/SW/Database, Computer/SW/SpamAssassin] UID:34416 Activity:nil
10/28   Re: "spamassassin going over quota" thread below, I will restate:
        Try ifile.  It's an excellent bayesian filter whose database currently
        uses less than 230K for me.
        \_ I tried setting up ifile. It was that much more complicated and
           didn't work nearly as well as sa once I did. YMMV. Still, if sa is
           going to consistently involve up to 10M of reference files, I may
           give it another go. I have only so many hours to burn on this stuff,
           though. I am not the sysadmin from a couple of days ago who "works
           1.5 hours a day".
2004/10/14-16 [Computer/SW/Database, Computer/SW/SpamAssassin] UID:34119 Activity:nil
10/14   I've been getting some errors trying to mark spam in spamassassin
        the last few days. "Cannot open bayes databases [...]
        Inappropriate file type or format." RTFMing seems to indicate
        that I need to migrate my bays_tok database using the BerkeleyDB
        db_dump program, but I can't seem to find this executable. Pointers
        to the program or alternate solutions appreciated. Thanks!
        \_ db3_dump might be what you're looking for -dwc
        \_ did they install spamassassin 3.0 on the machine you're using?
           it seems like in 3.0 the bayes database format changed, so you
           need to retrain.

           need to retrain.
2004/10/11-12 [Computer/SW/Database, Computer/Networking] UID:34034 Activity:nil
10/11   Anyone have a recommendation for a serial cable analyzer? I need
        one that works with "live" circuits. I am interested in debugging
        DB-9 to RJ-45 cables. E.g, inserting the device inbetween a PC COM1
        port and terminal server port. Bonus points for jumpers/wires
        that one can fiddle with to essentially re-wire the cable on
        the fly.
        \_ I don't know exactly what you mean by analyzer, and this is
           probably not what you're looking for, but since no one else is
           answering...a nice little juper box for db-9 is
           http://tinyurl.com/64gx8
           you have to solder wires to make the connections, though.
2004/9/23-24 [Computer/SW/Database] UID:33727 Activity:kinda low
9/23    SQL/MySQL question:  If I create a DB with a field that's a
        varchar(256), will I be wasting a lot of disk if the data is typically
        only 5-10 chars long?
        \_ No.  It's not 1981 anymore.
           \_ I just wanted to be sure I wasn't setting up something in a
              horribly inefficient way.
           \_ But what about my Atari 2600?!?  NOOOOOO!
              \_ You have MySQL for Atari?
                 \_ Yeah, but it can only hold 128 bytes of data.
                    \_ Dude, my Sinclair ZX-81 version of LISP totally
                       r0x0rs your Atari MySQL.
                       \_ Do you need to use the 16K RAM expansion to hold
                          all the parenthesis?
 __  __  ___   ___  _
|  \/  |/ _ \ / _ \| |
| |\/| | | | | | | | |
| |  | | |_| | |_| |_|
|_|  |_|\___/ \___/(_)
        \_ You mean varchar(255)
           \_ I guess, but would it really matter? -op
           \_ yes. limit is 255 in mysql
        \_ YES it'll take the same amount of space. If space is an issure
           use TEXT or VARCHAR, but you'll trace space with time. Nothing
           comes in free.
2004/9/17 [Computer/SW/Languages/Misc, Computer/SW/Database] UID:33585 Activity:nil
9/17    In SQL it seems DATE, DATETIME, TIME and TIMESTAMP are all reserved
        words.  What do you use to name your date fields?
        \_ What date it actually is, e.g.: "created_date", "updated_date",
           "renewed_date" (or just "created", "updated", "renewed", etc)
           --dbushong
           \_ Good idea, thanks.  Another question:  How do I create a table
              with a record which is an array of strings, eg: a table of
              some type of record where one element is a list of keywords.
              Do I have to put all the keywords in one string and do something
              like comma-seperation?
              \_ If they're going to be of varying length and short, then the
                 comma separation bit will work.  Otherwise, make a new keyword
                 table and tie it to the first table with a foreign key.
2004/8/31-9/1 [Computer/SW/Database] UID:33252 Activity:nil
8/31    IIRC, Oracle requires a "where" statement to make updates.  Is there
        anyway I can make mysql require the same thing?  Developers keep
        doing ' update TABLE set column="newvalue" '.  When they don't mean
        it.  It is easy enough to type "where 1=1" if you really do mean it.
        I'm hoping this is a config i can change, maybe? possible? thanks.
2004/8/25-26 [Computer/SW/Database] UID:33148 Activity:very high
8/25    Does anyone know of any good way of donating software that is no
        longer being used?  E.g. I have an old copy/license/manual of
        Oracle 8 for NT.  I was going to just toss it, but I thought I'd
        check first to see if it could be used anywhere? (I imagine that
        newer versions of free databases might be better already, but I'm
        interested in the answer since I have other CDs/products that I
        could also get rid of). Thanks!
        \_ I wouldn't inflict Oracle 8 on my worst enemy, but that's just me.
        \_ The licenses for commercial software are usually non-transferable.
           As for Oracle, anyone seriously considering using it for production
           should buy a support contract which probably also entitles them to
           the latest versions of the software anyways while the developers
           already have free or almost free access to the Oracle software for
           development and testing purposes.
           \_ Thanks for the info! - OP
           \_ http://www.accrc.org should take it.
        \_ When I wanted to get rid of my NetWare 4.0, I just dropped it off
           at the dropbox of a public library.  Don't know what they'll do
           about it.
2017/10/19 [General] UID:1000 Activity:popular
10/19   

2004/8/19-20 [Computer/SW/Database, Computer/SW/Languages/Web] UID:33025 Activity:moderate
8/19    Please suggest a good web hosting site.  Ideally with
        php/shell/sql/cgi-bin support.  TIA
        \_ http://findmyhosting.com is a good search engine for what you want.
        \_ http://he.net
        \_ http://qualityhostonline.com -- starting at $4/year
           \_ I pay $2/yr.
           \_ that doesn't have shell does it?
        \_ thanks for your help - op
2004/6/2 [Computer/SW/Database] UID:30553 Activity:high
6/2     NetFlix rental queue, is it just pure sql to store it or do they
        use a "priority queue" for each member?
        \_ does this mean anything?
        \_ priority queues do exist already. They're called
        relational databases, so they use pure sql
        \_ they store member info in the database, but when it
        comes time to ship they probably build a "priority queue"
        data structure and figure out what the customer wants
        then update the database. So you need both
        \_ it's all real-time, whenever you update your priority
        on NetFlix's queue, your priorities get renumbered starting
        with 1, 2, .etc. ie: if you put 3, 4, they get reset to 1,2
        there, this indicates some business logic which utilizes
        a priority queue before they write back to the database.
        \_ but if multiple people vy for the same titles, NetFlix will give
           priority to those who rent less frequently.
           \_ just add more business rules, yes
2004/5/13-14 [Computer/SW/Database] UID:30215 Activity:high
5/12    SQL question. Let's say I want to perform an outer join, like
        "SELECT a.column FROM a LEFT OUTER JOIN b ON a.column=b.column
         WHERE b.column='hello'"
        and I get a list of column from table a. But the following doesn't
        work where I want to delete all of the rows in a selected by the above:
        "DELETE FROM a LEFT OUTER JOIN b ON a.column=b.column
         WHERE b.column='hello'"
        How do you get around this? Thanks.
        \_ Your select statement is equivalent to
           select a.column from a.column='hello'.
           perhaps you're joining on a different column?
           \_ sorry, yes, all columns are unique, I forgot to make it clear.
              So if they're all unique column how would this be done? ok thx
              \_ You're saying the solution below doesn't work?
        \_ I think you want something more like
           DELETE FROM a WHERE a.col=b.col AND b.col2="hello".
           \_ Wouldn't you need to do
              DELETE FROM a WHERE a.col IN
                (SELECT col FROM b WHERE b.col2='hello')
              -geordan
        \_ why are you left outer joining and then filtering out the stuff
           that don't have a match in b?
2004/4/25-26 [Computer/SW/Database] UID:13368 Activity:nil
4/24    In SQL, when I insert a row with sequence (auto_increment), I don't
        know which sequence it is assigned to. How do I find out what number
        I just inserted? I guess I could try (SELECT max(id) ...) then insert
        max+1, but if I have 2 people doing it, I may be screwed. By the way
        I'm using mysql so there is no transaction...
        \_ Um, the whole point of auto_increment fields is that *you* don't
           have to worry about them.  The way you phrased your question seems
           to suggest you're trying to perform an insert where you specify the
           auto_increment.  That's just silly.
        \_ Take a look at:
           http://dev.mysql.com/doc/mysql/en/Getting_unique_ID.html
           http://dev.mysql.com/doc/mysql/en/mysql_insert_id.html
           (If you ever switch to postgres you will have to rewrite this
           to use curval/nextval instead)
           to use curval/netval instead)
                            \_ fixed.
        \_ That's funny, I'm using transactions on some InnoDB tables with
           mysql 3....
                         \_ probably a typo.  should be nextval
2004/4/9 [Computer/SW/Database] UID:13107 Activity:nil
4/8     In SQL, say I have two tables, one references to another. What is the
        query that will list all the entries in the first table that doesn't
        occur in the second table? I'd like to do "SELECT a.id FROM
        a,b WHERE a.id!=b.id". However, this doesn't quite work. Thanks.
        \_ The following works in PostgreSQL; I don't know if the IS NULL
           syntax is part of SQL or an extension. Note that, in Postgres,
           replacing 'IS NULL' with '= NULL' doesn't work.
           SELECT a.id FROM a LEFT OUTER JOIN b ON a.id=b.id WHERE b.id IS NULL
           There may well be a more efficient way of doing this, but this
           one works. -gm
        \_ SELECT id FROM first_table a WHERE NOT EXISTS
           (SELECT * FROM second_table b WHERE b.id = a.id)
2004/4/7-8 [Computer/SW/Database] UID:13060 Activity:low
4/7     Does anyone know of a good website that has small icons/images
        of individual countries? I don't want any text to be on the
        image (no country/city names, etc). Thanks.
        \_ Outline maps?  Or flags?
                \_ Outline maps (definitely no flags) -op
        \_ If you could get a world political map, you could run it through a
           sharpen filter and then use a "smart select" tool to select an
           individual country.
           sharpen(x) = x - smooth(x)
        \_ http://www.cia.gov/cia/publications/factbook/reference_maps/pdf/political_world.pdf
n       \_ http://www.cia.gov/cia/publications/factbook/reference_maps/pdf/political_world.pdf
           See if you can substitute the fonts with invisible ones in Acrobat.
           I don't know how.  --- yuen
        \_ may be you are looking for GIS maps.
2004/4/7 [Computer/SW/Database] UID:13050 Activity:moderate
4/6     How to select entries x to y in SELECT in mysql? I don't want to
        get a whole list and then do a @list[x..y] which is inefficient.
        ok thx.
        \_ moron
        \_ I think you are looking for LIMIT and OFFSET.
        \_ does select() always return things in the same order?  are you
           ORDER BY'ing something?
        \_ all of the above- you need ORDER BY, LIMIT, OFFSET, and probably
                DISTINCT                        -brain
2004/3/31-4/1 [Computer/SW/Database] UID:12946 Activity:low
3/31    What's the difference between KEY, PRIMARY KEY, UNIQUE, and INDEX?
        \_ 3, b, 6, 5
        \_ use SQL_book; import knowledge; do(homework);
        \_ I think PRIMARY KEY means both UNIQUE ande INDEX. INDEX does
           fast indexing with fast lookup but slow insert. I actually
           don't know the difference between KEY and PRIMARY KEY
        \_ PRIMARY KEY cannot be null but KEY and UNIQUE KEY can contain NULL
2004/3/30-31 [Computer/SW/Database, Computer/SW/Unix] UID:12939 Activity:nil
3/30    How can I tell what has been compiled into my postfix binary?
        For example, I want to see if it has mysql support built in.
        \_ If you know what you're looking for, you can probably use
           strings/grep (assuming you have just the binary.)  Or you
           could just roll your own... -John
        \_ Try ldd if dynamically linked, or nm postfix | grep mysql
           if static. --scotsman
        \_ If you installed with a package it should say.  If you installed
           from source, look at the makefile and config files.
2004/3/29-30 [Computer/SW/Database] UID:29884 Activity:low 71%like:12915
3/29    In mysql, I'm getting huge files like the ibdata1, logfile,
        bin files, etc. How do I compact them? Thanks.
        \_ philcompress
2004/3/29-30 [Computer/SW/Database] UID:12915 Activity:low 71%like:29884
3/2  9    In mysql, I'm getting huge files like the ibdata1, logfile,
          bin files, etc. How do I compact them? Thanks.
        \_ philcompress
2004/3/29-30 [Computer/SW/Database] UID:12906 Activity:nil
3/29    What kind of database does http://csua.org use?
        \_ I think mysql, but you'd have to ask dbushong to be sure. --scotsman
2004/3/27-29 [Computer/SW/Database] UID:12890 Activity:nil
3/27    In SQL, is there any reason to use bounded VARCHAR instead of the
        unbounded TEXT? TEXT gives you the ability to expand as your start
        to insert data whereas VARCHAR is bounded, but what about performance
        and other issues?
        \_ Access and search of text datatypes tends to be pathetic compared
           to varchar performance on many databases.  I'm not an export so I
           can't speak on, say, Oracle or SQL Server's exact performance, but
           this is _certainly_ true on Postgres.  I believe many databases
           story text datatypes as unbounded linked lists.
                \_ ok so how do I find out the minimum page size per TEXT
                   on MySQL? I'm going to use FULLTEXT index on TEXT so that
                   search will be fast. Also I'm wondering how MySQL deal
                   with internal fragmentation (say you allocate 5K size, then
                   some other data comes in, then you increase the size of
                   that text to say, 6K, what happens? It's a standard heap
                   problem...)
                   \_ All of this is *very* specific to the particular
                      database you are using.  Read the docs, read the source
                      if you can, query relevant mailing lists, etc.  Above
                      all, profile, profile, profile.
2004/3/25 [Computer/SW/Database] UID:12849 Activity:nil
3/25    Ok please tell me the pros/cons of mysql vs. postgreSQL. For me
        speed is really really important. On the other hand, packaging
        (ease of install, consistent commands, etc) is also very important
        for development. I've just tried mysql for the first time and I'm
        NOT very impressed. The documentation that came with it was outdated
        (some of the tutorials didn't work) and it didn't even pass all of
        the regression tests!!!
        \_ omg, for the millionth time... google. there's tons on the web
           abt this. eg http://openacs.org
        \_ Welcome to open source.  In any case, my understanding is mysql
           is easier setup and deployment, postgreSQL is more robust and
           full featured.  If speed is an issue, postgreSQL is probably
           faster since it features a query optimizer.
        \_ We have used mysql for our db layer for about 3 years now and
           recently decided to switch to postgreSQL. The main problems with
           mysql were the licensing terms for commerical use, the lack of
           decent txn support in the 3.x version and its non-standard sql.
           The performance was adequate most of the time but we used to
           have problems with tomcat's db connection pools under high load.
           As far as installation and configuration go, both mysql and
           postgreSQL are pretty easy to install and configure on Linux,
           FreeBSD and Solaris. PostgreSQL might be a bit harder because
           it expects you to understand something about the care and feeding
           of a database. If you spend a few hrs reading the online docs
           you should be able to get it running smoothly.
           \_ You'll probably want to make InnoDB if you're using mysql.
2004/3/17-22 [Computer/SW/Database] UID:12716 Activity:nil
3/17    Looking for Oracle DBA/expert in downtown Oakland.
        /csua/pub/jobs/SavageBeast/OracleDBA.txt
2004/3/17 [Computer/SW/Database, Consumer/Audio] UID:12715 Activity:nil 50%like:29878
3/16    [ car stereo query deleted because op has an attitude ]
        \_ What? I'm the original poster and this is the first I've
           even seen the thread. Why do you think I have "attitude"?
           I never even got a chance to see the replies.
           \_ "for my asshole. -op"
           \_ I think he meant "Car stereo query deleted because it attracted
              useful responses."
              \_ Whew! 'Cause I tried putting a DVD there and it broke.
        \_ there is no authentication on the motd, you know. -you
2004/3/13-14 [Computer/SW/Database, Computer/SW/Languages/Web] UID:12653 Activity:nil
3/13    Anyone got pointers to docs/files for info on using MySQL on soda?
        It's for a class project and wanted to use PHP and MySQL on soda
        to experiment with it.  Has anyone tested it out?
        Is this it? '/usr/local/bin/safe_mysqld'  Thanks in advance...
        \_ We have a postgres server available for such projects; email
           root for more info.
2004/2/29-3/1 [Computer/SW/Database] UID:12451 Activity:nil
2/28    Did anyone ever come up w/ a solution to the SQL sorting question?
        \_ yes
2004/2/26-27 [Transportation/Car, Computer/SW/Database] UID:12424 Activity:nil
2/26    Suppose I have a database of car dealers and the cars they have in
        stock.  I want to query this database for N cars that I'm
        interested in, something like
        SELECT dealerId, carId FROM cars WHERE (carId=1 OR carId=2 OR carId=42)
        The problem is, I need to sort the result such that a dealer who
        has all N cars I'm interested in is ranked higher than a dealer that
        has only 1 or 2 such cars.  Can this be done with some sort of
        aggregate function?  Something like
        SELECT dealerId, count(dealerId) as numCars, list(carId)
          FROM cars WHERE (carId=1 OR carId=2 OR carId=42)
          GROUP BY dealerId
          ORDER BY rank
        where the output would be
        dealer  | numCars       | list(carId)
        ----------------------------------------
        Fred      3               1,2,42
        Bob       2               1,2
        Tom       2               1,42
        Jerry     1               2
        Thanks in advance.
        \_ Please tell me this is for work.
           \_ I would, but then I wouldn't get the input from the smart types
              who do it because it's challenging. -op
              \_ Your question was better when it was jive'd.
                 \_ Yo! Yo!  Shiznitz!  Wez be needin' ah jive update!
2004/2/26-27 [Computer/SW/Database] UID:12420 Activity:moderate
2/26    Someone explain this to me please.  Why US Government give Oracle
        a hard time under the anti-competitive ground, yet gave Microsoft
        a free hand to do whatever he wants?
        \_ Why prc no free market noodles make Ayn Rand?
        \_ Bill gave W more campaign contributions than Larry did
2004/1/29-30 [Computer/SW/Database] UID:12014 Activity:nil
1/29    MySQL vs. PostgreSQL. Discuss.
        \_ MySQL for easy setup, PG for anything important / heavy writes.
        \_ c'mon... just do a little google'ing. you'll get a much more
           thorough answer than you will from here. in particular check
           out the postgres website... or http://openacs.org
2004/1/8 [Computer/SW/Database] UID:11714 Activity:nil
1/7     How do I escape an apostrophe character in an SQL query
        SELECT * FROM foo WHERE bar LIKE '%it\'ll be a long summer%'
        \_ In Oracle, you escape apostrophes with another apostrophe.
           \_ Thanks.
        \_ It's different for different dbs.  The above works for a number of
           different ones.
2003/11/10-11 [Computer/SW/Database, Computer/SW/Editors, Computer/SW/Languages] UID:11000 Activity:nil
11/8    I'm looking for free websites that allow you to dig up information
        on people.  Stuff like phone numbers, email addresses, driving
        records...  Any ideas of sites?
        \_ ever notice how in old comic books they would always
           print the address of people writing letters to the editor?
           I wonder when they stopped.
        \_ google?
        \_ http://find.intelius.com/index.php
           \_ this is so fucked up.  Is there anyway to protect myself
              against this?
              \_ I'm not on it, why not?  [formatd]
                 \_ are you a student?  few students have done enough in life
                    to get into any public records.  when They can start
                    tracking you, you've entered the adult world.  public
                    records are the least of your privacy concerns.
                \_ I'm not on it, why not?
              \_ it's all public information.  you can kill yourself, but oh
                 wait that will get you into the death certificate db.
        \_ http://peoplefinder.com, http://411.com, http://bigfoot.com, or better yet just pay a
           PI $50.  An unscrupulous one won't ask you any questions about
           why you want to know where you ex-gf fled with your dog, car, and
           nintendo and what the butcher knife is for.
2003/10/23 [Computer/SW/Database] UID:10750 Activity:very high
10/22   Sockets again (WinSock): select() on my socket descriptor fails with
        error 10038 (http://www.sockets.com/err_lst1.htm#WSAENOTSOCK which
        means the socket is not valid.  But I just created the f**ing thing.
        Any ideas?  This happens on both server & client.
        Update: I can select() without errors until I try to send(), then it
        fails.
        \_ Server or client?
           \_ Ok, this is screwier than I thought.  Thanks for your help,
              but I'm going to sleep on it-- when I simplified it a bit,
              select() started returning data ready, but recv() kept
              returning 0 bytes.  Again, thanks.
2003/9/14-15 [Computer/SW/Database] UID:10190 Activity:nil
9/13    http://www.magnetbox.com/riaa/search.asp
        RIAA radar -- enter label or artist name and find out if they're evil
        or not.
        \_ Evil?  Meaning what?
           \_ Suing some of the 60 million file sharers for not being good
              little moral-less music buying consumers.
              \_ Huh?  you're not making any sense.  I think you're lost in
                 your own self justifying little world.
2003/9/4-5 [Computer/SW/Database, Computer/SW/Languages/Java] UID:10078 Activity:nil
9/4     For files that end in .avi, is it a fairly simple matter to tell
        what codec is necessary to play it, e.g. DivX or XviD? I'm talking
        about programmatical methods here, like reading headers or something.
        \_ http://www.geocities.com/ajmas/software/rifffileinfo
        \_ why programmatic?  are you going to write your own tool?  there
           are plenty of good tools out there already
           (e.g. http://www.headbands.com/gspot), and I don't think you
           want to maintain your own independent fourcc->codec database.
        \_ prompt% man magic
2003/8/21 [Computer/SW/Database, Computer/Companies/Google] UID:29423 Activity:moderate
8/20    Google calculator
        http://www.google.com/help/features.html#calculator
        \_ I dont really get the point of this feature... what does this
           have to do with web searching? seems pointless to me
           \_ Just because it has nothing to do with searching doesn't mean
              it's not cool.
        \_ Very cool!!!
        \_ Haven't any of you guys used /usr/bin/units? Sheesh.
2003/8/11-12 [Computer/SW/Database, Academia/Berkeley/CSUA/Motd] UID:29304 Activity:very high
8/10    Whoever told me that Gallery is backed by a database, I just found
        out that it is a lie.  God damn, you guys use Gallery and doesn't
        even know rather it has a database behind it or not?
        \_ "don't", not "doesn't". "you guys" is third person plural, not
            singular. Stop sounding like a FOB.
            \_ You rock!  --motd grammarian #1 Fan
                            \_ should it be "motd grammarian's #1 Fan"
                               -- grammatical psuedo-fan
                               \_ no.  it's a title where "motd" is modifying
                                  "grammarian", thus "motd grammarian" which
                                  then modifies "#1 Fan".
                                  \_ If it's a title, and you're not e.e.
                                     cummings, you should capitalize each
                                     word.  (If you are e.e. cummings, I'd
                                     love to know your ISP.)
                                     \_ yous guys should go fuck yourselves.
                                        \_ I got this helpful email about
                                           penile enlargement and now I can
                                           fuck myself!
                                     \_ It's the motd.  cAPs arE opTIoNal
                                        \_ Not if you're going to pretend
                                           to be the MOTD Grammarian #1 Fan
                                           \_ I'm just a fan.  I like to watch
                                              boxing, that doesn't mean I'm any
                                              good at it.
            \_ In addition "you guys" isn't grammatically correct either,
               but I let it slide, (maybe he wanted to sound like a NJ
               gangster). Apparently OP doesn't understand the difference
               between a pronoun and a possessive adjective.
               \_ NJ gangsta would say "youse guys"
                  \_ Youz bin wotchin too mutch uh dah teli!
               \_ What about "... even know rather it has ..."?  I like it.
2003/6/24 [Computer/SW/Database, Computer/SW/Security, Reference/Law/Visa] UID:28824 Activity:high
6/24    Oh god.  I wish the EU (useless bunch of poltroons) would get at
        least a semblance of a backbone.
        http://www.theregister.co.uk/content/55/31380.html
        Does anyone know more about new biometric passports the US is supposed
        to be issuing?  I'd frankly much rather deal with the hassle of a
        visa with my Swiss passport than submit to this.  -John
        \_ Maybe it's just me, but John seems to talk about his Swiss passport
           pretty frequently.
        \_ Biometrics are such a huge mistake.  No one seems to be addressing
           the issue that if your biometrics are compromised, there is no way to
           issue new ID--well, without replacing your eyes.  -emarkp
           \_ Hm?  Perhaps I'm misunderstanding the process:  you have an ID
              or passport with your retinal scan/fingerprints on it.  They
              scan your ID, compare it to a db of such things, and then you
              put your eye/hand to the scanner and verify that you are who
              the system says you are.  Are you saying that someone could
              hack the db and sub their own particulars for yours and so take
              your bank account?  If so, you now have their fingerprints /
              ret. scan on file-- should be fairly easy to find the duplicates
              in the system and arrest the perp.
              \_ No, if someone else can ID themself with your biometrics or
                 subvert the system somehow, you're screwed.  You can't get
                 different biometrics. -emarkp
                 \_ What are we talking here?  Fake fingerprint gloves?
                    False retinal scan contacts?  Not saying it can't be done
                    but quite a stretch, no?
                    \_ Actually it's quite easy to fake out the fingerprint
                       thing. The retinal scans can be horribly difficult
                       obtain accurately at times. The real problem is identity
                       theft and proving that it wasn't you who shifted your
                       bank account/stock portfolio/real estate to party X.
                       VERY tough to dispute.
                        \_ I fail to see how biometrics makes this worse;
                           right now you're being authenticated on your
                           signature, which is way easier to forge than
                           even the simplest biometric.  -tom
                           \_ It's not worse. It makes id theft much more
                              difficult. I'm more for dual source
                              authentication. Bio + PIN. However, businesses
                              might make it much harder to dispute id theft
                              and make corrections since it is technically so
                              difficult. I fear an overreliance on tech.
                              \_ I think this has less to do with tech, and
                                 more to do with the nature of big business
                                 and bureaucracy.  Bureaucracy and silly
                                 overhead happen just fine without any
                                 technology at all.  What you'd hope is that
                                 intelligent policies will be put into place
                                 to deal with situations that the tech makes
                                 'unlikely'.
        \_ You'll submit and you'll like it.
           \_ Grey matter! Grey matter!
2003/6/21 [Computer/SW/OS/Windows, Computer/SW/Database] UID:28792 Activity:high
6/20    anyone have a good reference on the advantages of nonblocking io?
        some guy i'm talking to is insisting that blocking w/ select is better
        than nonblocking. he says "if your IO is nonblocking, you're going
        to use 100% CPU." ?!!@?$#
        \_ http://tangentsoft.net/wskfaq/articles/io-strategies.html
        \_ kqueue!
        \_ Don't you have to use select/poll with both blocking and
           non-blocking fd's in order to know when you can read/write
           to the fd? How can one be better than the other?
           to the fd? How can one be better than the other? -!*nix hacker
           \_ if you use read or write on a blocking fd then those system
              calls will block too. That's the difference.
                \_ I'm confused. If I select/poll on an fd and select/poll
                   tells me that the fd is ready for reading/writing can't
                   I read/write the fd without it blocking? What is the
                   advantage of making the fd non-blocking?
                   \_ When data can't be read or written from the non-blocking
                      fd, the read/write system calls simply return instead of
                      "blocking" (I thought it was clear from the name
                      "non-blocking"). Why would you want to do that? You can
                      manage multiple I/O streams from a single process
                      without having to use threads. In fact, some people
                      argue that servers that use non-blocking IO tend to be
                      faster than either multithreaded or forking servers.
        \_ It allows var/ dev/ to interlace with the kernel so that daemons
           arent locked.
2003/6/11 [Computer/SW/Database] UID:28699 Activity:very high
6/10    What is the backend for Nasdaq/NYSE/etc? Compaq? Sun clusters? HP?
        \_ for "etc" ask keithyw@csua, he works at Nikko+Citigroup in .jp
           as a sysadmin for their trader stations/backend stuff.  He keeps
           bitching about solaris so I'm guessing it's sun.
        \_ obGoogle "Nasdaq servers".
           \- helo does anyone know what the Fed's Master Computer
              runs on hardwarily and OS-wise? I am talking about the
              one at the bottom of a mine in Colepepper VA or something
              like that. --psb
              \_ YouAskedSoNowYouHaveToDieOS
        \_ used to live in NYC and attend school there.  Most of Wall Street's
           backend are mainly fueld by Sun Clusters.  IBM is always there.
           Software wise, interesting part is that Oracle is absent in
           virtually all the big Wall Street boys.  People there uses either
           Sybase or DB2 for their DB.  I asked them why, all i got is
           "because of something stupid Oracle did in the early 90's."
                                        -kngharv
            \_ Wasn't it Oracle who shredded a bunch of documents reserved
                for SEC investigators?
               \_ no idea.  But if any of you guys want to get a job in NYC,
                           \_ fuck you.  I believe that is grammartically correct
                  here is an idea: Oracle is desperately need a sales force
                  there to expand their market :p
                        \_ Hopefullwoone know grammar.
                           \_ fuck you.  I believe that is grammartically
                              correct
                                \_ puk goo.  "Oracle is desperately need a
                                        sales force" != good grammar
                                \_ try "is desperately in need of a sales
                                    force" or "Oracle desperately needs a ..."
                                   \_ or "Oracle's sales force is FUCKED!"
           \_ Nasdaq ran on Tandem Himalaya machines according to some posters
              at WRL.  This was a couple months ago.
              \_ Last I recall these are the actual database machines. Lots
                 of transactions and hot swappable boards for 20 years.
2003/5/26-27 [Computer/SW/OS/Linux, Computer/SW/Database] UID:28555 Activity:high
5/26    I saw _The Matrix Reloaded_ and thought that I "got it".  I didn't.
        Reading http://www.corporatemofo.com/stories/051803matrix.htm
        revealed much to me.  --darin
        \_ what? the guy didn't even know how tank died?
        \_ He got it all wrong. Here's how it works:
           Architect: Bill Gate$/Tanenbaum
                \_ You think Microsoft ever actually created anything?
                   \_ Other than a large software mess that enslaves
                      most of the worlds coders/computer users?
                      Notice how bugs are still being worked out in
                      Version 6.x.
           Morpheus: RMS
           \_ RMS? Who's that?
                \_ A hacker.  See: http://tinyurl.com/cnmd
                \_ http://www.stallman.org
                \_ random psycho idiot who makes a lot of sense if only he'd
                   let go of some of his weirder bits.  at least he's very
                   consistent.  btw, anyone remember playing xtrek in the
                   planets cluster on the rms/rms account?
                   \_ of course.  Faster than the web, plus you could get
                      into sequent before 11:00 PM.  -tom
           Neo: Linus Torvalds
                \_ One is a hot young star, the other a greasy fat hacker who
                   has no political opinions.  I can't buy this one.  Sorry.
                   \_ Have you ever talked to Linus? The guy is pretty
                     \_ Donald Kunth
                      opinionated (about everything not just politics).
                      And his wife kicks some major ass a la Trinity.
           Zion: Bitkeeper
           Oracle: ESR
                \_ So you think ESR is working hard to keep Microsoft alive?
                        \_ It is debatable whether or not the oracle is
                           working to keep the matrix alive.
           Keymaker: Phil Zimmermann
           Merovingian: NAI
           Agent Smith: SCO/Redhat
           \_ Who is Cornel West in your mapping?
                     \_ Donald Knuth
2003/4/17-21 [Computer/SW/Database] UID:28158 Activity:nil
4/17    .NET, SQL Server, SOAP, XML job in /csua/pub/jobs/EmployEng
        --dbushong
2003/4/13-14 [Computer/SW/Database] UID:28107 Activity:high
4/13    Any recommendations on oracle vs MS as place of employment?
        My cousin has offers at both and is unsure which to go with.
        \_ Choose to innovate at M$.
        \_ Oracle has a rep as slave drivers.
           \_ Oh?  And MS doesn't?  OP's cousin should go for cash and
              location and potential for future job growth.  As places of
              employment both will suck big time in all the other ways.  BTW,
              I assume this means full time on staff employment and not MS's
              fake full time contracted employment.
              \_ most ppl assume that if you are hired as a "contractor", but
                 treated like an employee, that you really are an employee as
                 defined by law (i.e. not the employers "title"). some M$
                 "contractors" sued M$ and won when M$ "employee's" got
                 stock options and so forth during M$'s success, but the
                 "contractors" got zippo. I heard about this at an SBA
                 workshop.
                 \_ good for you. i heard about this on the news.
                 \_ SBA?  What's SBA?  *Everyone* heard this in the news
                    years ago.  And btw, MS contractors are still treated
                    like shit on a day to day basis no matter what their
                    compensation as forced/required by a court.
                        \_ Small Business Administration. The point is that
                           no matter if they call you a contractor, if they
                           treat you like an employee (set your hours, etc)
                           then you *are* an employee as defined by law, not
                           a contractor as defined by the company. So you do
                           have legal recourse, if needed. You can be treated
                           like shit anywhere whether your are a "real"
                           employee or not, especially nowadays.
                           \_ You missed *my* point.  At MS if your status is
                              'contractor' you get treated even worse than
                              *real* full time staff.  I understood *your*
                              point the first time.  A court can't rule that
                              people have to be as nice to you day to day as
                              they are to real FTE.  Only that they have to
                              compensate you the same way.  I work for a
                              different place where my compensation is really
                              great but I'm looking for a new job which is
                              going to treat me better even though I'm 100%
                              certain it'll mean a drop in money.
                                \_ I got your point the first time, too. So
                                   why are you trying to lecture me? Just let
                                   it lie, take some prozac, go out for a walk,
                                   do some yoga, calm down. breathe in, breathe
                                   out, breathe in, breathe out...
                                   \_ You got a lecture because you obviously
                                      didn't 'get it' the first time.  Good try
                                      with the prozac line but not really, I'm
                                      just being nice about it.
                                        \_ You *really* do need prozac. lots
                                           of therapy, too. Work on those
                                           breathing exercises, ya' hear?
                                           good boy.
                                           \_ Uhm, ok, whatever, son.  Really,
                                              you made a good effort, you came
                                              across as an illiterate and a
                                              fool and it's over now.  Let it
                                              go.  You're just repeating
                                              yourself.  It isn't helping.
                        ----------------------\
                        yea, that MS contracted employees had to resort to a
                        lawsuit to get equal compensation tells everyone that
                        it's not a good idea to work there as contracted
                        employees.  Also, everyone learned about it from the
                        news and not from some SBA.

                        \_ You make me laugh. If you are the orig poster,
                           then perhaps they just don't treat you "better"
                           because you are hard to deal with. Take a good
                           look in the mirror, you really need to. This is
                           serious advice. Good luck in therapy, I sincerely
                           wish you well.
                           \_ You seem to know a lot about prozac and therapy.
                              Did you learn them from SBA too?
                                \_ You crack me up. You do seem to be hung
                                   up on this SBA thing, some kind of fixation,
                                   make sure to tell that to your therapist.
                                   \_ Nah, the only thing I am fixated on is
                                      your stupidity.
                                      \_ In the movies this would be the point
                                         where you two passionately kiss.
                                         \_ Are you a Meg Ryan fan?  You are
                                            so passe.
                                            \_ Now you've insulted Meg Ryan,
                                               this won't stand!!! It's not
                                               right, man, it's just not right!
                                               -#1Meg Ryan fan!
        \_ Can you give some details? Is your cousin a new grad or what?
           What school / Where does she live? Salaries? Which groups? Future
           goals? etc. etc. etc. All else being equal, I think I'd choose ms,
           for nothing more than future marketability. I know lots of idiots
           who work or used to work for oracle, but i dont know many ms'ers,
           and those that i met seemed to be relatively smart. ymmv.
           \_ My cousing is graduating from CS at Berkeley this
              May.  Group at MS is 3Degrees.  Group at Oracle is unknown.
              Salaries comparable.  I told him I'd go w/ MS.  --sky (OP)

           \_ All true but by this point I suspect Oracle has dropped 99% of
              the morons from the payroll.
                \_ speaking as an Oracle customer, this is definitely not
                   true.  -tom
                   \_ you work for UC, how could you tell?
                     \_ This would appear to be a valid point.
2003/4/3 [Computer/SW/Database] UID:27973 Activity:high
4/2     any known tools to make HTML form / db connection easier?
        I have heard of Namo Webeditor.  Any others? open source ?
        \_ Define "easier".  I played with phprojekt, which does php/mysql
           pretty nicely.  Seemed very straightforward.  -John
        \_ vi, a cup & string and a whistle.
2003/3/12-13 [Computer/SW/Database] UID:27673 Activity:very high
3/12    mySQL vs. postgreSQL: Thoughts? Likes? Dislikes? Horror stories?
        Success stories?  Thanks.
        \_ I have found mySQL to be surprisingly good. I built a network
           and system management product using mySQL for the db backend.
           This system has been deployed in several dozen sites worldwide
           with between 100-500 nodes managed per site. Most of the sites

           have been running for about 1 1/2 to 2 yrs and during this time
           with between 100-500 nodes managed per site. The amount of data
           I originally wanted to use postgres or sysbase (the cheap one,
           store per node varies, on ave its about 25-30 MB. Most of the

           sites have been up for about 1 1/2 to 2 yrs and during this time
           mySQL has been quite reliable (no data loss to date).
           Originally I wanted to use postgres or sysbase (the cheap one,
           SQLAnywhere iirc) but one of the people in my group told me
           about mySQL so we tried it out for a bit and really liked it
           because it was easy to install and maintain.

        \_ PostgreSQL used to have edge over MySQL because MySQL by design

           sacraficed features for performance.  Some of the features
           MySQL at the time didn't have includes: Transaction, Nested
           Queries, and things like foreign key constraint support.
           Later version of MySQL uses either innoDB or BerkeleyDB, which
           effectively allow transaction (table locking, oppose to row-locking
           but personally i can live with table locking for now) and
           enforcing foreign key constraint.
           I think in 5.2, MySQL started to support nest queries.  it used
           to be clear on when to use PostgreSQL (i.e. you need transaction)
           now, the answer is less clear.  You can ask other guys about the
           performance aspect.  Personaly, I perfer MySQL because 1. I don't
           do anything real.  2. better on-line documentation, 3. more
           on-line communities support, and 4. easy to use.
           Then again, true hacker may have different opinions.
        \_ I've never heard of a reason NOT to use PostgreSQL over MySQL
           other than "I've never heard of it and can't pronounce it".
           \_ MySQL is much easier to install and maintain.
        \_ PostgreSQL is a "real" database: ACID compliant, supports
           transactions, etc. MySQL is just a small lightweight
           DB that is fine for small jobs but can't (shouldn't) be
           trusted for any serious application
           \_ That's what I've heard.  The benchmarks I've found have
              been pretty crappy all around, but the mySQL users in
              general tend to be pretty unclear on standard DB concepts.
              Not that benchmarks are particularly useful anyway, in the
              computer industry there are lies, damn lies and then
              there are benchmarks.
              \_ You are so kewl!  Can I use that clever quote?!
           \_ Um, no.  #f.  Try again.  What you said was true six months
              ago before mysql stable natively supported the innoDB table
              format.  The innoDB table format supports (among other things)
              transactions and gives mysql ACID compliance.  mysql has a
              larger, more active support community, is backed by mysql AB,
              which is a successful and growing company, and, at this point
              appears to be developed faster than postgres.  Success story:
              http://Kuro5hin.org.  They've been using mysql + innodb support since
              innodb was WAY beta.  Success story: Slashdot.
              \_ I'm not sure I'd use kuro5hin and slashdot as examples of
                 success.
                 \_ me neither. mysql is a hobby database and the only
                    reason to use it is if you can't get oracle.
                    \_ Um, wow.  You ARE an idiot.  Oracle is good for one
                       thing only: putting money in Larry Ellison's pockets.
                       \_ Don't be stupid.
                       \_ Hi Mr. Clueless Mindlessly Anti-Establishment Lad!
                 \_ Hmmm, hammers on database, both sites have impressive
                    uptimes.  How do YOU define success?
                    \_ Slashdot is slow as shit and has a mediocre uptime.
                       Kuro5hin doesn't have that much traffic and frankly
                       in the real world where neither does slashdot.  It's
                       all heavily cached which won't work for anything
                       important.
                       \_ Please continue doing that thing where you make
                          your ass talk.  It's almost as funny as when
                          Jim Carrey does it in Ace Venture: Pet Detective.
                          Let me know when you have some *gasp* examples
                          from your 'real world'.  Go away troll.
                          \_ Thank you for adding nothing to this thread but
                             mindless personal attack.  When you can explain
                             why I'm wrong without using 3 and 4 letter
                             childish 'insults' then maybe you'll be able to
                             discuss databases with the rest of us.  Troll,
                             indeed!  Your 'reply' is laughable.
                             \_ Thank you for admitting that you are wrong.
                                What does it matter if I use 3 and 4 letter
                                insults while explaining that you are wrong.
                                This does not change the fact that you are,
                                as per your admission, wrong.  Please let
                                me know when you have real world examples.
                                Until then, I repeat, go away troll.
                                \_ Uhm, no one admitted to being wrong or you
                                   being right about anything.  You're just
                                   being silly now.  I've no idea how you came
                                   to believe that you're right or anyone
                                   else is wrong about anything.
                 \_ Google, Slashdot and Yahoo use mySQL, some w/ innoDB.
                    Also, Google and Slashdot gzip their content, which is
                    another sign of a savvy site.
                    \_ who have you been talking to? you don't want to go
                       citing us as a testimonial; mysql has given us more
                       headaches than you can imagine. --aaron
                       \_ Don't confuse the issue with facts!
2003/3/7-8 [Computer/SW/Database] UID:27617 Activity:nil
3/7     Is there a way to partition a MS SQL Server table based on a
        row's, say, primary key?  The "partitioned view" feature
        is not exactly what I want.  I want a single logical
        tables with its rows partitioned on different disks, not multiple
        tables on different disks and mapped to a single view.
2003/2/13 [Computer/SW/Database] UID:27394 Activity:nil
2/12    I Would like to allow the developer to change the mysql tables at will
        (add non-constrained columns, etc.) and propegate only those structural
        changes to the production mysql database without also updating the data
        itself, when i "release".  Can anyone tell me the easiest way? or point
        me to the appropriate reference/section in the docs?
2003/1/25 [Computer/SW/Database] UID:27194 Activity:high
1/24    Network problems?
        \_ *something* is up...
        \_ A panicked post on BugTraq suggests a worm via MS SQL server
        \_ everyone you know someday will die
2003/1/17-18 [Computer/SW/Database, Computer/SW/SpamAssassin] UID:27131 Activity:high
1/16    Is there anyway to peek / modify the auto_whitelist.db on
        spamassassin?  Dunhills Vacation is keep bombarding my email
        account that it made to my stupid auto_whitelist.  Thanks
        \_ -R.  rtfm.
        \_ Dude, read the fucking docs right there in the same directory.
           Fucking ridiculous.  The motd is willing to help with real problems
           but not this baby sitting hand holding can't-read shit.  --motd
           \_ Does the almighty motd even help with real problems?
           \_ This is actually a reasonable question. The docs say
              how to add or remove entries, but they do not shed any light
              on how to determine if an address is in the db. That's of
              questionable utility but I don't think you should dogpile
              this guy. --aaron
              \_ If you can show that you've made an honest effort to solve
                 the problem you need help with BEFORE you post to motd,
                 then yes, the almighty motd is often very helpful.  There's
                 a very simple ettiquite for getting help in technical forums
                 such as this one.  It might behoove you to learn it.
              \_ The motd is chock full of *really* great answers to questions
                 worth answering.  "I clearly made no effort so just spoon feed
                 me!" is not worth answering.
           \_ The "peek" part is not documented. The docs say how to add or
              remove entries, but they do not shed any light on how to
              determine if an address is in the db. That's of questionable
              utility though. You can set, why check? --aaron
              \_ strings is the magic command for all unreadable formats but
                 I totally agree with you on this one.
                 \_ Real Men Use od.
           \_ There are actually two whitelists.  one is auto-generated,
              another is user defined inside the user_pref file.  It is not
              clear rather whatever defined in user_pref is made into
              auto-whitelist.db or not, that is why I posted the original
              question on how to peek the database.   Having said that,
              I apologize not reading the man page more thoroughly. I went
              to the spamassassin website and read much of documents before
              I posted the question.  The information on man page was not
              very accessible on its homepage.                  -op
2003/1/9 [Computer/SW/Database] UID:27053 Activity:nil
1/9     What is the default behavior of a "join" clause in SQL?  Is it an
        inner join or some sort of outer join?
        \_ inner.
2003/1/7-8 [Computer/SW/Database] UID:27016 Activity:moderate
1/7     SQL/DB Question: Is there any way to do a query and only return a
        certain set of results? Like the results between 20-30. Kinda like
        what Google does when you choose what subset of results you want
        to see. It seems like they don't do one query and cache it,
        they do it dynamically based on the parameters. And I can't use
        something like Scrollable ResultSets because my program has to
        be stateless and the query can be done at any time. Did that make
        sense?
        \_ Yes.
        \_ Create an incremental column and use BETWEEN.
          \_ It's not the rows in the DB table I want, it's going to be
             the rows that are returned by the SQL Query. But thanks. -op
          \_ I meant create a computed incrementing column in the select
             clause.
        \_ use 'limit' and 'offset'.  Not all db support it and this is
           not a standard sql.
2002/12/19-20 [Computer/SW/Database] UID:26856 Activity:high
12/19   Does anyone have experience with oracle licensing?  My company is
        buying some oracle licenses.  We have one production server, and
        will get a 2 yr processor license on it.  We also have a backup
        database which will only be interacting with the main server.  Can
        we get the lower priced per-user license for the backup?
        \_ We threatened to go with IBM or Sybase, and they dropped the
           price from $20k to $10k per cpu (hehe).
        \_ Oracle: don't do it.  The dotcom era is over.  Use db2 or sybase
           if you want to pay money or mysql or postgres if you don't.
           \_ oh please. the fact you mention sybase says enough.
                \_ Sybase? You can still buy something from Sybase?
                \_ What's wrong with Sybase?  Curious.  -John
                        \_ many things. Limited support for partitioning, data
                           extraction (tools), fewer tuning options. Row-
                           level locking introduced only recently. Writing
                           stored procs as a way of life.
                                \_ Sure but they aren't fucking bastards like
                                   Oracle and their DB is more than enough for
                                   what most people do.  If you really need to
                                   pay Oracle on a per cpu basis, then you're
                                   either doing things wrong or you work for a
                                   bank so it's ok they're fucking you.
                                   \_ Sounds like what I was thinking--I only
                                      "ran" a few Sybase boxes for pretty
                                      ho-hum DB stuff, and aside from backups
                                      being a a PITA, things ran like a charm.
                                      -John [ reformatted - formatd ]
                                        \_ you were a sysadmin, not a developer
                                           Also try administering that baby
                                           when the database gets large.
                                \_ Sybase has its drawbacks.  But RLL has
                                   been availble since 97.  Release 11.2
                                   or something.  I wouldn't call 5 years
                                   "recently" -ex-Sybase employee.
                                        \_ are you a happy or disgruntled
                                           Slimebase employee?
                                                        -ex-Debacle employee
2002/12/5-6 [Computer/SW/Database] UID:26724 Activity:high
12/5    Q for DBAs.  How often do you examine your schema for new indexes
        needed.  Our lead programmer is giving me headaches with his "Well
        it works on MSSQL," while our Postgres and Oracle development continues
        to falter.  I came up with a possible new index last night to solve
        a customer's issue, and he got all up in arms with "DON'T QUESTION MY
        SCHEMA!"  Am I insane thinking that DB tuning should be ongoing?
        Or is he just trying to defend his ignorance? --scotsman
        \_ He is defending his ignorance.  It's not like you should be doing
           quarterly schema reviews though.  Tune as needed, i.e. if you
           notice a serious performance issue, if your dataset changes
           significantly, or if the kinds of queries you make change
           significantly.
           \_ Mostly agree. Quarterly reviews of the database can be useful.
           \_ even if you dont do a review every 3-4 months, every 3-4 months,
              you should ask "should we do a review?"
        \_ Developers should only be responsible for the logical schema
           design anyway.  Physical designs such as indexes should be the
           DBA's responsiblity.  Mostly because most developers don't know
           better how a particular index would affect performance.  Tell
           your ignorant lead programmer that it works on MSSQL because
           its optimizier works completely differently (duh, as if it
           needs to be said).
2002/11/7-8 [Computer/SW/Database] UID:26460 Activity:kinda low
11/7    I have an SQL table where an auto-incrementing value got cleared
        (i dont know how). What's an easy way to go through each row and assign
        it an incrementing value?
        \_ Which database?  In Oracle, use PL/SQL and a for loop.
2002/11/5-6 [Computer/SW/Database, Computer/SW/Security] UID:26423 Activity:nil
11/05   What form of encryption is used for system passwords?  Is it
        possible to use that same form in mysql?  I would like to be able to
        take a users encrypted password from sql (which needs to be usable
        through mysql) and give them a system account once they have jumped
        through additional hurdles.  Is this possible? how? URLs appreciated.
        \_ ???  What's the project goal?
        \_ man crypt
2002/10/16-17 [Computer/SW/Database] UID:26209 Activity:very high
10/16   Enter this address into Yahoo maps and zoom in all the way:
        1500 Clay St., Davenport, IA
        \_ this is terrifically funny. map{blast,quest} confirm it (or ALL buy
           the same db which is doubtful) --aaron
           \_ I don't think I would put my name behind "terrifically funny."
              BTW, In http://maps.expedia.com, the streets in question look like
              they're there but are unlabeled and you can't search them.
        \_ For convenience: link:csua.org/u/408
        \_ What does "Fagdaddy" mean?  I only know it's some dirty word.
        \_ Must be some joke by some engineer.  There's neither Buttlickin Ave.
           nor Fagdaddy St. in the USPS database, only Clay St.
        \_ It's common for mapmakers to put in a couple easter eggs, partly
           for fun, partly to counteract copyright violations.  -tom
           \_ My cousin worked for Etak. He said there were lots of these
              deliberate errors to track who was using their maps. This would
              indicate that all these folks do, in fact, use the same original
              map database. -- ulysses
           \_ So what are some of these other common map easter eggs?
        \_ Is that where your daddy lives?
           \_ Wow, you are so funny. Hahahaha. You really crack me up.
        \_ Hey, the street name disappeared. It was there a minute ago.
           \_ Whoah. You're right! Maybe word got 'round.
              \_ op:  where did you find that link?
                 \_ friend. -op
           \_ Buttlickin' Ave is on mapquest and mapblast, but no Fagdaddy
           \_ Screenshot kept at http://csua.org/u/40e -geordan
           \_ It's still sorta on MapQuest
              http://www.mapquest.com/maps/map.adp?country=US&address=1500+Clay+St.&city=Davenport&state=IA
           \_ Both are on maporama at http://www.maporama.com/share/Map.asp?SESSIONID={3ABB491A-B7CE-4F65-A838-AFF796791E7C}&ZoomSet=1
2002/10/16 [Computer/SW/Database] UID:26205 Activity:nil
10/16   Will I be laid off? What does the MOTD Oracle say? If I will, then
        what should I do? what should I ask for?
        \_ If I get laid off, I'll have more time to get laid. That's my plan!
        \_ If you have to ask, the oracle says you're already fucked and should
           have been looking for a new job months ago.  You should ask for a
           new job at a more stable company or just surrender and join the
           university staff and sink into the depths of academia.
2002/10/2 [Computer/SW/Database, Consumer/PDA] UID:26079 Activity:kinda low
10/2    Anyone know how to convert palm dba (calendar) format to csv?
        I'm replacing my Prism w/ an iPaq.
        \_ You should be able to export from the palm desktop.
        \_ I was able to Shift-select all of my addresses and export
        individually or all. Selecting individually gives me the option of
        comma spaced or tab spaced file, but if I clicked on export all, it
        would only accept the format that Palm Desktop uses. I can't select
        the calendar individually, only ALL, which uses the Palm Desktop
        database format.
2002/9/12-13 [Computer/SW/Database] UID:25868 Activity:high
9/12    KALX recruitment meeting today, 7:30pm, 145 Dwinelle  - danh
        \_ I don't think that there are any undergrads on the motd...
           \_ We killed them and ate their souls.  -alum
           \_ Both alums and undergrads can be part of the station.
        \_ I was an undergrad last semester... I attended this meeting then...
           everyone I talked to was a complete putz. I offered to build
           a database w/ web interface for their music library and DJ
           playlists (which I've done professionally before) but there
           was already a team of incompetent DJ-cum-programmers on the job
           who had been putzing around with design docs for like 2 years.
           I gave up.
                \_ I am sorry to hear your input was not considered and sign
                        your name next time you want to insult people. -petr
                   \_ It's the motd.  He can insult putzes anonymously if he
                      wants to.
        \_ that "incompetent dj-cum-programmer" designs the interface
           between kaiser's patient database and the guys who
           pull up your data and ignore you when you call kaiser,
           he must know a thing or two. - danh
           \_ That explains a lot of my Kaiser problems....
        \_ KALX techwise is still in the stone ages...but at least there's
           finally digital editing equipment.  -warm w.o.e.
           \_ What is this "digital" of which you speak?  --KALX
                \_ The "D" in DAW. -petr
        \_ I'm a bit out of the loop, but I thought there was some newish
           equipment in the production studio...at least a step up from
           reel to reel...maybe "digital" is a stretch.   -wwoe
        \_ there's a Grand Plan to convert the carts to a digital
           format.
2002/9/3-4 [Computer/SW/Database] UID:25758 Activity:kinda low
9/3     Some DB web site told me not to put under_scores in my field/column
        names.  Is there a good reason for this?  If so, what?
        \_ Could you post the URL to that article?
        \_ Seriously, what's the url? That sounds like crap. (and
           plus, we do that all over in our DB)
            \_ sorry, i can't find the url (damn-it) but i swear i saw it
               In my search to find the travelled to link on google, i've
               come across other site's that actively recommend it "for
               readability."  (funny, 'cause that is what the first page
               basically said "we have these with underscores here for
               readability, but you shouldn't do this in real life."
2002/8/16-18 [Computer/SW/Database, Computer/Networking] UID:25591 Activity:moderate
8/16    I'm not sure i'm clear on the point of an IDS like snort.
        It sits on a box behind your firewall and listens (not very
        well, if you are on a switched network) by running a tcpdumpish
        application and looks for... what?  all non-specified traffic ?!?
        Pointers to (preferably online) overview would be appreciated too.
        \_ IDS can be anomaly-based or pattern-based.  Pattern-based has a
           built-in database of "suspicious" traffic, while anomaly-based
           tries to figure out for itself what's the "norm", and looks
           for deviations.  Neither are very reliable for proactive-type
           suspicious traffic detection.  IDS are very often used for post-
           fuckup forensic analysis, trying to figure out exactly what's gone
           wrong.  I have an excellent paper written by a colleague, if you're
           interested--if you want to know something specific about IDS you
           can also mail me question.  And sign yer fuckin posts.  -John
        \_ http://packetstormsecurity.nl/papers/IDS/lisapaper.ps
           snort looks for whatever its rules say to look for
        \_ are you trying to sound like an idiot?
           \_ I think this was supposed to a classic motd "How to snort net?"
              style question gone wrong.
        \_ Ya stick it on a switch port configured as 'monitor' so it sees all
           the traffic the switch sees.  Then it looks for network patterns
           ('signatures') and alerts you of them.
        \_ For switched networks you need to plug the snort sensor in to a
           tap or mirror/span port.  See:
           http://online.securityfocus.com/infocus/1594
2002/8/1 [Computer/SW/Database, Politics/Domestic/California/Arnold] UID:25468 Activity:kinda low
7/31    What's the DB equivalent of http://routergod.com?
        \_ http://www.rotten.com
           \_ uhhh...right. what exactly does DB stand for?
2002/7/18-19 [Computer/SW/Database] UID:25381 Activity:nil
5/17    What are MySQL privileges on Soda?  I want to create a database to do
        some stuff.  Can I create the database, or does root have to?
        \_ You should be able to create tables in the "test" database.
           \_ Is it reachable from www?  Can I create my own database?
           \_ Can I create my own database?  (Made a test CGI script to access
              it from www--so I answered that question.)
2002/7/8 [Computer/SW/Database] UID:25298 Activity:very high
7/7     I have many notes, scans, tex-files etc for my research and I want
        to organize them so that I can browse/search by subject, keyword,
        full-text, date etc.  What software should I use?  mysql/postgress?
        I wish it to have some backup, version control, and synchronization
        features, but it is just for personal use and needs not to be fancy.
        -- someone who never used mysql/postgress
        \_ mysql or postgres are probably more than you need.  You might
           take a look at CVS and CVSWEB.
        \_ dude!  linux is the answer!
                \_ relevance? -motd relevance god
        \_ Take a look at WebDAV.  I think that tomcat is bundled nowadays
           with a simple implementation...
           \_ None of the above support search or linking of related items,
              right?
              \_ Right.  And WebDAV supports metadata search, version
                 control, synchronization, linking, etc...
2002/7/2-3 [Computer/SW/Database] UID:25262 Activity:high
7/2     ufsdump manpages say that the filesystem needs to be unmounted to
        do a correct dump. Well, I can't really just unmount the filesystem
        once a week... Do people actually use dump/ufsdump?
        \_ yes.  ignore the manpage.  -tom
           \_ I should say, ignore the manpage unless you're backing up
              something like an Oracle server where the bulk of your
              interesting data is in files which are likely to change while
              the dump is going on.  -tom
              \_ Doing backup of /var/mail on a busy mail server often fails
                 because of files being constantly accessed.
        \_ It's a good suggestion. Would be nice if it were possible.
        \_ Recent Solaris 8 HW releases have a feature called ufs snapshots.
           You can create a read-only snapshot of a file system that doesn't
           change for backup purposes.  I had some problems with snapshots but
           YMMV.
           \_ I think the read-only snapshot will have the same problem as
              ufsdump--the files could change while the snapshot is being
              read/written.  -tom
              \_ Not entirely clear on the concept, but is this sort of thing
                 alleviated by jfs?  I.e. does it kind of keep track of
                 what is changing at any given point and back it up
                 correctly?  -John
              \_ but the point of the snapshot is that even if the files are
                 open and being written to, changes wont be made to the files
                 in the snapshot while the snapshot is active... worst case
                 scenario is that something is writing to the file and you
                 only get half the write, but you can come back to the same
                 snapshot an hour later and it will still look like that.
                 -shac
                 \_ Well, sure, you can back up the snapshot without ufsdump
                    failing, but if the snapshot contains files in an
                    inconsistent state (say, an Oracle database that was
                    in the process of writing a transaction), your good
                    ufsdump won't let you restore the system to a consistent
                    state.  -tom
                    \_ that's why it is probably a good idea to stop the
                       database app before taking a snapshot.
                       \_ Has anyone played with Veritas's Oracle backup?
                          I seem to recall it claims to be able to deal
                          with running databases no problem.  -John
                          \_ Yes, it works.  It uses a script to change the
                             Oracle database into backup mode and then does
                             the backup.  And yes, we have been able to
                             restore. You need DBED in order to do any of
                             the fancier stuff.  -mlee
                          \_ Y'know, for all the shit I've talked about it, DB2
                             really made backups very simple.  It's probably
                             not any harder than oracle, but it felt cleaner
                             somehow.  --scotsman
        \_ At one place I was at we did live dumps for dailies and weeklies
           but once a month took everything down and did single user mode
           fulls.  Needless to say this was a total bitch but yes some people
           do this.
2002/6/26 [Computer/SW/Database, Politics/Domestic/Immigration] UID:25196 Activity:high
6/25    Search the H-1B database, apparently there are 1,000,000+
        as of 3/12/2002
        http://www.zazona.com/LCA-Data
        \_ http://www.zazona.com
           "The promiscuous immigration programs for studies or work in
           the United States allow foreign terrorists easy passage into the
           United States. Given the tragic events of September 11, 2001, all
           nonimmigrant visas should be immediately halted in the interest
           of national security."
        \_ http://www.nsf.gov/sbe/srs/seind00/c3/tt03-22.htm
2002/6/18 [Computer/SW/Database] UID:25131 Activity:high
6/17    Interesting comments about oracle and india
        "One potential key to cutting costs could be efforts to shift
        some work to India, where the company can pay workers an average
        of 25 percent of what it pays U.S. employees.
          Over the past 18 months, Oracle has enhanced its operating margin
        by transferring an estimated 5 percent of its operating headcount
        to India, according to B of A analysts"
          What is interesting in here are a few things. How about the
        reason why corps hired indians, so that they could hve easier
        transitions to move the whole business over there later. Believe
        me HR policies at large corps is rocket science stuff. How to
        manage salaries is a big business.
          I was also interested inthe 25% cheaper figure. From what I know
        its more like 75% cheaper, I wonder how they come up with that
        number.  This is something I don't like about media today, they
        just go ahead and publish figures without backup. The reporter
        must have gotten the number from somewhere??? Then they talk
        about BofA analysts and how they have concluded that Oracle has
        transfered 5% of its operation to india. I would like actual
        figures directly from Oracle. What type of operations have they
        transfered?? That is like saying a corp is diversified if it has
        15% mexican working for it. They don't tell you that 85% of the
        mexicans are janitors.
          Anyway there are also interesting comments on sales. But they
        don't go into the details on what actually comprises Oracle
        sales. How liscensing revenue, consulting rev, maintance rev. etc
        are all difference markets and all changing and all have
        different contract types. Honestly I love the dynamics of large
        corporations in their abilities to do such things as work sharing
        with india and have a multitiudeof different contract structures
        and revenue streams, but unless you are a higher up within one of
        these large corps you never get a firm grip on it- and the media
        certaintly doesn't inform us.
          Anyway US 2-0./
        \_ 25% of what they pay US employees == 75% cheaper
        \_ Are you stupid or just stupid?
        just go ahead and publish figures without backup. The reporter
        must have gotten the number from somewhere??? Then they talk
        about BofA analysts and how they have concluded that Oracle has
        transfered 5% of its operation to india. I would like actual
        figures directly from Oracle. What type of operations have they
        transfered?? That is like saying a corp is diversified if it has
        15% mexican working for it. They don't tell you that 85% of the
        mexicans are janitors.
          Anyway there are also interesting comments on sales. But they
        don't go into the details on what actually comprises Oracle
        sales. How liscensing revenue, consulting rev, maintance rev. etc
        are all difference markets and all changing and all have
        different contract types. Honestly I love the dynamics of large
        corporations in their abilities to do such things as work sharing
        with india and have a multitiudeof different contract structures
        and revenue streams, but unless you are a higher up within one of
        these large corps you never get a firm grip on it- and the media
        certaintly doesn't inform us.
        \_ i saw it before it got deleted! yay!
          Anyway US 2-0./
2002/6/8-9 [Computer/SW/Database, Computer/SW/WWW/Browsers] UID:25042 Activity:low
6/8     Where's the best, free, most complete MSDS web site?
        \_ if you're really concerned about the health risks of a
           material, don't just read the msds.  that's just a
           place to start.
        \_ I don't know about best, but we used this one in chem 3B:
           http://hazard.com/msds
           It's linked from the chem 3B website:
           http://www.cchem.berkeley.edu/chem3b/useful_links.htm
                \_ Thanks, that's just what I was looking for.
2002/5/8 [Computer/SW/Database, Computer/SW/Languages/Perl] UID:24749 Activity:kinda low
5/7     Contract position working with a Perl/MySQL installation at Sonoma
        State available.  Mail tom if interested.
        \_ Will they blame me when MySQL peuks all over their data?
2002/5/3-5 [Computer/SW/Database] UID:24695 Activity:nil
5/3     What's up with s/key?
        soda:~ [104] keyinit
        error in opening database: Permission denied
        \_ skey bad, telnet good
2002/4/23-24 [Computer/SW/Database, Computer/Theory] UID:24554 Activity:high
4/34    Most databases use B-tree structure to store the data.  Is there a
        mathematical proof that this is the most efficient way to store
        a dbase?  Best in update times, delete times, record sizes, etc?
        I'm wondering if there are better structures for specific structures.
        Like a database full of numbers is different from a database of
        words.  thanks.
        \_ Proving lower bounds on storage space of an arbitrary object is
           undecidable (it reduces to finding the Kolmogorov complexity of
           the said object). -- ilyas
           \_ You meant "reduces from," of course... (the other direction does
              not imply uncomputability; and there are other issues with
              storage of arbitary data structures [e.g. efficiency of
              later access]). -alexf
              \_ Sorry, I wasn't using 'reduces' in the technical sense, I just
                 meant the two problems are equivalent, but yes.  If I had a
                 terminating algorithm for proving lower bounds on storage
                 space I could use that algorithm to find the Kolmogorov
                 complexity of an object, which isn't possible.  Interestingly
                 enough, some lower bounds on running time of data access exist
                 (O(log n)). -- ilyas
        \_ Uh, the insert/delete/search bounds are well known and well
           understood.  STFW or read a databases book to find out and draw
           your own conclusions.  They are not by any means the best, but,
           they are good for many of the more common operations that are done
           on a database, and not too bad (TM) on the less common operations.
           And the fact that you ask if the performance would be different for
           a database of numbers vs. words shows a gross misunderstanding of
           what the hell a database is.
2001/12/18 [Computer/SW/Database, Politics/Domestic] UID:23285 Activity:high
12/17   http://www.smh.com.au/breaking/2001/12/14/FFX058CU6VC.html
        This is for you "I love the UN" types.  What comes after this?  Do
        we tatoo a number on your arm at birth?  Oh wait, the arm-tatoo
        thing was already done by a different European empire....
        \_ It was never about "I love the UN" and all about "I hate the UN".
           Nowhere in the UN charter does it say we should have universal
           identification. This URL talks about one member state proposing
           something equivalent to what Sun Microsystem's CEO proposed
                Don't you mean Oracle? _/
           for America, but on a much larger scale (which, I might add,
           is supported by many Republican law makers).
           \_ No where in the UN charter does it say a zillion other things
              voted in by the General Assembly or the Security Council.  WTF
              does the UN Charter have to do with anything?  That's a lame
              red herring point.  Republican law makers and the *ORACLE*
              CEO also have nothing to do with this.  It is evil.  The very
              concept of recording and databasing people at birth is wicked
              beyond belief.  This doesn't bother you at all?
           \_ Don't you mean Oracle?
              \_ Don't let facts get in the way on the motd.  Rule #1.
        \_ What's wrong with the UN?  This seems impractical and probably
           ineffective, though .
        \_ Not to mention the mind control lasers and Bangladeshi secretly
           impregnating our women with their Black Helicopters...
           \_ You meant Bang-lades-hi?
        \_ The part that bugs me most is not the bit about stamping everyone
           at birth.  It's the attitude of "to control something you must
           measure it or register it in the case of people".  After reading
           shit like this you get all warm fuzzy about the UN?  That it would
           even get seriously proposed at the UN?  What's *not* to hate about
           an organisation formed from people like this?
2001/10/18 [Computer/SW/Database] UID:22768 Activity:nil
10/17   What's the easiest way to read a berkeley DB?  Is there a program that
        allows you to specify a db file and make sql-like queries on it?
        \_ perl.
        \_ Specifically, the perl DBI.  There's a good O'Reilly book on it,
           but the book really isn't necessary unless you're going to be doing
           heavy duty work with it. -dans
2001/10/12-14 [Computer/SW/Database] UID:22702 Activity:low
10/11   SQL question:  How can you get all the data from two tables matched
        up, and include any rows that dont have matches.  Specifically, is
        there a way to do an OUTER JOIN that includes everything on the left
        and everything on the right, matching up when possible by some
        join condition? Thanks.  acheng
        \_ in Oracle, u can do this:
           (nvl(left, foo) = nvl(right, foo)) OR
           (left = right (+) OR left (+) = right)
           nvl takes care of cases when both sides are null.
        \_ in DB2, after you receive my pity, you can do
           select foo
           from bar {left|right|full} outer join baz
               on bar.quux = baz.garply
           where ... --scotsman
        \_ thanks for the responses!
           Im using MySQL (pity me more) with no full outer join.
           I ended up first applying to both tables a (left) outer join with
           a temporary table containing all the values possible for the join
           condition. (b/c the cross join already doesnt contain the desired
           result). If anyone has more elegant suggestions for MySQL, pls
           tell. Thx-acheng
           [ reformatted ]
2001/9/15 [Computer/SW/Database, Computer/HW/Drives, Computer/SW/OS/Windows] UID:22458 Activity:very high
9/14    I added a second IDE drive (slave) to the primary chain in my system
        and the drive is only detected on cold start (ie power up) and its
        never detected on warm start (ie reboot)?  I've tried jumpering the
        drive for cable select but that didn't work. Any ideas?
        \_ get a new hard drive
           \_ So this is a drive problem and not a controller/config
              problem? Sigh. I really didn't want to wait in the return
              line at fry's.
              \_ what OS?
        \_ Check the settings on your first drive.  Some older drives have
           different settings for Solo vs. Master.
2001/9/6 [Computer/SW/Database] UID:22333 Activity:moderate
9/5     Stupid Questions:
        Postgre SQL seems to be a better Database, but why MySQL,
        which lack of nested queries, foreign key, and other major feature,
        seems to be used more in the real world than Postgre?
        \_ Because it's comparatively easy to set up, and is "good enough".
           It's the microsoft syndrome.
           \_ Postgres isn't hard to setup.  In fact, it's very easy.
              \_ yeah, it is cake.  Was mysql first?  I suspect this is just
                 one of those critical mass things.  MySQL was first to reach
                 100 monkeys.  I used mysql first because all the hip PHP kids
                 were using it, saying how great it was and that it was the
                 fastest thing out there, when i set up my apache-php and wanted
                 a database a couple years ago. I just recently installed
                 PostgreSQL -crebbs
        \_ I first started out using MySQL, and liked it well enough.
           Eventually I moved to postgres, but I've found some things that
           irk me a bit.  Getting PGSQL to allow network connections to
           the database was one hoop.  Trying to add columns to a table,
           and giving that column a default value and placing restrictions
           on it (NOT NULL) doesn't seem to work under postgres.  Admittedly
           I haven't used it that much to try to REALLY work past these
           problems, but that's one man's 10,000 foot view.  --sowings
        \_ There are still good reasons to use MySQL.  It's optimized for
           _read_ performance, both from a speed and integrity point of view.
           If you're rarely putting data in in large quantities, and have tons
           and tons of accesses, and you know how to guarantee integrity
           yourself, MySQL might be a good choice.
           \_ philcompress!  philcompress!  philcompress is the STANDARD!
              way to efficiently store data without guaranteeing integrity!
2001/8/22-24 [Computer/SW/Database, Computer/SW/Mail] UID:22209 Activity:nil
8/21    Anyone use KMySQL or any other gui mysql client.  Recommendations?
        \_ I've used xmysql.  Ugly as sin, but occasionally useful.  --dbushong
        \_ phpMyAdmin
2001/8/14-15 [Computer/SW/Database, Computer/HW/Drives] UID:22110 Activity:high
8/14    I want to take down (legally?) http://imatcher.org, a spamming site.
        What can be done?
        \_ DDoS it
        \_ Complain to their upstream provider.
           \_ not sure whether upstream provider == ISP, but they say
              they are an ISP so they can't be taken down.
              \_ Someone sold them bandwidth, unless they laid their
                 own cable (highly unlikely). In this case it is AlterNet.
                 \_ How did you find that out?
        \_ % whois -h http://whois.arin.net 208.253.173.31
           UUNET Technologies, Inc. (NETBLK-UUNET1996B) UUNET1996B
                                                 208.192.0.0 - 208.255.255.255
           iServices Inc. (NETBLK-UU-208-253-172) UU-208-253-172
                                               208.253.172.0 - 208.253.175.255
           These fuckers are under UUNET. You might as well give up now;
           UUNet is known for being a haven for spammers.
2001/7/24-25 [Computer/SW/Database, Computer/SW/Languages/Web] UID:21929 Activity:high
7/24    I was told that Broadvision AppServer cost $1 million a pop.  That's
        crazy.  I'm considering buying MS IIS + SQL + ASP programming to do
        the small b2b ecommerce site. It's the cheapest solution I've found
        so far.  I'm still open for a solaris solution though.  Anything
        equivalent in unix land that cost less than $1000?
        \_ Apache + MySQL + PHP is equivalent to IIS+SQL+ASP, and it's
           all free.  -tom
           \_ similarly; solaris-x86 +apache+mysql+php: still free.
        \_ intershop not do what you want?
           \_ I tend not to buy from companies whose stock is trading around
              1 dollar.  Where am I going to get the support if I buy?  At
              least if I use freeware I know that I'm getting what I paid for.
              which is nothing!
                \_ I agree with you about the freeware part, but Intershop
                   is a fairly decent product, and the stock price in this
                   case is completely irrelevant.  -John
        \_ Look into OpenACS... its a toolkit built on AOLserver +
           PostgreSQL. AOLserver uses Tcl for scripting and, of course,
           its all open source. - rory
        \_ ok.  BV is a little expensive.  for your small site, they will
           probably sell it to you for about $200k.  if cheap is what you
           want, then i second apache + mysql + php. -uctt
           \_ the company is not a dotcom and they don't depend on their web
              site for revenue generation.  They need a web site for automation
              and cost reduction.  $200K is the annual salary of a good
              designer.  gimme a break!  I think I will look into mySQL and
              PHP. Thanks guys!
        \_ Jakarta Tomcat + Jakarta Struts + Apache + Postgres.
        \_ Apache + mod_ssl + mod_perl + Mason + Postgres
        \_ yah!  yermom!
2001/7/20 [Computer/SW/Database] UID:21875 Activity:nil
6/19    Why I have to use msaccess. Simple Fucking politics. If I touch
        oracle ( or anything else for that matter ) another organization
        assumes control over me. If I ask to use oracle I have to do through
        an assigned DBA who will have to charge my project. Fuck that plus
        my project has to pay all these fees and BS.
          They are also forcing 8 down our thoats when 7 serves it purposes
        just fine. So anything new must be done using 8, again politics
        of having a different ORG control IT, they are a business and
        thus need to make money and make more money selling 8 than 7,
        just like any other IT group.  Is this not fucked?
2001/7/17 [Computer/SW/Database] UID:21824 Activity:high
7/17    Does mysql have jdbc drivers? If so, for which platforms? [I'm
        presuming that each database needs its own jdbc drivers
        for each platform?]
        \_ Google: mysql jdbc (mmmysql.sourceforge.net)
2001/7/1-2 [Computer/SW/Database] UID:21696 Activity:insanely high
7/1     SERIOUS QUESTION.  What are the performance differences between
        Postgre and Oracle? Now I know there are a whole lot of other
        things to take into consideration but here is what i am think
          Fluor spend a tonne on Oracle liscenses. Some of our mission
        critical database apps are only used by 100 users and probably
        never more than 10 concurrently. These apps utilize a good deal
        of space. ie lots of tables and lots of records.
          I want to put together a proposal to evaluate using a different
        database platform and need to know if using postgre is feasible.
        And what the conversion and maintance costs would be if we do
        convert. Take notice that this is going to be a very big field in
        consulting in the coming years.
          The fucking IT group probably will not even let me get to first
        base on this- but I can at least plant the seeds with some hard
        core numbers.  Anyway it will give me a good reason to bug out of
        here when I get the cold sholder for adancing such thoughts
        \_ hey you dumbass, mission critical means mission critical.
           Postgres MIGHT be good enough, but the fact is when it comes right
           down to it Oracle has a much more proven track record, Oracle does
           the job well right now, and (most importantly) if something goes
           wrong there are people at Oracle to help and to blame.  Stop being
           such an idiot by trying to cut corners like this.
                \_ i'm cheap and use postgres.  to impress
                   the investors we got support through
                   <DEAD>www.greatbridge.com<DEAD>
                        \_ Given the number of dotcom burnouts, they're
                           foolish to be impressed.  Oracle is far too
                           large to disappear completely - greatbridge
        \_ Suggestion number one: learn how to spell "Postgres".
           Suggestion number two: drop out of your "I am an omniscient
             superbeing" mode.  Do some remedial work in spelling, grammar,
             and rhetoric.  Otherwise, don't be surprised when your super-
             brillant proposal gets (circular) filed without comment by the
             "fucking IT group".  There's a reason why paolo is the only
             person on soda who's sycophantically worshipping you and your
             pearls of wisdom.
                           could easily be the next Eazel.
           \_ He is just your typical programmer.
              \_ Back to the game grid, program!!
        \_ ingres!!!!
        \_ Postgres RoX Mah NuTz!!
        \_ If you are interested in the best performance bang for your buck
           take a look at the sleepycat database.
2001/6/30 [Computer/SW/Database, Computer/SW/Apps/Media, Computer/SW/OS/Windows] UID:21681 Activity:high
6/29    This is like the 80's thing with Gotty instead of the tephlon don
        we have the tephlon monopoly. That is just total BS and i can't
        believe no one in the press is bitching about it. Bush is liable
        to get reamed on this issue is a few years.  The government needs
        to just gut ms. It really would then be a much more economically
        dynamic corp.  I actually believe that a break up would increase
        the shareholder value to the ability to unlock some of the hidden
        value of microsoft. Microsoft Media is basically going to buy out
        like Disney and maybe charter ( pual allen owns charter ) and go
        toe to toe with AOL. Right now people really need to worry Media,
        the whole Napster thing should have been a shot in the arm but
        people are concentrating on other issues like the slow down in
        hardware. If a company like msft controlled Napster what would
        have happened- they would have won- the technology and structure
        would have been bullet proof. They could have integrated the
        whole thing seemlessly into hotmail with streaming adverstisment
        and future released and "banners" Also note that disney and aol
        both trading for higher PE's than msft. In terms of media ms has
        always been into the "family" shit which would make a good case
        for merging with disney.  Microsoft has got some real value under
        the hood and all people look at is the OS and Office.
          Then the database group. Just spin off SQL Server and business
        Apps into a sep company to go toe to toe with ORacle and others.
        The guys that use SQL Server internally at fluor just love it-
        one of the biggest reasons- nice integrations with what?
        Win2k.... go figure.  For a breakup you don't need to touch the
        office suite or OS to is like so yesterday- leave that for later-
        but I don't want ms to control the media which given there
        structure and cash they go do it easily. They are a monopoly and
        a monolopy is alwasy going to assimilate assimilate assimilate.
        It is a losing battle to screw with what has already been
        assimilated- so they should prevent them from screwing with other
        perfectly heathly markets.  Just my 2 cents
        \_ You're delusional if you believe anyone took the time to read thru
           all that, Kinney.
           \_ they obviously do because they reply thru email.
2001/6/27-28 [Computer/SW/Database] UID:21643 Activity:nil
6/27    I want to do set union and set difference on some data that I have
        in mysql.  All of the items are integers, say up to 10,000,000 in
        value.  Union is easy, just select from both tables.  Difference
        is harder: mysql doesn't do "Delete from Table_X where Table_X.key
        in (Select key from Table_Y);".
        What's another good way to do it?  I'm thinking about using perl,
        with hashes for the data, and using DB_File to store the
        intermediate results.  Any other ideas?
2001/6/26 [Computer/SW/Database] UID:21638 Activity:nil
6/26    Again my users are just "browsing" they aren't buying and
        validating anything- they are just browsing the ailes as the site
        says.
          So there is not need to worry about inserts coming from all
        directions.
          Just massive queries being pushed to the clients
          The interface I am planning is to use ASP talk to MySQL thru ODBC
          Right now it is ASP to MSAccess thru ODBC
          Not much difference - except that I have access setup with a
        whole bunch of "views" which are not possible with MySQL. This
        can be changed by using like postgresql but right now I think I
        will probably use both- Mysql for speed functions- there are only
        a few pages and searchs which are getting bogged down and I can
        route them into MySQL, then use MSAccess for the other stuff.
2001/6/26 [Computer/SW/Database] UID:21635 Activity:insanely high
6/26    OK here is the deal- my new data structure was just bombing when
        I ran it in access- performing analysis in 1,000,000 records
        linked to countless other tables is just plain slow using access.
        They guy before me just had everything sitting in one table and
        only 250,000 records- blinding fast- but he had no thought of
        having any integrity to the data and flexibility of reference
        tables- See I don't think in terms of normalizing structure I
        think just of reference. Which basically can almost be defined as
        the same thing- But I still never design in real 3rd form- thats
        another subject....  So I changed the structure of the database
        and everything was running piss ass slow in Access These guys
        won't give me Oracle so I decided to setup MySQL.  Well last
        night I finally finished porting over some data to populate the
        new MySQL tables I ran a simple query joining 2 tables and MySQL
        took 2 seconds Access took 30 seconds.
          My boss was not impressed.... he went on a tirade about how fast
        access was with all the data sitting in one table-- and that
        mySQl was going to bomb in a multiple user env.  I had to sit
        calmly right next to him when he basically threw my work out the
        window- He then goes on to say- I think the multiuser env is
        going to really start to hurt us and we should probably upsize to
        Oracle........  People like this need to get out of the
        management business.  Right now corporations are blowing billions
        on Oracle databases to do functions which can easily be handled
        by FREE solutions...  He then goes on and says - oh we can't
        install that on the server. I was like its 2 damn files which
        don't screw with any windows setting
          Just amazing. good thing I am just content to work in my hole
        with no regard what happens around me.. Not really this does piss
        me off but what can I do-
          And this database isn't even modified- all the users do is run
        queries and view records.....  I do all the modifications and
        update of the data like once a quarter
        \_ work for oracle?
        \_ How are users going to access the mysql database to run queries?
           If your users going to do it with Access, it's going to be hell
           to administer.  Mysql doesn't handle locking too well with
           Access clients.
         \_ wow.  Tell your boss he is a moron and he shouldn't be making
            these decisions.  Do what is right (PostgreSQL) and then if
            you get fired be GLAD that you now will get a tiny bit of money
            on unemployment while you dick around before getting another job
            which you obviously need to do anyway.
2001/6/23 [Computer/SW/Database] UID:21609 Activity:high
6/22    I have a select() and read() question. I'm using select() in order to
        figure out whether or not a given socket fd has anything to read within
        the timeout. If the socket doesn't have anything to read, then I close
        the connection, as I'm trying to prevent a dos connection attack.
        Now my problem is this: if select() returns a given socket fd I try to
        read from it, read() will block if there are less than the specified
        number of bytes available on the socket, which is bad because someone
        can still do a connection based dos. What's the standard way of dealing
        with this problem? Threads? Alarm timers?
        \_ the solution is to make the fd O_NONBLOCK using ioctl() after you
           open the fd. subsequent reads will not block if there isn't
           enough data. instead, they read as much as is available and
           return it. -ali
           \_ Thanks. I'll try it out.
2001/6/21-2002/2/6 [Computer/SW/Database] UID:21592 Activity:high 80%like:21634 66%like:22367
6/26    [ Kinney's drivel deleted. ]
            \_ Does MySQL really do transactions, ACID, etc now?
               anyone have a URL handy? --oj
               \_ No, MySQL is not presently ACID compliant.  That's why you
                  can corrupt MySQL databases if you throw enough traffic at
                  one.  They just moved their transaction code into the stable
                  release.  Don't know if it's usable yet though.
                  \_ Its not. Our 'database' guy is a rabid MySQL fanatic and
                     had us use it in our project (instead of PostGres which
                     I wanted to use). The transactions code is turning out to
                     be the cause of a lot of our problems. We will probably
                     switch to PostGres in the next version.
                     \_ From what I read the corruption problems were due to
                        real multiuser env where multiple insert and update
                        statements clouded the water.
                        \_ Yup, that's the problem. MySQL "forgets" to do
                           some inserts and updates. We got about 5 daemons
                           reading network and system state and trying to
                           populate the db with this info and sometimes
                           stuff doesn't show up, but the db says everything
                           is okay. It really sucks.
                        My application having only read rights should not be
                        affected; but then again who cares- my master data file
                        is still maintained on my local computer and used only
                        by me. I do an update once and month on my local copy
                        and publish the new tables out to the network.
            \_ Will MySQL ever have transactions? I thought the point
               of MySQL was that it wasn't a real database, just a fast
               data source that could understand SQL.
               \_ Anyone who runs something they really care about with
                  either Access or MySQL is asking for what they'll get. They
                  each have their uses, but so does Excel for that matter.
                  If you want a real database, then use a real database like
                  MS SQL Server, Slimebase, Informix, Oracle, or the like.
                  Postgres/Ingres is about as good as its going to get for the
                  "freeware" camp, and in fact we use it here to catalog
                  near-earth objects and (in another application) store
                  GPS data. Rock solid. --dim
        \_ No Kinney, I don't wonder.  If I'm curious, I read the
           New York Times and the Christian Science Monitor (both
           available free online).  Add in a dash of The Economist
           and a liberal paper (insert SF Guardian or Village
           Voice here) to balance it out, and a grain of salt to
           account for the ridiculous conservative bias in one and
           the loony liberal bias in the other and you come out
           pretty well informed.
         \_ wow.  Tell your boss he is a moron and he shouldn't be making
            these decisions.  Do what is right (PostgreSQL) and then if
            you get fired be GLAD that you now will get a tiny bit of money
            on unemployment while you dick around before getting another job
            which you obviously need to do anyway.
            ( If this database will really stay like it is now forever, then
              yes, mysql is great).
            (Also, ignore the person who said (point 3) that Oracle is faster
              than MySQL.  That person is either a moron, or he typod).
             Finally, to answer another deleted question, MySQL does NOT support
             sub-queries.  (very annoying and another reason to run Postgres).
             One thing Mr. point #3 is Right about is that you should never even
             consider running Access. (so much for "Finally")
             \_ No, really, Oracle is significantly faster than MySQL.
                - Mr. Point 3
                \_ MySql is faster on simple selects.  But when you run join
                   join queries of many tables, mysql slows down significantly.
            \_ Does MySQL really do transactions, ACID, etc now?
               anyone have a URL handy? --oj
               \_ No, MySQL is not presently ACID compliant.  That's why you
                  can corrupt MySQL databases if you throw enough traffic at
                  one.  They just moved their transaction code into the stable
                  release.  Don't know if it's usable yet though.
                  \_ Its not. Our 'database' guy is a rabid MySQL fanatic and
                     had us use it in our project (instead of PostGres which
                     I wanted to use). The transactions code is turning out to
                     be the cause of a lot of our problems. We will probably
                     switch to PostGres in the next version.
        \_ godamn i missed this one before it was purged.  Pray tell it
           wasn't about h07 4zn ch1x?
           \_ D00D U N33D 2 134RN 2 5P311! 175 42N ! 4ZN!
           wasn't about H07 42N CH1X [ 5P3111NG C0RR3C73D ]
        \_ I hope it becomes standard MOTD policy that Kinneydrivel(tm) is
           automatically deleted.
           \_ I hope so too.
              \_ Solidarity, man.
        \_ Oh my god, you deleted kinney!  You bastard!
        \_ what's the average lifetime of Kinney's drivel?
           \_ 3-5 minutes
        \_ Are you on drugs? Do you even know what the ASP model is? This
           is the most nonsensical discussion I've ever seen.
           \_ Please ignore kinney, he is something I like to call a
              'blazing moron.'
        \_ I think "ASP" means something different to most people than
           what it means to you.
           \_ Please ignore kinney, he is something I like to call a
              'blazing moron.'
        \_ goddamn it stop censoring kinney.  Kinney you must share
           your wisdom with the world.  Put it all on a web archive
           or something.
        \_ you guys are fast. did you write an automatic kinneydrivel filter?
           i actually enjoyed the last two drivels.
           \_ yeah, i've yet to see any at all. someone got a repository of it?
           \_ I guess I happened to view the motd at the right moment and then
              immediately deleted it. Knee-jerk reaction I guess =)
        \_ Hey, this was the first one that wasn't drivel.
          \_ wasn't the post signed by psb? and yes, it was total drivel
             and completely random question that didn't follow from
             the story.
             \_ i'm gonna keep putting drivel in motd.kinney even if it might
                be fake kinney. making fake drivel is pretty lame anyway so
                i'm gonna hope no one bothers.
             \_ Did we read the same post? The one I read was a question
                about transmission limits imposed on communications equip.
                by the FCC as it related to a new technology. It seems to
                be a non-drivel question.
        \_ I thought it was cute.  Why'd you purge it?  I was going to have
           some fun with it.
2001/6/19 [Computer/SW/Database] UID:21575 Activity:high
6/19    database question
        is there a way to have a unique ID span a database as opposed to only a
        table... (so that no 2 tables will have records tied using the same
        "autonumber")
        \_ you could have a skinny table of just ID's and have all other tables
           that you care about reference this column. I'm not sure if that
           actually solves your problem.                - rory
        \_ yes, have your keys be drawn from a sequence table. In Oracle,
                you can do this with a sequence object. Do a search on
                google.
        \_ my irrelevant orig. solution deleted... mis-read the question.
        \_ In the oracle world this is called a sequence number. You create
           them like so: "create sequence someIdSeq start with 7070"
           You create new ids this way: select someIdSeq.nextval from dual;
           \_ i'm not sure if that's the situation. The way it was
              described seemed more like a foreign key, but I don't
              understand the need for that unique id.  Actually,
              sequences aren't unique to Oracle; they're standard
              SQL (or that's what the ANSI group says).  Naturally
              fuckers like MySQL won't support it.  Anyway...
              \_ Hence the oracle qualification. But you're right about
                 the standard SQL part.
              \_ I m sure there's a way, but why would you want to do that?
                 If you use natural numbers, you can't do much with the entries.
                 If you combined all the keys to create a unique ID,
                 the key will be very very very long. Waste of space.
                 Might as well stick with unique key of the table.
                 (whatever it's called)
                 Can't remember much from Oracle class. Ugh.    -- ivy
                 whatever it's called   Can't remember much from DB class.
                 Ugh.                                           -- ivy
                 \_ primary key?
2001/6/18-7/20 [Computer/SW/Database, Recreation/Food] UID:21554 Activity:moderate
6/17    Read an article I wanted to burn today-about how the oracle programmer
        who lost his 120K job is how homeless living in his car.. DUMB FUCKING
        IDIOT-- 120K DAMN that is enough money to live on for like 10years....
        Now he's living rent free in some place called the montgomery Inn inthe
        city- which suppose to take in houseless guys.. now all it does is take
        in unemployeed programmers...... I should write an article about
        What do you call an unemployeed programmer
        A DUMB FUCKING IDIOT.......  tell him to go work for Enron/Exxon/Shell/
        Calpine/ Fluor/ Aetna/ Insurance/ or something. People think the .com
        thing is going to bring the whole world down- well it will unless those
        damn unemployeed programmers get off their LAZY ASSES......... - kinney
        \_ URL? Sounds like a fun read.
           \_ http://www.salon.com/tech/wire/2001/06/15/new_homeless/index.html
        \_ nothing new. friend's roomate bought a new BMW, still had loans and
           living paycheck to paycheck. other guys I knew at work had no savings
           and kept buying gadget after gadget.
        \_ $120K is not so much after taxes...
           \_ I saved $70K on $120K last year.
           \_ I east on less than $3/day - I boil my own beans- make my own
              sandwhichs ( using roast meat I cook )
              And steal coffee... It really dawned on me about 2 weeks ago
              when I did an analysis of food costs-- Coffee was coming in at
              around $9/week while food was hitting around $21- Thus I
              realized I could cut my bill by a third by deleting one item-
              coffee... Now of course I actually kept the $2 sunday cup in city,
              for christ sake i need to get out sometime. But everything else
              is gone
              I should write the book - how to live on $3 a day -- kinney
              \_ So where do you get all this free coffee?
              \_ You could always ho yourself out.
                 \_ um, i think the point is that one doens't need to spend
                    lots of money a day to live comfortably.  that seems to
                    be an illusion with today's mcsociety - tyler durden
              \_ the unibomber lived on less than $1/day in Montana.  so...?
              \_ good for you.  what about your other expenses?  room and
                 board?  electricity?  water?  heat?  or are you the homeless
                 guy living for free in the Montgomery Inn?
                 \_ I don't know about kinney, but I live at home with my
                    parents. I helped them pay off the house, so its part
                    mine (ie my room or so). Food is free, so is gas, power
                    water etc. The only recurring expenses I have are for
                    my car, my dsl line and my computer.
                    \_ I bet the women are impressed when you take them
                       back to "your place". --dim
                       \_ yeah, like most Sodans have women to take back to
                          their places.  right.
                          \- so do people who fall this far also loose their
                          friends, girlfriends etc? have any of them started
                          to kill themselves? this is particularly interesting
                          when it happens to these Randoid/Libertarian geeks.
                          ok tnx --psb
2001/6/14-7/20 [Computer/SW/Database, Finance/Investment] UID:21513 Activity:nil
6/13    I am now assuming all you .commers/tech gods have more money than I-
        Thus I can finally be a financial consultant.
        1. ENRON they have gotten a lot of bad press recently and the
        stock is in the tank- but fundamentally they are still sound with
        a very good management group. They are right now basically
        pulling out of low margin old school projects to instead focus
        the entire company onto trading and management of utilities.....
        This is a wise business decision and will pay of sooner or later-
        2. GE 80% of their product is sold out for the next 5 years. nuf
        said Half their profit comes from GE Capital ( low interest rate
        helps them a lot ). Ie they already have huge lease agreements
        providing airplanes.  They just refinance their loan but the
        lease contract is already existing and has a lifetime of 10
        years.. a no brainer 10% easy
        3. Level 3/ MFN This is a competitive hedge position- long level3
        short mfn- given the recent tank of MFN this would not be a good
        entry point for this position but the position is still valid and
        good for at least 15% of you portfolio
        4. Sybase Oracle is fucking up big time- sybase has very strong
        financials and a depressed valuation- you could look at SEBL but
        they are way to overvalued. You could turn this position into a
        competive hedge against SEBL 15% easy maybe more
        5. Verizon I don't like what the FCC is doing to hamped Verizon
        but it doesn't change the fundamentals- they control the end user
        - nuf said 15%
        6. ATT I love the cable assets of att. They are pursuing a nice
        road to greatly reduce debt load and shoveling off useless
        assets.  15%
        7. CAT There is a current worldwide boom in heavy construction-
        CAT is the only supplier of major heavy equip. Add to this their
        generator business and they are golden 10%
        This would form a very nice portfolio assuming you have around
        40K to invest- it is really tough to build a real portfolio with
        less you can shovel off a few lines but make sure that each
        investment is at least 5K.
        \_ Please sign your name so we can have you arrested for giving
           financial advice without a license.
           http://www.leginfo.ca.gov/cgi-bin/waisgate?WAISdocID=9451818940+0+0+0&WAISaction=retrieve
2001/6/13-7/20 [Computer/SW/Database, Computer/SW/Languages/Misc] UID:21508 Activity:moderate
6/14    XML.... I know keith fully appreciates the power of XML. But its
        power just transends everything. What I have defined ( which is
        totally wrong but just used as an example for the flippin idiots
        I work with ) is the specification of an equipment list
        ITEM
             TAG_NO
             ACCT
             DESCRIPTION
             FLOWSHEET
             Properties
                  Property
                       Value
                       Def_units
                       Act_units
        Given this we can go ahead with all sorts of initiative. Data
        exchange with Vendors through the web, internal software
        development, application integration run the gambit- of course
        these guys are just idiots and think that SAP, EY and consultants
        will do everything for us- and in the interim lets maintain our
        current army of internal application developers to support our
        Crappy legact systems ( which all they do is study to get MCSE/
        or Oracle certified ).  Just sickening- and I of course am so
        damn low on the todem pole for anyone to give a damn of my
        opinions. And of course all our software developers are just
        swamped.. ya right I know a lot of them and really all they do is
        screw around all day- especially the network guys. Maybe if one
        of those network guys setup a wireless lan/ or publicize VPN
        capabilities I would respect them. You wouldn't believe our
        remote access. Everyone think you have to dial in using modems-
        while our notebooks all have this really cool VPN software which
        works seemlessly with broadband connection- But no one ever
        mentions it sickening anyway that my midweek rant

<not positive about this one, but note the telltale "????" and tone>
        \_ uh.... learn to spell/type? Next week, you should post this to
           the 31337 uber-motd called /dev/null .
2001/6/6-7/20 [Computer/SW/Database] UID:21436 Activity:very high
6/5     Where do I dump all this PCLN profit? New Power? any rumours?
        oracle is going to get slammed by IBM (in my opinion) I have never
        heard so many peope bad mouthing the new liscense contracts-
        Thinking of doing some spreads:
        BUY Verizon - I am big time bullish on them
        Sell SBC
        thus you are immune to market volatility and can judge your analysis
        directly- ie if the market tanks-- you net even- the only way you make
        or loss is if one or the other outperforms the other. - kinney.
        - dow theory says bull for a long time
        \_ That's a good racket, trying to get a bunch of people to buy a stock
           you own, then your bullishness will become a self-fulfilling
           prophecy.  Go away kinney.
        Sell SBC
        thus you are immune to market volatility and can judge your analysis
        directly- ie if the market tanks-- you net even- the only way you make
        or loss is if one or the other outperforms the other. - kinney.
        - dow theory says bull for a long time
        \_ Damn it is fun selling large quantities of stock at a profit and
           finishing up a month long web project at exactly the same time
           haven't had this much fun since I unloaded 2,000 shares of AFCI early
           last year at $75/share. This time it was 20,000 shares of priceline
           at between 6.25 and 7-- only difference the AFCI was all mine- the
           priceline was split between my dads account ( which I manage ) and
           mine, oh well.
           but now it is done-- no more priceline- BUT CASH,, cold hard CASH
           sitting in the account - kinney.
2001/5/17 [Computer/SW/Database, Industry/Jobs] UID:21298 Activity:nil
5/16    How much should an Oracle DBA with 3 years experience be paid in
        the Bay Area?  I have a friend that's thinking about relocating
        to the Bay Area.  Some real figures would be nice.
        \_ http://salary.com
           \_ Tried that, it wasn't specific enough.
        \_ $75k
           \_ Really?  Post a URL to their resume.  My company will hire them
              *immediately* at that rate.  Of course that's just a totally
              made up figure.  In the real world, it's much higher.
                \_ There's should be plenty right now in the market willing
                   work for that figure.
                   \_ No one worth hiring.  That's a junior level salary.
                        \_ Isn't 3 year experience still considered junior
                           level?
                        \_ I wouldn't expect Oracle DBA salary to be high
                           considering there many Oracle DBA out there.
                           The training to be a Oracle DBA is highly
                           available.  Heck, we just trained our sys admin
                           to be Oracle DBA.  He is doing just fine.
2001/5/10-12 [Computer/SW/Database] UID:21234 Activity:high
5/10  Is it too much to ask:  I'm looking for an open-source accounting/
      inventory controll application.  suggestions?  If there are none
      (i've been unsuccessful searching) is that an inditement of open-
      source.  (i.e. boring but usefull sofware will not get made in an
      all open source world).
        \_ boring is in the eye of the beholder.
        \_ spelling is usefull [sic].  Your troll is pathetic.  Open-source is
                                            \_ Shouldn't that be trolll?
                                                \_ heh. A+.
           not equivalent to "developed by volunteers".  And the lack of
           a particular kind of software is no more an inditement [sic] of
           open-source than the lack of a closed-source "mutt" is an
           indictment of closed-source.  In this particular case, the MOTD
           has already given you multiple open-source solutions.  -tom
            \_ Yes, "spelling" allows one to write a word which others will
               understand to be the same word.  Oh, but you did understand.
               Close Enough: Hand Grenades, HorseShoes and Spelling.
               SQL-ledger was exactly what i was looking for (thanks below)
               I had not seen it on the MOTD before.
               \_ Yes, I understood that you're a fucking idiot.  If that's
                  the message you're trying to get across, good job.  -tom
      \_ wasn't this answered in a previous motd question?
      \_ sql-ledger
2001/4/26-27 [Computer/SW/Database, Computer/SW/Languages/Perl] UID:21112 Activity:nil
4/26    I'm looking for software that can do the following.  Anybody know
        of such a package for a small business?
        1.  Track customers' data and their order history.  Plus I need to
            enter customized data fields that can be searched.  E.g, "list
            all customers who ordered XYZ".
        2.  A way to combine information from a arbitrary number of customers.
            E.g., "list all order from all customers from such date to such
            date".
        3.  Some minimum accounting functionality.  Accounts payable, accounts
            receivable.  Simple stuff.
        I'm doing all this stuff in Excel. And it's getting hard to manage.
        I need like a small database with a customizable front-end.  But with
        a lot of small-business functions preconfigured.  Thanks.
        \_ /usr/bin/perl or /usr/local/bin/perl on some systems.
        \_ Used to do this in Access.  It is Easy(tm) but not worth the effort
           compared to either PeachTree or QuickBooks Pro.  Both do full
           accounting, rudimentary customer management, and full order mgmt.
        \_ I was also going to reccommend peachtree, just as long as you don't
           ever intend to become a big (or even medium) sized company, 'cause
           peachtree is definitely a small business only system (or was 6 yrs
           ago when i last used it.  Things might have changed.
        \_ How about UNIX based systems?  Anyone? Ones that will work with
           a postgress backend database maybe?  or should i not hold my breath?
        \_ I'm looking at PeachTree and QuickBook web sites.  They are also
           offering online version of the products.  Like QuickBase.  It keeps
           customer information in their database and you use a web browser
           to access it.  Anybody used it?  Comments?
        \_ QuickBooks easily does this for you.  It isn't the most
           sophisticated piece of software, but it works.  From what you
           describe, you do not need QuickBooks Pro.  And you could perhaps
           use QuickBooks for the Web, although it only works on Windoze and
           only works with Internet Explorer (yes, they are lame... don't even
           get me started).  And if you want QuickBooks for cheap ($50), I can
           get it to you. -phale
2001/3/20-21 [Computer/SW/Database, Computer/Networking, Industry/Jobs] UID:20861 Activity:low
3/20    Of all the dot coms and mega corporations, which one do you want
        the most with a massive layoff?
        M$:     ..
        Oracle: ...
        Intel:  .
        Cisco:  ..
                \_ time to claim our scarce land and congested highways!!!
                \_ Time to get rid of the worthless newbie Gam3rz and bs
                   java programmers and 3rd line managers and directors with
                   one direct report (personal admin).
                   In the good old days, we build the best routers and
                   switches in the market with the fastest interfaces and
                   the most protocol support. Every engineer could rebuild
                   a basic router from parts and configure at least one ip
                   routing protocol in IOS and simple VLANs in CatOS.
                   Now we have a bunch of idiots who can't tell the difference
                   between L2 and L3 and don't know the difference between
                   IOS and WinNT. They need to go, NOW! Forget the fact that
                   they should never have been hired in the first place.
                   The old cisco culture made us #1 and it is what will save
                   us.
                   - disgrunted Cisco oldtimer
2001/2/21 [Computer/SW/Database] UID:20632 Activity:high
2/20    Why soda is so slow, ever heard of SWAP?
        70258 hkhung    18   0 26176K  6608K opause  17:16  0.05%  0.05% java_X
         1969 lila       2   0 21776K  3608K select   1:15  0.00%  0.00% screen
        56494 ilyas      2   0 13104K  1548K select   0:40  0.00%  0.00% screen
        50048 kane       2   0 11680K  8640K select   1:14  0.00%  0.00% screen
        78321 jones      2   0 11304K  6076K select   3:05  0.00%  0.00% pine
          851 mysql      2   0 11184K   176K poll     0:18  0.00%  0.00% mysqld
        20469 bray       2   0 10656K  9048K select   0:29  0.00%  0.00% pine
        84781 vadim      2   0 10184K  5128K select   1:00  0.00%  0.00% screen
        70635 chaos      2   0  9924K  5980K select   1:32  0.00%  0.00% screen
        33361 jon        2   0  9744K  5976K select   3:10  0.00%  0.00% screen
        \_ So why is soda running mysqld? And why hkhung (logged in from the
           \_ why not?
           farm) running java_X on soda?
           BTW, root is running screen -r. I sure hope we have the version
           of screen that doesn't have a local root exploit...
2001/2/7-9 [Computer/SW/Database, Computer/SW/OS/Solaris] UID:20530 Activity:high
2/7     Any recommendations for tape backup software on solaris?  I'm currently
        looking at Legato's NetWorker.  Is it any good?  Can somebody tell me
        other packages so that I can compare?  Thanks!
        \_ Legato works for small and medium scale applications. NetBackup
           by Veritas is better, though, and actually works with large
           scale installations (which NetWorker does not). -ausman
        \_ I second Ausman.  Legato worked fine for me with about a dozen
           Ultra2s and some DDS-3 tape robots, and 4 E4500s with L280
           autoloaders.  If you just want fairly simple backup for a small
              it works. --dim
           network, you might even want to consider not using a commercial
           package at all, but instead doing some form of rdist and dump/tar.
           Interestingly enough, in a multi-OS environment, we actually
           had the most success with IBM ADSTAR... -John
           \_ Legato sucks. Veritas sucks less and has its own problems
              (trashed the filesystem on a NetApp due to a bug they blame
              on Sun and Sun blames on them). Just use dump. It's free and
              it works. (By the way, use rsync instead of rdist). --dim
                \_ dump works for single machine+single device situations;
                   it's pretty weak at doing network backup.  -tom
                   \_ If you say so. My experience with *all* network
                      backup products (and I've used a lot) has been bad.
                      Dump has a lot of problems. So does AMANDA (based on
                      dump). Not any more or less than other products, though,
                      and it's FREE. --dim
                          \- note: you cant do a file system restore with
                          \- note: you cant do an OS restore with
                          legato ... as in it doesnt deal with devices and
                          such. it is for data backup. --psb
                          \_ I'm happy to restore my data.
                     \_ Are you a programmer dim?
                     \_ dump can't deal with databases.  A lot of people need
                        to do stuff like backup the database while it's
                        running.  dump can't do that for you.
                        \_ And you know what, it doesn't have to. If you place
                           your database on a mirrored filesystem, you could
                           take one mirror off-line, backup the database from
                           it and then resync with the other part of the mirror
                           \_ Sheer madness.  Don't send your resume here. We
                              mirror for a reason and we don't want it broken
                              for several hours a day while backups are going
                              off and pray that it resyncs properly.  Insane.
                              If your data has value, you'll use a real backup
                              system that can talk to your db without doing
                              the sort of whacky kludgey stuff you're talking
                              about.
                              \_ So buy a product to back up your DB. Why
                                 backup your whole LAN with that same
                                 product? I have Networker licenses I
                                 don't even use. It sucks that hard. --dim
2001/2/1-2 [Computer/SW/Database, Industry/Jobs] UID:20486 Activity:low
1/31    What job search sites do people use and have found useful?
        Thanks.
        \_ I heard http://www.dice.com is pretty good for hi-tech jobs.
           \_ I put my resume on dice, and the only responses I got were from
              (annoying) recruiters.
              \_ http://hotjobs.com does not allow 3rd party agencies to have access
                 to their resume database and do not allow 3rd party
                 agency to post jobs.  therefore, I recommend posting there.
                 however, http://monster.com has the most amount of hits, and their
                 search engines (the ones that companies pay to search the
                 resume database with) are much better than hotjobs's.  also
                 good to check out are http://brassring.com, http://headhunter.net (despite
                 its name, it is actually one of the top 5 largest job
                 boards), and http://craigslist.org.  http://dice.com, which is trying to
                 diversify its resume database, is still mostly
                 contractor-heavy...and attracts a lot of 3rd party agency
                 recruiters.  --chris
        \_ I posted hotjobs and dice recently.  I got a *lot* of calls and
           emails, about 1/2 were recruiters.  Just don't call them back.
           They usually go away after being ignored the first time.  If they
           don't mention a specific job at a specific company, then they don't
           have a job for you.  Also, since recruiters are getting 20% to 30%
           of your start salary as their pay for emailing your resume in, you
           can get a better deal if you can get hired direct without going
           through an agency.  Companies *do* calculate the recruiter cost in
           when figuring out how much you cost.  Why carry a big fat monkey on
           your back when you can stride across the finish line in style on
           your own?
        \_ Found my current job (which I love) on http://monster.com.
2001/1/31-2/1 [Computer/SW/Database, Computer/SW/OS/Windows] UID:20481 Activity:high
1/31    Wow, I just found out my company's software got cracked by crackers.
        A bit disheartening, but got me thinking, is there any commercial
        software out there that has been found to be uncrackable?
        \_ Just found out?  The moment the software was published it was
           cracked.  Probably took someone about 30 seconds between sips of
           Coke and Oreo cookies.  And no, if the whole binary runs on the
           local machine it can be cracked.  You can make it really annoying
           but that only increases the challenge for the crackers and makes
           your paying customers really pissed off.  Software protection is
           only good to keep the casual pirates at bay and doesn't even do
           that very well.  Let it go, move on.  They wouldn't have paid for
           it anyway.
        \_ Any non-commercial? Or are you trying to say only non open-source
           software can be cracked?
           \_ open source software can be commercial
        \_ I have yet to see a successful crack on Mathematica.  But the
           protection scheme really sucks since the password changes based
           on your hardware config (hard disk size, ethernet card #, etc)
           I paid for the software but found its copy protection mech
           really annoying.
        \_ Only idiots release software with copy protection.
           \- what do you mean by "cracking MMa"? i got around the licensing
           stuff in 1988 or so with adb. --psb
        \_ Incidentally, there is a working crack to Office 2000 SR-1.
           \_ Why do you need to crack Office 2000?  Just install the same CD
              onto tens of machines.
              \_ Please read:  SR-1.  Come back and try again.
                 \_ I see.  What does SR-1 have that prevents someone from
                    installing on multiple machines?
                    \_ Apply the SR-1 patch and see for yourself.  The
                       less destructive approach is to look for articles
                       on Whistler's anti-piracy scheme, which was rolled
                       into the SR-1 update for Office 2000.
        \_ Only idiots release software with copy protection. People who
           are inclined to pay for software will, those who are not will
           go to http://russiancd.com or something and get fully cracked versions
           for $50.
           \_ Our software sells for $29.99.  That would be dumb. -orig poster
                   \_ Okay, what I ment is your software + all M$ software +
                      all Adobe Software + Oracle 8 + AutoCad + ProE + your
                      favorite software for $50 from http://russiancd.com
                \_ It isn't about price.  And anyway, your software and 20+
                   others are getting squeezed on the same CD for $9.99.
2001/1/31 [Computer/SW/Database, Computer/Networking] UID:20478 Activity:kinda low
1/30    Arg.  I upgraded from BIND 8.2.2 to 8.2.3 (you wouldn't think that
        would cause problems) and now i'm getting all kinds of errors
        when it tries to load the db files! Can anyone point me to an
        example of the new format.  Thanks.
        \_ New format?  My files worked fine.  I did the make all;make install
           and copied named-xfer into my chroot'd named home, killed and
           restarted named and it ran perfectly.  Maybe you could post a few
           of the errors you're getting?  Please don't post more than a few
           lines.
           \_ Thanks, but i figured it out.  8.2.2 was allowing me to
                get away with " (  " on its own line and 8.2.3 requires
                it on the line above - as does 9. (feel free to delete
                this thread now, or i'll do it tomorrow)
                \_ Why put ( on it's own line anyway?  Aesthetics?
2001/1/6-16 [Computer/SW/Database] UID:20246 Activity:moderate
1/5     Is there a way to specify an email to not be included when reader
        replies or forwards?  For example, I replied on an email I received
        And the content was empty even I chose to include original text on
        forward and reply.
             \_ Likely the e-mail text was in an attachment, and your mailer
                was configured to not include attachments in replies.
                \_ that wasn't the case.  There are people mentioning that in
                Notes or Oracle mail, you can set some kinda option to disallow
                people forward your email...I wonder that's really such a thing
                   \_ Put the e-mail on /tmp.  Include headers, please.
                   \_ Ditto.  Most likely it's a pilot error or mail client
                      misconfiguration.
        \_ You've not enough clue. Mine more clue.
          \_ so do you have any clue at all how to do that?  If so, show us
             how...
             \_ Likely the e-mail text was in an attachment, and your mailer
                was configured to not include attachments in replies.
                \_ that wasn't the case.  There are people mentioning that in
                Notes or Oracle mail, you can set some kinda option to disallow
                people forward your email...I wonder that's really such a thing
                   \_ Put the e-mail on /tmp.  Include headers, please.
        \_ Use the mail/mailx standard.
                   \_ Ditto.  Most likely it's a pilot error or mail client
                      misconfiguration.
        \_ Use the mail/mailx standard. Or include it, but mess with the
           included message a little to throw off any internal mechanism
2000/12/30 [Computer/SW/Database] UID:20192 Activity:nil 57%like:20181
12/29   Any recommendations for good reference books on Informix and
        Sybase? -alexf
        \_ I would recommend
           \_ message deleted for lack of motd formatting
           \_ repost? or was there never anything posted to start with?
2000/12/27-28 [Computer/SW/Database] UID:20181 Activity:nil 57%like:20192
12/26   Any recommendations for good reference books on Informix and Sybase?
        (presumably separately for each). Assume intermediate experience
        coming in; I don't need tutorials/intros.
2000/12/22-25 [Computer/SW/Database] UID:20162 Activity:nil
12/22   I have a database program that I would like to view the code for. Any
        suggestions on how I go about doing this?
        \_ Download the source or objdump --disassemble
        \_ alt.sex.software.reverse-engineering
        \_ MS SQL?  Are you mad?  Do you *really* want to know how it works?
           \_ Am bettink is at least one line that looks like:
              return((char *)(rand()*0xFFFFFFFF));
2000/12/19-20 [Computer/SW/Database, Computer/SW/Security] UID:20126 Activity:high
12/19   One of my major performance bottlenecks is the need to log
        every entry in a single log file.  This leads to contention for
        write access lock to the file, delaying each process. What to do?
        \_ write to per process log file, and have a background process
           coalesce log files together.
                \_ this method provides the most concurrency
         \_ or write to sockets with a separate process listening
            on each, handling the logging.
                \_ this method is easy and most similar to what you're
                   already doing
        \_ use a real db engine
           \_ for something this simple it might not be worth paying for
              one.  plus, it gives this guy job security.
2000/11/2 [Computer/SW/Database] UID:19633 Activity:moderate
11/1    anyone know how to determine what "sort order" or character set an
        existing installation of SQL 7.0 is using? on NT 4.0 sp 3 or later
        \_ find an expert in SQL 7.0 and kick him in the nuts.
        \_ That depends on whether you're using Computer 5.0 or Computer 6.0
2000/10/29-31 [Computer/SW/Database] UID:19597 Activity:low
10/29   I need a good, inexpensive ISP to host a web site; suggestions? CGI
        a must, access to an SQL DB would be even better.       -- Marco
        \_ Check out http://he.net
           \_ ask dbushong/geordan/scotsman about http://he.net
              \_ we just buy net from http://he.net, but they rock pretty well.
                 they have kickass connectivity, fu through most levels of
                 people you deal with, and their fremont colo center is very
                 cool  --dbushong
2000/10/21-23 [Computer/SW/Database, Academia/GradSchool] UID:19537 Activity:nil
10/21   An acquaintance of mine has a CS grad school question: "I am graduating
        with my undergrad CS degree in June (from De Paul U., Chicago, IL). I
        had a concentration of database/data analysis.  Now, I was looking into
        graduate programs and have not been able to find any DB graduate
        programs.  Does any one know of any schools that might offer some type
        of DB grad degree?" Please respond to my account. -elizp
        \_ My very cool summer 61B instructor got her Ph.D. at Berkeley in
           95, thesis topic:  Active Storage Management for Database Systems
           \_ Could you tell me her e-mail address? -elizp
              \_ E-mail this guy:  http://www.cs.ucla.edu/~zaniolo
                 Ask him, if he doesn't have time personally, to direct
                 you to a grad student.  Be direct, brief, intelligent.
                 If you don't have any luck ask again on the motd and
                 I'll put you in touch.
2000/10/8-9 [Computer/SW/Database, Transportation/Bicycle] UID:19436 Activity:moderate
10/7    Anyone able to host a website, fairly small, for local
        nonprofit bicycle group (BFBC)?  Take a look at current
        format at http://www.bfbc.org  -- jnat
        \_ Yah, Ride Bike!
        \_ you can't afford $30/month?
            \_ we can if you'll pay it.  easier to find someone who
               is already online who can handle a small website
        \_ http://www.dbwired.com = $5.95 per month
2000/8/11 [Computer/SW/Database] UID:18966 Activity:high
8/11    Why do people ever use trees instead of hash tables?  If I have
        a hash table which grows dynamically to stay less than half full
        then insert/query/delete are all expected constant time.  On the
        other hand, if I use a tree which is perfectly balanced then
        insert/query/delete all take log(n).  Do people use trees just
        because they are better in the worst case?  Thanks.
        \_ Trees let you search for key ranges: if you want to find all
           the elements with keys between 5 and 13, that's fast in a tree
           but slow in a hash table.
        \_ Along the same lines as the post above, you can do an incremental
           search in trees.  For example, if you have a bunch of command names
           in a tree and the user types the first three letters you can find
           all the k matching commands in k+log(n) time. -emin
        \_ But why use trees when God created SkipLists?
                              \_ Not God. Phillip "Edward" Nunez!
                \_ Ease of coding.  Sometimes it just doesn't matter and isn't
                   worth any extra effort.
        \_ Take 186 and become enlightened.
           \_ I have heard trees (or tries) are used in database and disk
              heavy applications, but except for the 2 comments above, why
              not just use hash tables?  I'd be happy if you could give me
              a simple example, or point me to a good book or URL.  I'm no
              a student so taking 186 is not an option.
              \_ Read any data structures book.  And look up "tradeoff".
2000/7/31-8/1 [Computer/SW/Database] UID:18821 Activity:moderate
7/30    For those who haven't developed on it, which do you recommend?
        MS Acess?  MS SQL Server?  Oracle?
        \_ Eh?  For those who _haven't_ developed on it?
        \_ For ease of development/configuration?  Mysql.  For advanced
           (real) database features?  Postgresql.
           (real) database features?  Postgresql.  --foo
                \_ postgresql doesn't compare to oracle.  -tom
                        \_ benchmarkP
                        \_ yermom is better than Oracle
                           \_ yermom accepts multiple concurrent users
                              and processes insertions at a phenomenal pace
                        \_ mysql is better than tom
                                \_ tom < mysql < postgres < oracle < yermom
                    \_ very true, but i think he was asking about development
                       --foo
2000/7/27-29 [Computer/SW/Database] UID:18789 Activity:nil
7/27    Anyone have a link for the free Sybase for Linux?  Thx.
2000/6/15-19 [Computer/SW/Database] UID:18475 Activity:nil
6/15    AirTouch/Verizon needs Sysadmins and DBA.  /csua/pub/jobs/AirTouch -ax
        \_ I'm dang Tired of high stress Database Administration!
           Where's that job where The working environment is low stress,
           casual dress, and currently does not include any overtime or
           weekend work?  Dang!
           \_ HP.
           \_ HP, IBM, Cisco, Oracle, Sybase, AOL/Netscape, Sun, Pacbell,
              and any other large companies where you can just blend in and
              get ignored.  You won't have casual dress at all of these places
              but low stress is easy at a big sloppy company.
           \_ EECS Instructional.
        \_ I borrowed a copy of a how-to for msql and mysql.  That good enough?
           Also, do I get a free phone with unlimited minutes?
2000/6/14 [Computer/SW/Database, Industry/Jobs] UID:18469 Activity:very high
6/12    \_ uctt, are you a contractor? what do you do?
        \_ full time employee at my own startup now. never contracted in my
           life.  but i did spent some time in big 5 consulting managing
           various e-Commerce projects and our team of consultants from big
           5 was always much better than the employees in the client company
           (that's why they were paying us $275-$350/hr to be there) -uctt
                \_ No.  They were paying that so management could have someone
                   to blame when it all falls to shit.  No one pays you more
                   because you're more skilled.  They don't have a basis to
                   judge your skill level.
                        \_ of course that's a big part of it.  we'll take
                           the blame if it all "falls to shit".  it's called
                           taking RESPONSIBILITY and i'll take the
                           responsiblity for a project in exchange for the
                           big bucks that they have to pay us.  i've
                           met morons in consulting.  i've met a lot more
                           morons that work as full time employees for the
                           client. -uctt
                           \_ You know why that is, right? The companies
                              that don't need your expertise don't hire
                              you. If there's a better staff in house then
                              likely they'll go with that. Granted,
                              sometimes management does stupid things
                              anyway, but I bet this helps explain your
                              experiences. --dim
                                \_ Holy cow!  I find myself agreeing 100% with
                                   dim.  Hell has just frozen over.
                                   \_ I think it's a great idea to hire
                                      consultants when the current staff
                                      is better.  What's the matter with
                                      you?!?
                                        \_ Sorry, what was I thinking.  I'll
                                           call uctt right away to pay more to
                                           get less.
                        \_ that's why nearly all of the largest and *best*
                           companies in the world employs a large number of
                           consultants.  why doesn't sun, cisco, microsoft,
                           oracle, hp, ibm, etc... all just hire the best
                           talent and do all of their work in house?
                           certainly they have the money to hire pepole
                           right? why do they have consulting companies in
                           there if the consulting companies easily cost 2x
                           as much as their normal employees?  oh...b/c
                           you know something that bill gates, john
                           chambers, scott mcnealy, larry ellison, etc.
                           doesn't know right? -uctt
                           \_ Your definition of "best" is what?  You mean the
                              way IBM took a huge fall in the 80s?  The way
                              Sun, Oracle and others needed the DoJ to level
                              the playing field?  The way HP is falling apart?
                              Or that Cisco had to buy Arrowpoint because they
                              couldn't build their own load balancing switches?
                              You're confused.  Big != better.  The *best*
                              companies are the ones you've probably never
                              heard of.  You'll know who they are 5 years from
                              now.  These large but not best companies use
                              consultants because the *best* people wouldn't
                              work for them at any price.  I'd be ashamed to
                              have IBM or Oracle on my resume.  The *best*
                              people have all left these giant ugly slow beasts
                              for startups.  It's still happening today.  Don't
                              spend too much time convincing yourself how great
                              you are.  The day you meet the people working
                              for the *best* companies will be the worst day of
                              your life as your giant ego comes crumbling and
                              tumbling down and all of IBM's horses and all of
                              Oracles men won't be able to put it back together
                              again.  The emperor wears no clothes.  I know the
                              exact same thing your top 5 list of CEOs knows:
                              that their employees suck, they can't hire the
                              best so they have to pay vampires and leeches to
                              do it for them and just pass along the costs to
                              their customers.  It's people like you that make
                              software and hardware so expensive for no real
                              reason.  You're not a value-add.  You're a value
                              minus.
                                \_  who are you???  Preach it brother!  you rock.
                                    - anonymous#1fan
                                        \_ Thanks.  Just calling it like I see
                                           it.
                              \_ Uh ... gee!
                              \_ so what are the best companies right now
                                 that i haven't heard of but i will hear
                                 about 5 years from now?  and why is it that
                                 most of the upper level executives in large
                                 corportations have worked in consulting at
                                 some point in their careers?  just name a
                                 few of these companies and we'll continue
                                 the discussion... -uctt
                                 the discussion...but i can tell you right
                                 now that either their executive staff is
                                 made up of former consultants, many of
                                 their developers are former consultants, or
                                 they just don't have enough cash for
                                 outside consultants....YET.  all of the
                                 successful companies have used consultants
                                 very heavily and they cannot all be wrong.
                                 -uctt
2000/6/13-14 [Computer/SW/Database] UID:18460 Activity:moderate
6/14    Where is a good place to go after you've served your time at Oracle?
        \_ any place but oracle.
        \_ Inferiorix or Diebase
        \_ Siebel is a good place.
        \_ more hard time at intel
2000/4/28-29 [Computer/SW/Database] UID:18138 Activity:nil
4/28    In terms of market availability, ease of obtaining certification,
        and financial reward, which certification would you guys recommend
        for non-tech majors who are interested in high-tech? MCSE?
        Oracle certification, or CCNA?
        \_ The intro Cisco courses are really good.  You'll learn a lot about
           networking protocols, more than the actual router configuration.
           I wouldn't worry too much about certification, since you'll be
           useless without actual clue.  I don't know about Oracle, but
           the general consensus seems to be that DBA'ing is only marginally
           more exciting than watching paint dry, if lucrative, and MCSE, what
           can I say.  If you can't learn the shit by playing with it, then
           you need to go back to non-tech.  -John
        \_ Let's see... you finally realized that majoring in "wood" isn't
          going to make you any money... so you want to make what CS majors,
          make, without doing the work.
          I'd have to say the MCSE is most appropriate for you.
        \_ There is no easy answer to this. There are trade-offs and it all
           depends on what you want. For example, getting MCSE is probably
           the cheapest way to go (competition on books, classes, etc), but
           the pay is only mediocre. Oracle certification will be very
           financially rewarding, but it is extremely stressful and the
           classes are more expensive than MCSE classes. CCNA classes are
           also financially rewarding, but like Oracle certification, they
           are also very expensive. Any average Joe can probably do MCSE
           and Oracle (you just play with them on your PC). CCNA however is
           a totally different ball game.
        \_ You seem to have erased my very serious answer. So let me
           rephrase it in a more direct manner for you, since you dont
           understand subtlety:
           You're a loser looking for a fast buck. Therefore, join the
           rest of your ilk,in the MSCE flock
2000/4/9 [Computer/SW/Database, Computer/SW/OS/Solaris] UID:17962 Activity:nil
4/9     Note:  For those of us who are unfortunate enough to have
        to use Oracle 8.0.3~8.0.5 on Solaris, there is a SERIOUS BUG
        in the asynch write mode of Oracle.  Turn off asynch write
        in the parameter file or upgrade to 8.0.6+ a.s.a.p.  Otherwise
        you run a high risk of running into a data corruption error
        undetected by Solaris or Oracle.  We lost 4 of 9 databases
        to this error (fortunately they were not critical ones).
        Synch writes: slow but safe.  Frequent exports: help but doesn't
        solve the problem.  If you need more help or info on this
        don't contact Larry E., he'll deny everything, send me mail
        instead.  --mtbb
2000/4/5-6 [Computer/SW/Database] UID:17932 Activity:low
4/5     Are there real DBAs using Oracle Enterprise Manager? Or is that
        just a marketing scheme?
2000/4/5 [Computer/SW/Database] UID:17927 Activity:nil
4/3     A friend of mine is interviewing for a QA job at a software
        company soon.  Any ideas on what kind of questions she will
        get asked?  The company she is interviewing at does a lot of
        work with Orcale databases.  Thanks.
        \_ She might be asked "What is an Orcale database?"
           \_ It's like an Oracle database, but with a spell checker.
        \_ how about, "do you mind not doing jack shit much of the time
        but trying to look busy until a new build comes out, and then
        performing hours upon hours of monotonous tests?"
2000/4/2-3 [Computer/SW/Database, Computer/HW/Memory] UID:17911 Activity:high
4/1     EE question.  Why would the delay through a CAM (content addressed
        memory) cache, like those used in TLBs, increase with size. Since
        CAMs are built with each entry connected to a comprator and the
        selection is done through an N-way multiplexor using straight
        pass logic gates (no multiplexor select line decoding is involved)
        then theoretically a 64 entry CAM should be about as fast as a
        32 entry CAM right (at least it shouldn't be drastically slower)?
        \_ how much slower is a 64 entry CAM? if it's on the order of a few
           ns, then it's the additional stage required to select between the
           output of the decoders and routing. if it's larger, then your
           assumption that there's one decoder per entry is wrong.
           \_ But in this case there is no need to decode the select lines
              since the select lines are not in an encoded form.  They
              come from the actual comparators themeselves so there are
              N select lines for an N-entry CAM.  There is no time to
              decode the select lines.
              \_ i guess if each select line is an OE for a buffer which
                 drives the output pads, then yeah. I guess using tristate
                 buffers instead of muxes on the output is the right way of
                 doing this. so what's the answer? have you looked at a
                 datasheet?
                 \_ I actually don't know the answer. I don't think anyone
                    makes an entire IC as a CAM for them to publish a
                    datasheet for them.  But every prof I've had in
                    \_ MCM69C233, for example.  you must not have looked
                       really hard, since i found one at the first place
                       i bothered to check.
                    computer architecture related courses have always
                    said that larger TLB's and higher associativity caches
                    are slower.  I don't see why.
                    \_ bigger rams are slower.  larger area is slower than
                       smaller area.  i can get a big tag ram for a direct
                       mapped cache.  or i can split the tag ram in 2 and
                       do 2-way associativity.  each ram is smaller, but i
                       eat an extra couple of levels of logic to figure out
                       which way hits.  is one always faster than the other?
                       doubt it for small cache sizes/ways.  probably for
                       extreme cases the n-way cache is always slower.  ditto
                       for cams.  i can see for small sizes the difference in
                       loading/driving the pass gate wouldn't make much
                       difference if num loads go from 32 to 64.  can't do
                       pass gates for large loads.  for large cams the extra
                       levels of logic to decode the hit entry will make a
                       difference.
2000/3/23-25 [Computer/SW/Database] UID:17834 Activity:moderate
3/22    Are DBA jobs really as boring as the motd posters claim?
        \_not unless you find getting paid bank really boring.
          \_ They have to pay DBA's well because the job is so boring.  -tom
             \_ Plus, it's kinda like brain surgery. It's really
                fiddly stuff, and if you screw up, someone is going to
                be really, REALLY unhappy.
            \_ I would have expected a more intelligent response from you,
               tom. In answer to the original question:
                1. Do you get misty-eyed looking at ERDs?
                2. Do you love applying normalizations to ERDs?
                3. Do you know any normalizations beyond the 3rd normal
                   form?
                4. Do you know how to do a left outer join in Oracle,
                   DB/2, Informix, and Sybase?
                5. Do you know wtf a left outer join is?
                6. Do you think database nulls are the greatest thing
                   since IEEE floating point?
                7. Is Chris Date your hero?

                If the answer to the above questions is yes, then
                being a DBA would not be boring to you. A good DBA is
                indespensible on a project, especially since so few people
                properly understand relational theory and practice. I have
                a lot of respect for DBAs, but its not my cup of tea.
                \_ Sounds hideously boring to me.  -blojo
                   \_ That's nice. Presumably, this is why you are whatever
                      it is you are and not a DBA. Either way, the person
                      who asked the question should get enough information
                      to make up his/her own mind.
                        \_ I think blojo was just offering his personal
                           opinion and comment.  That's all.
                           \_ I don't want to know personal opinions coming
                              from a blowjob.
                \_ Don't say that again!  I almost jizzed my keyboard when you
                   said "left outer join" and hit my third orgasm at "database
                   nulls"!  I need to go clean up now.
2000/2/14-15 [Computer/SW/Database] UID:17511 Activity:nil
2/14    Are there differences between svrmgrl and sqlplus? Is sqlplus
        suppose to be better? Also, in /var/opt/oratab, the last argument
        specifies whether to start up the DB or not. Which script reads
        oratab and starts it up? Is that part of the OUI install process?
        \_ sqlplus an interactive sql prompt, and svrmgrl for starting
           your listner
2000/1/27-28 [Computer/SW/Database, Academia/Berkeley/CSUA] UID:17354 Activity:moderate
1/27    My favorite job hunting web site is:
        http://dice.com        0
        http://monster.com     1
        http://vfc.com         0
        careermosaic    0
        http://bayareacareers.com 1
        /csua/jobs      -14
        P.S. http://jobs.com really sucks
        careerpath      1
2000/1/19-20 [Computer/SW/Database] UID:17267 Activity:kinda low
1/18    Wanted 2 programmers to help develop web based apps:  Between the
        two, will need PERL, CGI, SQL, Yacc(or Bison), Javascript, HTML.
        Full time or Part time (20 hours minimum).  At least two weeks(tm)
        with possibilities of more if appropriate.  Work on-site (downTown
        Oakland)  or off-site. (510) 271-4142 ask for Garo, Alan or Ephram.
        -gargamel
        \_ sign posts like this
           \_ sign posts in general.
        \_ What kind of SQL?
           \_ If you have to ask, you don't know.
1999/12/2 [Computer/SW/Database] UID:16992 Activity:high
12/2    Kudos to http://Amazon.com and http://yahoo.com. They are 10X faster (in web
        page responce time) than http://cdnow.com, <DEAD>bn.com<DEAD>, http://borders.com, etc.
        Does anyone know what kind of DB backends these web sites use?
        \_ I've heard that yahoo! uses sleepycat.
        \_ Response time isn't solely limited to DB backends.  They may
           split up incoming requests to more machines or use caching
           accelerators, etc.
1999/11/20-22 [Computer/SW/Database] UID:16926 Activity:nil
11/19   Anyone know of an easy way to use perl to query an SQL server?
        (If so, then the follow up question is how.) -emarkp
        \_ Use the DBI module.
        \_ Use the DBD modules.
        \_ If this is an M$ SQL 7.0 server, you can try the FreeTDS stuff
           which is at http://freetds.org or .com or .net or something.
1999/11/9 [Computer/SW/Database] UID:16852 Activity:very high
11/8    Hello how do I use Select statement in mysql to find and display the
        most current pollID, given a table called vbooth_desc from mydb.
        Basically I want $newpoll to always be the greatest pollID #.

        I have tried defining variables with Select that don't work:
        $newpoll=mysql_query("SELECT max(pollID) FROM vbooth_desc") &
        $newpoll=mysql_query("SELECT * FROM vbooth_desc WHERE GREATEST(pollID)

        from mydb.vbooth_desc;

        +-----------+-----------+------+-----+---------+----------------+
        | Field     | Type      | Null | Key | Default | Extra          |
        +-----------+-----------+------+-----+---------+----------------+
        | pollID    | int(11)   |      | PRI | 0       | auto_increment |
        | pollTitle | char(100) |      |     |         |                |
        | timeStamp | int(11)   |      |     | 0       |                |
        +-----------+-----------+------+-----+---------+----------------+
        \_ "select pollID from vbooth_desc order by desc"  maybe... --peterl
        \_ "SELECT * FROM vbooth_desc
            WHERE pollID=(SELECT MAX(pollID) FROM vbooth_desc);"
        \_ What sort of interface are you using?  Your lang looks like perl,
           but the Perl MySQL DBI interface I've seen has you doing stuff
           more like:
           $sth = $dbh->prepare('select max(pollID) from vbooth_desc');
           $sth->execute;
           while ($hash = $sth->fetchrow_hash) { ... }
1999/10/28 [Computer/SW/Database] UID:16781 Activity:nil
10/27   Can anyone point me to an SQLnet dist. for Linux?  (I can't find
        one on the Oracle page).
1999/10/19 [Computer/SW/Database] UID:16731 Activity:nil
10/18   I'm looking for AFile.h but can only find AFile.h.in. Can anyone
        tell me what the deal is?  (background: I am trying to install
        php  --with-mysql on a machine that doesn't actually have mysql
        on it (i want to keep the sql db on a separate machine) so
        i'm just copying over what is needed from a tarball)  -crebbs
1999/10/9-13 [Computer/SW/Database, Computer/Companies/Yahoo] UID:16682 Activity:nil
10/9    Anybody know of a scientific or research search engine?  I want to
        read about say fault-tolerant OSs.  Yahoo points me to a bunch of
        commercial sites.  I just want academic research sites or journal
        publications on it.  Thanks.
        \_ go to melvyl, and type "ins" to get into the inspec database
           it has most techincal publications, and basically kicks ass.
           the syntax is very similar to the cat database in melvyl,
           the help is easy to use, and there are some amazing features
           like you can set it up to email you when a new article comes out in
           your specialty in any publication.  dont waste your time with the
           internet at large if you have access to the berkeley library system.

        \_ Try http://www.acm.org then click on Digital Library.  You have to
           subscribe, but if you're a student it's very very cheap and
           worth it. -mogul
        \_ possibly helpful: use "host:edu <keyword>" on altavista  -tom
1999/9/24-26 [Computer/SW/Database] UID:16593 Activity:high
9/24    Got an awsome offer from Oracle. Can you guys comment on the
        working environment there? Thanks.
        \_ You are a dump sh!* j if you want to work for INDUSTRY and
           caring only about GREEDY MONEY.  ACADEMIA is the only place
           to do meaningful working.
           \_ Fool.  Please get a new attitude so I don't have to pay increased
              taxes to take care of your poor dumb ass in your old age.
        \_ Oracle is mostly APPLICATION PROGRAMMING,
           testing, and porting. You do yer shit based on your clients'
           need. There is absolutely no research related position.
           Overall, it's not an intellectually challenging place to be.
           You will never deal with "optimization of an algorithm" or
           "reorganizing datapath" or anything interesting like
           that. That being said, Oracle has extremely competitive
           salary, gives out lots of options, has kick ass health
        \_ why no comments yet about babes@oracle.com?
           \_ What, the mailing list for Larry's personal assistants?
          \_ Got a great deal for your sister, $150k
           and 401K plan, has a nice gym, and has 6 really nice
           restaurants in the company.          -X Oracle employee
           \_ That exactly what most business majors think computer
              science is about - making web pages and doing asp crap.
              Fortunately most of them get weeded out when they try
              to delcare the CS major or minor.
                \_ I declared CS for the babes.
                \_ you mean man-women trolls.
1999/8/17-18 [Computer/SW/Database] UID:16330 Activity:very high
8/17    Been looking for a job. What the heck is a "data modeler"? Why
        do they have kick ass salary?
        \_ Those are the women who pose on the covers of computer game
           magazines.  Data modeling can be demanding work, but at
           $10K a photo shoot, it's very rewarding.
        \_ I think it has something to do with 3D modeling, not sure though
        \_ "I don't know the answer, but I'll answer you anyway"
           A data modeler designs database relations and normalizes them.
           It's basically a glorified file clerk.  -tom
                \_ Sounds easy. How do you explain the 100K+/yr salary?
                        \_ He can't because as usual tom has no clue wtf he's
                           talking about but he'll try anyway.
                \_ gee I didn't know we had data modelers with inferiority
                   complexes on soda.  Tell me, how many Oracle installations
                   do you run?  -tom
                        \-saying someone who does data modelling is a glorified
                file clerk is like saying someone who is an astronomer is some-
                one who counts stars. a fair amount of intelligence and
                crativity can go into modelling. if you cant tell the diff
                between modeling and recordkeeping, i suppose that makes you
                a not very glofied dumbass. file clerks dont know much about
                ponteitially sophisicated statistical techniques, error
                analysis, botstrapping data, testing models, or the science
                underlying the real world phonomena being modeled. both of the
                people i know who self descibe themselves as data jockeys have
                science phd from major research universites [they are both
                pretty hot too, but that's a different thread]. --psb
        \_ too bad they didn't find something more interesting to
           do with their lives, then.  -tom
                \-like running installing oracle over and over?
                  \_ phb is just unhappy that the new garmin he bought
                     didn't impress those data modelling chicks.
1999/8/16 [Computer/SW/Database] UID:16317 Activity:very high
8/15    Been looking for a job on http://monster.com, http://dice.com, and link:acareer.com.
        It seems that a majority of the high paid jobs are DBA, DB consulting,
        DB app, Java+DB related. I don't understand. Database is boring. Why
        the heck are they in such high demand?
        \_ DB related is a specialist just like a Network Engineer,
           Device Programmer or Graphics Programmer.  If you're looking for
           C/C++ jobs, they're not paid as well since there's a high supply
           of those right out of college.  Therefore those programmers are
           easier to find (or replace).
        \_ DB related is a specialist just like a Network Engineer,
           Device Programmer or Graphics Programmer.  If you're looking for
           C/C++ jobs, they're not paid as well since there's a high supply
           of those right out of college.  Therefore those programmers are
           easier to find (or replace).
        \_ I once worked in a place where there was a DBA and a unix sysadmin.
           Something went horribly wrong with the Oracle database and the DBA
           didn't know jack shit so the sysadmin had to fix it himself. DBA
           requires that you get some shit degree at some shit career college
           like Devry or Heald College.  Usually, DBAs are incompetent morons
        \_ Uhh, because its boring, so not many people do it?  Hence,
           a high demand?
           \_ no, hence a low supply.
        \_ Because the work sucks but DB stuff is vital at many places thus
           there aren't a lot of folks doing it b/c it isn't as interesting
           as many other jobs but it must be done thus they pay the bigger
           bucks for the fewer folks out there with those skills.
           \_ DB requires more experience.  Not many people can easily jump
              into that market.  It's in low supply not because it's not
              interesting.
              \_ Spoken like a DB professional.
           \_ understated:  if your company does ANYTHING relating to ANY
              kind of data or eCommerce, you need a DB, and therefore a DBA.
              And unlike your developers, you need them FOREVER.
                \_ Every company needs a DB to keep track of financial data.
        \_ What!  DB professional higher paid!?!  Looks like I am well under
           paid by my company.  - A Debacle DBA.
        \_ It's boring trash work. An Oakland trashman gets paid $65K/year
           without any education. A DB man gets paid high salary. Both are
           trash work. DB related jobs are high-tech trash work.
1999/3/16-17 [Computer/SW/Database, Computer/SW/Languages] UID:15595 Activity:nil
3/16    http://www.bookpool.com has the best prices on O'Reilley books.
        \_ But usually out of stock.
1999/3/2-3 [Computer/SW/Database] UID:15518 Activity:insanely high
3/2     I just got an AWSOME offer from Oracle. What do you guys think
                \_ Ok girl, what's the offer like? why are you so silent?
                      \_ Apparently they didn't make sure candidates could spell
                        \_ Spelling is opshunal at Orickle.  -Orickle employee
        about going there?
        \_ In the apps division? Hope not cuz they biz sucks are Oracle...
                \_ Ok girl, what's the offer like? why are you so silent?
                      \_ Apparently they didn't make sure candidates could spell
                        \_ Spelling is opshunal at Orickle.  -Orickle employee
        about going there?
        \_ Oracle definition of "5/1 Development"-- Spend your first 5
           years debugging other people code. Complain about the quality
           of the code while debugging it up. After 5 years, you spend 1
           year writing your own code. Don't debug your new code; have
           new hires spend their first 5 years debugging your code. The
           new hires complain about the quality of your code. You leave
           Oracle. After 5 years, the new hires spend 1 year writing
           their own code. They don't debug their new code; they have
           new hires spend the first 5 years debugging their code. They
           leave Oracle. Restart.
           \_ One person complained that they didn't like using in-house
              dev tools and would rather be using industry standard tools
              (MSVC6, etc.)
              \_ hopefully that idiot has been fired from oracle, and
                 has taken a $20/hr job at mickeysoft
                \_ Should you be fired if you use MS windows, words or excel?
                   This is PROGRAMMING, you numnut. If you are using
                   a M$ product for programming, in an environment that
                   usually requires high reliability, etc. then you
                   should be fired. Even if the product itself does not
                   directly make things crash, a penchant for using M$ tools
                   is a bias that should be purged as quickly as possible.
                        \_ I worked at oracle for 3 months (internship) and
                        all the dev tools *are* standard! we used only gmake
                        and gcc, or g++ whenever available, or the cc ov that
                        specific *nix. go to hell VC for unix dev???
                   \_ you sound quite familiar with product bias
                \_ Oracle doesn't fire people.
        \_ Pride in work is kind of unimportant there, and morale isn't
           exactly high either, at least in the front- and back-office
           Apps divisions.  (yeah I was a tech writer there, but I'm
           talking about the developers) --goetz
                \_ Back office market is drying up and Siebel is kicking the
                   shit out of Oracle in th front office, what's to like...
                        - Siebel Employee
        \_ But they have a grrreat in-house email system!  -John
1999/2/20-21 [Computer/SW/Database] UID:15453 Activity:moderate
2/20    I need a list of sodans that works at Oracle.  This is an emergency.
        Thanks.
        \_alright anonymous "emergency" poster with no reason. No thanks.
        \_ OH MY GOD!  PEOPLE ARE DYING BECAUSE THIS PERSON DOES NOT HAVE A
            LIST OF CSUA PEOPLE WORKING AT ORACLE!!!  HOW MANY MORE HAVE TO DIE
            HORRIBLE DEATHS BEFORE WE HELP THEM?
1999/2/4-5 [Computer/SW/Database] UID:15360 Activity:nil
2/4     I'm looking for a good book on Oracle administration, i.e. proper
        care and feeding of the database (as opposed to PL/SQL lessons
        or whatever). Any suggestions? Thanks.
        \_ Debacle DBA Handbook by Debacle Press.
           \_ Thanks, I found this book called Oracle DBA Handbook by Oracle
                Press, not Debacle. Is Debacle a generic Oracle book?

Merriam-Webster's Collegiate® Dictionary contains 1 item
relevant for "debacle".

*

de.ba.cle n [F debacle, fr. debacler to clear, fr. MF desbacler,
fr. des- de- + bacler to block, perh. fr. (assumed) VL
bacculare, fr. L baculum staff] (1802) 1: a tumultuous
breakup of ice in a river 2: a violent disruption (as of
an army): rout 3 a: a great disaster b: a complete
failure: fiasco
1999/1/12-13 [Computer/SW/Database] UID:15215 Activity:high
1/12    Oracle (aka. Debacle) REALLY SUCKS.     -new Debacle employee
        Warning: The statements and opinions expressed here are my own and
        do not necessarily represent those of Oracle Corporation.
        \_ You should've been listening to the MOTD, with those near-monthly
           diatribes and complaints on all DB companies.
        \_ I've interned at M$ in 97, and sadly to say, the people at Debacle
           have IQ that is 1/10 of the people at M$. Now that is really
           pathetic                                     -new Debacle employee
        \_ I work for Debacle...those girls are cute.
           \_ is Debacle hiring?
1998/11/6-8 [Computer/SW/Database] UID:14922 Activity:very high
11/6    To the Intel workplace poster-- Intel may suck, but DEBACLE SUCKS
        EVEN MORE!!! Word of advice to you new grads: DO NOT, DO NOT work
        for Debacle, Slimebase, and InferiorX no matter how well they pay
        & how good a facility they have. 99% of the jobs there are for
        stupid|average intelligent|brain-dead people.
        \_ ew, databases has got to be the dullest field to get into.
        \_ That's why you get a job at Scient.  Good atmosphere, great
           people, and challenging assignments.  Check out their site at
           http://www.scient.com  They've already had great reviews in the
           Wall Street Journal and the New York Post.  For a 10 month
           old company that's amazing.
           \_ It is not a coincidence that db jobs are one of the highest
              paying jobs in the software industry. It is definitely NOT a
              glamorous job... no, it is dry and stupid. Anyone stupid
              who has a lot of patience can do quite well in a db industry.
              Although it is a stupid job, someone has to do it (like sewer
              engineering... not glamorous, but someone has to do it). So
              remember kids... sewer engineers may get 6 digit figures, but
              do you really want to do it?
        \_ How different are they from Viant (or formerly known as Silicon
           Valley Internet Partner)? I knew they were found by the same
           \_ Difference in focus.  Scient is dedicated to eBusiness and
              does anything and all things related to eBusiness.  Also,
              Scient is interested in Long term relationships, not just
              one time deals.  Plus, Scient is looking at $15M in business
              in year 1 alone.  This has never been done before, and we
              are 2-3 years ahead of ANYONE.  email brianl for more info.
              -- brianl
           people. I have to warn people who are thinking about stock
           options offered by those small consulting companies: not only
           they offer very few shares, also the shares might get dilluted
           when they issue more shares. Only the founders and a few people
           on the top + VC people get the money. Plus, challenging
           assignemnt usually means not living at home, travelling 365 days
           a week. Consulting is not as glamous as the info. session and
           the sales pitch by the consultants.
           \_ Difference in focus.  Scient is dedicated to eBusiness and
              does anything and all things related to eBusiness.  Also,
              Scient is interested in Long term relationships, not just
              one time deals.  Plus, Scient is looking at $15M in business
              in year 1 alone.  This has never been done before, and we
              are 2-3 years ahead of ANYONE.  email brianl for more info.
              -- brianl
        \_ I interned @ Sybase. Lemme tell you, it is not a friendly
           atmosphere. What's the point of cubicles when you get those
           fold-out blinds covering the entrances? Everyone seems to be
           in their own little world. What's worse, group memebers are
           not always even in the same aisle or group of aisles.
           \_ Sounds bad, but why is it a problem that your group members are
              not nearby in this day and age (i.e. phones and e-mail)? --dim
              \_ Furthermore, if your team isn't right next to you, then
                 you can get up and walk around sometimes, even meeting
                 people outside of your team.  This is a problem?
                 \_ I guess my point is, where I work now, we often have
                    spontaneous, informal meetings in the aisles. That's
                    hard to do if everyone's spread out. And with the blinds,
                    people huddle themselves within. You can't meet people
                    that way. Also, I rarely saw anyone walking around
                 \_ I guess my point is, where I work now, we often have
                    spontaneous, informal meetings in the aisles. That's
                    hard to do if everyone's spread out. And with the blinds,
                    people huddle themselves within. You can't meet people
                    that way. Also, I rarely saw anyone walking around
                    Sybase, at least in Atrium.
        \_ I WORKED at Sybase. The general rule there is trust no one.
           Everyone is out to look after #1; themselves..
        \_ brainl's troll erased. Brain washed employees are banned from wall
                    Sybase, at least in Atrium.
        \_ I WORKED at Sybase. The general rule there is trust no one.
           Everyone is out to look after #1; themselves..
           \_ One more Scient plug.  I work at Scient.  This is the BEST
              environment to work in.  No cubicles.  Everything is open.
              Everyone gets the same view from our 28th floor office in
              SF.  We all work together.  We win as a team, we lose as a
              team.  There is no "i" in team.  Everyone helps everyone
              else.
                \_ Is this guy for real?
                  \_ It must be flame bait.  But then again, I know alot
                     of dysfunctional CS grads...
                     \_ Which begs the question: are you dysfunctional for
                        entering CS, or were you turned dysfunctional b/c
                        of CS?
                \_ Do YOU think for yourself or everyone thinks for you?
1998/7/29-8/3 [Computer/SW/Database, Computer/SW/Unix] UID:14411 Activity:nil
7/30    Anyone know if and HTTP-FILE-UPLOAD will be encrypted if you're
        using SSL on the server and the form POSTs to an https URL?
        \_ Watch it with tcpdump and find out.  tcpdump rules.  -- schoen
        \_ it should. HTTP file upload is basically a pretty way of
           including the contents of a file into an HTTP POST query.
           The query *is* the file transmission, so if the query is
           encrypted...
           \_ I like that, making a statement as a question.  "Hey, server,
              did you know that the contents of the file foo are
              050775 117475 152557 033201 042626 110101 003330 133077?"
              "Of course!"
1998/7/14 [Computer/SW/Database, Computer/SW/OS/Linux] UID:14329 Activity:moderate
7/13    Someone was asking about using Perl DBI::Oracle modules before
        soda crashed.  Print your login so I can email you some sample
        scripts.
        \_ Actually, I am interested in knowing whether it is possible to
           use Perl DBI::Oracle on Linux.  I am getting this impression
           (from the DBI::Oracle readme) that it requires SQL*NET and PRO*C
           to make DBI::Oracle.  I don't know if Oracle have SQL*NET or PRO*C
           for linux.
           \_ I didn't get a chance to read your message completely before
              soda crashed so I didn't know what you were asking.  I'm
              personally using DBI::Oracle on Solaris and I'm not sure why
              that wouldn't work on Linux (I don't have experience as
              DBA).
              \_ Isn't that what session locking is for?
           \_ You are SOL, unless you can find a rogue port of SQL*NET for
              Linux build by charitable Oracle employees/contractors.
              \_ There are continuing rumors of an Oracle Linux port coming
                 up.  It might happen.  In the meantime, there are excellent
                 free RDBMS systems for Linux, although they are not as
                 scalable as the commercial products.
                 \_ try PostgreSQL. It comes free with the RedHat
                    distribution.
                     \_ DONT use postgres. it sucks and is slow.  Use mysql
                      (not msql) http://www.tcx.se
                 \_ Try Solaris or HP.  I am sure you must have some unix box
                    that you can install your application server.  If you are
                    running Linux, you'll be relying too much on freeware
                    support.  It's a waste of your time searching for them.
1998/7/14 [Computer/SW/Database] UID:14327 Activity:nil
7/14    Does anyone know a guy named Leo who graduated from MIT a couple
        years ago and worked for Oracle?  --pcjr
        \_ Yeah me and Leo go way back.
            \_ I was knockin' down a few Buds with Leo yesterday. Leo's
               a fine man. He cried when Brazil lost on Sunday.
               Had to wipe the tears from his eyes. Poor Leo.
               Now that Leo has recovered from his hang over, I'll tell
               him that you are looking for him. -- Lord Vader
1998/7/1 [Computer/SW/Database, Computer/SW/OS/Linux] UID:14281 Activity:nil
7/1     July 11, all day at the Robert Austin computer show at the Cow
        Palace, the CABAL presents a Linux installfest.  Bring your
        computer for latest RedHat/various or consulting, or enjoy the
        hardware vendors there and take home a new machine.  -- schoen
        \_ Is this the same day as that livestock festival?  Am I going
           to be surrounded by computer geeks?  Curse you and your
           technology!  COWS AND SHEEP SHALL STOP YOUR PUNY SHOW!

7/1

The Usenet Oracle has pondered your question deeply.
Your question was:

> You are standing in front of a white house with boarded up windows and

> doors. All around you is forest.
>
> There is a mailbox here.

And in response, thus spake the Oracle:

} > Shoot mailbox.
}
} Unfortunately, your gun is actually a transmogrifier.  The mailbox
} turns into a pony intent on oral-genital intimacy with you.
}
} > Run.
}
} Outrunning a pony is rather difficult.  You trip and fall.  The pony
} rips off your pants.
}
} > Kick pony.
}
} The pony deftly dodges your kick.  You wind up with the pony's head
} between your legs.  The pony slurps once.
}
} > Stab pony.
}
} Your knife is actually a hypodermic needle containing aphrodesiacs.
} The pony is already at maximum lust level.  The pony slurps twice.
} You moan.
}
} > Hit pony.
}
} With what?  Your bare hands?
}
} > Yes.
}
} You hit the pony, but it only moans.  The pony slurps once.  You moan
} twice.
}
} > Think about England.
}
} You think about England, but all you can think of is the horses there.

} The pony slurps twice.  You moan three times.  You are now close to
} orgasm.
}
} > Teleport.
}
} You cannot teleport.  The pony slurps once.  You orgasm with a loud
} scream.  The pony moves away.
}
} > Get up.
}
} You are now the pony's sex slave.  You cannot get up without a direct
} order.  The pony orders you to get up.
}
} > Stay still.
}
} Your penalty for disobeying the pony is one lick.  You moan once.
}
} > Get up.
}
} You follow the pony to a clothes closet.  The pony tells you to get
} dressed.  The closet contains:
}   - A silken negligee.
}   - A pair of cowboy boots.
}   - A pair of split-crotch riding pants
}   - A riding crop
}
} > quit
}
} You cannot quit.  This is real life.
}
} > quit
}
} Sorry. If you attempt to quit again, you will be punished.
}
} > ^C
}
} Your penalty for attempting to quit is four licks.  You scream and
} writhe in orgasm.
}
} > Damn you you fucking computer my pants are all sticky and I want to
} > go home NOW.
}
} The pony tells you to get dressed or suffer a further penalty.
1998/6/26-27 [Computer/SW/Database, Computer/Domains] UID:14254 Activity:moderate
6/25    how do you do this w/ a shell "foreach" or equiv?:
        for ($i=0;$i<127;$i++) {
          print "$i: ",`whois -h http://whois.arin.net ${i}.0.0.0 | head -1`;
        }
        \_ csh: --jsjacob
        % @ n=0
        % while ($n < 127)
        while? echo "${n}: `whois -h http://whois.arin.net ${n}.0.0.0 | head -1`"
        while? @ n++
        while? end
        \_ sh: -- schoen
        $ N=1; while [ $N -lt 127 ]
        > do echo "$N, `whois -h http://whois.arin.net $N.0.0.0 | head -1`"
        > N=`expr $N + 1`
        > done
          \_ However, there is a limit on the query rate in practice, which
             makes this not work quite right.
             \_ A 5 second delay is sufficient
          \_ Aren't there others besides http://whois.arin.net?  Can't you do
             host ${n}.0.0.0 | head -l
             \_ it's head -1, not head -l!
             \_ It's not finding a host in DNS, it's finding a network in whois
             \_ Use whois.nic.mil instead. Faster server.
        \- jot 128 0 --psb
1998/6/4-8 [Computer/SW/Database, Computer/SW/Security, Computer/SW/Languages/Web] UID:14175 Activity:moderate
6/4     Anyone have experience with http://best.com as web host provider? Good?
        Bad? Comparable alternatives?
        \_ Good.  No comparable alternatives.  -tom
        \_<DEAD>www.best.com/boxes/~indian<DEAD>
        \_ Best experience i've ever had with a web provider. They
                provide competent and beyond-the-call-of-duty technical
                support, FAQs, etc. -appel
                http://www.chaosium.com
                http://www.glorantha.com
           \_ I'm using it for two of my web sites (http://www.theil.com and
              http://www.docmisha.com and would definitely recommend it to
              other folks.  Haven't had such a good experience with their
              tech support though.   -genie
           \_ I plan on having several CGI scripts. They list a 1000cgi
              seconds/day. I highly doubt I'll reach that limit, but just
              so I have a reference, what type of program with how many
              uses per day would come close to hitting that quota?
                \_ run your CGI with "time foo.cgi" to see the amount of
                   CPU time it takes.  It's basically a non-issue unless
                   you're grabbing nude pictures out of a database. -tom
                   \_ Though wall-clock time on your system and wall-clock
                      time on their system may be rather different.
                      Is it an issue if you're grabbing pictures of clothed
                      people from a DB? :-)
                      \_ You're not charged for wall-clock time, you're charged
                         for CPU time.  They run boxes very similar to soda,
                         so CPU time here should be comparable.  It is unlikely
                         that you'll get enough hits to matter if you're
                         grabbing pictures of clothed people from a db.  -tom
1998/3/26-27 [Computer/SW/Database] UID:13863 Activity:high
3/26    FormZ rendering and modeling work for a graphic artist.
        mail ari for details.
        \_ networkgen is a dead business in a huge ISP/consulting sea.
        \_ the work is for a friend of mine.  And Network Genesis is not an
           ISP, but thank you so much for the insight. --Ari
           \_ you can call it anything you want, it is still an ISP
           \_ This is fun.  I learn more every day.  So developing
              ( and selling )next- generation database technology constitutes
              an ISP?  I just guess Oracle is one BIG ASS ISP, huh?  --Ari
                \_ If your company is such a bad ass database company, you would
                   already be holding press release on your record breaking
                   TPC-C and TPC-D, on scalability, on light weight (ie.
                   Oracle Lite), on portability (Cloudscape), and such and such.
                   Seriously now, you can make a much better business sense
                   devoting time to consulting than to waste time developing
                   your pet database project that simply sucks.
                   <DEAD>www.databasegen.com<DEAD> -- ha ha, I think not!
                \_ your homepage indicates that you're a solution provider for
                   network and interconnection. That is internet service
                   provider business. You probably make a lot more money
                   because they want a solution for their business, not because
                   they want YOUR database.
        \_ "Help, I'm a woman trapped in a man's body!"
           "Help, I'm a database wannabe trapped in an ISP!"
1998/2/17-19 [Computer/SW/Database, Computer/SW/OS/Windows] UID:13686 Activity:nil
02/17   FedEx Backs Away From NCs In Favor Of Windows Machines. Big blow for
        companies like Sun/Oracle/Netscape.
        \_ http://www.techweb.com/wire/story/TWB19980217S0005
1998/2/11 [Computer/SW/Database] UID:13657 Activity:nil
2/10    Is there such database that allows you to insert arbitrary kinds and
        arbitrary number of columns? Traditionally you need to create a new
        column for new type/attribute, but is there such database that manages
        "arbitrary column insertion" for you? Thanks.
        \_ MSExcel.  heh
        \_ just out of curiousity, are you sure your db design is sound?  Why
           would you need to do that?  This isn't meant as a flame, Im just
            wondering...
                \_ I have a weird data structure that I need to store, and
                   each object can arbitrarly grow/shrink different attr.
1998/1/23-24 [Computer/SW/Database] UID:13549 Activity:very high
1/22    Earthlink is offering 60-70K for web designers in Pasadena (Southern
        California).  I read in Time Magazine last year that Stanfurd grads
        in the "Web Design Industry" were being offered and making 75-100K
        straight outta college.  Should I look for greener pastures, or count
        my blessings and send my resume?
        \_ 100% pure bullshit.  At Cnet, designers get paid much less than
           Software Engineers.  I have an MSCS ftom Stanfurd, and I wasn't
           offered more than 70k.
       \_  Forget web design.  get yer MSCE degree and then you'll rewl.
        \_ So what is the average starting salary for Cal CS?
                \_ Depends on how good your blow job skill is
        \_ depends on what the working conditions are like I guess.  If they
          make ya put in 50-60 hour weeks, or be on call or whatever they
           do (I don't know) then it might really suck.  But if you don't
        \_ You should just transfer to stanford before it's too late.
           have a life now, it prolly doesnt matter so GO FOR IT!!
        \_ You should just transfer to stanfurd before it's too late.
           That way, you can also cheer for a team that actually wins games.
        \_ What "Time" meant to say was that some Stanford grads managed
           to get such offers. I'm sure some UCB grads did, too. It's not
           very realistic to assume the median salary was 75-100K
           straight out of school (which implies no experience, which is
           probably not the case). I work and live in Pasadena, and know
           people who were employed by Earthlink. They all got outstanding
           offers. Most of them aren't there anymore. Draw your own
           conclusions. I should say that none of them had jobs as web
           designers, though. Earthlink can be cool, but it's high
           pressure and high stress. Send your resume. If you don't get
           the job, then this is all moot anyhow --dim
        \_ Web designers are so over-rated.  Anyone one can be a web designer
           regardless of w or w/o CS degree.  Don't need to know cs160's or
           cs170's.
                \_ I think that CS160 would be quite useful for WebWeenies.
        \_ Maybe they meant to say web developers instead of designers.
           Web developers, straight out of college, depending on their talents,
           can get into the $75K range.  Also...if it's HR (or non-technical
           people who work off of checklists and go by college degrees),
           strange decisions can easily be made.  IT professionals straight
           out of college can make anywhere between $35K and $80K. A wide
           range, I know, but it all depends on the skills you pick up. --chris
                \_ Oh, what's the difference?  Still WebWeenies.
                   \_ imho...web development is a large category, but
                      the way I see it, it refers to web _development_ which
                      means stuff beyond adobe photoshop and graphics..and
                      more like C, Perl, and JAVA coding around databases like
                      SQL, Oracle, and Sybase with a web outcome.  Companies
                      pay top dollar for these skills.  --chris
2017/10/19 [General] UID:1000 Activity:popular
10/19   
Results 1 - 150 of 239   < 1 2 >
Berkeley CSUA MOTD:Computer:SW:Database:
.