~/talk

django-rdflib and postgresql - the best of both worlds

Talkat EuroPython 2011 · 2011-06-20..06-26· [databases, python]
links:none on file
slides:none on file

Integrates django-rdflib with PostgreSQL full-text search by forking and fixing django-fts and rdflib, adding a custom manager that preserves chaining, a management command to rebuild all indices, result highlighting, and buffered bulk inserts (graph.commit) to avoid per-row synchronous inserts. Drops SQL constraints to speed writes, uses PostgreSQL stemming/dictionaries and a rank_field to sort by relevance, supports SPARQL and a Pythonic API, and powers the Brain Architecture Management System with immediate indexing and on-the-fly RDF/XML export.

AI-written summary · about

  1. 0:00Intro
  2. 15:58Custom Manager
  3. 19:08Database Migration
  4. 22:13Sparkle alternative
  5. 22:48Writing from scratch
  6. 23:43Jungle integration
  7. 24:55Constraints
  8. 26:20Basic operations
  9. 26:51Simple triples
  10. 27:44Remove triples
  11. 28:46Sparkle
  12. 30:18Brain Architecture Management
  13. 31:38Search
  14. 32:17Terminal Nerve
  15. 33:27Extended Form
  16. 33:44Relevance Naming
  17. 34:44Full Text Search
  18. 35:07Complete Search
  19. 35:36Mixing Search Terms
  20. 36:59Highlighting
  21. 37:26Questions
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.