Suggestion

Joshua · Post by **Joshua** » 2004-02-15 05:40:29

Hi there, I have a question for the author of this soft.
The database (catalog) file seems to be very stable and it works excelent.
Did you design it by yourself?
Do you have any tips or any usefull info about that? (I mean to design one)
I'm trying to develop a soft for my work and I really need some suggestions!!

THANKS!!!!
Joshua Kent.

Post by **antp** » 2004-02-15 13:01:27

Hi
This is not a real database actually.
It is just a file where I write all the data of the movies.
When opening the file I read the whole file to memory, and when saving I write the memory to disk.
So it is not very efficient.
The main problem is that images are also put in memory when opening the file, so the file size is limited by available memory.
In the next version I will probably put all the movie info in a XML file that I will load, and keep the pictures in a separate file (and read in memory only what has to be displayed, or request)

Joshua · Post by **Joshua** » 2004-02-15 18:29:32

Thanks!!!
I was looking for something with the performance of a database but smaller.
It's seems I'm gonna have to design it in xml or a single file like you did.

Thanks again!!

bmm · Post by **bmm** » 2004-02-15 20:24:28

Hi,

Have you thought about using an actual database to store the data?

I am pretty impressed by a little music library software called Musik (http://musik.berlios.de/) that uses SQLite (http://www.sqlite.org/) as the backend and thought that this could also be used in AMC.

Just a suggestion.

Post by **antp** » 2004-02-15 21:22:23

In AMC 4 I will use XML for the first version, but I'll maybe use something else later. There are already lots of things to think for the 4.0

Joshua · Post by **Joshua** » 2004-02-20 11:52:13

Thanks man!
SQLite seems to be an excelent database, an really small, just what I've looking for.