Re: [sqlite] wrong version number when compiled

hmmm ... Maybe try hash -r (man bash) HTH -- kjh On 11/23/2007 04:47 PM, Jonathan Otsuka wrote: On Nov 23, 2007, at 4:31 PM, Xabriel J Collazo Mojica wrote: Guys: Thank you all for your quick replies! As P Kishor suggested, I restarted the mac and guess what? It now reports the cor

Re: [sqlite] Re: A valid SQL fails with SQLite

On Fri, 23 Nov 2007 18:47:40 +0100, <[EMAIL PROTECTED]> wrote: >Btw, what would be the best GUI to use? I am happy with SQLite3Explorer. http://www.sqlite.org/cvstrac/wiki?p=ManagementTools http://www.singular.gr/sqlite/ HTH -- ( Kees Nuyt ) c[_] -

Re: [sqlite] wrong version number when compiled

On Nov 23, 2007, at 4:31 PM, Xabriel J Collazo Mojica wrote: Guys: Thank you all for your quick replies! As P Kishor suggested, I restarted the mac and guess what? It now reports the correct version. So yes, there is some kind of caching somewhere. I'll try to search a little more on this

Re: [sqlite] wrong version number when compiled

Turns out that bash does implement some kind of caching... this may also be known as keyseq binding. See Of course, the canonical bash docs at are more than copious. Don't know why you suddenly got

Re: [sqlite] wrong version number when compiled

Guys: Thank you all for your quick replies! As P Kishor suggested, I restarted the mac and guess what? It now reports the correct version. So yes, there is some kind of caching somewhere. I'll try to search a little more on this caching behaviour and get back to you so that it gets documented. I

Re: [sqlite] wrong version number when compiled

Xabriel J Collazo Mojica wrote: As mentioned previously my PATH is all right: xabita:/ xabriel$ echo $PATH /usr/local/bin:/usr/local/sbin:/usr/local/mysql/bin:/bin:/sbin:/usr/bin:/usr/sbin Sorry, I didn't read this before I posted. You might benefit from otool, though, to see what librari

Re: [sqlite] wrong version number when compiled

P Kishor wrote: On Nov 23, 2007 3:56 PM, Xabriel J Collazo Mojica <[EMAIL PROTECTED]> wrote: You're right! I tried /usr/local/bin/sqlite3 -version an it reports the correct version 3.5.2: xabita:/ xabriel$ /usr/local/bin/sqlite3 -version 3.5.2 [snip] Does anyone know if there's any

Re: [sqlite] wrong version number when compiled

On Nov 23, 2007, at 3:56 PM, Xabriel J Collazo Mojica wrote: You're right! I tried /usr/local/bin/sqlite3 -version an it reports the correct version 3.5.2: xabita:/ xabriel$ /usr/local/bin/sqlite3 -version 3.5.2 I cannot remove the old one as I know some Mac programs (Mail, Safari, ...)

Re: [sqlite] wrong version number when compiled

"Xabriel J Collazo Mojica" <[EMAIL PROTECTED]> wrote: > > I cannot remove the old one as I know some Mac programs (Mail, Safari, ...) > depend on it. > > Does anyone know if there's any other variable I should flush / reset / > anything to get sqlite3 3.5.2 as the default? > I routinely build e

Re: [sqlite] wrong version number when compiled

On Nov 23, 2007 3:56 PM, Xabriel J Collazo Mojica <[EMAIL PROTECTED]> wrote: > You're right! I tried /usr/local/bin/sqlite3 -version an it reports the > correct version 3.5.2: > > xabita:/ xabriel$ /usr/local/bin/sqlite3 -version > 3.5.2 > > I cannot remove the old one as I know some Mac programs (

Re: [sqlite] wrong version number when compiled

You're right! I tried /usr/local/bin/sqlite3 -version an it reports the correct version 3.5.2: xabita:/ xabriel$ /usr/local/bin/sqlite3 -version 3.5.2 I cannot remove the old one as I know some Mac programs (Mail, Safari, ...) depend on it. Does anyone know if there's any other variable I should

Re: [sqlite] wrong version number when compiled

On Nov 22, 2007, at 8:52 PM, Xabriel J Collazo Mojica wrote: Hi all: I've just downloaded, compiled and installed SQLite3 3.5.2 on my mac. Everything is working fine but the version number. I know OS X 10.4 comes with SQLite built-in on /usr/bin. I installed 3.5.2 on /usr/local and updated

Re: [sqlite] Re: sqlite3_get_table question

Igor Tandetnik wrote: Martin Pelletier wrote: Is there a similar function that would place the result of a query in memory just like SQL3_get_table but their stored type (integer, float, etc), with perhaps a header to indicate what type the data should be read as? With SQLite's manifest

[sqlite] Re: How to reset errcode

Igor Sereda <[EMAIL PROTECTED]> wrote: From API docs: [quote] The sqlite3_errcode() interface returns the numeric result code or extended result code for the most recent failed sqlite3_* API call associated with sqlite3 handle 'db'. If a prior API call failed but the most recent API call succeed

[sqlite] Re: sqlite3_get_table question

Martin Pelletier wrote: I am using an SQLite to host data for various projects, some of which take up significant place with some large monolithic tables (around 750 MB). Querying goes through the DLL using a call to SQLite3_get_table. The function allocates memory space to record the table in

[sqlite] sqlite3_get_table question

Hello, I am using an SQLite to host data for various projects, some of which take up significant place with some large monolithic tables (around 750 MB). Querying goes through the DLL using a call to SQLite3_get_table. The function allocates memory space to record the table in chars, even if

Re: [sqlite] Re: A valid SQL fails with SQLite

On Nov 23, 2007 11:47 AM, <[EMAIL PROTECTED]> wrote: > Yes, you are right, I just tested it in another GUI myself. It is the GUI's > fault (SQLite Studio), which I found on the list on the SQLite site. > > Damn, I would never have suspected the GUI. I would have thought that it > would just rerout

Re: [sqlite] Re: A valid SQL fails with SQLite

Yes, you are right, I just tested it in another GUI myself. It is the GUI's fault (SQLite Studio), which I found on the list on the SQLite site. Damn, I would never have suspected the GUI. I would have thought that it would just reroute whatever text I type in to the commandline... They must ha

[sqlite] How to reset errcode

>From API docs: [quote] The sqlite3_errcode() interface returns the numeric result code or extended result code for the most recent failed sqlite3_* API call associated with sqlite3 handle 'db'. If a prior API call failed but the most recent API call succeeded, the return value from sqlite3_err

[sqlite] Re: A valid SQL fails with SQLite

[EMAIL PROTECTED] wrote: As you can see, the same color (the last one, emissive) will be the result for ALL colors. It seems as if your SQL-interpreter cannot handle multiple definitions of the same table (aliased with AS) in the FROM-clause? Everything works correctly for me with sqlite3 com

[sqlite] A valid SQL fails with SQLite

hello mailing list It is the first time I do something like this, so I hope I do it right :) (the database can be downloaded, and the SQL can be cut/pasted - see bottom) Here is the structure and the data: http://www.mercenaries.ws/db_data.jpg http://www.mercenaries.ws/db_structure.jpg --

Re: [sqlite] Optimizing Application - SQLite Connection Creation/Sharing

On Nov 23, 2007 2:19 PM, Sabyasachi Ruj <[EMAIL PROTECTED]> wrote: > I have an application that uses SQLite extensively. > In a part of that application, I need to do the following steps:- > 1. I need to create a thread per request basis. > 2. Open SQLite connection. > 3. Th

Re: [sqlite] Optimizing Application - SQLite Connection Creation/Sharing

On 11/23/07, Sabyasachi Ruj <[EMAIL PROTECTED]> wrote: > I have an application that uses SQLite extensively. > In a part of that application, I need to do the following steps:- > 1. I need to create a thread per request basis. > 2. Open SQLite connection. > 3. Then retrieve

Re: [sqlite] benchmarking UTF8 vs UTF16 encoded databases

On Nov 23, 2007 1:56 PM, Igor Sereda <[EMAIL PROTECTED]> wrote: > > About the endieness, you don't need to know if you > > don't care. SQLite handles it. > > SQLite does handle that, but what would be the performance loss when working > with a UTF-16 encoded database, but with endianness opposite t

[sqlite] Re: (瑞星提示-此邮件可能是垃圾邮件)[sqli te] Who has the sqlite3.dll and lib for version 3_3_14 for windows

I think you didn`t add sqlite3.def to your project. try again~ :) - Original Message - From: "learning Sqlite3" <[EMAIL PROTECTED]> To: Sent: Friday, November 23, 2007 5:08 PM Subject: (瑞星提示-此邮件可能是垃圾邮件)[sqlite] Who has the sqlite3.dll and lib for version 3_3_14 for windows > > Hel

Re: [sqlite] benchmarking UTF8 vs UTF16 encoded databases

"Igor Sereda" <[EMAIL PROTECTED]> writes: >> About the endieness, you don't need to know if you >> don't care. SQLite handles it. Does SQLite really handle that? or does SQLite just delegate the handling to the underlying OS, which in turn delegates the handling to the underlying Hardware. If it

[sqlite] Optimizing Application - SQLite Connection Creation/Sharing

I have an application that uses SQLite extensively. In a part of that application, I need to do the following steps:- 1. I need to create a thread per request basis. 2. Open SQLite connection. 3. Then retrieve data from SQLite and do some calculation. 4. Construct th

RE: [sqlite] benchmarking UTF8 vs UTF16 encoded databases

> About the endieness, you don't need to know if you > don't care. SQLite handles it. SQLite does handle that, but what would be the performance loss when working with a UTF-16 encoded database, but with endianness opposite to the system? That's quite probable scenario, say, a database created on

Re: [sqlite] Who has the sqlite3.dll and lib for version 3_3_14 for windows

Open your VS2005 command prompt, type: Lib /def:sqlite3.def it will generate proper sqlite3.lib for you. /Mike/ learning Sqlite3 wrote: > Hello, > > Who have the sqlite3.dll and sqlite3.lib of version 3_3_14 for windows. > > I created them wtih visual studio 2005. But they did not work. > > Or t

Re: [sqlite] benchmarking UTF8 vs UTF16 encoded databases

On 11/23/07, Jarl Friis <[EMAIL PROTECTED]> wrote: > Hi Daniel. > > Thanks for the benchmark reports, interesting studies. > > Another reason to stay away from utf-16 is that it is not endianess > neutral. Which raise the question are you storing in UTF-16BE or > UTF-16LE ? If you only speak Japan

Re: [sqlite] Sqlite version for libc 2.1.3

Look in LFS (Linux From Scratch) on how to create a cross-compiler that you can chroot into before the compile. It makes sure only the libraries you installed are the ones your binaries will link to. It should be an easy easy, but quite frankly haven't found it yet (and I am cross-compiling to the

Re: [sqlite] rollback fails incomprehencibly

Hi, Statements will be in progress until you issue an sqlite_reset or sqlite_finalize on them. I don't know why rollback doesn't take care of this; perhaps someone will explain, Rgds, Simon On 23/11/2007, ??? <[EMAIL PROTECTED]> wrote: > Hi all... > > Explain me something please. C

[sqlite] rollback fails incomprehencibly

Hi all... Explain me something please. Consider scenario: Connection 1: begin Connection 1: update... Connection 2: begin Connection 2: update... -> SQLITE_BUSY Connection 2: rollback -> "cannot rollback transaction - SQL statements in progress" Why didn't rollback work? How can I cancel

Re: [sqlite] benchmarking UTF8 vs UTF16 encoded databases

Hi Daniel. Thanks for the benchmark reports, interesting studies. Another reason to stay away from utf-16 is that it is not endianess neutral. Which raise the question are you storing in UTF-16BE or UTF-16LE ? Jarl - T

[sqlite] Who has the sqlite3.dll and lib for version 3_3_14 for windows

Hello, Who have the sqlite3.dll and sqlite3.lib of version 3_3_14 for windows. I created them wtih visual studio 2005. But they did not work. Or tell me how I can create them with visual studio 2005 porperly? Thanks! _ Invite you

Re: [sqlite] Sqlite version for libc 2.1.3

Thanks for your response, Trevor. It is what I had initially thought too, that if I built it with an older set of libraries it will look for those versions at runtime too. But these libs versions seem to be inbuilt. I cannot seem to change the sqlite-v3.5.2 dependency on the specific versions of l