Martin Engelschalk wrote: > > Hello Lukasz, > > to insert a picture (or any binary data for that matter), you can read > the data from the file and use sqlite3_bind_blob to insert (or update) it. > When selecting it from the database, use sqlite_column_blob to retrieve > the data and sqlite3_column_bytes to get the length. > > An alternative is to convert the binary data to a string before storing > it in the database. For this you can use base64 - encoding or sonething > like this. > > See > http://www.sqlite.org/capi3ref.html#sqlite3_bind_blob > http://www.sqlite.org/capi3ref.html#sqlite3_column_blob > and the sqlite3_blob* - functions. > > On how to design your database, that would depend on what you are > planning to to and how to use the data. Perhaps you could provide more > information. > > Hope this helps, > Martin > > lukasz p. wrote: >> Hi. >> I would like to write an application wich helps me to manage with my >> cd/dvd >> collections. It will scan all files on cd/dvd add it to a datebase and it >> could also insert pictures (cd/dvd covers). My questions are: >> - is there any possiblity to add in sqlite datebase pictures like gif, >> jpg ? >> - how to design datebase to scan cd/dvd and make tree layout (Folders, >> files >> etc.) ? >> Thx for any sugestions. >> > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >
Thx for help Martin. When I'm scanning my CD/DVD for a files I'll scan all path to it for example: \etc\lilo.conf \etc\x11\xorg.conf and after that I'll be creating tree layout in application, but I don't know is it a good idea maybe there is something simpler. How to keep those data in datebase ? Could it be a blob or string? -- View this message in context: http://www.nabble.com/Sqlite-catalog---datebase-with-pictures-tp16369126p16380197.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
