On út 24. března 2009, Oscar Miras wrote: > > The sqlite database solves this problem, > > therefore I still think that it has to be implemented first. > > Oh. I think I get it now. > Are you saying that now there is not any implementation of sqlite database?
Yes, it is just in planning phase. > > :$ > > If so, all make sense to me now xD. > > Directory table with directory_id, directory_path, timestamp > File table with file_id, directory_id, file_name, timestamp,*times_clicked* > Metadata table with file_id, metadata_key, metadata_value, That would be enough for the beginning, but this database structure is definitely not ideal, there could be made some optimizations, for example the directory can be stored as a string with full path or as a name (without path) and parent directory id. The second is probably faster. > > More possible stats: > - Metadata/Directory/file *enthrophy*: times a concept appears in the whole > collection. > I'll check my Artifical Intelligence documents to see if they help in the > work of allowing intuitive navigation. > ( we'll have to see how it threats performance the collection of stats) > > Don't worry, first of all, i'll implement Sqlite database with the main > keys, then we'll always be able to add more. To the implementation, there is a function "filelist_recursive" which is called from pan view to get the file list. It should be changed to use the database and the change-detection algorithm I described before. Files should be added/updated from functions like file_data_new or around. And finally we should decide if we made sqlite a hard requiremet. IMHO we can do it because it is installed on most distributions by default. Vladimir ------------------------------------------------------------------------------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ Geeqie-devel mailing list Geeqie-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geeqie-devel
