-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 16/01/12 21:46, Matt Young wrote:
> Group projects, collected together because sqlite is the common
> foundation. Would be nice?
You'll need to use longer sentences. What exactly do you want to achieve
and who do you want to do the work of
Hi Mr Black,
I am very thankful to you. My code is working fine.
Regards,
Bhaskar Reddy.
Black, Michael (IS) wrote:
>
> You have to do all the binds together, THEN step. This works for me.
>
>
>
> #include
> #include
> #include
> #include "sqlite3.h"
>
> int main()
> {
>
Group projects, collected together because sqlite is the common
foundation. Would be nice?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Tue, Jan 17, 2012 at 5:05 AM, John Elrick wrote:
> >
> I can try that approach with BCC. I was concerned that the IDE would be
> getting inaccurate information from the .OBJ. Crossing into a pre-complied
> library can be tricky.
>
>
As I recall,I could not make
On Mon, Jan 16, 2012 at 5:31 PM, Richard Hipp wrote:
> On Mon, Jan 16, 2012 at 5:13 PM, John Elrick >wrote:
>
> > I did this trace through the Delphi IDE and hand copied the call stack.
> > Unfortunately, I can't give you line numbers, although I
I will adjust the realloc tests tomorrow and let you know. The two
routines are unique in the Delphi library unit.
Thanks again for your time and efforts.
On Mon, Jan 16, 2012 at 5:36 PM, Richard Hipp wrote:
> On Mon, Jan 16, 2012 at 5:31 PM, John Elrick
On 16 Jan 2012, at 11:05pm, Ralf Junker wrote:
> Reading the sources, sqlite3_db_release_memory() always returns
> SQLITE_OK. Will it stay this way or will it some day return another
> value like the amount of memory released?
It will stay like that. Almost all the sqlite3 routines return a
At 01:08 17/01/2012, you wrote:
´¯¯¯
Richard, Simon, and you are seeing eye-to-eye on this. Earlier in the
thread (since trimmed, of course), it was stated that SQLite was
designed to be tiny so that each app could include the entire system
without draining resources significantly (this would
> The search path stuff is a mess under Microsoft.
Yes, it sure is. The link you sent has some interesting stuff. In
particular, this point is key:
Before the system searches for a DLL, it checks the following:
(1) If a DLL with the same module name is already loaded in memory, the
system
Reading the sources, sqlite3_db_release_memory() always returns
SQLITE_OK. Will it stay this way or will it some day return another
value like the amount of memory released?
Ralf
___
sqlite-users mailing list
sqlite-users@sqlite.org
On Mon, Jan 16, 2012 at 5:31 PM, John Elrick wrote:
>
> I don't know if the calls to _realloc will help also, but I've added
> tracing for those also. My updated output:
> Cumulative _mallocs by size
> <= 1kb: 1,118,058,528 bytes
On Mon, Jan 16, 2012 at 5:13 PM, John Elrick wrote:
> I did this trace through the Delphi IDE and hand copied the call stack.
> Unfortunately, I can't give you line numbers, although I could go back and
> give you hex offsets from the start of the procedures. These are
Richard,
I don't know if the calls to _realloc will help also, but I've added
tracing for those also. My updated output:
Application: Surveyor.exe
Sqlite version: 3.7.9
Date/Time:01/16/2012 17:20:58
Memory Used:
On Mon, Jan 16, 2012 at 5:14 PM, Simon Slavin wrote:
>
> On 16 Jan 2012, at 9:37pm, John Elrick wrote:
>
> > Lacking the status interfaces for 3.6.17 I was forced to mark them as
> > "interface not supported". Simon suggested I track the calls to _malloc,
> > so I've added
On 16 Jan 2012, at 9:37pm, John Elrick wrote:
> Lacking the status interfaces for 3.6.17 I was forced to mark them as
> "interface not supported". Simon suggested I track the calls to _malloc,
> so I've added extensive tracing code.
Those results are excellently detailed and make no sense to
I did this trace through the Delphi IDE and hand copied the call stack.
Unfortunately, I can't give you line numbers, although I could go back and
give you hex offsets from the start of the procedures. These are literally
the first seven call stacks from _malloc after I initiate the trace. I'm
On Mon, Jan 16, 2012 at 4:37 PM, John Elrick wrote:
> Sqlite version: 3.6.17
> Cumulative _mallocs by size
> <= 1kb: 109,025,904 bytes (565,230 count)
> 1kb to 4kb: 510,357,112 bytes (485,801
The sqlite3_uri_int64() doc reads: "If the value of P is something other
than an integer, then zero is returned." I found this to be not true.
Instead, it returned default.
Ralf
___
sqlite-users mailing list
sqlite-users@sqlite.org
Addendum: This test was conducted using a full size test dataset. I had
been using one that was an order of magnitude smaller for profiling before,
but could use the full size for this test.
On Mon, Jan 16, 2012 at 4:37 PM, John Elrick wrote:
> Lacking the status
Lacking the status interfaces for 3.6.17 I was forced to mark them as
"interface not supported". Simon suggested I track the calls to _malloc,
so I've added extensive tracing code. Here is the final output from the
two versions:
Application: Surveyor.exe
Sqlite version:
You don't need to "register" the SQLite DLL. That's for ActiveX and COM DLLs.
Not ones that just export functions.
The search path stuff is a mess under Microsoft.
http://msdn.microsoft.com/en-us/library/windows/desktop/ms682586(v=vs.85).aspx#standard_search_order_for_desktop_applications
On 16 Jan 2012, at 8:11pm, Bill McCormick wrote:
> I was sort of hoping it might be narrowed down to one of the documents on
> this page:
>
> http://www.sqlite.org/docs.html
>
> Typing "script" and "command line" in the search box didn't help me find what
> I was looking for either.
Ah, I
On Mon, Jan 16, 2012 at 9:21 PM, Tim Streater wrote:
> I'm using the PDO interface from PHP for SQLite3 with no problems. What
> are you referring to?
>
Sorry for the confusion - i meant that those are languages which _do_ have
sqlite3 bindings (but my wording implied the
On 16 Jan 2012 at 18:15, Stephan Beal wrote:
> On Mon, Jan 16, 2012 at 7:12 PM, Bill McCormick wrote:
>
>> Is tcl the only scripting interface for SQLite? I'm just wondering what
>> the options are.
> There are few scripting languages which don't
Simon Slavin wrote, On 1/16/2012 1:45 PM:
On 16 Jan 2012, at 7:34pm, Bill McCormick wrote:
Looks like pipes work as well (cat yoursql.sql|sqlite3 yourdb.db3).
Also, can I safely delete the database file (yourdb.db3, using your example) if
I just want to start again? It appears that I can.
Ah, I see that embedded images don't make it in this group, so the screen
shot referred to in my previous message is attached. Regards, Joe
Original Message
Subject: Re: [sqlite] Incompatible versions of SQLite on same system
From: Joe Winograd
To: General
Am 16.01.2012 20:34, schrieb Bill McCormick:
Oliver Peters wrote, On 1/16/2012 1:02 PM:
Am 16.01.2012 19:59, schrieb Bill McCormick:
James Pearson wrote, On 1/16/2012 12:28 PM:
If it's just for setting up databases, tables, etc, why not just use a
sql script?
Throw all your database object
On 16 Jan 2012, at 7:34pm, Bill McCormick wrote:
> Looks like pipes work as well (cat yoursql.sql|sqlite3 yourdb.db3).
>
> Also, can I safely delete the database file (yourdb.db3, using your example)
> if I just want to start again? It appears that I can.
Not while an app has it open, but if
On Mon, Jan 16, 2012 at 2:28 PM, Udi Karni wrote:
>
> (2) I am new to share-ware. I don't compile my own code. How long between
> "checked in" and "included in the shell-for-windows on the download page" ?
>
>
Since SQLite 3.7.10 was released earlier this morning, you hit the
Thanks for the response, Michael.
This is a 64-bit W7 machine. The two supposedly conflicting programs are:
c:\Program Files (x86)\TurboTax\Home & Business 2010\32bit\TurboTax.exe
c:\Program Files (x86)\Hewlett-Packard\HP Connection
Manager\HPConnectionManager.exe
TurboTax does not have a
Oliver Peters wrote, On 1/16/2012 1:02 PM:
Am 16.01.2012 19:59, schrieb Bill McCormick:
James Pearson wrote, On 1/16/2012 12:28 PM:
If it's just for setting up databases, tables, etc, why not just use a
sql script?
Throw all your database object creation sql into a file and then
execute that
Thanks Dr. Hipp !
(1) Wow - what fast turnaround in the share-ware world !!!
(2) I am new to share-ware. I don't compile my own code. How long between
"checked in" and "included in the shell-for-windows on the download page" ?
On Mon, Jan 16, 2012 at 8:57 AM, Richard Hipp
On Mon, Jan 16, 2012 at 8:02 PM, Bill McCormick wrote:
> I assume that you are *NOT* naming the few that don't, rather these
> scripting languages *DO* have sqlite3 binding support.
Yes, sorry - a bad choice of wording on my part. :/
--
- stephan beal
Am 16.01.2012 19:59, schrieb Bill McCormick:
James Pearson wrote, On 1/16/2012 12:28 PM:
If it's just for setting up databases, tables, etc, why not just use a
sql script?
Throw all your database object creation sql into a file and then
execute that file from within sqlite using the ".read
Stephan Beal wrote, On 1/16/2012 12:15 PM:
On Mon, Jan 16, 2012 at 7:12 PM, Bill McCormickwrote:
Is tcl the only scripting interface for SQLite? I'm just wondering what
the options are.
There are few scripting languages which don't have an sqlite3 binding. Just
to
On 16 Jan 2012, at 6:59pm, Bill McCormick wrote:
> James Pearson wrote, On 1/16/2012 12:28 PM:
>> If it's just for setting up databases, tables, etc, why not just use a sql
>> script?
>>
>> Throw all your database object creation sql into a file and then execute
>> that file from within
James Pearson wrote, On 1/16/2012 12:28 PM:
If it's just for setting up databases, tables, etc, why not just use a
sql script?
Throw all your database object creation sql into a file and then
execute that file from within sqlite using the ".read FILE" command.
I think this is what I'm
On 16 Jan 2012, at 4:34pm, James Pearson wrote:
> I just updated my sqlite install from 3.7.5 with the 3.7.10 precompiled
> binaries for Mac OS X and find that the up arrow command recall isn't working.
Works fine for me, downloading the shell from the 'Downloads' page and running
it under
If it's just for setting up databases, tables, etc, why not just use a
sql script?
Throw all your database object creation sql into a file and then execute
that file from within sqlite using the ".read FILE" command.
On 16 Jan 2012, at 11:23, John Elrick wrote:
Ruby also.
On Mon, Jan
Ruby also.
On Mon, Jan 16, 2012 at 1:15 PM, Stephan Beal wrote:
> On Mon, Jan 16, 2012 at 7:12 PM, Bill McCormick >wrote:
>
> > Is tcl the only scripting interface for SQLite? I'm just wondering what
> > the options are.
> >
>
>
> There are few
On Mon, Jan 16, 2012 at 7:12 PM, Bill McCormick wrote:
> Is tcl the only scripting interface for SQLite? I'm just wondering what
> the options are.
>
There are few scripting languages which don't have an sqlite3 binding. Just
to name a few:
- Perl
- PHP
- JavaScript (v8
Is tcl the only scripting interface for SQLite? I'm just wondering what
the options are.
I'm trying to write a script to setup my database on new systems (create
the db, add tables, etc.), but I don't have much experience using Tcl.
My fist attempt is not going so well and I'm not finding
On 16 Jan 2012, at 10:53, Richard Hipp wrote:
We have now uploaded a new prebuilt command-line shell binary for Mac
that
has the command-line editing built in. Please download the new one
and try
again.
On Mon, Jan 16, 2012 at 12:47 PM, James Pearson
wrote:
On 16 Jan
Read here on Mac OS X
http://sqlite.org/cvstrac/wiki?p=ReadLine
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems
From: sqlite-users-boun...@sqlite.org
We have now uploaded a new prebuilt command-line shell binary for Mac that
has the command-line editing built in. Please download the new one and try
again.
On Mon, Jan 16, 2012 at 12:47 PM, James Pearson wrote:
> On 16 Jan 2012, at 10:12, Richard Hipp wrote:
>
> On Mon,
On 16 Jan 2012, at 10:12, Richard Hipp wrote:
On Mon, Jan 16, 2012 at 11:34 AM, James Pearson
wrote:
I just updated my sqlite install from 3.7.5 with the 3.7.10
precompiled
binaries for Mac OS X and find that the up arrow command recall isn't
working.
Searching for
On Fri, Jan 13, 2012 at 5:58 PM, Richard Hipp wrote:
> On Fri, Jan 13, 2012 at 4:49 PM, John Elrick >wrote:
>
> >
> > 3.6.17
> >
> > Procedure % TimeTimeCalls
> > _sqlite3_step 58.4% 1.795,052
> >
Am 16.01.2012 17:57, schrieb Richard Hipp:
Changes to the command-line shell so that it understands quoted fields have
now been checked in.
thanks - what about a possibility to recognize special characters (i.e.
\NULL) or delimiter""delimiter or delimiterdelimiter as NULL during the
import?
On Mon, Jan 16, 2012 at 11:34 AM, James Pearson wrote:
> I just updated my sqlite install from 3.7.5 with the 3.7.10 precompiled
> binaries for Mac OS X and find that the up arrow command recall isn't
> working.
>
> Searching for fixes online I can only find suggestions for
On 01/16/2012 04:17 AM, Bill McCormick wrote:
Tim Streater wrote, On 1/15/2012 3:00 PM:
On 15 Jan 2012 at 20:44, Bill McCormick wrote:
What is the problem with the shared lib stuff?
Thanks!!
Black, Michael (IS) wrote, On 1/15/2012 2:27 PM:
A simple one -- and please
On 16 Jan 2012, at 4:49pm, Udi Karni wrote:
> Hm so there is no way to specify (borrowing syntax from other DBs)
> something like - "DELIMITED BY ',' ENCLOSED BY ' " ' ?
To import fields which contain commas use a delimiter other than a comma to
separate your fields and preceed your
Changes to the command-line shell so that it understands quoted fields have
now been checked in.
On Mon, Jan 16, 2012 at 11:49 AM, Udi Karni wrote:
> Oliver - thanks !
>
> Hm so there is no way to specify (borrowing syntax from other DBs)
> something like - "DELIMITED
I just updated my sqlite install from 3.7.5 with the 3.7.10 precompiled
binaries for Mac OS X and find that the up arrow command recall isn't
working.
Searching for fixes online I can only find suggestions for correcting
the issue by compiling sqlite myself. Is that the only way to get
Am 16.01.2012 17:49, schrieb Udi Karni:
Oliver - thanks !
Hm so there is no way to specify (borrowing syntax from other
DBs) something like - "DELIMITED BY ',' ENCLOSED BY ' " ' ?
yes, no way :-)
if you want to discover the possibilities of the CLI type .h (after
having started with
Oliver - thanks !
Hm so there is no way to specify (borrowing syntax from other DBs)
something like - "DELIMITED BY ',' ENCLOSED BY ' " ' ?
On Mon, Jan 16, 2012 at 8:32 AM, Oliver Peters wrote:
> Am 16.01.2012 17:10, schrieb Udi Karni:
>
> Simon - thanks - but this
Am 16.01.2012 17:10, schrieb Udi Karni:
Simon - thanks - but this used to work on 3.7.7.1 (I believe was the last
version I downloaded and unfortunately replaced with the latest...)
afaik this never worked with the original CLI (might be that you have
used a fork that can do this)
I see 3
Simon - thanks - but this used to work on 3.7.7.1 (I believe was the last
version I downloaded and unfortunately replaced with the latest...)
How, then, do you import character columns that contain commas (like
addresses) from a .csv which uses commas as a delimiter?
Thanks !
On Mon, Jan 16,
On Mon, Jan 16, 2012 at 10:33 AM, Richard Hipp wrote:
> On Mon, Jan 16, 2012 at 10:29 AM, John Elrick >wrote:
>
> >
> >
> > > SQLite has lots of interfaces that can be used to determine performance
> > and
> > > status information. Some example code
On 16 Jan 2012, at 3:34pm, Udi Karni wrote:
> "COL1","COL2"
> "",""
> "XX,X",""
Sorry, but the shell tool doesn't understand quotes in csv files.
Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
C:\>type k:\data\test.csv
"COL1","COL2"
"",""
"XX,X",""
C:\>sqlite3 k:\db\testdb
SQLite version 3.7.9 2011-11-01 00:52:41
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .separator ','
sqlite>
sqlite> CREATE TABLE TEST (COL1 CHAR (4), COL2 CHAR
On Mon, Jan 16, 2012 at 10:29 AM, John Elrick wrote:
>
>
> > SQLite has lots of interfaces that can be used to determine performance
> and
> > status information. Some example code from the command-line shell that
> > accesses this status information is here:
> >
On Fri, Jan 13, 2012 at 5:58 PM, Richard Hipp wrote:
> On Fri, Jan 13, 2012 at 4:49 PM, John Elrick >wrote:
>
SNIP
> SQLite has lots of interfaces that can be used to determine performance and
> status information. Some example code from the
2012/1/16 Csaba Jeney
> Is there any way to query the valid savepoints? At least their names?
> Many thanks.
>
>
AFAIK, the only way to do this is to keep track of each begin, rollback,
add savepoint, ... executed, to always know where you are.
(Anyway this is what's done in
If you insist on using the shared library instead of compiling in as we all
recommend you don't need to worry about the different file extensions on the
shared libraries. There are no options when linking the shared libary.
CFLAGS=-O
OBJECTS=myapp.o
LIBS=-lsqlite3 -lpthread -ldl
myapp:
On Mon, Jan 16, 2012 at 5:37 PM, John Elrick wrote:
> > is this test ok for you (still showing bad performance)?
> >
> > On my side it's about 800 ms for 3.7.9 static and about 6000 memory calls
> > during the query. For 3.6.20 the number of calls ~ 7000, the time is
>
You have to do all the binds together, THEN step. This works for me.
#include
#include
#include
#include "sqlite3.h"
int main()
{
sqlite3 *db;
sqlite3_stmt *stmt;
int status;
char *create = "create table
ONTTable(slotId,ponChannelId,onuType,onuId,adminStatus);";
char
Hi Friends,
When i tried,
query = "insert into ONTTable
(slotId,ponChannelId,onuType,onuId,adminStatus) values (?1,?2,?3,?4,?5);";
then binding each parameter.
//sqlite3_prepare_v2(db,query,strlen(query)+1, , NULL);
sqlite3_bind_int(stmt,1,ontTable -> slotId);
On Mon, Jan 16, 2012 at 4:37 AM, Max Vlasov wrote:
> On Sun, Jan 15, 2012 at 3:35 AM, John Elrick >wrote:
>
> > On Fri, Jan 13, 2012 at 5:13 PM, Max Vlasov
> wrote:
> >
> > 5,008 calls to
> >
> > UPDATE RESPONSES SET
> >
Hi Mr. Black,
I tried what you recommend me. But i am getting error as,
sqilte3_bind_int(stmt,2,ontTable -> ponChannelId) failed with status 21:
library routine called out of sequence.
Regards,
Bhaskar Reddy.
Black, Michael (IS) wrote:
>
> You did 5 inserts and got 5
You did 5 inserts and got 5 records. You need to do either just ONE insert or
ONE insert and FOUR updates.
I'd got for the one insert.
query = "insert into ONTTable (slotId,ponChannelId,onuType,onuId,adminStatus)
values (?1,?2,?3,?4,?5);";
then bind each parameter.
Michael D. Black
Hi friends,
While i am writing data into the table the values are not storing
in a single records, instead the values are storing in improper order.
I am adding the values to the table as,
query = "insert into ONTTable (slotId) values (?1);";
I am not sure if this is the correct mailing list to ask this question. If
not, please redirect me to the correct forum.
I am using Node js with node-sqlite extension. I tried to use the commented
out caode in node-sqlite to add an update callback. On running the code I am
getting a
For this particular test cache_size didn't matter much...actually ran a touch
faster with smaller cache (although may be within the margin of error)
I dropped the cache_size to 125 pages (which matches the 16X increase in page
size that I did)
On SSD:
time sqlite3 gen.db
int
main ()
{
Yes...Linuxforgot to mention that.
Also Intel E5405 @ 2.00Ghz -- 8 processors and 32G mem in an HP Blade on local
storage. System was pretty well I/O bound.
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman
Yup...I'm sure...
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Peter
On 16 Jan 2012, at 7:18am, Max Vlasov wrote:
> Michael, thanks for the info, your tests confirms some advantages of ssd,
> at least on some of the current platform (linux, can you confirm?).
> Probably the page size is a parameter that also should be adjusted for
> optimal performance. I suppose
On Sun, Jan 15, 2012 at 3:35 AM, John Elrick wrote:
> On Fri, Jan 13, 2012 at 5:13 PM, Max Vlasov wrote:
>
> 5,008 calls to
>
> UPDATE RESPONSES SET
> RESPONSE_NAME = :RESPONSE_NAME,
> prelisted_value = :prelisted_value
> WHERE RESPONSE_OID =
On 01/16/2012 03:31 PM, Csaba Jeney wrote:
Is there any way to query the valid savepoints? At least their names?
No way to do that at present.
___
sqlite-users mailing list
sqlite-users@sqlite.org
Is there any way to query the valid savepoints? At least their names?
Many thanks.
Csaba
This message is intended to be confidential and may be privileged. If
you are not the intended recipient, please delete this e-mail from your
system immediately and notify us of the erroneous transmission
79 matches
Mail list logo