Page 1 of 3 123 LastLast
Results 1 to 10 of 22

Thread: Why use a database?

  1. #1
    Newbie
    Join Date
    Dec 2003
    Posts
    25

    Why use a database?

    Just wondering why the creators opted to have the system run off a database vs just having it operate as a glorified explorer? I have ~750 albums now, and it takes a long time to update the database, especially when you're just adding 1 or 2 albums. It seems like it would be alot more efficient if they just threw away the whole idea of a database.

  2. #2
    Maximum Bitrate CarComp's Avatar
    Join Date
    Oct 2001
    Location
    Indiana
    Posts
    515
    The database is there for speed. We used to not have one... Try reading the ID3s from a list of 1000s of songs quickly.. You can't do it. Also, you don't have to rebuild the database everytime you add new songs.. Just add them. In a moment or two after re-launch of the app, they will become part of the database. We're not getting rid of the database.
    Get MediaEngine !!!
    Media Engine Download

  3. #3
    Newbie
    Join Date
    Dec 2003
    Posts
    25
    could just read the id3's of the album you're playing, similar to how it works on a normal desktop computer when you open a m3u. i didnt know thats how albums got added into the db though, so it doesnt matter anymore

  4. #4
    Variable Bitrate NoPistonPC's Avatar
    Join Date
    Apr 2004
    Location
    Boston
    Posts
    360
    Using a database is totally the way to go. The only downside that I can see is that setting it up for the first time may take some time. A database makes coding things like sorting, searching, categorizing, etc. so much easier. And it lets you associate additional information to each of your songs that isn't available through explorer (like audio fingerprints: http://www.research.philips.com/Info...sp?lNodeId=927). And it makes it more portable to other OSs as well... etc. etc...

  5. #5
    Newbie OrangePeel's Avatar
    Join Date
    Nov 2003
    Location
    Wellington, New Zealand
    Posts
    53
    Some M3U's actually store the title information... Winamp's ones do anyway. Shouldn't need to re-read the ID3 when you load a playlist.

    ME takes a different approach by using an "M3U" which can be accessed using SQL.. Very clever I thought, but can be a tad slow on my Epia 800, but no slower than loading an entire playlist and reading the ID3's. A little more time in the beginning for a faster experience later. I do like the way you can disable automatic updates though, ME used to always rebuild for no reason... Easy way around.

    Just a pity it had to be Access. It really is a load of rubbish
    89 Celica, CarPC installed, 1st bday :)
    http://www.fishy.net.nz/carpc/
    • MediaEngine
    • Epia V8000
    • 80GB WD 7200RPM HD
    • Xenarc 700TS
    • SB Live
    • Opus 90W
    • CIMR100 remote
    • Deluo serial GPS
    • D-Link USB radio wired to power antenna

  6. #6
    Raw Wave hijinks21's Avatar
    Join Date
    May 2002
    Location
    Albany, NY
    Posts
    1,803
    they might want to look into sqllite

    i just it for embeded apps in linux and it works great. Beats having the user run mysql. On the down side.. i'm not sure how the windows version works.. like can you include it in the installer?? i dunno
    '98 Explorer Sport
    http://mp3car.zcentric.com (down atm)
    AMD 800mhz 192megs RAM 60gig hard drive 9 inch widescreen VGA
    80% done

  7. #7
    FLAC samc's Avatar
    Join Date
    Feb 2003
    Location
    Brooklyn, NY
    Posts
    944
    yeah, ever heard of arrays, hash tables, search algorithms. Imagine how long it'll take you to scroll through 1000+ mp3s with just an explorer (I assume most people have that much songs).
    Mine needs to be updated.

  8. #8
    Mac Car Moderator kandyman676's Avatar
    Join Date
    Apr 2004
    Location
    Maryland
    Posts
    813
    yah, or 60,000 songs:-P also remember if you are using Access, you might want to install office on your car, and optimize the database every once in a while.

    Access likes to make the DB REALLY large when you add stuff in often. doing the compact database feature every so often will help speed it up and reduce its size.
    "If it works this good why F with it?" -KMFDM "Intro"

    Strive for ethical wardriving: http://faq.wardrive.net/

    My CarCPUs: v1 - 2000 | v2 - 2004
    Mp3Car Meets: http://detrimental.org/eyecandy/MP3CarMeets

  9. #9
    I'm sorry, and you are....? frodobaggins's Avatar
    Join Date
    Jan 2003
    Location
    Ruston, LA
    Posts
    8,846
    Quote Originally Posted by kandyman676
    yah, or 60,000 songs:-P also remember if you are using Access, you might want to install office on your car, and optimize the database every once in a while.

    Access likes to make the DB REALLY large when you add stuff in often. doing the compact database feature every so often will help speed it up and reduce its size.

    No need. Put this in your Media Engine Folder and run it.
    (The ME database is still called tags.mdb right ?)

    Frodo
    Attached Files Attached Files
    [H]4 Life
    My next generation Front End is right on schedule.
    It will be done sometime in the next generation.
    I'm a lesbian too.
    I am for hire!

  10. #10
    Mac Car Moderator kandyman676's Avatar
    Join Date
    Apr 2004
    Location
    Maryland
    Posts
    813
    ahh, the lazy man's way! :-) was not aware of that niftly exe
    "If it works this good why F with it?" -KMFDM "Intro"

    Strive for ethical wardriving: http://faq.wardrive.net/

    My CarCPUs: v1 - 2000 | v2 - 2004
    Mp3Car Meets: http://detrimental.org/eyecandy/MP3CarMeets

Page 1 of 3 123 LastLast

Similar Threads

  1. put all info from mp3 cds in a database...
    By Raas in forum Off Topic
    Replies: 13
    Last Post: 09-23-2006, 10:34 AM
  2. Using UK speed cam database in VB
    By Jamez_Warner in forum Software & Software Development
    Replies: 2
    Last Post: 04-04-2004, 04:04 PM
  3. Database question?
    By jagreen2 in forum Software & Software Development
    Replies: 11
    Last Post: 02-12-2004, 09:19 PM
  4. Feature request. Browsing database.
    By Mikesz in forum ME Archive
    Replies: 6
    Last Post: 12-02-2003, 08:18 PM
  5. a database of id3 info
    By etrik in forum Software & Software Development
    Replies: 16
    Last Post: 01-18-2001, 10:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •