Sheeri Dot Org

The slides for today’s presentation at Shmoocon are here:

http://technocation.org/files/doc/2008_02_SecuringDBs.pdf

Just a note so folks at the conference can download them whenever they want. Folks not at the conference can, too but the slides don’t give away the whole talk so I don’t know how useful they’re going to be…..

http://pgfoundry.org/projects/pllolcode/
Do I really need to say more?

A friend asked for this, so I thought it’d be helpful:
All tables with no primary key:

use INFORMATION_SCHEMA;
select CONCAT(t.table_name,”.”,t.table_schema) as tbl,
from TABLES AS t LEFT JOIN KEY_COLUMN_USAGE AS c
ON (t.TABLE_NAME=c.TABLE_NAME
AND c.CONSTRAINT_SCHEMA=t.TABLE_SCHEMA
AND constraint_name=’PRIMARY’)
WHERE t.table_schema!=”information_schema”
AND constraint_name IS NULL;

All tables and their primary keys, if exist:

use INFORMATION_SCHEMA;
select CONCAT(t.table_name,”.”,t.table_schema) as tbl,
c.column_name,c.constraint_name
from TABLES AS t LEFT JOIN […]

In Stuffing Six Million Pages Down Google’s Throat, Tim O’Reilly brings up a point, and some questions:
. . . just how poorly the big search engines index small sites with large collections of data . . .
But it’s worth thinking about absolute (and temporary) limits to the growth of Web 2.0. What constraints do […]

Well, Paul Vallee tagged me, and as I haven’t yet passed my probationary period I should probably answer the call…..
Eight things about me that aren’t common knowledge:

I like to start lists with 0. I stole that idea from a friend of mine, who is not a computer geek…completely.
I’m more of a “problem solver” engineer […]

A company has come up with a vendor-neutral database certification exam. Some are wondering how much use this will be, as it doesn’t go into vendor-specificities. Now, the specifics of how a query optimizer handles queries, how backups, restores and security are done and with MySQL specifically, how different storage engines act are […]

In a linkage of biblical proportions, Log Buffer #83 pointed me to Tom Kyte’s reiteration which pointed me to Coding Horror’s rant about source controlling the database schema.
Now, for starters, I agree with Tom’s sarcasm and Coding Horror’s rant — the database schema really should be source controlled in the same place as the application […]

Someone asked me what applications were good/bad for MySQL Cluster. As I’ve now actually had experience with a Cluster setup and a real-life application of it, and dug through the manual, I present a few characteristics of applications that will work with Cluster, and why they are so (so that if you have an […]

Play or download the podcast here: http://technocation.org/content/oursql-episode-24%3A-sun-shining
OurSQL Episode 24: “The Sun is Shining”
Sun Microsystems recently announced the purchase of MySQL. In this interview the day of the announcement, OurSQL asks Brian Aker about what this means for customers, community, Sun and MySQL.
Tell us what you think of Sun buying MySQL by calling the […]

Sun Microsystems recently announced the purchase of MySQL. In this interview the day of the announcement, OurSQL asks Brian Aker about what this means for customers, community, Sun and MySQL.

Tell us what you think of Sun buying MySQL by calling the comment line or sending your voice through Odeo!

Links:
Register for the MySQL Users Conference Today!
www.mysqlconf.com

A special thank you to our sponsor, The Pythian Group, www.pythian.com.

Feedback:

Email podcasttechnocation.org“>podcasttechnocation.org