Hello Folks,
When I perform the DELETE operation on a Table using In-Memory Database
(":memory:"), the memory usage increases.
I tried using PRAGMA auto_vacuum=1; /* result - nothing works */
Even I tried using VACUUM table_name; /* this too isn't work */
if I perform DROP the table operation, m
Folks:
Thanks so much for your replies. I have absorbed a lot of information about
code pages and unicode in the last couple of days. My understanding is far
from complete, but I'm ahead of where I was...
In the end, my best answer was to set the text_factory property of the
connection object
Donald, thanks for your response.
Currently, I'm executing importation by executing a ".reading
filename.ext" command from the SQLite command line. The command file
contains these commands:
__
.separator ""<-- thi
Hi Lee,
If I answer wrongly here, I trust (and hope) someone will correct me:
Regarding: "I need a way to programmatically import data from flat
files..."
Sqlite itself is designed to be small and simple -- for some embedded
uses even the sql parser is removed. I don't think there's an api cal
--- Ken <[EMAIL PROTECTED]> wrote:
> You should be using the external API calls not the internal sqlite calls and
> types.
Please point us to where you can get the Select parse tree from the external
API.
>
> See: http://www.sqlite.org/capi3ref.html
__
Which external api should I use in that case? I just want a parsed tree of
the sql statement
Rohit
On 7/31/07, Ken <[EMAIL PROTECTED]> wrote:
>
> You should be using the external API calls not the internal sqlite calls
> and types.
>
> See: http://www.sqlite.org/capi3ref.html
>
>
> Rohit Morda
--- Rohit Mordani <[EMAIL PROTECTED]> wrote:
> So just to confirm - the Select structure (Select *p) is populated after the
> call to sqlite3Select() method right?
No. sqlite3Select() uses the Select tree - it does not produce it.
See parse.y for the parser that builds the Select tree.
See also
My company's application has a need to regularly refresh an entire
read-only database, at one week intervals.
The COPY API call is no longer available. I have read the documentation on
the .IMPORT command but it is a line item command interface.
I need a way to programmatically import data
You should be using the external API calls not the internal sqlite calls and
types.
See: http://www.sqlite.org/capi3ref.html
Rohit Mordani <[EMAIL PROTECTED]> wrote: Hi,
This is my program...
#include "sqliteInt.h"
int main(int argc, char **argv){
Parse parse;
Select sel;
BTW,
tempTable has 2 columns name varchar(20) and phone varchar(20) and I
have 2 entries in tempTable
Thanks
Rohit
On 7/31/07, Rohit Mordani <[EMAIL PROTECTED]> wrote:
>
> Hi,
>This is my program...
>
> #include "sqliteInt.h"
>
>
> int main(int argc, char **argv){
> Parse parse;
>
Hi,
This is my program...
#include "sqliteInt.h"
int main(int argc, char **argv){
Parse parse;
Select sel;
const char *selectStmt = "select * from tempTable;";
parse.zSql= selectStmt;
sqlite3Select(&parse, &sel, SRT_Discard, 0, 0, 0, 0, 0);
sqlite3PrintSelect(&sel, 4
Re: [sqlite] strategy adding indexes
drh
Tue, 31 Jul 2007 03:12:54 -0700
T&B <[EMAIL PROTECTED]> wrote:
> Hi RBS,
>
> > - indexes that include all possible combinations of fields that may
> > appear
> > in a WHERE clause.
>
> As an aside, note that, AFAIK, indexes are only used:
>
> 1. To
So just to confirm - the Select structure (Select *p) is populated after the
call to sqlite3Select() method right? In that case if I call
sqlite3PrintSelect() after this then the statement will be printed right?
Thanks
Rohit
On 7/27/07, Joe Wilson <[EMAIL PROTECTED]> wrote:
>
> --- Rohit Mordani
never mind.
It seems I have it. It seems I had to include the source - the sqlite3.h file
Stephen Sutherland <[EMAIL PROTECTED]> wrote:
by dynamic link library. i'm gusiness you are talking about the sqlite3.dll.
What is hte procedure to link it ?
it seems to me that as long as I have
by dynamic link library. i'm gusiness you are talking about the sqlite3.dll.
What is hte procedure to link it ?
it seems to me that as long as I have an include to , I need to
have that file on my PC somewhere.
Stephen
John Stanton <[EMAIL PROTECTED]> wrote:
You don't have to i
The new experimental sqlite3_collation_needed [1] functions seem ideal
to use in a collation library, but I believe they have a design flaw
that invalidate their use in the generic case.
The use case I see for a user using a 3rd party collation library is
something like this:
1. open the database
[EMAIL PROTECTED] wrote:
http://www.sqite.org/optoverview.html
In case the error in the URL above is not obvious to someone, it should be:
http://www.sqlite.org/optoverview.html
-
To unsubscribe, send email to [
First, let me start by saying I don't have much experience with
Python, but this isn't a python problem.
On 7/31/07, wcmadness <[EMAIL PROTECTED]> wrote:
[...]
> I'm on a Windows machine. It turns out that the default code page on
> Windows is cp437. So, in my Python code, if I type:
Wrong. The
Hi Richard,
It's great to see clarity on this "from the horse's mouth" (I hope
that translates across the equator). Thank you.
- indexes that include all possible combinations of fields that
may appear in a WHERE clause.
As an aside, note that, AFAIK, indexes are only used:
1. To get the
On Tue, 2007-07-31 at 10:22 +, Zoobave wrote:
>
>
> On 7/31/07, Dan Kennedy <[EMAIL PROTECTED]> wrote:
>
> By default, the configure script generates a makefile that
> includes
> the -DSQLITE_OMIT_LOAD_EXTENSION option. It's just too big of
> a
>
On 7/31/07, Dan Kennedy <[EMAIL PROTECTED]> wrote:
>
>
> By default, the configure script generates a makefile that includes
> the -DSQLITE_OMIT_LOAD_EXTENSION option. It's just too big of a
> security hole to do otherwise.
>
> Open the generated Makefile and remove the line that sets this
> option
T&B <[EMAIL PROTECTED]> wrote:
> Hi RBS,
>
> > - indexes that include all possible combinations of fields that may
> > appear
> > in a WHERE clause.
>
> As an aside, note that, AFAIK, indexes are only used:
>
> 1. To get the first match of a query. If you ask for more than one
> matching rec
You don't have to include the Sqlite source to use DevC0++. Just
include the link library.
Stephen Sutherland wrote:
Hi;
I'm pretty much a newbie.
I'm just about finishing a PC a game with Dev C++.
I decided to use sqlite3 to load content from XML repository (for user write access) into the
On Tue, 2007-07-31 at 08:45 +, Zoobave wrote:
>
>
> On 7/31/07, Dan Kennedy <[EMAIL PROTECTED]> wrote:
>
> You probably need to recompile the SQLite library. Either the
> one
> you have installed is too old or it was compiled with the
> -DSQLITE_OMIT_L
On 7/31/07, Dan Kennedy <[EMAIL PROTECTED]> wrote:
>
>
> You probably need to recompile the SQLite library. Either the one
> you have installed is too old or it was compiled with the
> -DSQLITE_OMIT_LOAD_EXTENSION flag, which omits the
> sqlite3_load_extension() API.
>
> Dan.
>
>
i have downloaded
On Tue, 2007-07-31 at 07:26 +, Zoobave wrote:
> Hi Group,
> I got the follwoing error while doing make. Is there any
> library to be loaded other than sqlite3?
>
> /bin/sh ../libtool --tag=CC --mode=link gcc -g -O2 -o foo main.o
> callbacks.o -L/usr/local/lib -lgtk-x11
Hi Group,
I got the follwoing error while doing make. Is there any
library to be loaded other than sqlite3?
/bin/sh ../libtool --tag=CC --mode=link gcc -g -O2 -o foo main.o
callbacks.o -L/usr/local/lib -lgtk-x11-2.0 -lgdk-x11-2.0 -latk-1.0-lgdk_pixbuf-
2.0 -lm -lpangocairo
27 matches
Mail list logo