Solving Common SQL Problems with the SeqEngine (Presentation, HTML, view online)
Solving Common SQL Problems with the SeqEngine (Presentation, PDF, download)
The SeqEngine is a storage engine plug-in for MySQL 5.1 to generate configurable sequences on the fly. It was hacked as a demo for a presentation at the MySQL Conference 2009. You can download the source code for the storage engine and the presentation slides from this site.
The SeqEngine is distributed as source code and to be built as a plug-in within the MySQL source tree. Download the source below and read the further instructions in the README file.
You'll find examples on how to use SeqEngine in the presentation below.
The presentation was held at the MySQL Conference & Expo 2009 on April 21 in Santa Clara.
Experienced SQL developers know how to solve a class of quite different problems efficiently with the help of an auxiliary sequence table: We'll learn from them with easy to understand hands-on examples – and meet the SeqEngine, a pluggable storage engine for MySQL 5.1 that helps us to apply the expert's tricks even more efficiently.
Did you ever try to find the few missing rows in a table holding an extremely large time series? Or did you have to fight with somebody else’s weird database design—storing data in columns that should have been rows, or even multiple values per field? Ever wanted to use a prepared query for a variable-sized IN-predicate?
Some common problems like these are solved easily and efficiently using an auxiliary table containing nothing but a sequence. This session will show you how, with hands-on examples—but instead of manually filling our sequence tables and wasting disk storage (or RAM) and I/O resources, we’ll use the SeqEngine: A pluggable storage engine for MySQL 5.1 that creates our customized sequences on the fly.
The session mostly concentrates on the SQL-side to the problems. But as this tiny engine also serves well as a nice example of how to make use of MySQL’s pluggable storage engine API, there will be an associated BOF: We’ll be able to have a closer look behind the scenes there.
Solving Common SQL Problems with the SeqEngine (Presentation, HTML, view online)
Solving Common SQL Problems with the SeqEngine (Presentation, PDF, download)
This is an incomplete list of blogs and websites where SeqEngine was mentioned.
Beat Vontobel, b.vontobel@meteonews.ch
