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/4/6-7 [Computer/SW/Database] UID:42713 Activity:kinda low | 4/6 mysql expert, I've created a db with mixed innodb and isam tables.
The isam tables have *.MYD and *.MYI (data and index). However the
innodb tables only have a small *.FRM file. Copying isam tables
works (when your db is shutdown) but it's not true with innodb.
Where is the actual data and index located for innodb and how
do you copy them? Thanks.
...
|
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/2/16-17 [Computer/SW/Languages/Web] UID:41887 Activity:nil | 2/16 In PHP, If I loop $result=mysql_query("...SQL here..."); with
a lot of results, while reusing the variable
$result without ever using mysql_free_result($result),
would that make the memory space blow up? Like:
while (1) {
$result=mysql_query("...SQL HERE...");
...
|
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/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.
...
|
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/10/29-30 [Computer/SW/Languages/Web] UID:10849 Activity:nil | 10/29 Hosting question...
So what are some recomendations for very cheap and reliable
hosting options? I want DB support (MySQL, or postgres), JSP/servlet
stuff, and other general scripting things like PErl, PHP. I'd also
like to get a couple domains, and dont have any access to servers
to do name serving. thanks.
...
|
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
...
|
2010/7/21-8/9 [Computer/SW/OS/FreeBSD] UID:53890 Activity:nil | 7/21 Can I just use ifconfig to expand my netmask on a FreeBSD box?
Are there any gotchas here? Linux forces me to restart my network
to expand my netmask.
\_ yes... and no, you don't have to restart your network on linux either
\_ Rebooting is the Ubootntoo way!
\_ Oooboot'n'tootin!
...
|
|