For file-to-database path, don't use QPixmap or QImage or anything like
that. Use QFile::readAll to read bytes from file into a QByteArray, then
QByteArray::data() and sqlite3_bind_blob (or equivalent in your SQLite
wrapper, which I'm not familiar with) to bind the data to a SQL statement.
Whe
On Nov 6, 2013, at 8:00 PM, Richard Hipp wrote:
> See http://www.sqlite.org/whentouse.html#appfileformat for further thoughts
> on this. SQLite is commonly used as an application file format. In such
> cases, it is entirely appropriate to store content files directly in the
> database, rather
On Wed, Nov 6, 2013 at 1:54 PM, Petite Abeille wrote:
>
> On Nov 6, 2013, at 7:42 PM, Ulrich Goebel wrote:
>
> > Every hint is welcome!
>
> Don't store your files in the database. Store them on the file system, as
> the Almighty intended. Much simpler and flexible altogether.
>
> Perhaps of inte
On Nov 6, 2013, at 7:42 PM, Ulrich Goebel wrote:
> Every hint is welcome!
Don't store your files in the database. Store them on the file system, as the
Almighty intended. Much simpler and flexible altogether.
Perhaps of interest:
http://www.sqlite.org/intern-v-extern-blob.html
Hallo again,
now I have to handle pictures. In a SQLite database I would like to save
pictures from people. So I made a table
CREATE table pictures (id integer, pic blob)
With PyQT4 I build a formular where I want to show the pictures. (In
fact the formular shows data from a person, and even
5 matches
Mail list logo
