Re: [sqlite] ambiguous columns with natural join

On Wed, Jan 21, 2009 at 01:37:39PM +0100, Emil Obermayr wrote: > I am not sure what the standard says, but I am used to single columns > after a natural join. So if table a and b are joined through column c > the following statement is valid: > > select c from a natural join b; bad example,

[sqlite] temporay file

my query take hundreds of MB temporary file if i execute this query. why sqlite make enourmous big temporary table. my table in only 9 MB and have 12000 row. then i compare with mysql again, it's not make big temp table too much. my query is in topic "[sqlite] confusing with how to to this in

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

On Jan 22, 2009, at 6:33 PM, Igor Tandetnik wrote: > Derek Developer > wrote: >> I am using >> sqlite3_prepare_v2() >> to process my SQl queries. This takes around 80% of the processing >> time compared to recovering the result set. >> >> Once the querire has been

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

Derek Developer wrote: > I am using > sqlite3_prepare_v2() > to process my SQl queries. This takes around 80% of the processing > time compared to recovering the result set. > > Once the querire has been processed i can obviously provide a > progress bar when stepping

[sqlite] Progress update while Prepare() is executing

I am using sqlite3_prepare_v2() to process my SQl queries. This takes around 80% of the processing time compared to recovering the result set. Once the querire has been processed i can obviously provide a progress bar when stepping through the result set, but what progress indication is

Re: [sqlite] Leading/trailing whitespace overrides Numeric type affinity - workarounds ?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 MikeW wrote: > I guess one approach would be to compile with SQLITE_ENABLE_COLUMN_METADATA > and then to read the column type from there rather than from > sqlite3_column_type(). Or just call sqlite3_column_decltype -

Re: [sqlite] sqlite3_profile() not working with SQLite 3.6.10

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 manohar s wrote: > 1) Am I doing something wrong here? [I couldnt find even a single sample > source or snippet regarding this :( ] sqlite3_profile is experimental hence the light documentation. The profile callback is only executed once the query

[sqlite] Strange child process.

I have recently deployed sqlite 3.6.4 as a replacement for a mirrd database. I am only opening a single database connection on a single-threaded process. The process is built and run two ways, natively compiled on an x86 linux system, and cross-compiled using DENX's ELDK to run on a powerpc-6xx

[sqlite] SQLite 3.6.10: public functions modified to attend VB standards of compatibility

I created a version of SQLiteVB, using the latest SQLite source released (3.6.10). Both binary and source can be found here: http://code.google.com/p/sqlitevb/ Anyone who wishes to improve it or help to adapt it upon the next SQLite public release will be welcome. To be added as a project

Re: [sqlite] Changing the actual data contained based on calculation...

"Igor Tandetnik" wrote in message news:gl9sa9$be...@ger.gmane.org... > "jose isaias cabrera" wrote in message > news:740bad1423a549f6ba68c1e02ab7a...@stso.mc.xerox.com >> Let us imagine the following table: >> CREATE TABLE PMTime (id integer primary key, rec integer, date, secs >> integer); >> >>

Re: [sqlite] Effective way to use RTree to find the neighborhood ???

Hi, > LOCAL: RTREE 8x faster then my OLD implementation > NET: OLD is 2x faster then RTREE > Can I use some special caching concepts? How can I > improve the run-time in the NETWORK environment? You could use/write also a small Appserver-Layer - and perform the query locally then at the

Re: [sqlite] Effective way to use RTree to find the neighborhood ???

On 23/01/2009 12:58 AM, Igor Tandetnik wrote: > "Sergej Schwarz" wrote in > message news:20090122133954.74...@gmx.net >> unfortunately, this does not work, the RTree documentation by SQLite >> leads to misunderstanding of the concept... The query would results >> in an

Re: [sqlite] SQLITEBUSYTIMEOUT

See the following: http://www.catb.org/~esr/faqs/smart-questions.html#beprecise The quick answer to you question is no I can not tell you why this is occurring. I can tell you, its probably a bug in your code. You need to post a specific example, that reproduces the issue. --- On Wed,

Re: [sqlite] Binding with Views

On Thu, Jan 22, 2009 at 09:55:06AM +, Ed Hawke scratched on the wall: > Hi all, > > I have an SQL application that relies on using views to allow a user to > make an array of choices to filter down the information returned to them > from multiple tables, without having to code complex

[sqlite] sqlite3_profile() not working with SQLite 3.6.10

Hi, I am trying to profile queries on a database of size 2 GB, but the code inside callback is not executing. Here is the snippet: ret = sqlite3_open("before_vacuum.data", ); if(ret != SQLITE_OK) printf("error in opening sqlite database file!\n"); ret =

Re: [sqlite] Effective way to use RTree to find the neighborhood ?? ?

Sergej Schwarz wrote: > Amazing! Thanks Guys! This query working best! > > The runtime difference between LOCAL execution and execution in LAN > environment is still absolutely a show stopper! The old algorithm (get all > polygon data from Polygon table) and search for the neighbors in C++ is >

Re: [sqlite] Effective way to use RTree to find the neighborhood ???

Amazing! Thanks Guys! This query working best! The runtime difference between LOCAL execution and execution in LAN environment is still absolutely a show stopper! The old algorithm (get all polygon data from Polygon table) and search for the neighbors in C++ is faster in LAN, then RTree

Re: [sqlite] Effective way to use RTree to find the neighborhood ???

"Sergej Schwarz" wrote in message news:20090122133954.74...@gmx.net > unfortunately, this does not work, the RTree documentation by SQLite > leads to misunderstanding of the concept... The query would results > in an empty set. > > //your query > select * from demo where

Re: [sqlite] Effective way to use RTree to find the neighborhood ???

Dan, unfortunately, this does not work, the RTree documentation by SQLite leads to misunderstanding of the concept... The query would results in an empty set. Here is the table described in the picture http://home.arcor.de/schwar_s/images/polygons.jpg create virtual table demo using rtree

Re: [sqlite] Changing the actual data contained based on calculation...

"jose isaias cabrera" wrote in message news:740bad1423a549f6ba68c1e02ab7a...@stso.mc.xerox.com > Let us imagine the following table: > CREATE TABLE PMTime (id integer primary key, rec integer, date, secs > integer); > > What the program does is to keep track that the secs

Re: [sqlite] Effective way to use RTree to find the neighborhood ???

On Jan 22, 2009, at 6:48 PM, Sergej Schwarz wrote: > Dear all, > > I'm using RTree to have FAST possibility to extract all the > polygons, which intersect a specified window, overlap this specified > window or are completely in this window. Please see the picture at >

[sqlite] Effective way to use RTree to find the neighborhood ???

Dear all, I'm using RTree to have FAST possibility to extract all the polygons, which intersect a specified window, overlap this specified window or are completely in this window. Please see the picture at http://home.arcor.de/schwar_s/images/polygons.jpg. The idea is to find all the polygons

Re: [sqlite] Leading/trailing whitespace overrides Numeric type affinity - workarounds ?

Roger Binns writes: > > > MikeW wrote: > > I note that in the codebase, sqlite3IsNumber() will return False if an > > otherwise numeric value has leading and/or trailing whitespace, > > *overriding the table schema*. > > Such is dynamic typing ! > > Your dynamic typing statement

Re: [sqlite] Leading/trailing whitespace overrides Numeric type affinity - workarounds ?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 MikeW wrote: > I note that in the codebase, sqlite3IsNumber() will return False if an > otherwise numeric value has leading and/or trailing whitespace, > overriding the table schema. > Such is dynamic typing ! Your dynamic typing statement is wrong.

[sqlite] Leading/trailing whitespace overrides Numeric type affinity - workarounds ?

In determining the type of a value returned from a SELECT in some generic SQLite code, an implementation uses sqlite3_column_type to check a field type. I note that in the codebase, sqlite3IsNumber() will return False if an otherwise numeric value has leading and/or trailing whitespace,

[sqlite] GCC Compiler Warnings

Hi, my C skills are not the very best, but GCC reports some warnings when compiling 3.6.10 (amalgamation) and I guess GCC is right: if( unlink(zLockFile) ) { int rc, tErrno = errno; if( ENOENT != tErrno ) { rc = sqliteErrorFromPosixError(tErrno, SQLITE_IOERR_UNLOCK); } if(

[sqlite] Binding with Views

Hi all, I have an SQL application that relies on using views to allow a user to make an array of choices to filter down the information returned to them from multiple tables, without having to code complex statements to take into account the order in which they need to be applied. To speed up

Re: [sqlite] In memory SQLite

On Jan 22, 2009, at 4:20 AM, Ionut Subasu wrote: > The problem for me is at compile time. > Since we have a new OS we do not have implemented the posix and the > file > access librays(like fstat...). > Therefore everything should work in memory. > So I have set the >

Re: [sqlite] In memory SQLite

The problem for me is at compile time. Since we have a new OS we do not have implemented the posix and the file access librays(like fstat...). Therefore everything should work in memory. So I have set the SQLITE_OMIT_DISKIOflag and also

Re: [sqlite] In memory SQLite

On Jan 21, 2009, at 12:15 PM, Ionut Subasu wrote: > Hi, > > I am trying to use SQLite in a new operating system. > Right now we don't support a large functionality > Is there a way to make SQLite to work entirely into memory? > (meaning that everything should be on main memory, from journals, >

Re: [sqlite] 'UPDATE shop_orders SET comments=comments||? WHERE oid=?', ('test', '1')

thanks On Tue, Jan 20, 2009 at 5:54 PM, Hoover, Jeffrey wrote: > if comments is null then comments||? is also null, try this: > > comments=coalesce(comments,'')||? > ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] In memory SQLite

Hi, I am trying to use SQLite in a new operating system. Right now we don't support a large functionality Is there a way to make SQLite to work entirely into memory? (meaning that everything should be on main memory, from journals, logs...) Regards, Ionut