Tanker Embrace the relational model
14 views · Published 11 March 2018 · 31:51 · Indexed 14 November 2026
Channel: FOSDEM · 2018 · Science & Technology
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