| 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
...
|
| 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
...
|
| 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
...
|
| 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?
...
|
|
http://csua.com/feed/