BedquiltDB, the JSON document-store built on PostgreSQL, has reached Version 2

See the Upgrade Instructions to get up-to-date
or Get Started right now with version 2

New Features



Query Operators

Go beyond simple match queries with these new query operators.

  • $eq: Equal to
  • $noteq: Not equal to
  • $in: In a list
  • $notin: Not in a list
  • $gt: Greater than
  • $gte: Greater than or equal to
  • $lt: Less than
  • $lte: Less than or equal to
  • $exists: Key exists
  • $type: Match against type
  • $like: String pattern match (as PostgreSQL LIKE)
  • $regex: Regex match (as PostgreSQL ~)

articles.find({
    'upvotes': {
        '$gte': 4,
        '$lt':  10
    },
    'authorId': 'abcd',
    'metadata': {
        '$exists': True
    }
})

articles.find({
    "title": {
        "$regex": "^.*Elixir.*$"
    }
})

conferences.find({
    "city": {
        "$notin": ["London", "Glasgow"]
    }
})


sort and skip params for find_one

The find_one operation now accepts optional skip and sort parameters, just like its sister-operation, find.

collection.find_one(
    {"title": {"$like": "%Ruby%"}},
    sort=[{'upvotes': -1}],
    skip=2
)


$created and $updated sort options

Internally, BedquiltDB keeps track of when documents are created and updated. Now, you can sort by these hidden fields.

# returns documents in order of the time they were created
collection.find({...}, sort=[{'$created': 1}])

# returns documents in order of the time they were updated
collection.find({...}, sort=[{'$updated': 1}])


A new remove_many_by_ids operation

A glaring oversight, corrected. Enjoy bulk removal of documents via a list of _id values

widgets.remove_many_by_ids(
    ["5c3b9277812c6a6752b2aff7",
     "6697e90ceb808d6161aee879",
     "9707b283e98a456e1e1f6b85",
     "f3d177f0be545430cb517d6f"]
)


Assorted Improvements

An Official Docker Image

Getting started with BedquiltDB is now even easier, with the bedquiltdb/bedquiltdb Docker image.

Even Better Documentation

The BedquiltDB Docs have been overhauled and updated, including an updated Guide

A New Website

Presuming this whole "internet" thing catches on, people will be thrilled with the new BedquiltDB Website

About

BedquiltDB is a super-cool open source project.

Social Links

   

What's with the crazy name?

Go play Kentucky Route Zero, then you'll get it.