Can your software use an offline copy CDDB or FreeDB when ripping CDs? - Page 2

SyNTaXer · 09-08-2005, 03:00 AM

anything new in the use of an offline copy from freedb or cddb ?

veetid · 09-08-2005, 03:13 AM

main.dat in the application folder is simply an access database... You could import the data from FreeDB to allow access to all the information offline fairly easily...

david

SyNTaXer · 09-08-2005, 06:20 AM

thank you very much david, i'll try it

Maximus · 09-11-2005, 05:09 AM

Quote: Originally Posted by veetid

I am pretty sure the file is 500MB compressed, but a lot larger when uncompressed into text... It would probably shrink back up once imported into the DB.

Well, it was ~350MB compressed as an rar archive, the extracted tar image was 3GB

Then extracting it all into separate files about 1GB is gone and I cant even see that the progressbar has moved from 0%

So lets say you do extract 'em all and import them into the main.dat database,
which shouldn't be much of a problem although your "discid" format is a bit confusing, I'd still expect the size of the database to reach ~2-3GB
Just extracting the tar archive will take a day, and that's with a 15K SCSI drive.

So David, would a 3GB database still be usable in Centrafuse ?

/M

SyNTaXer · 09-11-2005, 05:34 AM

but there is also a windows version of the freedb database which is easier for windows to handle, because of less files (not each entry in an own file)

veetid · 09-11-2005, 04:58 PM

Quote: Originally Posted by Maximus

Well, it was ~350MB compressed as an rar archive, the extracted tar image was 3GB

Then extracting it all into separate files about 1GB is gone and I cant even see that the progressbar has moved from 0%

So lets say you do extract 'em all and import them into the main.dat database,
which shouldn't be much of a problem although your "discid" format is a bit confusing, I'd still expect the size of the database to reach ~2-3GB
Just extracting the tar archive will take a day, and that's with a 15K SCSI drive.

So David, would a 3GB database still be usable in Centrafuse ?

/M

Access will start to slow down around 850MB, so I would not try it with 3GB... You would want a full on SQL Server for that, which is not really viable in the car... SQL Lite might could do it, but 3GB is a huge database to not be using a full database server like SQL Server or Oracle... this is why I never really looked into importing FreeDB...

And the data would always be old... you would have to update it all the time if you wanted to be able to go buy brand new CD's and have it work...

david