Berkeley CSUA MOTD:Entry 36088
Berkeley CSUA MOTD
 
WIKI | FAQ | Tech FAQ
http://csua.com/feed/
2024/11/23 [General] UID:1000 Activity:popular
11/23   

2005/2/7-8 [Computer/SW/Database] UID:36088 Activity:nil
2/7     Trying to get a Windows-based ER tool for PostgreSQL that supports
        both reversed and forward engineering, any suggestions?  Sybase
        sales guys just won't call me back on PowerDesigner.  Is there
        mature modeling tool for PostgreSQL available?  I will try
        QDesigner, which I heard is just a repackaged product of PowerDesigner.
        \_ It's not terribly advanced or mature, but you can do simple
           schema to-and-from graph work with pgsql through Visio.  --dbushong
2024/11/23 [General] UID:1000 Activity:popular
11/23   

You may also be interested in these entries...
2008/2/7-8 [Computer/SW/Database] UID:49086 Activity:nil
2/7     What the hell?  Is there configuration option to make mysql behave
        reasonably?  By "reasonably" I mean, when a user tries to put in
        the wrong data type i'd like it to fail and throw an error, not just
        say "hmmm, I'll just put a '0' there instead". -crebbs
mysql> desc hi;
+-------+------------+------+-----+---------+-------+
	...
2005/9/28-30 [Computer/SW/Database] UID:39919 Activity:nil
9/28    http://sqlzoo.napier.ac.uk/cgi-bin/oliver/gisq.htm
        A gentle introduction to SQL, with how-to's for many different DBs
        \_ keywords: oracle informix sybase postgres mysql
	...
2005/4/7-8 [Computer/SW/Database] UID:37111 Activity:moderate
4/7     Does postgreSQL or mysql have anything like Oracle Advanced
        Security?
        \_ obUsePostGresInsteadOfMySQL
        \_ What is OAS?
        \_ err, OAS doesn't seem like a database product to me so much as a
           suite of network security applications.  So... doubt it.
	...
2005/3/26-30 [Computer/SW/Database, Computer/SW/Languages/Java] UID:36897 Activity:nil
3/26    FBI to scratch their Virtual Case File after squandering millions of
        dollars. So here is my question. How is it implemented? Is it using
        Java/J2EE/Sybase or C or something else?
        http://www.foxnews.com/story/0,2933,151421,00.html
        \_ They probably followed these guidelines:
           http://mindprod.com/unmain.html
	...
2005/1/5-7 [Computer/SW/OS/Linux, Computer/SW/OS/Solaris] UID:35563 Activity:very high
1/5     So who else thinks that Linux Kernel Development has gone haywire?
        WTF is up with this movement from an 8k to a 4k stack in the kernel
        that breaks tons of existing drivers that are ported over from
        Windows? And wtf is this crap doing on production distros like
        Fedora? Don't they realize that if you're going to have a large
        install base that you can't arbitrarily do crap like that anymore?
	...
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,
	...
2004/3/25-26 [Computer/SW/Languages/Perl] UID:12844 Activity:nil
3/25    Do you need to install a special DBI module for PostgreSQL or it's
        built in Perl5 already?
        \_ AFAIK, you need the correct DBD module (Pg.pm) for PostgreSQL.
           This isn't part of Perl. On RH you can install a perl-DBD-Pg-1.x
           rpm which should include everything you need. On FreeBSD make
           install in /usr/ports/databases/p5-DBD-Pg should give you
	...
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
	...
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
	...
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
	...