On Sat, Sep 14, 2019 at 5:11 PM Albretch Mueller <lbrtchx@xxxxxxxxx> wrote:
just download a bunch of json info files from youtube data Feeds
Actually, does postgresql has a json Driver of import feature?
Sort of.... There are a bunch of features around JSON and JSONB data types which could be useful.
the metadata contained in json files would require more than one
small databases, but such an import feature should be trivial
It is not at all trivial for a bunch of reasons inherent to the JSON specification. How to handle duplicate keys, for example.
However writing an import for JSON objects into a particular database is indeed trivial.
C
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in.