Re: [sqlite] Am I understanding Blobs correctly?

Mike McGonagle wrote: > I have never used Blobs before, and in reading some of the literature, > I am just a bit confused. From what I am understanding, I get the > impression that a Blob is no more than the binary data from a disk > file, stored as a string of bytes in a field of the database. >

Re: [sqlite] Am I understanding Blobs correctly?

On Jan 27, 2009, at 8:56 AM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Mike McGonagle wrote: >> From what I am understanding, I get the >> impression that a Blob is no more than the binary data > > Binary large object. I came across this the other day:

Re: [sqlite] Am I understanding Blobs correctly?

On 1/26/09, Mike McGonagle wrote: > Thanks, the datatypes are going to be varied, but I am sure the sizes > are the things I need to consider. I am not totally sure what you mean by "datatypes are going to be varied." The datatype for all the entries is going to be "blob."

Re: [sqlite] Am I understanding Blobs correctly?

Thanks, the datatypes are going to be varied, but I am sure the sizes are the things I need to consider. Mike On Mon, Jan 26, 2009 at 8:27 PM, P Kishor wrote: > If you have a lot of tiny images, especially if the images can be > smaller than a page size in the db, then

Re: [sqlite] INNER JOIN, JOIN Confusin

"Cnichols" wrote in message news:21676221.p...@talk.nabble.com > What i am trying to do right now is select the questions that have > been asked for the current session (ie 7) > Stats - contains 46 rows with sessionid of 7 > Temp - holds 52 missed questions from the previous

Re: [sqlite] Am I understanding Blobs correctly?

On 1/26/09, Mike McGonagle wrote: > Hello all, > > I have never used Blobs before, and in reading some of the literature, > I am just a bit confused. From what I am understanding, I get the > impression that a Blob is no more than the binary data from a disk > file, stored

Re: [sqlite] INNER JOIN, JOIN Confusin

On 27/01/2009 12:00 PM, Cnichols wrote: > I have stumped myself with this sql goal. > > With this statement I am working with 3 tables > Stats - contains question asked history and if it was answered correcty > sessionid > questionid > correct > Questions - contains a list questions and mul

Re: [sqlite] Am I understanding Blobs correctly?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mike McGonagle wrote: > From what I am understanding, I get the > impression that a Blob is no more than the binary data Binary large object. Large is by comparison to other typical data in a database. For example numbers are typically up to 10

[sqlite] Am I understanding Blobs correctly?

Hello all, I have never used Blobs before, and in reading some of the literature, I am just a bit confused. From what I am understanding, I get the impression that a Blob is no more than the binary data from a disk file, stored as a string of bytes in a field of the database. Basically, I am

[sqlite] INNER JOIN, JOIN Confusin

I have stumped myself with this sql goal. With this statement I am working with 3 tables Stats - contains question asked history and if it was answered correcty sessionid questionid correct Questions - contains a list questions and mul choice answers and answer id - pk .

Re: [sqlite] Progress update while Prepare() is executing

On Mon, 26 Jan 2009 10:44:12 -0600, Nicolas Williams wrote in General Discussion of SQLite Database : >On Sun, Jan 25, 2009 at 01:32:57PM +0100, Kees Nuyt wrote: [...] >> To get a % progress indicator you need a more or less >> accurate

Re: [sqlite] Smaller issues with transactions in "undefined mode"

"D. Richard Hipp" schrieb im Newsbeitrag news:f6c1943c-f8ef-400a-800a-4afb2013f...@hwaci.com... > > This forgotten switch was causing a JournalMode = Off. > > > > Later on Transactions were used inside the Copy-over- > > process from FireBird. >

Re: [sqlite] commit causes error - why?

Vance E. Neff wrote: > I'm having trouble on the "COMMIT TRANSACTION" Query. > > I seem, for some reason, to be violating a SQLite rule. > > This is from a language called RUN BASIC. > > Here is the test program, note that "" translates to a single " and > the print

Re: [sqlite] Smaller issues with transactions in "undefined mode"

On Jan 26, 2009, at 12:03 PM, Olaf Schmidt wrote: > > This forgotten switch was causing a JournalMode = Off. > > Later on Transactions were used inside the Copy-over- > process from FireBird. > > And that is, what I mean with "undefined mode" - > Journal-Mode=Off and nonetheless "transactions >

[sqlite] Smaller issues with transactions in "undefined mode"

Hi Devs, This is not really a "bug-report", but I want to mention it nonetheless, since engine-crashes are probably not what should be left unhandled, regardless if the user tries to use the engine in an undefined-mode. Let me explain: Background: Platform Windows. StdCall-compile of the

Re: [sqlite] Progress update while Prepare() is executing

On Sun, Jan 25, 2009 at 01:32:57PM +0100, Kees Nuyt wrote: > If the replace statement is the same every time, you only > have to prepare it once. As drh said, to be able to help you > more, we need the schema and more detailed code. > > prepare() > begin() > while data_available{ > bind()

Re: [sqlite] Progress update while Prepare() is executing

On Sun, Jan 25, 2009 at 01:32:57PM +0100, Kees Nuyt wrote: > The progress indicator of both REPLACE and SELECT can be > driven by the while { step() } loops in your program. > A progress callback is not of much use here, except for the > first step(), because the first step() returns after any >

[sqlite] commit causes error - why?

I'm having trouble on the "COMMIT TRANSACTION" Query. I seem, for some reason, to be violating a SQLite rule. This is from a language called RUN BASIC. Here is the test program, note that "" translates to a single " and the print statements are just for this demo: [code] CLS PRINT "Start"

Re: [sqlite] codepages

"Sherief N. Farouk" schrieb im Newsbeitrag news:000301c97e09$2556f0f0$7004d2...@com... > > dear users > > I use sqlite for vb6, utf-8 database, > > when insert arabic data to database > > and search it with 'like' operator > > (within % syntax), return all records!!! > >

Re: [sqlite] codepages

Sherief N. Farouk writes: > > > dear users > > I use sqlite for vb6, utf-8 database, > > when insert arabic data to database > > and search it with 'like' operator > > (within % syntax), return all records!!! > > Please help me... > > thanks > > John Smith > >

Re: [sqlite] What is the advantage of using native c API over ODBC

goldy writes: > > Hi All, > > What are the basic advantage of using SQLite with C API over ODBC. Whereas the advantage of ODBC is having the same(?) interface to different database systems. Horses for courses ... MikeW ___

Re: [sqlite] How many tables can a database hold?

J. R. Westmoreland writes: > > Can someone tell me how many tables a given database can hold. > > I'm looking at an initial design of an application that could have a table > of data for each city in a state. This could be possibly more than a > thousand tables. > > With that many

Re: [sqlite] problem with view

On 1/26/09, MEVEL Marie (PDL/ELOG PDL) wrote: > Hello. I use SQlite and i create a database since 3 week. I'm never > have problem but yesterday, i consult my database and one table doesn't > want to show it. When i want to see data to this table, the message is : >

Re: [sqlite] Lock SQLite file by overwriting bytes and then un-lock?

Thanks; will do that. RBS -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of MikeW Sent: 26 January 2009 12:02 To: sqlite-users@sqlite.org Subject: Re: [sqlite]Lock SQLite file by overwriting bytes and then un-lock? RB

Re: [sqlite] Lock SQLite file by overwriting bytes and then un-lock?

RB Smissaert writes: > > Thanks for the tip, but does that work on a Windows Mobile device? > > RBS Don't know - also look at http://www.freeotfe.org/ (Google: encrypted files windows mobile) Cheers, MikeW ___ sqlite-users

Re: [sqlite] Lock SQLite file by overwriting bytes and then un-lock?

Thanks for the tip, but does that work on a Windows Mobile device? RBS -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of MikeW Sent: 26 January 2009 11:40 To: sqlite-users@sqlite.org Subject: Re: [sqlite]Lock SQLite file by

Re: [sqlite] Lock SQLite file by overwriting bytes and then un-lock?

RB Smissaert writes: > > For some reason this mail went to the junk mail folder. > That sounds good and I would be happy to buy this, but I am not sure about: > > All you need to do is replace the DLL > I have number of dll's: > For the desktop: an ActiveX dll and a plain

[sqlite] problem with view

Hello. I use SQlite and i create a database since 3 week. I'm never have problem but yesterday, i consult my database and one table doesn't want to show it. When i want to see data to this table, the message is : "there are no items to show in this view". I search in the internet but i don't