This is not the complete list of event; some events are missing (e.g. opening session, closing session, keynote, social events)


pentabarf_bsdcan=# SELECT DISTINCT E.title, string_agg(S.name,', ') as name, E.event_type
  FROM event E, view_event_person P, view_mail_all_speaker S
 WHERE E.event_id = P.event_id
   AND P.person_id = S.person_id
   AND E.conference_id = 12
   and E.event_state = 'accepted'
   and P.event_role_name = 'Speaker'
  group by E.title, E.event_type order by 1;
                                           title                                           |                    name                    | event_type 
-------------------------------------------------------------------------------------------+--------------------------------------------+------------
 A Brief History of the BSD Fast Filesystem                                                | Kirk McKusick                              | lecture
 A Look Inside FreeBSD with DTrace                                                         | George Neville-Neil                        | tutorial (full day)
 A Walkthrough of CAM                                                                      | Warner Losh                                | lecture
 Amateur Radio and SDR                                                                     | Aaron Poffenberger                         | BOF
 An OpenFlow implementation for OpenBSD                                                    | Reyk Floeter                               | lecture
 Beyond Monocultures                                                                       | George Rosamond                            | lecture
 Bidirectional Forwarding Detection (BFD) implementation and support in OpenBSD            | Peter Hessler                              | lecture
 Booting from Encrypted Disks on FreeBSD                                                   | Allan Jude                                 | lecture
 Building The Network You Need With PF, The OpenBSD Packet Filter                          | Peter Hansteen                             | tutorial
 Capsicum and Casper                                                                       | Mariusz Zaborski                           | lecture
 Case Study: Linux to FreeBSD ... to FreeBSD?                                              | Paul Chvostek                              | lecture
 Creating a nice IPv6 addressing plan                                                      | Massimiliano Stucchi                       | tutorial
 DNSSEC Tutorial                                                                           | Massimiliano Stucchi                       | tutorial
 Dodging Raindrops: Escaping the Public Cloud                                              | Ike Eichorn                                | lecture
 Everything You Always Wanted to Know About "Hello, World"*                                | Brooks Davis                               | lecture
 FreeBSD 8 to 10                                                                           | Nick Wolff                                 | lecture
 FreeBSD and GDB                                                                           | John Baldwin                               | lecture
 FreeBSD based high density filers                                                         | Baptiste Daroussin                         | lecture
 FreeBSD on Cavium ThunderX System on a Chip                                               | Wojciech Macek                             | lecture
 FreeBSD, BeagleBone Black and Robotics                                                    | Vinícius Zavam, Edicarla Andrade           | lecture
 Haskell/FP                                                                                | Aaron Poffenberger                         | BOF
 Implementation of Xen PVHVM drivers in OpenBSD                                            | Mike Belopuhov                             | lecture
 Improving PF's performance and reliability.                                               | Kajetan Staszkiewicz                       | lecture
 Improving the FreeBSD Build                                                               | Bryan Drewery                              | lecture
 Improving the FreeBSD Translation Tools                                                   | Warren Block                               | lecture
 JSON-based configuration of kernel subsystems                                             | Giuseppe Lettieri                          | lecture
 LLD: A new linker for FreeBSD                                                             | Davide Italiano, Rafael Ávila de Espíndola | lecture
 Limits and the practical usability of BSDs,  a big data prospective                       | Predrag Punosevac                          | other
 Making the internet more secure                                                           | Massimiliano Stucchi                       | lecture
 Modern tooling to assist with developing applications on FreeBSD                          | Sean Chittenden                            | lecture
 Network Performance Improvement for FreeBSD Guest on Hyper-V                              | Dexuan Cui                                 | lecture
 Open/LibreSSL in FreeBSD                                                                  | Bernard Spil                               | lecture
 OpenBSD rc.d(8)                                                                           | Antoine Jacoutot                           | lecture
 OpenPAM and BSD                                                                           | Michael W. Lucas                           | lecture
 OpenSMTPD for the Real World                                                              | Aaron Poffenberger                         | tutorial
 OpenZFS space allocation                                                                  | Matt Ahrens                                | lecture
 Opensource Routing                                                                        | Sebastian Benoit                           | lecture
 Packet Pacing - Rate Limit per flow (TCP \ UDP)                                           | Oded Shanoon                               | lecture
 Porting bhyve on ARM-based platforms                                                      | Mihai Carabas                              | lecture
 RISC-V: Berkeley Hardware for Your Berkeley Software (Distribution)                       | Arun Thomas                                | lecture
 Reproducible Builds in FreeBSD                                                            | Ed Maste                                   | lecture
 Running an ISP on OpenBSD                                                                 | Henning Brauer                             | lecture
 Through the Wire                                                                          | George Neville-Neil                        | lecture
 Using VXLAN to network virtual machines, jails, and other fun things on FreeBSD           | John Nielsen                               | lecture
 Using competitive analysis to increase the effectiveness of operation system fuzz testing | Kirk Russell                               | lecture
 ZFS BoF                                                                                   | Allan Jude                                 | BOF
 diskctl: A permissively-licensed S.M.A.R.T. and raw disk command framework                | Michael Dexter                             | lecture
 netmap-fwd                                                                                | Luiz Otavio O Souza                        | lecture
(48 rows)

pentabarf_bsdcan=#