12/29   Is it worthwhile to use ext4 on VMs? Is Journaling necessary on VMs?
         \_ what about DBs?  I read somewhere ext3 was better for DB voumes (mysql)
	...

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.
	...

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.
	...

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
	...

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...");
	...

7/22    When I do SELECT AVG(col) FROM table, where col is integer, it takes
        2 minutes and returns a float type. I'm suspecting part of the
        problem is that it's doing floating point add? How do I make it
        faster? Thanks.
        \_ How many rows it is querying over?
           \_ about ~2,000,000
	...

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
	...

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
	...

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.
	...

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.
	...

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.
	...

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
	...