Re: [sqlite] Schemas

On 9/27/05, Vivien Malerba <[EMAIL PROTECTED]> wrote: > Hi! > > I'm working on the SQLite interface between the Libgda library and the > SQLite database. For the job, I need to know information about the > database schema, and I'm using the PRAGMA statements regarding > schemas. > > However I

RE: [sqlite] csv .import problems

Here's a little fix I just wrote for an application for a custom format import. The incoming file is a .csv generated by MickeySoft Excel. The code below will scan a text buffer "S" returning a parsed field value. You must maintain a global referenced variable "RP" for retaining the current

Re: [sqlite] any suggestion for the database file extension?mine is xxx.drh

I recommend not using SDB (on windows machines) SQLite DataBase sounded like a good name too :) That is the default extension for something called "Appfix Package" and in certain circumstances, Windows will automatically back the DB up every time it is changed thinking that a DLL or

[sqlite] csv .import problems

2 problems when importing data in sqlite3 with .import: 1. It leaves quotes in. If data field is enclosed in quotes, they are 'doubled'. (As reported in this list on Feb 16th) 2. When a string contains a comma, it is interpreted as separator, and an error is issued, of the type -"4 fields

Re: [sqlite] Using SQL and direct BTree interface to SQLite

I was also looking to do something similar with tabular type data that exists in my application and create "synthetic" Sqlite tables without actually populating the Sqlite database. i.e., I just wanted to leverage the excellent SQL select engine of Sqlite to query the transient data that is

RE: [sqlite] Using SQL and direct BTree interface to SQLite

> Perhaps the use of EXPLAIN would show the way to implement > certain types > of common accesses I expect to be done frequently, such as > inserting one > row, selecting one row using a unique key or updating one > row. Then I > could correlate the virtual machine instructions with >

[sqlite] [OFF TOPIC] How to unsubscribe the mailing list?

Thanks, Cláudio Leopoldino __ Faça ligações para outros computadores com o novo Yahoo! Messenger http://br.beta.messenger.yahoo.com/

Re: [sqlite] Using SQL and direct BTree interface to SQLite

D. Richard Hipp wrote: On Tue, 2005-09-27 at 09:36 -0600, Brian Roe wrote: I'm interested in using SQLite both at the SQL and BTree levels in an application. That is, I would like to create tables and be able to run queries using SQL while also inserting into, querying and updating

Re: [sqlite] Using SQL and direct BTree interface to SQLite

On Tue, 2005-09-27 at 09:36 -0600, Brian Roe wrote: > I'm interested in using SQLite both at the SQL and BTree levels in an > application. That is, I would like to create tables and be able to run > queries using SQL while also inserting into, querying and updating > tables directly via the

Re: [sqlite] Issue with sqlite3_result_error inside aggregatefunction

On Tue, 2005-09-27 at 08:33 -0700, Roger Binns wrote: > > You should not call sqlite3_result_* from within the step > > function of an aggregate. Those routines may be called from > > within the finalizer function only. > > So what should I do if an error occurs? Since I am ultimately > running

[sqlite] Using SQL and direct BTree interface to SQLite

Hello. I'm interested in using SQLite both at the SQL and BTree levels in an application. That is, I would like to create tables and be able to run queries using SQL while also inserting into, querying and updating tables directly via the BTree-level C API calls (thus bypassing the SQL

Re: [sqlite] Issue with sqlite3_result_error inside aggregatefunction

You should not call sqlite3_result_* from within the step function of an aggregate. Those routines may be called from within the finalizer function only. Could you add some sort of assertion so that it is caught if the functions are called? So what should I do if an error occurs? Since I am

Re: [sqlite] How to cross compile sqlite-3.2.7 for arm9 s3c2410?

> I have downloaded sqlite-3.2.7.tar.gz from Internet, but I do not know how > to compile it on s3c2410(linux 2.6, arm9, samsung)? There's some info in the wiki on it, but basically the steps are: 1. change the configure script (see attached patch for 3.2.6) 2. configure with something like

Re: [sqlite] compression

If you're on Linux read about the Reiser 4 file system. They found they could compress the entire file system on the fly and achieve higher performance as well. Most CPU's can compress and move data faster because they make up the difference on the slow I/O channels to hard disks. Might be a much

Re: [sqlite] any suggestion for the database file extension?mine is xxx.drh

Hi, several tools use .db3 (for sqlite3 - Format) Martin Huanghongdong schrieb: >sqlite-users，您好！ > > > >致 >礼！ > > >Huanghongdong >[EMAIL PROTECTED] >　　2005-09-27 > >

Re: Fw: [sqlite] bestIndex with Float values

On Tue, 2005-09-27 at 17:14 +0530, Sankara Narayanan wrote: > A gentle reminder requesting for clarification. If our processor does not > support floating points how do I modify the bestIndex function so that the > functionality is not affected. > (1) Get a compile (such as gcc) that will

RE: [sqlite] any suggestion for the database file extension?mine is xxx.drh

I use .db3 At least one tool, Sqlite3Explorer, assumes that extension if I am not mistaken. Shawn M. Downey MPR Associates 10 Maxwell Drive, Suite 204 Clifton Park, NY 12065 518-371-3983 x3 (work) 860-508-5015 (cell) -Original Message- From: Huanghongdong [mailto:[EMAIL PROTECTED]

Re: [sqlite] Enhancements for SQLite

On 9/27/05, Christopher Petrilli <[EMAIL PROTECTED]> wrote: > > On 9/27/05, Jay Sprenkle <[EMAIL PROTECTED]> wrote: > > > I'm developing an open source project (a Data Access Grid) that > > > uses internally the SQLite library as the storage method and I'm > > > interested in your opinion about 4

Re: [sqlite] Enhancements for SQLite

On Tue, 2005-09-27 at 13:40 +0200, Joxean Koret wrote: > Why not use mmap, munmap, mprotect, mlock, etc... system calls? > You ever tried to mmap a 10GiB database file into the memory of processor with a 4GiB address space? -- D. Richard Hipp <[EMAIL PROTECTED]>

Re: [sqlite] Enhancements for SQLite

On 9/27/05, Jay Sprenkle <[EMAIL PROTECTED]> wrote: > > I'm developing an open source project (a Data Access Grid) that > > uses internally the SQLite library as the storage method and I'm > > interested in your opinion about 4 questions: > > > > 1) SQLite can't deal with raw devices. Should be

[sqlite] How to cross compile sqlite-3.2.7 for arm9 s3c2410?

I have downloaded sqlite-3.2.7.tar.gz from Internet, but I do not know how to compile it on s3c2410(linux 2.6, arm9, samsung)? There is no useful tips in README or INSTALL, pls help me. Thx. -- 我现在使用Sogou.com的2G邮箱了，你也来试试吧!

[sqlite] any suggestion for the database file extension?mine is xxx.drh

sqlite-users，您好！ 致 礼！ Huanghongdong [EMAIL PROTECTED] 　　2005-09-27

Re: [sqlite] Assertion failure in btree.c, line 1166

Richard, Thanks for looking into this. It's actually compiled into PySQLite so I can't determine it directly. I'll ask on the PySQLite mailing list. Hugh > *Subject:* Re: [sqlite] Assertion failure in btree.c, line 1166 > *From:* "D. Richard Hipp" <[EMAIL PROTECTED]> > *To:* [EMAIL PROTECTED]

[sqlite] Schemas

Hi! I'm working on the SQLite interface between the Libgda library and the SQLite database. For the job, I need to know information about the database schema, and I'm using the PRAGMA statements regarding schemas. However I can't find the information about the AUTO INCREMENT attribute of a

Fw: [sqlite] bestIndex with Float values

Hi, A gentle reminder requesting for clarification. If our processor does not support floating points how do I modify the bestIndex function so that the functionality is not affected. Please advise. Thank you, With Regards, Sankara Narayanan Philips Innovation Campus No 1, Murphy Road,

[sqlite] Enhancements for SQLite

Hi list! I'm developing an open source project (a Data Access Grid) that uses internally the SQLite library as the storage method and I'm interested in your opinion about 4 questions: 1) SQLite can't deal with raw devices. Should be hard to patch the source to deal with raw devices?

Re: [sqlite] SQL Queries

Thanks Eric, That's exactly what the issue was, and it all works like a treat now. After about 4 hours I have managed to remove my Access Database and now have a far better solution, I'm impressed! Regards, Chris - Original Message - From: "Eric Bohlman" <[EMAIL PROTECTED]>

Re: [sqlite] Issue with sqlite3_result_error inside aggregate function

On Mon, 2005-09-26 at 23:16 -0700, Roger Binns wrote: > I am seeing a process go down. The issue is happening if > sqlite3_result_error is called from within the implementation > of an aggregate function during a step. The stack trace looks like this > (against 3.2.7 code): > You should not

[sqlite] Issue with sqlite3_result_error inside aggregate function

I am seeing a process go down. The issue is happening if sqlite3_result_error is called from within the implementation of an aggregate function during a step. The stack trace looks like this (against 3.2.7 code): ==2378== Conditional jump or move depends on uninitialised value(s) ==2378==