[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 _

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 http://sqlite.org:8080/cgi-bin/ma

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, > l

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 *SQLITE_TEMP_S

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 > SQLITE_OMIT_DISKIO

[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

[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( IS_L

[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, overriding

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.

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 is wrong. SQL

[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] 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 > http://home.arcor.de/sc

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 will not add to > more th

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 (id,

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 x1>=3 and x2<=19 and y1>=2

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 concept

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 >

[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", &vSqlite); if(ret != SQLITE_OK) printf("error in opening sqlite database file!\n"); ret = sqlite3_prep

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 statem

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, 1/21/

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 empty set. >> >> //your quer

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 serv

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); >> >>

[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 member,

[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 l

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 ha

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 - http://sqlite.org/c3ref/column_d

[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 availab

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 through the result set, but w

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 processed i can obviously provi

[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 sq

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, becau

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

Hi All, What are the basic advantage of using SQLite with C API over ODBC. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users