Tanker Embrace the relational model

14 views · Published 11 March 2018 · 31:51 · Indexed 14 November 2026

Channel: FOSDEM · 2018 · Science & Technology

Watch on YouTube

by Bertrand Chenal

At: FOSDEM 2017

Tanker goal is to allow easy batch operations without compromising databasemodeling. For pandas users, it's like DataFrame.to_sql on steroids.

The Tanker inception is based on two strong observations (not particularlynew):

  * The object-relation mapping in so called libraries is sometimes source of performance and semantic difficulties, especially with queries involving multiple joins. On the other hand, the relational model is both powerful and simple, and there are no reason not to expose it to the Python world.

  * When working with external data sources, we are often faced with the challenge of matching those records with the database content. We have to know which record is new, which has been updated, etc. We also often have to de-normalize content and map it with a (hopefully) well-designed and 3NF schema.

This presentation will show how Tanker answers those two aspects, how it wasinspired by existing libraries and how it is currently used in productionapplications.


Room: H.1308 (Rolin)
Scheduled start: 2017-02-04 12:00:00

More from this channel