Berkeley CSUA MOTD:Entry 40985
Berkeley CSUA MOTD
 
WIKI | FAQ | Tech FAQ
http://csua.com/feed/
2025/07/08 [General] UID:1000 Activity:popular
7/8     

2005/12/13-15 [Computer/SW/Database, Politics/Foreign] UID:40985 Activity:nil
12/13   MySQL PHP admin generates the entity relationship diagram as
        PDF. How does it know what the foreign keys are, and where
        can I find that out? The export of DDL doesn't seem to show
        foreign keys of this database that I'm trying to understand
        but the ER diagram shows them.
        \_ IIRC you need to tell it about the linkages (phpmyadmin) and it
           stores them in a metainfo table.
        \_ SHOW TABLE STATUS has fk constraints in the columns.
           SHOW CREATE TABLE foo \G
           shows it in a more readable format.
           \_ Right, but that only works for InnoDB tables that actually
              support foreign keys.
              \_ I was under the mistaken impression that myisam would record
                 the constraint but not actually enforce the constraint.  But
                 why are you using MyISAM?
        \_ MySQL supports Foreign Keys?
2025/07/08 [General] UID:1000 Activity:popular
7/8     

You may also be interested in these entries...
2011/12/20-2012/2/6 [Politics/Foreign/Asia/China, Computer/Rants] UID:54268 Activity:nil
12/20   A higher percentage of people in China than in Pakintan have an
        unfavorable view of China:
        http://www.pewglobal.org/database/?indicator=24&response=Unfavorable
        Go figure.
        \_ damn these self critical liberals!
	...
2011/12/29-2012/2/6 [Computer/SW/Database] UID:54274 Activity:nil
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)
	...
2011/11/27-2012/1/10 [Computer/HW/Drives] UID:54244 Activity:nil
11/27   CalMail has been down for a few days (hardware failure and database
        corruption -- sounds like fun!) and is starting to come back online.
        Looks like they're planning to outsource all campus mail to either
        Google Apps or Microsoft 365 as part of Operational Excellence.
        <DEAD>kb.berkeley.edu/jivekb/entry!default.jspa?externalID=2915<DEAD>
        \_ http://ist.berkeley.edu/ciocalmailupdates/november-30-2011
	...
2010/11/21-2011/1/13 [Computer/SW/Languages/Web] UID:53988 Activity:moderate
11/21   Lifehacker's recommending Dreamhost as a personal web hosting service.
        Apart from csua, who do you guys use? --erikred
        \_ What do you want to use it for? Do you need CGI or PHP?  My
           brother worked for Dreamhost and said they are unethical. In
           fact, he sued them. This refers to their treatment of customers
           and employees both. I don't know who  or what "Lifehacker" is,
	...
2010/8/12-9/7 [Computer/SW/Languages/Perl] UID:53922 Activity:nil
8/12    Ruby coders, do you mostly DIY your stuff or use the ruby libs out
        there?   How is their quality compared to other libs you have used
        for other langs?  Thx.
        \_ I use Ruby for hobby stuff, etc.  I use libraries for system stuff
           (web access, process, etc.) but that's about it.  Perl libraries are
           much better/more complete.  I assume because of the maturity and
	...
2009/10/27-11/3 [Computer/HW/Drives] UID:53474 Activity:nil
10/27   I just read an article that Facebook had moved their database
        to all SSD to speed throughput, but now I can't find it. Has
        anyone else seen this? Any experience with doing this? -ausman
        \_ I hope you're not running mission critical data:
           http://ask.slashdot.org/story/09/10/27/1559248/Reliability-of-PC-Flash-SSDs?from=rss
        \_ Do you have any idea how much storage space is used by Facebook,
	...
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.
	...
2009/9/10-15 [Computer/SW/Database] UID:53357 Activity:moderate
9/9     Larry Ellison is a bigger idiot than I thought:
        http://www.techcrunch.com/2009/09/10/oracle-to-sun-customers-and-ibm-were-in-it-to-win-it
        \_ My company's customers are insurance companies. Non-tech corporates don't
           trust open source. Why risk it. They have tons at stake and are willing
           to spend for solid products, support, and consultants who don't have long
           hair. They're being raped by IBM mainframes for millions. An optimized
	...
2009/8/18-9/1 [Computer/SW/Database, Computer/SW/Languages/Perl] UID:53283 Activity:low
8/18    trying to write an intentionally slow regex.
        what is your worst regex ever?
        this is using MySQL regexp but I'll also accept
        perl format         --brain
        \_ you need to know how regex is implemented internally in order to
           have a worst regex in terms of running time. Something that uses
	...
2013/6/13-8/13 [Politics/Foreign/Asia/China, Politics/Foreign/MiddleEast] UID:54693 Activity:nil
6/13    NSA NSA NSA!!!
        http://www.businessinsider.com/nsa-prism-keywords-for-domestic-spying-2013-6
        \_ I am shocked, *SHOCKED* that the NSA spies on foreign and US
           citizens and foreign governments. This Snowden guy must have
           been born yesterday to think he is revealing anything of import.
           \_ Most people seem to have been surprised by this.
	...
2009/8/26-9/9 [Politics/Foreign, Politics/Foreign/Europe] UID:53303 Activity:nil
8/26    Micro$oft is racist!!!
        http://news.yahoo.com/s/ap/us_tec_microsoft_poland_picture
        Seriously, is it any different from replacing the black actor with a
        white actor and then re-taking a real photo to suit a foreign market?
        Would it cause the same outcry if, say, M$ Photoshop'ed ... I mean
        photo-edited ... the Asian man and the white woman with two blacks for
	...
2009/5/26-30 [Politics/Domestic/Election] UID:53044 Activity:kinda low
5/26    Is it correct to call someone the daughter of Puerto Rican
        "immigrants"? Seems wrong to me. Puerto Ricans get US Passports.
        \_ Yes it is correct.
           \_ Thanks! Obama immigrated from Hawaii, right?
              \_ Not the same.  Doubly not the same in the early 50s.  Go watch
                 yourself some West Side Story.
	...
2009/2/2-8 [Politics/Domestic/Election] UID:52497 Activity:nil
2/1     Pres. Obama keeps rendition
        http://www.latimes.com/news/la-na-rendition1-2009feb01,0,7548176,full.story
        \_ This does not mean what you (or the LA Times) think it means.
        \_ More on how this article does not mean what you (or the idiotic
           LA times) think it means:
           http://www.salon.com/opinion/greenwald/2009/02/02/renditions
	...
2009/1/28-2/6 [Politics/Domestic/911] UID:52481 Activity:low
1/28    One of the criticisms of the Patriot Act was that it was rammed
        through without any time for legislators to properly review
        it.  Isn't that the same problem with this $800B bill?
        \_ Is this $800B bill hundreds upon hundreds of pages long? It's not
           coming off the heels of a crisis in national defense; rather, it's
           attempting to fix a spiraling economy. Plus it seems that the
	...
2009/1/15-22 [Politics/Foreign, Politics/Domestic/President/Bush] UID:52388 Activity:nil
1/15    Foreign Intelligence Surveillance Court of Review finds (1) a foreign
        intelligence exception to the 4th amend.; and (2) that a warrantless
        search under FISA is not unreasonable for 4th amend. purposes:
        http://preview.tinyurl.com/8rg8qj [NYT]
        http://www.fas.org/irp/agency/doj/fisa/fiscr082208.pdf [opinion]
	...