FOSSLC is a non-profit organization that specializes in technology and know-how to record conferences with excellent quality. Click on the icons below to view great videos from communities we are actively involved with:

 

PostgreSQL

Content related to the PostgreSQL RDBMS.

What's New in PostgreSQL 9.1

in SoTM, SoTM2011, Video, PostgreSQL
PostgreSQL

An introduction to what is new in the newest release of PostgreSQL by Steve Singer

 

Event: 
SoTM2011
Speaker: 
Steve Singer

PostgreSQL replication

in How To, SC2011 - Software Developers' Haven, PostgreSQL
PostgreSQL

PostgreSQL is an open source relational database system that features a high level of standards complience and support for most programming languages.   PostgreSQL offers a number of different options for data replication.   This talk will provide an introduction to database replication in PostgreSQL and explain the different types of problems that replication can solve.  The talk will explain how the built in WAL shipping replication works, how to set it up and discuss the limitations.  The Slony replication system will be explained including the basic steps involved in setting up a Slony cluster and how Slony can be used to solve common problems

 

 

Event: 
SC2011
Speaker: 
Steve Singer

OpenStreetMap - Location, Location, Location

in Community, Database, How To, Open Data, SC2011 - Software Developers' Haven, OpenLayers, PostGIS, PostgreSQL, OpenStreetMap, Databases, OSGeo, Programming, Web Programming
Speaker: 
Richard Weait
Event: 
SC2011
Abstract: 

OpenStreetMap is geographic data that you can use and improve.  This presentation will:

  • cover a brief history of OpenStreetMap
  • show you why you want to be involved in OpenStreetMap
  • familiarize you with common solutions using OpenStreetMap
  • familiarize you with the OpenStreetMap tool set

Plan to join us at the Mapping Party on Sunday for peer-coaching on OpenStreetMap data surveys and editing tools.

Level: 
Beginner

Test Driven Development web development with postgres or mysql.

in How To, SC2011, MySQL, PostgreSQL, Python, Ruby
Speaker: 
Michael Richardson
Event: 
SC2011
Abstract: 

Test Driven Development is about writing the test cases first, and then writing the code.  To use this method, a programmer needs to actually be able to quickly write test cases.

Web site development falls into two flavours: legacy development is where your only tool for testing is a browser, and modern development using some kind of systematic unit testing such as occurs with Django or Ruby on Rails.   Rewriting an application into a modern framework is not always an option, and one can be stuck with an older language with poor support, or an older application with no framework.

Even with frameworks, it is often difficult to test web services applications where there are multiple web servers necessary.

This talk presents some fast ways to get testing up and running, and to separate oneself from endlessly reconfiguring the database servers on your development platform.

 

Level: 
Intermediate