Hi everyone,
I have a program that reads the directory tree from a specified path
(Windows only) for example c:\tmp or c:\ or d:\ etc. My plan is to read
the directory tree into a tree control. I want the data in the tree to
be inserted into some kind of database. Now I'm not sure what the most
efficient way of storing this would be. The database must be searchable
and editable.
Any ideas?
Regards,
Wayne
Now I'm not sure what the most
efficient way of storing this would be. The database must be searchable
and editable.
You would have to be more specific on what kind of sizes you want to
be the sweet spot. For one of my projects I just a Python dictionary,
but then I am only storing a few thousand pieces of information
and don't worry about concurrency with other processes on the same
or other machines.
If you want an actual database, you could start with SQLite.
Roger
Roger Binns wrote:
You would have to be more specific on what kind of sizes you want to
be the sweet spot.
Well we're looking at a CD collection of typically about 20 to 30 CD's. So that's a large amount of files. Ok, 'large' is also relative but I'm sure you get the idea.
Look, if I'm going to use any stand-alone db it will definitely be sqlite, no problem there. The problem is this: How do I store the directory tree in the database so that I can retrieve the data and then re-format it into a tree control. There must be an easier way than slash-detecting.
Regards,
Wayne