On 16 Jun 2010, at 7:58am, Navaneeth Sen B wrote:
> 3. What is the difference produced in storing the file inside DB(not
> in blob format) and storing the same file in BLOB format in the DB?
What tool are you expecting to use to store the file inside the DB ?
Simon.
_
Hi Simon,
I am using SQLite.
Thanks
Sen
**
On 6/16/2010 12:40 PM, Simon Slavin wrote:
> On 16 Jun 2010, at 7:58am, Navaneeth Sen B wrote:
>
>
>>3. What is the difference produced in storing the file inside DB(not
>> in blob format) and storing th
On 16 Jun 2010, at 5:04am, Eric Smith wrote:
> Simon Slavin wrote:
>
>> The standard assumption about SQLite is that it's faster to do your
>> INSERTs first, then create the indices. How much of a difference this
>> makes depends on a lot of things.
>
> On what things does it depend?
Not
On 16 Jun 2010, at 5:33am, Jay A. Kreibich wrote:
> On Tue, Jun 15, 2010 at 08:58:22PM -0700, Roger Binns scratched on the wall:
>> On 06/15/2010 07:59 PM, Simon Slavin wrote:
>>> The standard assumption about SQLite is that it's faster to do your INSERTs
>>> first, then create the indices.
>>
On 16 Jun 2010, at 8:14am, Navaneeth Sen B wrote:
> I am using SQLite.
>
> Thanks
> Sen
>
> **
>
> On 6/16/2010 12:40 PM, Simon Slavin wrote:
>> On 16 Jun 2010, at 7:58am, Navaneeth Sen B wrote:
>>
>>> 3. What is the difference produced in storing the fil
> int sqlite3_open_v2(
> const char *filename, /* Database filename (UTF-8) */
> sqlite3 **ppDb, /* OUT: SQLite db handle */
> int flags, /* Flags */
> const char *zVfs/* Name of VFS module to use */
> );
>
> With the last argument "unix-dotfile".
>
>
Does it work
Hi
2010/6/15 Roger Binns
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 06/15/2010 01:46 PM, Fabio Spadaro wrote:
> > I am developing an interface to Python 's SQLite and would it be
> > you can store files in the sqlite database. To do this
> > obviously need to create a blob field b
for some reason, I remember you asking the same question not too long
ago, and getting a bunch of answers. I recall chipping in with an
answer myself. DIdn't any of those answers help?
On Wed, Jun 16, 2010 at 1:58 AM, Navaneeth Sen B
wrote:
> Hi All,
> I would like to know more about this BLOB su
> That is, other than polling, .
Yep, that trick. (Why does everyone dismiss polling...don't we have
any embedded programmers here? Hey Windows CE guy, don't raise your
hand...)
Roger summed it up, and labeled it correctly (crappy). But if it
works sufficiently for him, why not explore
Do some testing to find out if it suits the application you develop.
But just in general .. file systems are build to handle files, databases are
for handle data.
I don't think BLOB in SQlite will increasing the performance compared to
store the files in
the file system.
Some SQlite APIs do not s
On Wed, Jun 16, 2010 at 7:23 AM, Andreas Henningsson
wrote:
> Do some testing to find out if it suits the application you develop.
> But just in general .. file systems are build to handle files, databases are
> for handle data.
>
Well, at the risk of being pedantic, you say files I say data (sun
Hi,
2010/6/16 Fabio Spadaro
> Hi
>
> 2010/6/15 Roger Binns
>
> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> On 06/15/2010 01:46 PM, Fabio Spadaro wrote:
>> > I am developing an interface to Python 's SQLite and would it be
>> > you can store files in the sqlite database. To do this
>
Thank you all for your responses. This discussion has grown a lot more
than I thought it would.
Like I said in my original question, my system is made up of several
programs that communicate by sending messages to each other. I have a
utility program that can send messages to the programs for testi
On Wed, Jun 16, 2010 at 8:34 AM, P Kishor wrote:
> On Wed, Jun 16, 2010 at 7:23 AM, Andreas Henningsson
> wrote:
>> Do some testing to find out if it suits the application you develop.
>> But just in general .. file systems are build to handle files, databases are
>> for handle data.
>>
>
> Well,
> I am not using BEGIN IMMEDIATE, just BEGIN, but I don't think it is a
> problem in my case, since now there really is just one program accessing
> the database.
Did you forget the message this thread was started from? The sqlite3
command line utility is a second program, so this could be a probl
On Tue, Jun 15, 2010 at 7:11 AM, Sylvain Pointeau
wrote:
> Hi,
>
> What is the error?
> did you make a sample project that you could share?
The error was between the keyboard and the chair... Once the SQLite
DLL was moved into the Qt bin directory, all worked as expected.
Thus the answer to my
Morning all,
I recently updated my copy of SQLITE to the v3.6.x line.
Everything appeared to be working just fine and I had no problems until I went
to the documentation to look up the syntax for an SQL command.
Then I noticed that the syntax pages have all changed. No longer is the syntax
for a
Hi,
2010/6/15 Roger Binns
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 06/15/2010 01:46 PM, Fabio Spadaro wrote:
> > I am developing an interface to Python 's SQLite and would it be
> > you can store files in the sqlite database. To do this
> > obviously need to create a blob field b
Hi,
A little question for you...
how is the minumun space required for sqlite3 library ??
I try to compile my application with sqlite3.c file,
but I have some kind of problem of insufficient memory when my application do
"sqlite3_inizialize"
Can you help me ??
thank you so much
Bye
Airpalaz
__
I scanned through the bug list on the website and didn't see one that was
related to this, so please forgive me if this has already been answered.
We have created a function that takes a string and returns a substring that is
split on a given character (I'll provide the source below), called spl
Hello Sam,
I store multiple gigs of image files, some as large as 2-3 megs in
Sqlite DB's. For pretty much the same reason, the convenience of
having them in one package. For my requirements, extracting the images
from the DB, and displaying them isn't a bottleneck. It's fast enough.
Search speed
> Is this working as designed and the 3.0.8 behavior was incorrect? Or is this
> a valid bug?
I'm not developer of SQLite and don't know what did they intend to do.
But applying common sense I'd say that behavior of 3.0.8 was incorrect
and it's fixed in 3.6.23. To get the same result as you used
On Tue, Jun 15, 2010 at 03:46:17PM -0700, Jeff Webb scratched on the wall:
> Is this working as designed and the 3.0.8 behavior was incorrect?
It sounds like it. Collations are typically not "promoted" through
operations. Having one promoted from a function parameter to the
result seems
On Wed, Jun 16, 2010 at 10:04 AM, Teg wrote:
> Hello Sam,
>
> I store multiple gigs of image files, some as large as 2-3 megs in
> Sqlite DB's. For pretty much the same reason, the convenience of
> having them in one package. For my requirements, extracting the images
> from the DB, and displaying
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA512
Clone the latest fossil source at:
http://www.sqlite.org/docsrc
and open art/syntax/all-bnf.html. I had the same problem a while
back, and someone kindly created that file. You might be able to
access it from the website, but the anonymous login is p
> I'm running on SCO OpenServer so I'm not
sure your product would work for me but I'll take a look
StepSqlite compiler's Linux target generates shared objects (.so) that
should work on virtually all Unix-like systems thanks to ELF format.
As an aside, further in SQLite exploration you may find i
On Wed, Jun 16, 2010 at 3:42 PM, Sam Carleton
>
> The error was between the keyboard and the chair... Once the SQLite
> DLL was moved into the Qt bin directory, all worked as expected.
>
> :-)
> Thus the answer to my question would seem to be: Qt will simply use
> the SQLite3.lib you give it,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/16/2010 04:14 AM, Fabio Spadaro wrote:
> But the next time I select a single line instead of two:
> fetchall [( 0x02CC2A30>,)]
>
> What's wrong.
Errr, nothing. Blobs are returned as buffers too. (This way you can
distinguish them from
Hi,
2010/6/16 Roger Binns
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 06/16/2010 04:14 AM, Fabio Spadaro wrote:
> > But the next time I select a single line instead of two:
> > fetchall [( > 0x02CC2A30>,)]
> >
> > What's wrong.
>
> Errr, nothing. Blobs are returned as buff
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/16/2010 11:35 AM, Fabio Spadaro wrote:
> You can also determine the path and file name from the blob or should I
> create a column attached with this information stored?
You are overthinking this. A blob is just a collection of bytes in the sam
30 matches
Mail list logo