Sessions at EuroPython 2011 about PostgreSQL and Django

Your current filters are…

Clear

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.

    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.

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

    Coverage video