Re: [sqlite] is there any way for create a sqlite blob field with python?

-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

Re: [sqlite] is there any way for create a sqlite blob field with python?

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.

Re: [sqlite] is there any way for create a sqlite blob field with python?

-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

Re: [sqlite] SQLite and Qt

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 >

Re: [sqlite] Avoiding Database Is Locked Error

> 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

Re: [sqlite] issue with v3.6 documentation

-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

Re: [sqlite] BLOB Support

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

Re: [sqlite] Sqlite 3.6.23 string functions do not follow case sensitivity in comparions

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

Re: [sqlite] Sqlite 3.6.23 string functions do not follow case sensitivity in comparions

> 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

Re: [sqlite] BLOB Support

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

[sqlite] Sqlite 3.6.23 string functions do not follow case sensitivity in comparions

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

[sqlite] Memory request

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

Re: [sqlite] is there any way for create a sqlite blob field with python?

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

[sqlite] issue with v3.6 documentation

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

Re: [sqlite] SQLite and Qt

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

Re: [sqlite] Avoiding Database Is Locked Error

> 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

Re: [sqlite] BLOB Support

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

Re: [sqlite] Avoiding Database Is Locked Error

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

Re: [sqlite] is there any way for create a sqlite blob field with python?

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

Re: [sqlite] BLOB Support

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

Re: [sqlite] BLOB Support

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

Re: [sqlite] notify all processes of database modification

> 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

Re: [sqlite] BLOB Support

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

Re: [sqlite] is there any way for create a sqlite blob field with python?

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

Re: [sqlite] Locking issue on NFS filesystem

> 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

Re: [sqlite] BLOB Support

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

Re: [sqlite] create index before or after many inserts?

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

Re: [sqlite] create index before or after many inserts?

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?

Re: [sqlite] BLOB Support

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

Re: [sqlite] BLOB Support

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.

[sqlite] BLOB Support

Hi All, I would like to know more about this BLOB support in SQLite. Some of my queries are: 1. One of my colleague suggested that using BLOB support for storing images in the DB is a good idea, whereas storing AVCHD data(huge size) as blobs is not a good idea. I need a bit more

Re: [sqlite] create index before or after many inserts?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/15/2010 09:33 PM, Jay A. Kreibich wrote: > Contiguous, yes, but the pages may not be in any logical order. > The internal node pages will get shuffled as the tree is built, > meaning you might still have a significant number of seeks.