jima wrote:
>
> Hi,
>
> I build **without** -DSQLITE_OMIT_LOAD_EXTENSION
>
> I do ldd on sqlite3 and I get
>
> libdl.so.2 => /lib/libdl.so.2 (0x00402000)
>
> but I cannot load my Extension.so
>
> Do Extension.c has to include sqlite3.h ?
> Presently I am only including sqlite3ext.h.
Includin
I far as i know you compile with php5-pdo-sqlite, but this was only tested
on debian. Last time i looked this supports sqlite 3.2.8 and you have to use
php's pdo functions and not the sqlite functions which only work with v2.
- Original Message -
From: "Michael Young" <[EMAIL PROTECTED
Liam Healy wrote:
I have a database that has one writer which runs once a day, and
potentially many readers running whenever someone wants some
information. I am trying to understand concurrency in sqlite3 so that
I can have the writer run each day, regardless of whether a reader is
already runn
SQLite databases are protected like a big reader-writer lock: there is
no way read while you are writing. "BEGIN IMMEDIATE" simply changes
when it takes the write lock, and won't affect this.
On 9/15/06, Liam Healy <[EMAIL PROTECTED]> wrote:
I have a database that has one writer which runs once
Well, its a little more complicated than that. I don't want the whole
table, just the set of records that matched the initial search criteria
in the select. But thanks for your response. I did a little redesigning
of the database schema and the way my code handles things and I came up
with a be
that's the hard way:
open db1
attach db2
insert into db2.destinationTable select * from db1.sourceTable
done
On 9/15/06, Kevin Stewart <[EMAIL PROTECTED]> wrote:
I need to move some records from one database (and table) to another.
The tables are identical. My idea was to 'select' all records
I'm not a Unix programmer, but I would like to compile PHP5 so that
it will be able to read/write SQLite3 files on my Mac.
In particular, I have tried to follow the installation script
suggested at www.phpmac.com for Apache 2.2.2 and PHP 5.1.4. However,
this only results in a compilation th
I need to move some records from one database (and table) to another.
The tables are identical. My idea was to 'select' all records that match
my search criteria and in the callback that is called from sqlite_exec()
I can add them to the other table in the other database. This way I
don't need
I have a database that has one writer which runs once a day, and
potentially many readers running whenever someone wants some
information. I am trying to understand concurrency in sqlite3 so that
I can have the writer run each day, regardless of whether a reader is
already running or a reader sta
I meen, If SQLite has two index and very large Index (about 10.000.000 each
one) how do i merge it, I mean (index1 = index2 for every one and limit it
in thousand).
Understand?
On 9/15/06, Dennis Cote <[EMAIL PROTECTED]> wrote:
Cesar David Rodas Maldonado wrote:
> If there a document of how S
Cesar David Rodas Maldonado wrote:
If there a document of how SQLite Virtual Machine Works ( papers )? I
would
like do something similar with B-Tree, B+ Tree but i dont know how to
merge
a select with tow Index? Understand my question??
Please answer me
see the links VDBE Tutorial and VDBE Op
If there a document of how SQLite Virtual Machine Works ( papers )? I would
like do something similar with B-Tree, B+ Tree but i dont know how to merge
a select with tow Index? Understand my question??
Please answer me
Hi,
I build **without** -DSQLITE_OMIT_LOAD_EXTENSION
I do ldd on sqlite3 and I get
libdl.so.2 => /lib/libdl.so.2 (0x00402000)
but I cannot load my Extension.so
Do Extension.c has to include sqlite3.h ?
Presently I am only including sqlite3ext.h.
If I have used --enable-thread at sqlite makef
jima wrote:
>
> Thanks for the advice but it would not work either. I just tried with the
> flags you mentioned at compile time and full path when loading.
>
> Do you know if I have to enclose that full path in quotes or something at
> load time? like...
>
> ..load '/path/Extension.so'
>
> ?
>
Better still, I have tried with full text search extension and I was able to
load it.
I will re-check my code. It is the most clear suspect now.
jima
2006/9/15, jima <[EMAIL PROTECTED]>:
I have them both...I read the wiki page before trying this myself. I will
try with the exact code that it
I have them both...I read the wiki page before trying this myself. I will
try with the exact code that it is contained at the page.
Thanks for the hint.
jima
2006/9/15, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
jima <[EMAIL PROTECTED]> wrote:
>
> unable to open shared library [Extension.so]
>
>
jima <[EMAIL PROTECTED]> wrote:
>
> unable to open shared library [Extension.so]
>
> Any clues of what is going on?
>
Did you base your implementation of Extension.c off of the
example C code contained in the wiki?
http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions
The magic macros SQ
Thanks for the advice but it would not work either. I just tried with the
flags you mentioned at compile time and full path when loading.
Do you know if I have to enclose that full path in quotes or something at
load time? like...
.load '/path/Extension.so'
?
I tried several combinations of qu
jima wrote:
> ...
> And then I go, no problems building. I have sqlite built with this
> feature I guess.
>
> But the thing is that I cannot make it to work. I prepared a c file
> following the template given in the wiki. I generated a .so using:
>
> gcc -I/path_to_sqlite-3.3.7/src -c -o Extensi
Hi all,
I hope this is now the right place to tell this story after being
redirected to this list by drh. I first submitted this as a ticket
(sorry about that).
I am building sqlite from sources in a debian sarge box.
I am interested in Loadable Extensions.
I had to introduce into the Makefile
Fred Williams wrote:
Just a suggestion. When I am learning a new language, database, etc. I
sometimes find working with and even stepping through supplied samples
prove to be the quickest way to gain insight into how the new entity
works. Saves both me and a lot of other people a lot of time
Roger Binns wrote:
Alternately, you may want to consider the simpler sqlite3_exec api
Roger,
The sqlite3_exec interface may seem simpler than the sqlite_prepare et
al API at first glance, but it really isn't for queries. Yes you make
fewer calls to sqlite functions, but you have to define
NFS. The same test works fine in /tmp, which is apparently local. I'll
report the problem to the host. Thanks for the help.
On 9/15/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
"Jay Johnston" <[EMAIL PROTECTED]> wrote:
> Yes, the directory is writable. No, there is no journal file -- th
sandhya a écrit :
You mean there is no need for me to take care of this function calls ..Its
just enough having definition there.
But by doing that i am not getting any kind of output ie my OID.
No you should write the callback and do whatever you want with the
passed data.
You the pass t
"Jay Johnston" <[EMAIL PROTECTED]> wrote:
> Yes, the directory is writable. No, there is no journal file -- this
> happens even when creating a new database.
>
>
> [barranca]$ whoami
> jpj
> [barranca]$ ls -dl ./
> drwxr-x--x 38 jpj pg547368 4096 2006-09-15 09:25 ./
> [barranca]$ ec
Yes, the directory is writable. No, there is no journal file -- this
happens even when creating a new database.
[barranca]$ whoami
jpj
[barranca]$ ls -dl ./
drwxr-x--x 38 jpj pg547368 4096 2006-09-15 09:25 ./
[barranca]$ echo "create table foo(x varchar(12));" | ~/src/sqlite3-
3.3.
"Jay Johnston" <[EMAIL PROTECTED]> wrote:
> Yes, I can open the file created on the server on my laptop. No, I haven't
> changed anything on the server that would have caused this. Even when I run
> the static binary from sqlite.org I receive the same error, so it doesn't
> seem to be a library i
> -Original Message-
> From: Igor Tandetnik [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 15, 2006 10:27 AM
> To: SQLite
> Subject: [sqlite] Re: Re: Re: Which API to use to get
> resultant of query
>
>
> sandhya <[EMAIL PROTECTED]> wrote:
> > But where as when i am executing the sam
sandhya <[EMAIL PROTECTED]> wrote:
But where as when i am executing the same from command prompt it is
showing
the OID alone.
Why it is showing DONE when i am doing it through program?Anything
wrong?
Check your condition. Make sure it's the same as the one you use in
console. Most likely, you'
yaI got now...
But where as when i am executing the same from command prompt it is showing
the OID alone.
Why it is showing DONE when i am doing it through program?Anything wrong?
Whether i should do in some other way?
please help me
-Sandhya
- Original Message -
From: "Igor Tandetni
Hi,
Dennis,thank you very much for your advice. You are right. I do make some
stupid mistake when I wrap the realloc() function for my os-less platform.
But now a new problem has emerged.
sqlite3_exec(db, "create table myt(age smallint)", NULL, NULL, NULL);
during the parser parsing the above
I got but the return type of all API's is int..So where the result will get
stored and how can i get..Please don't get fed up with the same question
again and again
i am not getting how to ask this?
i used
sqlite_exec() i don't know where the result stored and how to get it.
I also used the follow
Yes, I can open the file created on the server on my laptop. No, I haven't
changed anything on the server that would have caused this. Even when I run
the static binary from sqlite.org I receive the same error, so it doesn't
seem to be a library issue.
On 9/15/06, Jay Sprenkle <[EMAIL PROTECTED
sandhya <[EMAIL PROTECTED]> wrote:
Ya now i am getting error code which says SQLITE_DONE
It's not an error. It's a success code meaning that you've reached the
end of resultset. If you get that on the very first call to
sqlite3_step, it means your resultset is empty - there are no rows
match
> Ya now i am getting error code which says SQLITE_DONE...so how can get my
> resultant now?
> Which API i should use?Please tell me
After running prepare, you can get the data like this:
//This while loop will step through every row one by one
while (sqlite3_step(pStmt) == SQLITE_ROW)
{
You mean there is no need for me to take care of this function calls ..Its
just enough having definition there.
But by doing that i am not getting any kind of output ie my OID.
- Original Message -
From: "Noel Frankinet" <[EMAIL PROTECTED]>
To:
Sent: Friday, September 15, 2006 8:02 PM
On 9/15/06, Jay Johnston <[EMAIL PROTECTED]> wrote:
No trac.db in the results of lsof. Also, no processes owned by me in
/proc/locks.
can you open the file created on the server on your laptop?
if you're dynamically linking it may be loading the wrong shared libs.
Have you installed anything o
On 9/15/06, sandhya <[EMAIL PROTECTED]> wrote:
Actually my query is returing only one data ie OID of the fileIn this
case what i can do to get that data.Where it will get stored?
look at the documentation for sqlite_bind():
http://sqlite.org/capi3ref.html#sqlite3_bind_text
It explains how t
Ya now i am getting error code which says SQLITE_DONE...so how can get my
resultant now?
Which API i should use?Please tell me
- Original Message -
From: "Igor Tandetnik" <[EMAIL PROTECTED]>
To: "SQLite"
Sent: Friday, September 15, 2006 7:57 PM
Subject: [sqlite] Re: Which API to use to
No trac.db in the results of lsof. Also, no processes owned by me in
/proc/locks.
On 9/15/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote:
On 9/14/06, Jay Johnston <[EMAIL PROTECTED]> wrote:
> I'm having a strange problem since earlier today where all sqlite tables
on
> my shared webserver seem to
sandhya a écrit :
Thanks a lot for your response
Actually there is one function call in some sample found like,
static int callback(void *NotUsed, int argc, char **argv, char **azColName)
{
int i;
for(i=0; i
you don't call that callback , its called by sqlite...
In your case argc will b
sandhya <[EMAIL PROTECTED]> wrote:
sprintf(szQuery,"select oid from %s where filename =
'%s'",sampletbl,test.htm);
sqlite3_prepare(db,szQuery, 512 , &pStmt, 0);
It is unlikely that szQuery string is 512 characters long. So you
instruct SQLite to compile a long string of garbage. sqlite3_prepa
Thanks a lot for your response
Actually there is one function call in some sample found like,
static int callback(void *NotUsed, int argc, char **argv, char **azColName)
{
int i;
for(i=0; i
To:
Sent: Friday, September 15, 2006 7:38 PM
Subject: Re: [sqlite] Which API to use to get resultant o
On 9/14/06, Jay Johnston <[EMAIL PROTECTED]> wrote:
I'm having a strange problem since earlier today where all sqlite tables on
my shared webserver seem to be locked. I have a trac installation using
sqlite that started giving me "database is locked" errors earlier today and
continues to do so.
On 9/15/06, sandhya <[EMAIL PROTECTED]> wrote:
sprintf(szQuery,"select oid from %s where filename = '%s'",sampletbl,test.htm);
there's an example program here:
http://sqlite.org/quickstart.html
and a more involved one here
http://www.reddawn.net/~jsprenkl/Sqlite
--
--
SqliteImporter and Sqli
hi list
in other DBs one can create time stamp column with
CREATE TABLE todo (
id serial primary key,
title text,
created timestamp default now(),
done boolean default 'f'
);
I thought this was fixed. Which version do you have?
The DEFAULT constraint specifies a default value to use
sprintf(szQuery,"select oid from %s where filename = '%s'",sampletbl,test.htm);
sqlite3_prepare(db,szQuery, 512 , &pStmt, 0);
errcode = sqlite3_step(pStmt);
But the error code i am getting is 21..Somethig when i read in docs it gave
misuseCan you please tell me where i did mistake.
Is
hi list
in other DBs one can create time stamp column with
CREATE TABLE todo (
id serial primary key,
title text,
created timestamp default now(),
done boolean default 'f'
);
in SQLITE probably I have to add a trigger on the INSERT
event (right?) to do the same:
CREATE TABLE todo (
id
Thanks a lot for your response
Actually there is one function call in some sample found like,
static int callback(void *NotUsed, int argc, char **argv, char **azColName)
{
int i;
for(i=0; i
To:
Sent: Friday, September 15, 2006 6:31 PM
Subject: Re: [sqlite] reg:Sqlite API's
> sandhya wrote:
sandhya wrote:
Hi all,
Can you please tell me the usage of sqlite_prepare() /sqlite_exec()
Have you looked at the SQLite source code? The stand-alone executable
should be of help. I believe it is shell.c
HTH,
Gerry
--
Hi all,
Can you please tell me the usage of sqlite_prepare() /sqlite_exec() inorder
to execute a query say for example,
I have given a query like ,
strcpy(szQuery," SELECT OID from table sample where name ="XXX"");
I have used sqlite_exec(db,szQuery,0,0,0);
Where my resultant data will get s
Dixon Hutchinson <[EMAIL PROTECTED]> wrote:
> I am running version 3.3.6 compiled with Visual Studio .net 2003 in a
> single threaded app.
>
> While using sqlite3_exec to execute a "COMMIT;", in run into a null
> pointer problem in sqlite3_step.
>
> I added tests for the null pointer to vdbeapi
Mark Richards <[EMAIL PROTECTED]> wrote:
> With sqlite version 3.3.7 if I create a new database using:
>
> if (sqlite3_open("/var/tmp/solarwave/aem.db", &db)!=0)
> {
> printf("Cannot open db\n");
> return(false);
> }
>
> and then issue the following:
>
> snp
Hi Jose,
thanks for your explanations. :)
AFAIR it is a good practice to separate OLTP and OLAP databases. In this
case you do not impact interactivity and feel free to
rotate/transform/reformat data as you wish.
WBR, Denis
-Original Message-
From: jose simas [mailto:[EMAIL PROTECTED]
54 matches
Mail list logo
