Which embedded database to use for file indexing applications

Question

Hi,

I need to develop a file indexing application in python and wanted to know which embedded database is the best one to use for indexing.

Any help on this topic is appreciated. Thanks,

Rajesh

Answer 1

you could use sqlite :

• http://www.sqlite.org/
• http://code.google.com/p/pysqlite/

Another one that you could explore is

• http://www.equi4.com/metakit/

For file indexing there are tools like pylucene, xapian.

• http://stackoverflow.com/questions/532312/python-file-indexing-and-searching

Other relevant link on SO

• http://stackoverflow.com/questions/2110843/file-indexing-using-binary-trees-in-python

Answer 2

You can also check Firebird who have for good drivers for Python
You can also use the sphinx add in Or you can also use lucene and firebird like infovark