- "Philipp Morath" <[EMAIL PROTECTED]> wrote:
> Hello all,
>
> I made a terrible mistake. I change my running debian system.
> Hours ago, I tried to reinstall my webserver. Everything goes fine,
> exept sqlite.
> I don't know how I've done it several years ago.
> Fatal error: Call to
Hello all,
I made a terrible mistake. I change my running debian system.
Hours ago, I tried to reinstall my webserver. Everything goes fine,
exept sqlite.
I don't know how I've done it several years ago.
Fatal error: Call to undefined function sqlite_open()
I've already uncomment the lines
On Mon, Jun 23, 2008 at 01:06:05PM -0600, Gregor Brandt scratched on the wall:
> Are there any docs on how to make the amalgamation. I have to make
> this executable smaller... 409K is too big.
http://www.sqlite.org/cvstrac/wiki?p=TheAmalgamation
scratch that request, found the info...thanks
Gregor
On 23-Jun-08, at 1:06 PM , Gregor Brandt wrote:
> Are there any docs on how to make the amalgamation. I have to make
> this executable smaller... 409K is too big.
>
> Gregor
>
> On 23-Jun-08, at 1:01 PM , Jay A. Kreibich wrote:
>
>> On
Are there any docs on how to make the amalgamation. I have to make
this executable smaller... 409K is too big.
Gregor
On 23-Jun-08, at 1:01 PM , Jay A. Kreibich wrote:
> On Mon, Jun 23, 2008 at 12:40:02PM -0600, Gregor Brandt scratched on
> the wall:
>> Hi,
>>
>> I'm trying to compile the
On Mon, Jun 23, 2008 at 12:40:02PM -0600, Gregor Brandt scratched on the wall:
> Hi,
>
> I'm trying to compile the amalgamated src in 3.4.8 with -
> DSQLITE_OMIT_TRIGGER and I get the following errors:
You can't apply the flags to an existing amalgamation. You have to build
from base
John Stanton <[EMAIL PROTECTED]> wrote:
> Without looking up my code I recollect being able to pick up the
> connection pointer from the context and to continue accessing the DB.
But that's not what the OP is asking. He wants the function to pick up
values from the current row it is being called
Hi,
I'm trying to compile the amalgamated src in 3.4.8 with -
DSQLITE_OMIT_TRIGGER and I get the following errors:
Undefined symbols:
"_sqlite3TriggerSelectStep", referenced from:
_sqlite3Parser in sqlite3.o
"_sqlite3TriggerUpdateStep", referenced from:
_sqlite3Parser in
[EMAIL PROTECTED] wrote:
>
> Given a user-defined function of Foo(), and a query such as
>
> select * from sometable where foo()
>
> Is it possible from within the body of Foo() to access data from the
> current row of the database that is being examined?
>
> For instance, if I have a text
Without looking up my code I recollect being able to pick up the
connection pointer from the context and to continue accessing the DB.
Igor Tandetnik wrote:
> [EMAIL PROTECTED] wrote:
>
>>Given a user-defined function of Foo(), and a query such as
>>
>>select * from sometable where foo()
>>
BareFeet wrote:
>
> Do you have or know where to find some regex (regular expressions) for
> parsing SQLite statements such as create table, create trigger etc
> into their component parameters?
>
>
> I am only accessing SQLite from scripting environments such as
> sqlite3, perl,
[EMAIL PROTECTED] wrote:
> Given a user-defined function of Foo(), and a query such as
>
> select * from sometable where foo()
>
> Is it possible from within the body of Foo() to access data from the
> current row of the database that is being examined?
As far as I know, no. You would need to
Hi folks-
Given a user-defined function of Foo(), and a query such as
select * from sometable where foo()
Is it possible from within the body of Foo() to access data from the
current row of the database that is being examined?
For instance, if I have a text field in the db record named
>> The program took 47 seconds to run, but the results only account for
>> .39 seconds
>
> Most likely all the time is being spent in IO related system calls
> - read(), write() and fsync().
>
> Dan.
Thanks for the idea Dan. How can I confirm this or try reducing the time
spent? I use the
> Use actual field names in lookup table for idField, xField and yField.
>
Thank you!
--
Christophe Leske
www.multimedial.de - [EMAIL PROTECTED]
http://www.linkedin.com/in/multimedial
Lessingstr. 5 - 40227 Duesseldorf - Germany
0211 261 32 12 - 0177 249 70 31
Christophe Leske <[EMAIL PROTECTED]> wrote:
> can someone remember me how to fill in a rtree table with values from
> another table?
>
> Something like
>
> insert into lookup (select id, x,y from othertable) -- this doesnt
> work btw
insert into lookup(idField, xField, yField)
select id, x, y
On Jun 23, 2008, at 10:38 PM, Andrea Connell wrote:
>
>> Have you tried compiling with the profiler and seeing where the
>> time is
> being spent?
>
> I compiled with the profiler and used prof to analyze the mon.out
> file.
> The program took 47 seconds to run, but the results only account
Hello all,
I am having issues when opening the sqlite db. Here's a snippet of my code..
#include "sqlite3.h"
Int main(){
sqlite3 *db;
if (sqlite3_open("/full/path/to/mysqlite.db", ) != SQLITE_OK)
{
fprintf(stderr, "MyError found: %s\n", sqlite3_errmsg(db));
>Have you tried compiling with the profiler and seeing where the time is
being spent?
I compiled with the profiler and used prof to analyze the mon.out file.
The program took 47 seconds to run, but the results only account for .39
seconds
I do compile sqlite3.c into sqlite3.o then link it into
Dan wrote:
>
> You don't, by chance, know how to get gcc to report variable
> declarations
> mixed in with code as errors (or warnings) do you?
>
> i.e. how do I get the following to cause an error?
>
>void somefunction(){
> int one;
> popuateOne();
> int two;
>}
>
"Shailesh Birari" <[EMAIL PROTECTED]>
wrote in message
news:[EMAIL PROTECTED]
> Thanks for the input but the link you sent does not cover the
> following
>
> 1) Max number of tables in the sqlite database?
> 3) Max column name size?
> 4) Max table name size?
> 5) Max database name size?
> 6) Max
Thanks for the input but the link you sent does not cover the following
1) Max number of tables in the sqlite database?
3) Max column name size?
4) Max table name size?
5) Max database name size?
6) Max constraint name size?
7) Max table constraints in the table?
Pardon me if I have missed out
http://www.sqlite.org/limits.html
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
http://www.sqlabs.net/realsqlserver/
On Jun 23, 2008, at 8:55 AM, Shailesh Birari wrote:
> Hello all,
> I wanted to know if there are any upper limits on the following: I
> have
> seen
Hello all,
I wanted to know if there are any upper limits on the following: I have
seen sqlite_ext.h but did not any so just wanted to confirm the same.
1) Max number of tables in the sqlite database?
2) Max number of fields/columns in the table : 2000??
3) Max column name size?
4) Max table
24 matches
Mail list logo