Sessions at EuroPython 2011 about PostgreSQL and Django

Tuesday 21st June 2011

• django-rdflib and postgresql - the best of both worlds

  by Ştefan Talpalaru

  rdflib is a python library implementing a database with various triples back-end, parser, data serializers, SPARQL is a Python interface to extract/insert triples. We integrated it in Django reusing the database connection and exposing an ORM interface, along with full-text search on literals. This presentation shows a django-rdflib case study with a PostgreSQL backend in Brain Architecture Management System (http://brancusi1.usc.edu) - a neuroscientific project for the University of Southern California. Benefits of the flexible RDF structure will be shown, allowing researchers to insert free format data, making data public with a customizable serialization and use the powerful full-text search integrated in PostgreSQL.

  Objective: show attendees an effective combination of RDF, PostgreSQL full-text search and Django ORM via django-rdflib.

  Requirements: Django familiarity.

  • Django
  • Django ORM
  • PostgreSQL
  • RDF
  • Semantic Web

  At 11:15am to 12:15pm, Tuesday 21st June

  Coverage video

Thursday 23rd June 2011

• Data Driven Cache Invalidation

  by Magnus Hagander

  In todays world, nobody (should) deploy a web application facing the
  internet without having a proper caching system in place. There are
  many different solutions to choose from, from manual use of memcached
  through framework integrated caching to external caches like Squid or
  Varnish. Most modern frameworks come with integrated functionality for
  at least one of these methods, and often more than one.

  However, they often relies on all traffic going through the same
  framework to work properly - a caching layer in Rails is hard to share
  with one in Django. This talk will show a way to break the design
  rules of these frameworks just a little, and have the database help
  solve this problem.

  This talk will use a small application written in Python using Django
  to illustrate the examples, but the method is language independent.
  Unsurprisingly, the database used is PostgreSQL.

  • Caching
  • Django
  • Memcached
  • PostgreSQL
  • Python
  • Scaling

  At 3:30pm to 4:30pm, Thursday 23rd June

  Coverage video