Presentations

Gabriel Covarrubias
Audience: Everyone
Topic: LibreGraphics

When i started taking pictures 2 years ago my main concern was that all the guides were for proprietary software and only worked in Windows or Mac. At one point someone mocked me and said "Uhh finally you will have to switch to Mac". I responded "Hold my beer" and started researching a full FOSS Photography Workflow. In this presentation you will learn about how to use Rapid Photo Downloader, Darktable, Gimp and Bash for your photography needs.

Jason Kridner
Topic: Embedded

The Beagle experience tracks mainline u-boot, Linux and Debian development, while augmenting it to enable development to start as quickly as possible. Attendees will get started interacting with the hardware via the command-line, shell scripts, Python and JavaScript. Attendees will be walked through the configuration details for the boot configuration, pin multiplexing, USB networking and other helper scripts they should get to know. Support and development processes within the BeagleBoard.org community will be covered. Exercises will pave the way for the other workshops.

Patty Jula

Many government agencies have made datasets publicly available on their Open Data Portals, but how do we make use of that data? This talk will demonstrate modern open source analytic methods on datasets from the San Francisco and Los Angeles Police Departments. We'll discuss the importance of data cleansing, code re-usability, and learning about the data you are working with. Python libraries will be used to cleanse data, standardize it, and provide visualizations of what the data represents. A GitHub repository will also be available to clone or download, giving you the chance to build on pr

Robert Treat
Audience: Beginner
Topic: PostgreSQL

Postgres 10 added a new form of replication; logical replication; into its wide array of replication and failover options. In this talk, we'll discuss what logical replication is, differences between Postgres 10 and 11, how it differs from other replication options, and why you should, or maybe shouldn't, use it. We'll then walk through a live demo of setting up logical replication between two servers and do live experimentation with our cluster based on audience participation. Want to know how easy it is to break replication? There's no better way to find out!

Dmitrii Dolgov
Audience: Intermediate
Topic: PostgreSQL

In this talk we will discuss how much impact different knobs and options of the Linux kernel have on PostgreSQL and why, what would happen if we run our databases in virtualized environment or inside a container, how to see what's going on inside and how to break something spectacularly.

Joe Conway
Audience: Everyone
Topic: PostgreSQL

We expect to have several long term PostgreSQL community insiders handy and will corral them into an AMA (ask me anything) session. Bring your PostgreSQL questions that you have been afraid to ask!

Josh Berkus
Audience: Intermediate
Topic: PostgreSQL

You can have fully automated high availability PostgreSQL on your Kubernetes cluster ... today.  The Patroni system for automating PostgreSQL deployment, failover, and migration is ready to use and in production in several places.  In this live demo session, we will show you how you can make use of this technology.

Mark Wong
Audience: Beginner
Topic: PostgreSQL

Stored procedures have arrived with PostgreSQL 11. Come see what has been implemented, and how procedures differ from usr-defined functions. We will discuss some use cases for procedures such as migrating from other database management systems and manipulating data. There will be more features coming in future releases of PostgreSQL and we will cover some proposed enhancement to what a procedure can do.

Darren Douglas
Audience: Beginner
Topic: PostgreSQL

This presentation is a collection of key tips, tricks, hacks, and concepts that can make learning PostgreSQL administration a bit easier. Even experienced database administrators and PostgreSQL users have found new tricks to implement from this presentation.

Aleksey Tsalolikhin
Audience: Everyone
Topic: General

This hands-on course will take you from a vi beginner or intermediate user to Power User, able to leap tall text buildings with a single bound. Unleash the full power of that blinking cursor, become more efficient at your job, and fame and fortune will surely follow. Most people use only 10% of what vi is fully capable of. Awaken your vi’s full potential. Target audience: Anybody who has to edit files on UNIX-like systems. A sysadmin who’s been using vi for 18 years come up to me afterward and told me he learned something useful.