This week we continue our discussion about Common Schema by talking about security views and schema analysis views. Ear Candy is that apt repositories for MySQL are available, and At the Movies is about copyright vs. civil liberties.
In the news, the OurSQL podcast will change to a monthly format after episode 200. We love doing the podcast, but it is very time consuming and production is expensive. We will still bring quality episodes, they will just be spaced further apart.
- Security Views
- Schema Analysis Views
- no_pk_innodb_tables - for finding tables with no primary key
- sql_range_partitions - for setting the next range of a given partition.
SELECT REPLACE(alter_statement,'MyISAM','InnoDB') as change_to_innodb,
alter_statement as revert_back_to_myisam
WHERE ENGINE='MyISAM' AND table_schema not in ('mysql','information_schema','performance_schema);
MySQL Debian-compatible repositories now released!
More detailed guide to deploying MySQL with apt repositories
At the movies
This week in at the movies, we present Copyright Regime vs. Civil Liberties, presented at Google Tech Talks by Rick Falkvinge, the founder of the Swedish Pirate Party and the international politicized pirate movement.
Where you can see us
Sheeri will be attending the TDWI Executive Summit in Boston from Sunday July 20th through Wednesday July 23rd.
Gerry will be attending OSCon 2014 from Sunday July 20th through Thursday July 24th.
Sheeri will be at the August Boston MySQL User Group on Monday, August 11th.
Gerry will be at the August Seattle MySQL User Group on Monday, August 11th.