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.
This talk is the updated and especially enhanced of the "Python and PostgreSQL - a match made in heaven" talk of EP 2006, CERN, Switzerland.
PostgreSQL and Python share more then the first letter: their communities have great similiarities; their development processes are really comparable; their licenses and their openness to academics AND business (on a technical and communitie perspective) are big pluses.
We will have a look at those similiarities and learn why PostgreSQL is really the database sister to Python. There will be an overview of PostgreSQL, information of how to connect PostgreSQL and Python; how PostgreSQL streaming replication works and what it can do for you, how PL/Python helps to have Web 2.5 JSON storage and handling right inside PostgreSQL. We will show that YESQL is also a valid answer to many data storage qeuestions.