| WIKI | FAQ | Tech FAQ | |
 http://csua.com/feed/ | |
| ||||||
| 11/27 |
| 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/Database, Computer/SW/Languages/Misc] 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. |
| 11/27 |
| 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/Languages, Computer/SW/Editors, Computer/SW/Database] 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/Database, Computer/SW/OS/Windows] 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/Database, Computer/SW/OS/Linux] 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/Security, Computer/SW/Database] 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/SW/OS/Windows, Computer/HW/Drives] 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 [Industry/Jobs, Computer/SW/Database] 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 [Industry/Jobs, Computer/SW/Database, Computer/Networking] 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 [Transportation/Bicycle, Computer/SW/Database] 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/OS/Solaris, Computer/SW/Database] 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 |
| 11/27 |