frictionlessdata / tableschema-sql-py

Generate SQL tables, load and extract data, based on JSON Table Schema descriptors.
MIT License
60 stars 19 forks source link

Allow updating storage using 'update keys' #53

Closed akariv closed 7 years ago

akariv commented 7 years ago

The update keys are used to identify already existing rows which should be updated. We make use of a bloom filter to avoid hitting the DB for every row - the bloom filter gives us a definite answer for missing rows, and a 99% certainity for existing rows.