Search code examples
sqlberkeley-dbberkeley-db-je

Using sum(), count(), and "group by" in Berkeley DB

How do I use sum(), count(), and group by in Berkeley DB? Is there any alternative way?

Solution

  • Which API are you using? If you're using the key/value API, then you will need to implement those functions yourself, essentially by scanning the database using a cursor. If you are using the SQL API, then you can simply do a "SELECT sum(), count() ... GROUP BY ..." SQL statement.

    You may want to post questions like this to the Berkeley DB forum.