[sqlite] Another 3.7.10 question

Dear all,   we have another question regarding the 3.7.10 version. We have a database with cca 10 tables. After creating a new database in 3.7.10 and filling each table with about 10 - 100 data rows, we noticed that the size of the database is 2x - 4x larger compared to 3.7.9 (using exact same

Re: [sqlite] Some pieces of the puzzle are coming together

I don't mean to blow anyone off, but there are over 100 prepared queries involved in a very interlaced manner. Getting the EXPLAIN data is very time consuming and since we've gone way past that point already by obtaining call stack information, I am not interested in revisiting the territory

Re: [sqlite] Some pieces of the puzzle are coming together

The problem is not in the queries. The problem is in a two order of magnitude increase in _mallocs between the versions. The _mallocs are coming from sqlite3Parser. On Fri, Jan 20, 2012 at 2:37 PM, Max Vlasov wrote: > On Fri, Jan 20, 2012 at 10:05 PM, John Elrick

Re: [sqlite] Some pieces of the puzzle are coming together

On Fri, Jan 20, 2012 at 10:05 PM, John Elrick wrote: > The change which results in a slow down occurred between 3.7.5.0 and > 3.7.6.0. > > What about EXPLAIN difference? Or just outputs of this prefix from both versions? Max

Re: [sqlite] BLOB concatenation?

>  > SELECT quote(cast(X'5445' || X'5354' as blob)); > >        Indeed, it seems to work.  Thanks! But beware that it's not guaranteed to work if blobs have embedded '\0' character (as it's actually not guaranteed to work if blobs don't have a valid UTF-8/UTF-16 text). Although I believe it works

Re: [sqlite] Some pieces of the puzzle are coming together

The change which results in a slow down occurred between 3.7.5.0 and 3.7.6.0. On Fri, Jan 20, 2012 at 8:34 AM, John Elrick wrote: > Thank you sir. I'll start looking. > > > On Fri, Jan 20, 2012 at 8:27 AM, Richard Hipp wrote: > >> On Fri, Jan 20, 2012

Re: [sqlite] BLOB concatenation?

> Pavel Ivanov writes: [...] >> Unfortunately, the string concatenation operator, when applied to >> two BLOB's, results in a text string instead of a BLOB, like: >> SELECT quote (X'5445' || X'5354'); => 'TEST' > Maybe the following? > SELECT quote(cast(X'5445' || X'5354' as blob));

Re: [sqlite] C# amalgamation hand holding requested

On 20 Jan 2012, at 3:42pm, Don V Nielsen wrote: > Recent conversations by users has > convinced me that I would be better off using the amalgamation file > instead. However, I don't know what steps in VS to do to specify the > source and header files so that it compiles into my application. >

Re: [sqlite] how to restore the column values into the structure.

Hi Bhaskar, I wrote the code to store the result of SELECT query. I treated the resultset as a table where each cell is the column value and row is set of cells, and table is set of rows. Below is the snippet of the class structure. You can modify it as per ur requirement. Hope it helps.

[sqlite] C# amalgamation hand holding requested

I need help using the amalgamation in my projects. I simply do not know what steps to take in VS to implement it. I have some fairly elaborate projects that I have been redeveloping to use sqlite instead of .net structure and memory functions. One project is complete, but it uses the sqlite

Re: [sqlite] BLOB concatenation?

>        Unfortunately, the string concatenation operator, when applied >        to two BLOB's, results in a text string instead of a BLOB, like: > > SELECT quote (X'5445' || X'5354'); >  => 'TEST' Maybe the following? SELECT quote(cast(X'5445' || X'5354' as blob)); Pavel On Fri, Jan 20,

Re: [sqlite] Windows Thread-safe

> Im observing that, if for example an SQL command in a transaction is > uncorrect, the rollback does not work: the previously inserted records are > not removed. If you are trying to execute an incorrect SQL statement this statement is not executed but transaction is not rolled back

Re: [sqlite] sqlite.dll

On Thu, Jan 19, 2012 at 7:22 PM, Hashry Adijan wrote: > Hi, > > I need some help here. > > Just now I got a message if I start my pc, it says something like: "program > not working, sqlite dll missing...etc" > > What does this meant? Idont have a clue why it suddenly showup. >

[sqlite] Windows Thread-safe

marcello.botrugno at dedalus.eu wrote: Hi all, I am new of SQLite and I am developing a multithread application using SQLite 3.7.9 on MS Windows. I am using the precompiled version of SQLite downloaded from www.sqlite.org. Each thread of the application, opens a private connection to the

Re: [sqlite] sqlite.dll

On 20 Jan 2012, at 12:22am, Hashry Adijan wrote: > Just now I got a message if I start my pc, it says something like: "program > not working, sqlite dll missing...etc" > > What does this meant? Idont have a clue why it suddenly showup. > > If I need to re-download it, which was included in

Re: [sqlite] Some pieces of the puzzle are coming together

Thank you sir. I'll start looking. On Fri, Jan 20, 2012 at 8:27 AM, Richard Hipp wrote: > On Fri, Jan 20, 2012 at 8:14 AM, John Elrick >wrote: > > > I asked in an earlier posting if the amalgamations were available > > somewhere. > > > > > >

Re: [sqlite] Some pieces of the puzzle are coming together

On Fri, Jan 20, 2012 at 8:14 AM, John Elrick wrote: > I asked in an earlier posting if the amalgamations were available > somewhere. > http://www.sqlite.org/sqlite-amalgamation-.zip where is one of: 3071000 3070900 3070800 3070700 3070603

Re: [sqlite] detach necessary

Petra Abele wrote: > I have a simple question (at least I hope so): is an explicit DETACH > database command necessary before an SQLITE3_close() or is the close() > alone sufficient? close is sufficient. -- Igor Tandetnik

Re: [sqlite] Bug or expected behavior?

Alex Dupre wrote: > is it expected the following behavior or is it a bug? > > %sqlite3 test.db > SQLite version 3.7.9 2011-11-01 00:52:41 > sqlite> CREATE TABLE a (x BLOB); > sqlite> INSERT INTO "a" VALUES(X'30313233'); > sqlite> INSERT INTO "a" VALUES('0124'); > sqlite>

Re: [sqlite] Some pieces of the puzzle are coming together

I asked in an earlier posting if the amalgamations were available somewhere. Since C isn't my primary language and I'm building on Windows, I'd prefer to have the simplest possible route to recreating. But yes, that is precisely what I wanted to do in the beginning to identify the point where

[sqlite] Windows Thread-safe

Hi all, I am new of SQLite and I am developing a multithread application using SQLite 3.7.9 on MS Windows. I am using the precompiled version of SQLite downloaded from www.sqlite.org. Each thread of the application, opens a private connection to the database. Im observing that, if for example

[sqlite] Bug or expected behavior?

Hi All, is it expected the following behavior or is it a bug? %sqlite3 test.db SQLite version 3.7.9 2011-11-01 00:52:41 sqlite> CREATE TABLE a (x BLOB); sqlite> INSERT INTO "a" VALUES(X'30313233'); sqlite> INSERT INTO "a" VALUES('0124'); sqlite> SELECT x, typeof(x) FROM a WHERE x LIKE '012%';

[sqlite] detach necessary

Hello, I have a simple question (at least I hope so): is an explicit DETACH database command necessary before an SQLITE3_close() or is the close() alone sufficient? I think, close() alone is enough but I can't find anything concerning that question in the documentation. Why do I want to

[sqlite] sqlite.dll

Hi, I need some help here. Just now I got a message if I start my pc, it says something like: "program not working, sqlite dll missing...etc" What does this meant? Idont have a clue why it suddenly showup. If I need to re-download it, which was included in the reminder above, what do I need

Re: [sqlite] Library run-time error

On Fri, Jan 20, 2012 at 12:40 PM, ASURADA wrote: > You have missing a point. > I need 64bit static library. so I have to compile the sqlite. > Why you need a static library? For testing, you can direct embed the Sqlite source in the test app.                              

Re: [sqlite] Library run-time error

I was tried SQLite3Test and SQLite3Static with "#define _WIN32_WINNT 0x0501" macro. but It's not work. Please make sure the _WIN32_WINNT macro is defined in all your projects then (and for all build configurations). -- Joe Mistachkin Solution + SQLite3 (Dynamic Library) + SQLite3Static

Re: [sqlite] Library run-time error

You have missing a point. I need 64bit static library. so I have to compile the sqlite. my solution is simple not complex. It was fine til v3.7.9. On Fri, Jan 20, 2012 at 10:21 AM, ASURADA http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users>> wrote: >* Solution*>* + SQLite3 (Dynamic

Re: [sqlite] 3.7.10

On 01/20/2012 06:16 PM, Alexandr Němec wrote: Dear all, we have two short questions regarding the new 3.7.10 SQLite release. 1. We read about the new "powersafe overwrite" feature in 3.7.10. We would like to go on (for a while) without this. If we set SQLITE_POWERSAFE_OVERWRITE to 0 in the

[sqlite] 3.7.10

Dear all,   we have two short questions regarding the new 3.7.10 SQLite release.   1. We read about the new "powersafe overwrite" feature in 3.7.10. We would like to go on (for a while) without this. If we set SQLITE_POWERSAFE_OVERWRITE to 0 in the amalgamation file, is this the only thing that

Re: [sqlite] Library run-time error

Please make sure the _WIN32_WINNT macro is defined in all your projects then (and for all build configurations). -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Library run-time error

On Fri, Jan 20, 2012 at 10:21 AM, ASURADA wrote: > Solution > + SQLite3 (Dynamic Library) > + SQLite3Static (Static Library) > + SQLite3Test Please simplify the setup. Please add sqlite3.c, sqlite3.h, sqlite3ext.h direct to SQLite3Test project. Remove the project SQLite3 and

[sqlite] BLOB concatenation?

With substr (), it's possible to split a BLOB, like: SELECT quote (substr (X'1337cafe', 3, 2)); => X'CAFE' However, how do I concatenate two blobs? Unfortunately, the string concatenation operator, when applied to two BLOB's, results in a text string instead of

Re: [sqlite] Library run-time error

Solution + SQLite3 (Dynamic Library) + SQLite3Static (Static Library) + SQLite3Test Directory of Z:\...\SQLite3Library\sqlite 2012-01-16 23:0491,925 shell.c 2012-01-20 17:50 4,711,082 sqlite3.c 2012-01-16 23:06 4,227 sqlite3.def 2012-01-16 23:06

Re: [sqlite] Library run-time error

Can you describe your project structure. One Visual Studio test project with sqlite3.c sqlite3.h inside or two separate projects?                               Jens ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] 3.7.10 problem : SQLite header and source version mismatch

-- -- -- --ô¿ô-- K e V i N On Thu, Jan 19, 2012 at 10:48 PM, Kevin Youren wrote: > G'day, > > thanks for such a great program. > > Slight problem with sqlite-autoconf-3071000 > > When I issue from the command line: sqlite3 > > I get > > SQLite

Re: [sqlite] Library run-time error

ASURADA wrote: > > _WIN32_WINNT was defined by 0x0501 already. > It must be defined in the project that you are using to actually compile the SQLite source code (i.e. not just the project that uses the SQLite code, unless they are in fact the same project). -- Joe Mistachkin

Re: [sqlite] Library run-time error

_WIN32_WINNT was defined by 0x0501 already. >* *>* What's the problem. How to fix this problem.*>* (I use Visual C++ 2005 >on Windows 7 x64)*>* * In your project, please define the _WIN32_WINNT macro to 0x500 and try again. -- Joe Mistachkin ___

Re: [sqlite] Library run-time error

This is call stack on Visual Studio 2005 () > SQLite3Test.exe!winFullPathname(sqlite3_vfs * pVfs=0x0055b6f8, const char * zRelative=0x002bff30, int nFull=261, char * zFull=0x002bb098) Line 35393 + 0x12 bytes C SQLite3Test.exe!sqlite3OsFullPathname(sqlite3_vfs * pVfs=0x0055b6f8, const