Count number of records in lmdb databse with python

Question

I open a lmdb database using this code:

    lmdb_env = lmdb.open(source_path, readonly=True)

How can I count the number of records in this database?

I don't understand the close votes. Just because a question is short or basic, that doesn't mean it's too broad or unclear. This is a straightforward, specific question about coding that can have a definite correct answer, and I see no reason why it's inappropriate for Stack Overflow's format. I'm voting to reopen. I respectfully ask in advance that anyone who votes to leave closed please post a comment explaining why. — Adi Inbar, Dec 22 '15 at 21:47

score 8 · Answer 1 · edited May 23 '17 at 12:00

8

I think it should be like this:

lmdb_env = lmdb.open(lmdb_file_name, readonly=True)
print lmdb_env.stat()

Then it prints the directory that Jaco pasted here.

edited May 23 '17 at 12:00

Community

1
1

answered Mar 09 '16 at 20:16

GieBur

137
1
8

score 3 · Answer 2 · answered Nov 03 '20 at 08:48

    env = lmdb.open('db file path', max_dbs = ' > 0')
    with env.begin() as tx:
        db = env.open_db(b'db name', txn=tx)
        print(env.stat()) 
        print(tx.stat(db)) # this gives stats about one specific db

env.stat() gives entries of the main database. tx.stat(db) gives entries of one named database.

score 1 · Answer 3 · answered Dec 22 '15 at 16:42

1

You can use event.stat(). It will return the following dictionary with entries detailing the number of records in this database:

{'branch_pages': 1040L,
'depth': 4L,
 'entries': 3761848L,
 'leaf_pages': 73658L,
 'overflow_pages': 0L,
 'psize': 4096L}

answered Dec 22 '15 at 16:42

Alex

21,273
10
61
73

score 1 · Accepted Answer · edited Dec 24 '15 at 17:11

1

I found a simple solution using for loop. Here it is:

count = 0
for key, value in lmdb_env.cursor():
        count = count + 1

However, I think there should be a better way using pre-defined function.

edited Dec 24 '15 at 17:11

Caleb Kleveter

11,170
8
62
92

answered Dec 24 '15 at 11:40

trminh89

877
2
10
17

1

`sum(1 for _ in lmdb_env.cursor() )` – Padraic Cunningham Dec 24 '15 at 17:16

Count number of records in lmdb databse with python

4 Answers4

Linked