Page 1 of 1
Suggestion
Posted: 2004-02-15 05:40:29
by Joshua
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.
Posted: 2004-02-15 13:01:27
by antp
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)
Posted: 2004-02-15 18:29:32
by Joshua
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!!
SQLite
Posted: 2004-02-15 20:24:28
by bmm
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.
Posted: 2004-02-15 21:22:23
by antp
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
Posted: 2004-02-20 11:52:13
by Joshua
Thanks man!
SQLite seems to be an excelent database, an really small, just what I've looking for.