Re: [sqlite] Sqlite catalog - datebase with pictures

I wrote something similar, the source might be useful to you: -- The PixAddixImage Collector suite: http://groups-beta.google.com/group/pixaddix ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Sqlite catalog - datebase with pictures

'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

Re: [sqlite] Sqlite catalog - datebase with pictures

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-tp16369126p1

Re: [sqlite] Sqlite catalog - datebase with pictures

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

[sqlite] Sqlite catalog - datebase with pictures

? - how to design datebase to scan cd/dvd and make tree layout (Folders, files etc.) ? Thx for any sugestions. -- View this message in context: http://www.nabble.com/Sqlite-catalog---datebase-with-pictures-tp16369126p16369126.html Sent from the SQLite mailing list archive at Nabble.com