justin = { main feed , music , code , askjf , pubkey };
Ask Justin Frankel
No reasonable question unanswered since 2009!

Suggested topics: programming, music, sleep, coffee, etc.

Note: please do not ask questions about REAPER features, bugs or scheduling, use the forums instead.

Name: Ask: Human (enter yes):
[back to index] | [unreplied] | [replied] | [recent comments] | [all]
Question: Amateur coder here. I'd like to try making something like the searchable databases in the REAPER media explorer. What's the general idea to create a searchable database? Does it extract meta data from the files and build some kind of full text search database? I was checking out the files in the MediaDB folder, but I didn't quite understand the format and how that is searchable. Is this something you created yourself or some kind of standard format? If you could point me in the right direction on what to
Asked by helpme (89.187.187.x) on August 14 2024, 1:56am
Reply on August 14 2024, 2:00am:
    The format on disk is more or less as text, but we then build our own lists of all of the metadata. But there's no index built, we just search everything when the time comes to search, even tens or hundreds of megabytes can be searched very quickly these days (if you need to search it a hundred times a second that might be another story...).

    Another option, of course, is to use something like sqlite. But it's probably overkill.

Comments:
  • Posted by helpme (185.242.5.x) on August 14 2024, 3:08am:
    So is it just a a linear search over the meta data files?

  • Posted by Justin on August 14 2024, 1:38pm:
    they are all stored in memory in an efficient format, and that is searched linearly, correct.

Comment:
    Your Name:   -- Site Owner's Name:  (for human-verification)

    Comment:
[back to index] | [unreplied] | [replied] | [recent comments] | [all]
Copyright 2024 Justin Frankel. | RSS