Re: [sqlite] sqlite with emacs (OT)

yes, it works perfect with -interactive. thank you so much! On Wed, Apr 2, 2008 at 11:56 AM, Evans, Mark (Tandem) <[EMAIL PROTECTED]> wrote: > If you are talking about the sqlite3 shell, add -interactive to the command > line. > > Cheers, > Mark > > > > > -Original Message- > > From:

[sqlite] Segmentation fault on database with 2.2 Gb

Hi all, very strange. Today I tried to open a database I created about half a year ago (version 3.?) and I get a segmentation fault. I run a current debian unstable with sqlite3.5.7 and have absolutely no clue what the problem might be! It works with other databases and it worked with that one as

Re: [sqlite] Virtual table used to query big external database

On Wed, Apr 2, 2008 at 11:59 AM, Evans, Mark (Tandem) <[EMAIL PROTECTED]> wrote: > One other consideration: If the query or update has to walk a large > range of rows, there's no way for the core to tell the VTM > that it's done accessing a given row as it sweeps the cursor > forward. You

Re: [sqlite] Exception running javasqlite on kaffe for arm architecture

In case anyone is interested, the cause of the problem was the -fPIC and -DPIC compiler/linker options. You need to remove them for the JNI to run on an arm target. Charlie > Message: 2 > Date: Tue, 01 Apr 2008 14:40:18 -0400 > From: Charlie Hamilton <[EMAIL PROTECTED]> > Subject: [sqlite]

Re: [sqlite] limts change with switch from bit maps to vectors?

On Apr 2, 2008, at 11:57 PM, Shane Harrelson wrote: > Is the limit of 64 tables in a join changed now that it's using "bit > vectors" instead of "bit maps"? Similar on number of attached > databases? > > Or were the changes only to the bitmaps used for page tracking? Only the dirty-page

Re: [sqlite] Virtual table used to query big external database

Hi Ben, You said: "You will notice that for certain queries, xBestIndex/xFilter does not get used. That means that the SQLite engine is going to have to walk through your entire table, evaluating the conditions on each field." I am not aware of this behavior. Could you cite an example? I

[sqlite] limts change with switch from bit maps to vectors?

Is the limit of 64 tables in a join changed now that it's using "bit vectors" instead of "bit maps"? Similar on number of attached databases? Or were the changes only to the bitmaps used for page tracking? http://www.sqlite.org/limits.html -Shane ___

Re: [sqlite] sqlite with emacs (OT)

If you are talking about the sqlite3 shell, add -interactive to the command line. Cheers, Mark > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Derrell Lipman > Sent: Wednesday, April 02, 2008 9:36 AM > To: General Discussion of SQLite Database >

[sqlite] sqlite3_interrupt and transactions

Greetings! I need to be able to interrupt a long-running query within a transaction. The question is: is it possible that changes made previously in this transaction will be affected? Example pseudo-code: 1. BEGIN IMMEDIATE 2. INSERT INTO x (x) VALUES ('y'); 3. SELECT long_running_query

Re: [sqlite] sqlite with emacs (OT)

On Wed, Apr 2, 2008 at 10:30 AM, Wensui Liu <[EMAIL PROTECTED]> wrote: > good morning, all, > when i tried to use sqlite in emacs with shell mode, it doesn't work. > is there a interface for sqlite in emacs / xemacs? > I use sqlite in emacs shell mode all the time. What problem are you

[sqlite] sqlite with emacs (OT)

good morning, all, when i tried to use sqlite in emacs with shell mode, it doesn't work. is there a interface for sqlite in emacs / xemacs? thanks. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Virtual table used to query big external database

Here's a link to the source: ftp://66.77.27.238/sourcecode/ddj/2007/0712.zip BTW, I totally missed the new bitvec recently introduced in the latest version to track dirty pages. This pretty much removes the previous constraints I mentioned on large databases, reducing memory consumption to

Re: [sqlite] Virtual table used to query big external database

Thank you. That's exactly the mistake I did :-)> Date: Wed, 2 Apr 2008 09:11:44 -0400> From: [EMAIL PROTECTED]> To: sqlite-users@sqlite.org> Subject: Re: [sqlite] Virtual table used to query big external database> > Hi, Aladin,> > Regarding: > "Do you know where I can get the files "fs.c" and

Re: [sqlite] Virtual table used to query big external database

Hi, Aladin, Regarding: "Do you know where I can get the files "fs.c" and "example.c" you mention? [ http://www.ddj.com/database/202802959 ] I've been on the FTP (available from www.ddj.com/code/) but I was not able to locate..." The code appears to be in the December 2007 (0712.zip) file,

Re: [sqlite] Trigger's actions and callbacks

> > Thanks. But I am experiensing some problems here. When I am using > the same > connection (I store it as third parameter to callback registering > function > > sqlite3_update_hook(db, Callback, db); > > and when trying to access to the db inside callback > >

Re: [sqlite] Trigger's actions and callbacks

"Vladimir Volkov" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] >>> sqlite_update_hook() returnes rowID, but I didn't >>> find any API to use this value... > >> You just run a statement along the lines of > >> select * from dbName.tableName where rowid=? > >> You need to run this

Re: [sqlite] Trigger's actions and callbacks

>If you are trying to use a different connection, you would only see >changes once the first connection committed its transaction - so don't >do that. >> sqlite_update_hook() returnes rowID, but I didn't >> find any API to use this value... >You just run a statement along the lines of

Re: [sqlite] Virtual table used to query big external database

Thanks a lot Mike for your detailed answer! I've just read your acticle. Do you know where I can get the files "fs.c" and "example.c" you mention? I've been on the FTP (available from www.ddj.com/code/) but I was not able to locate any file related to your article :( Could you please send them