move SQL design earlier

[debbugs-presentations.git] / debbugs.Rnw

diff --git a/debbugs.Rnw b/debbugs.Rnw
index 2deb057b533c334c20524652394d4de54d99a308..fc734035e0cc9df8a507783062c015fd89b9eb6d 100644 (file)
--- a/debbugs.Rnw
+++ b/debbugs.Rnw
@@ -173,7 +173,7 @@ print(ggplot(bug.growth,#[date > as.POSIXct(ISOdatetime(2005,1,1,0,0,0)),],
 \end{center}
 \end{frame}
 
-\begin{frame}{Bug Growth Rate}
+\begin{frame}[fragile]{Bug Growth Rate}
 <<bug_growth_rate,echo=FALSE>>=
 print(ggplot(bug.growth[date > as.POSIXct(ISOdatetime(2014,1,1,0,0,0)),],
              aes(x=date,y=`bugs per day`))+
@@ -283,15 +283,6 @@ print(ggplot(rc.bugs.long[date >
       scale_color_discrete("Measure"))
 @ 
 \end{center}
-  \setbeamercolor{postit}{fg=black,bg=yellow}
-  \begin{textblock}{4}(6,4)
-    \begin{onlyenv}<2>
-      \begin{beamercolorbox}[sep=1em,wd=5cm]{postit}
-        \centering \huge Too many RC bugs!
-      \end{beamercolorbox}
-    \end{onlyenv}
-  \end{textblock}
-
 \end{frame}
 
 \section{Debbugs Structure and Infrastructure}
@@ -310,17 +301,11 @@ print(ggplot(rc.bugs.long[date >
   \end{center}
 \end{frame}
 
-\section{Database Ho!}
+\section{New Features}
 
-\subsection{Overall Database Design}
+\subsection{Database}
 
-\begin{frame}{Overall Database Design}
-  \begin{center}
-    \input{debbugs_layout_db}
-  \end{center}
-\end{frame}
-
-\subsection{Perl Database Infrastucture}
+\subsubsection{Perl Database Infrastucture}
 \begin{frame}{Perl Database Infrastructure}
   \begin{itemize}
   \item DBIx::Class
@@ -331,23 +316,7 @@ print(ggplot(rc.bugs.long[date >
 \end{frame}
 
 
-\subsection{SQL Design}
-\begin{frame}{SQL Schema}
-  \includegraphics[width=\textwidth,keepaspectratio]{figures/schema.png}
-  \begin{itemize}
-  \item Current Debbugs SQL Schema
-  \end{itemize}
-\end{frame}
-
-\subsubsection{dak SQL Design}
-\begin{frame}{dak SQL Schema}
-  \includegraphics[width=\textwidth,keepaspectratio]{figures/dak_schema.png}
-  \begin{itemize}
-  \item Inspiration taken from dak SQL Schema where appropriate
-  \end{itemize}
-\end{frame}
-
-\subsection{SQL Loading}
+\subsubsection{SQL Loading}
 \begin{frame}[fragile]{SQL Loading}
   % SQL loading
   \begin{itemize}