Re: kind of a bag of attributes in a DB . . .

2019-09-15 Thread Chris Travers
On Sat, Sep 14, 2019 at 5:11 PM Albretch Mueller 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. >

Re: kind of a bag of attributes in a DB . . .

2019-09-14 Thread Adrian Klaver
On 9/14/19 2:06 AM, Albretch Mueller wrote: just download a bunch of json info files from youtube data Feeds Actually, does postgresql has a json Driver of import feature? I'm working without a net(coffee) and so I forgot to mention that for Python there is: http://initd.org/psycopg/doc

Re: kind of a bag of attributes in a DB . . .

2019-09-14 Thread Adrian Klaver
On 9/14/19 2:06 AM, Albretch Mueller wrote: just download a bunch of json info files from youtube data Feeds Actually, does postgresql has a json Driver of import feature? Not sure what you mean by above? Postgres has json(b) data types that you can import JSON into: https://www.postgres

Re: kind of a bag of attributes in a DB . . .

2019-09-14 Thread Albretch Mueller
just download a bunch of json info files from youtube data Feeds Actually, does postgresql has a json Driver of import feature? the metadata contained in json files would require more than one small databases, but such an import feature should be trivial C

Re: kind of a bag of attributes in a DB . . .

2019-09-11 Thread Adrian Klaver
On 9/11/19 9:46 AM, Albretch Mueller wrote: On 9/10/19, Adrian Klaver wrote: If there is no rhyme or reason to the metadata I am not sure how you could come up with an efficient search strategy. Seems it would be a brute search over everything. Not exactly. Say some things have colours but

Re: kind of a bag of attributes in a DB . . .

2019-09-11 Thread Albretch Mueller
On 9/10/19, Adrian Klaver wrote: > If there is no rhyme or reason to the metadata I am not sure how you > could come up with an efficient search strategy. Seems it would be a > brute search over everything. Not exactly. Say some things have colours but now weight. You could still Group them as b

Re: kind of a bag of attributes in a DB . . .

2019-09-10 Thread Adrian Klaver
On 9/10/19 9:59 AM, Albretch Mueller wrote: On 9/7/19, Adrian Klaver wrote: Is the metadata uniform or are you dealing with a variety of different data? You can expect for all files to have a filename and size, but their kinds (the metadata describing them) can be really colorful and wild w

Re: kind of a bag of attributes in a DB . . .

2019-09-10 Thread Albretch Mueller
On 9/7/19, Adrian Klaver wrote: > Is the metadata uniform or are you dealing with a variety of different > data? You can expect for all files to have a filename and size, but their kinds (the metadata describing them) can be really colorful and wild when it comes to formatting. lbrtchx

Re: kind of a bag of attributes in a DB . . .

2019-09-08 Thread Chris Travers
On Sat, Sep 7, 2019 at 5:17 PM Albretch Mueller wrote: > Say, you get lots of data and their corresponding metadata, which in > some cases may be undefined or undeclared (left as an empty string). > Think of youtube json files or the result of the "file" command. > > I need to be able to "instant

Re: kind of a bag of attributes in a DB . . .

2019-09-07 Thread Adrian Klaver
On 9/7/19 5:45 AM, Albretch Mueller wrote: Say, you get lots of data and their corresponding metadata, which in some cases may be undefined or undeclared (left as an empty string). Think of youtube json files or the result of the "file" command. I need to be able to "instantly" search that metad

kind of a bag of attributes in a DB . . .

2019-09-07 Thread Albretch Mueller
Say, you get lots of data and their corresponding metadata, which in some cases may be undefined or undeclared (left as an empty string). Think of youtube json files or the result of the "file" command. I need to be able to "instantly" search that metadata and I think DBs are best for such jobs an