FROM : Bill Bumgarner
DATE : Sun Nov 04 17:59:29 2007
On Nov 4, 2007, at 8:37 AM, Benjámin Salánki wrote:
> On Nov 3, 2007, at 11:58 PM, Ben Trumbull wrote:
>>> My problem is, that if I include a huge amount of data like an
>>> uncompressed image that will swell the SQLite file to 72MB,
>>
>> Generally, large media files should be stored externally to the
>> database, and a URI and metadata for it stored in a database record.
>
> I know, I was just testing to see if larger amounts of data would
> make any difference.
Not really -- you were testing whether or not a SQLite based backing
store is appropriate for storing large BLOBs of data; it is not.
Which does nothing to answer the question as to whether or not a
SQLite based backing store is appropriate for storing large quantities
of small data values (typical non-binary fields of data); which it
very much is....
b.bum
DATE : Sun Nov 04 17:59:29 2007
On Nov 4, 2007, at 8:37 AM, Benjámin Salánki wrote:
> On Nov 3, 2007, at 11:58 PM, Ben Trumbull wrote:
>>> My problem is, that if I include a huge amount of data like an
>>> uncompressed image that will swell the SQLite file to 72MB,
>>
>> Generally, large media files should be stored externally to the
>> database, and a URI and metadata for it stored in a database record.
>
> I know, I was just testing to see if larger amounts of data would
> make any difference.
Not really -- you were testing whether or not a SQLite based backing
store is appropriate for storing large BLOBs of data; it is not.
Which does nothing to answer the question as to whether or not a
SQLite based backing store is appropriate for storing large quantities
of small data values (typical non-binary fields of data); which it
very much is....
b.bum
| Related mails | Author | Date |
|---|---|---|
| Benjámin Salánki | Nov 1, 10:04 | |
| Adam Swift | Nov 1, 23:40 | |
| Benjámin Salánki | Nov 1, 23:53 | |
| Chris Hanson | Nov 2, 03:04 | |
| Benjámin Salánki | Nov 3, 21:09 | |
| Ben Trumbull | Nov 3, 23:58 | |
| Benjámin Salánki | Nov 4, 17:37 | |
| Bill Bumgarner | Nov 4, 17:59 |






Cocoa mail archive

