Open Mobile's Media Database Engine - Public Preview

**justchat_1** · 09-23-2009, 06:51 AM

Performance data on this engine will be shown in the upcoming media benchmark so I wont spoil that but I wanted everyone to get a chance to play around with it before then.

Using it is simple..select a top level music directory using the ... button or by entering it into the top textbox and then click go. Current status as well as a running average of how many items it's indexing per second are displayed in the status bar.

All data is stored in the OMMedia file. You can search it by typing in the second textbox (search begins when you type the 3rd character). It will also display the cover art for the first entry in a picture box really just as a proof of concept.

indexed fields:
title, artist, album, cover, track number and rating

Feedback is welcome...

**RBJensen** · 09-23-2009, 07:38 AM

I tried letting it loose on a small MP3 collection, and it does not seem to be able to find certain entries when I search.

Examples:
Did not find C:\Download\Music\Lacuna_Coil\01-lacuna_coil-the_last_goodbye.mp3
when searching for "lac"

Found no MP3s in C:\Download\Music\Bowling_For_Soup which contained 14 of them, searching for "bow"

Ah - now I see, it only looks for the title of the MP3...

Suggestions:
The ability to search for artist/album too?
Perhaps search results could first show hits for "title", then album, then artist?.
If the file does not contain those metadata - then just use the filename?

The app did crash once when I searched a certain folder - will see if I can repeat that and get an error description.

**justchat_1** · 09-25-2009, 09:13 PM

Missed your post.....Yea the app does just read the file tags and store them in a database. It was a proof of concept for technology thats going to be included in open mobile. Open mobile itself will be able to search by title, artist, album or genre as well as falling back to the file name if the tags are not available.

I am very interested in anything that caused the app to crash so if you do narrow it down to a file or even a folder that you wouldn't mind sending I would be happy to take a look. Things like that is what were really trying to iron out at this stage.

**Extide** · 11-02-2009, 08:38 PM

App crashed when I ran it on a 64-bit system, Looks like the .exe is compiled for anycpu but the SQLLite DLL only has the X86 (32bit) bits.

EDIT: BTW I just found out about this FE today and this is EXACTLY what I have been wanting forever! I like your design goals and total;ly agree with the faults/shortcomings of the existing ones out there.

**justchat_1** · 11-02-2009, 10:11 PM

Yea I guess I forgot I stopped using the managed version. I don't want to limit OM to just x86 but due to the native code used the dll needs to be compiled to 32 or 64bit. It's a windows only issue so I don't mind bundling two separate dll's with the installer. I've attached an x64 dll...see if dropping that in the folder does the trick.

On other platforms mono's sqlite library will be used which is compiled 32 or 64 at install time.