This week we complete our series on Common Schema by talking about QueryScript. Special guest co-host Jon Day of SkySQL joins us. Ear Candy is some MySQL security tips and At the Movies is a humorous look at value chain mapping.
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.
Common Schema's Query Script
query script documentation
Executing QueryScript programs with run() and run_file() and getting time information from script_runtime()
- flow control statements in QueryScript
- if-else flow control
- foreach flow control
- while flow control
- loop_while flow control
- try-catch flow control
- split flow control
Episode 191, where we talked about throttle()
Episode 143, where we talked about oak-chunk-update
Magic variables in split: $split_columns, $split_index, $split_min, $split_max, $split_range_start, $split_range_end, $split_step, $split_rowcount, $split_total_rowcount, $split_clause, $split_total_elapsed_time, $split_table_schema, $split_table_name
Parameters for split: start, stop, table, index, size,
- Episode 194, which talks about eval(). QueryScript is what provides eval()
- input for passing variables into QueryScript programs
- var for local variables in QueryScript
- Using variables in QueryScript
- report in QueryScript
- Episode 191, which discusses security_audit - security_audit uses QueryScript's report statement.
MySQL Security Tips from Shlomi Noach
At the movies
This week in At the Movies, we present a keynote video from last week's OSCon - Anticipating the Future: An Introduction to Value Chain Mapping by Simon Wardley. Simon is a Researcher for CSC's Leading Edge Forum, a global research and advisory programme that explores new thinking and develops next practice roadmaps that address the major challenges at the intersection of business, IT and management. In this keynote, at OSCON, Simon presents the general principles of industry change and describe what can and cannot be predicted.
Where you can see us
Sheeri will be at the August Boston MySQL User Group on Monday, August 11th where we will have Ike Walker talkign about "Assembling the perfect MySQL toolbox". He will go through the best tools for each job.
Gerry will be at the August Seattle MySQL User Group on Monday, August 11th.