2009/9/23-10/5 [Computer/SW/Database] UID:53392 Activity:nil | 9/23 I never took CS188, is there a good book that's an intro to formal
database theory, normalization, etc.? I've got experience with SQL
(MySQL & MSSQL), and understand tables, etc.
\_ You mean CS186?
\_ Oops, yah. 188 is AI or something?
\_ That's right.
...
|
2006/3/25-26 [Computer/SW/OS/FreeBSD] UID:42421 Activity:very high | 3/24 Wow! FreeBSD sure is stable! After seeing soda's amazing uptime
record, I sure want to go replace my Linux boxes with FreeBSD!
Please do not delete this, or burn down Linus' house because I have
blasphemed the holy FreeBSD. I'd love to see a genuine discussion with
examples from both sides comparing the stability of *modern* FreeBSD
and Linux machines running on x86 hardware. -dans
...
|
2006/3/14-16 [Computer/SW/Database] UID:42233 Activity:nil | 3/14 Hello Oracle experts. Is there a reason why .getProcedures takes
so long to execute? I've tried using different jdbc connectors
from different vendors and have the same results, so I think
it must be the DB hog backend. Why does it take so long?
try{
DatabaseMetaData dbmeta = con.getMetaData();
...
|
2005/7/22-25 [Computer/SW/Database] UID:38784 Activity:nil | 7/22 I never took a formal DB theory class, excuse me for asking SQL
questions. When I create a table, I can choose PRIMARY KEY to be
based on a single or n-tuple column. When I do that, are indices
created automatically? Second question is, if the indices are
created for n-tuple, does that mean all the column have fast
index, or they are all based on previous columns? For example, if
...
|
2005/4/8-10 [Computer/SW/Database] UID:37118 Activity:moderate | 4/8 Anyone reccomend a good mysql programming tutorial that goes
beyond the basic select statements ? I would like to be able
to do a distinct on specific column and then do a count of all
the rows that have the corresponding values. thanks --ramberg
\_ select t.col, count(*) from tble t group by t.col;
\_ thanks. --ramberg
...
|
2004/11/22-23 [Computer/SW/OS/OsX] UID:35021 Activity:low | 11/22 What's a good database program for Mac OSX? I just found out they
don't make MS Access for macs. I did a quick search and found a
Filemaker. Can anyone recommend any others? Thanks.
\_ what's your need? FileMaker is fine (better than Access) for
personal/home use. -tom
\_ MySQL? as above, what do you need it for? I also like
...
|
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
...
|
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
...
|
|