bedquiltdb / bedquilt-core Goto Github PK

We need some way of querying more than just sub-document matches against the json field.

We could use postgres schemas to namespace collections.

Needs quite a bit of thought

We should be able to easily get a count of documents in a collection.

An insert which is built like:

select bq_insert('things', '{"whatever": "Something I've eaten"}')

Will fail miserably. Need to fix it.

Appears to be an issue with how we quote strings while splicing them together with format.

The bq_remove_one_by_id function returns a boolean. The clients, documentation and tests all expect an integer.

Should change core signature to return an integer count of removed documents.

Currently most cloud offerings do not allow for python based extensions (example: aws RDS) but allow for plv8.
Any plans to break that dependency ? I noticed that there is only one function with that dependency...

Thanks
-Simo

This is essential for decent index performance. And could enable joins between collections.

Vague Requirements:

• When an index is added, create a column for that field, and copy the data into it
• trigger on insert/update to populate indexed columns
• think about how to ensure consistency if the column is updated separately from the json

We need:

• brew package
• Linux packages (at least debian and ubuntu)
• super-easy way of installing bedquilt-core on top of a postgres-9.5 installation

Hello. I tried to install bedquilt-core and got an eroor:
"ImportError: No module named jinja2"
I have installed Jinja 2 (pip install Jinja2). Nothig changes

Enough said

We should have sort, skip and limit parameters to the find* functions

More something to keep an eye on than an actionable task on this project, but we should ensure that bedquilt clients support optional transactions.

The default behaviour should be for each operation to commit automatically, but it should be possible for the programmer to open a transaction, do some operations and commit or rollback.

• should be able to specify constraints on documents in a collection.
• should support constraints on arbitriarily nested fields in document

See https://github.com/BedquiltDB/bedquilt-core/blob/master/doc/spec.md#add-constraint in spec.

Tasks:

• Spec for how the add_constraint function should behave
• implementation
• tests

• Should allow for partial updates of a document
• update, update_one, update_one_by_id

As described, we should have a Go driver