Re: [sqlite] SQLite Windows Mobile 6 Edition

[Shane Harrelson]

What compiler and compile time options are you using?


On Fri, Sep 4, 2009 at 2:00 PM, Dominique Jann wrote:
> Good night.
>
> I have a question about SQLite, very interesting project, how
> compiling SQLite sources for Windows Mobile 6.
> I couldn't compile project for this platform because have a many
> errors in compiling process.
> If you can hel me with this, i will be very thankful.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite Windows Mobile 6 Edition

[Timothy A. Sawyer]

I would be extremely interested in what you are doing with this project. 


-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Dominique Jann
Sent: Friday, September 04, 2009 2:00 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] SQLite Windows Mobile 6 Edition

Good night.

I have a question about SQLite, very interesting project, how 
compiling SQLite sources for Windows Mobile 6.
I couldn't compile project for this platform because have a many 
errors in compiling process.
If you can hel me with this, i will be very thankful.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite Windows Mobile 6 Edition

[Dominique Jann]

Good night.

I have a question about SQLite, very interesting project, how 
compiling SQLite sources for Windows Mobile 6.
I couldn't compile project for this platform because have a many 
errors in compiling process.
If you can hel me with this, i will be very thankful.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Slow SELECT query

[aba . elhaddi]

Let's see if we can make the 7pm one.

Eh
Sent via BlackBerry from T-Mobile

-Original Message-
From: wlof 

Date: Fri, 4 Sep 2009 07:52:43 
To: 
Subject: Re: [sqlite] Slow SELECT query




Sebastian Bermudez wrote:
> 
> 1)
> Ok, change the index to:
> CREATE INDEX IF NOT EXISTS log_idx ON log (timestamp)
> 
> column Id is not used for select...
> the Id column just is needed for delete operation.
> 
This seems to have done the trick. The SELECT query now takes ~15 ms. Much
better :)

I didn't think adding the id in the index would have such consequences! I
take it adding an index on id AND timestamp is definitely not the same thing
than adding an index on id AND adding an index on timestamp.

Thanks a lot for your help! It is much appreciated.


-- 
View this message in context: 
http://www.nabble.com/Slow-SELECT-query-tp25294597p25295851.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Loading FTS3 as module: SQL error: error during initialization:

[Lukas Haase]

Hi,

I want to load FTS3 dynamically as a module. I compile it from the 
source with:

gcc -c fts3.c
gcc -c fts3_expr.c
gcc -c fts3_hash.c
gcc -c fts3_icu.c
gcc -c fts3_porter.c
gcc -c fts3_tokenizer1.c
gcc -c fts3_tokenizer.c
gcc -shared fts3_expr.o fts3_hash.o fts3_icu.o fts3.o fts3_porter.o \
   fts3_tokenizer1.o  fts3_tokenizer.o -o libSqliteFts3.so

But then loading fails:

sqlite> SELECT load_extension('./libSqliteFts3.so');
SQL error: error during initialization:
sqlite>

Does anybody have a hint?

Background: I use Debian with PHP and PDO (php5-sqlite, libsqlite3-0) 
where FTS is built into the core. But I need a modified FTS: The module 
should ONLY save the index and not the data. So I modified the source so 
that the data is not inserted. I can't compile the whole system myself 
because of the many dependencies. So I want just to compile my own 
modified FTS3 (see above) and load it dynamically.

Thanks in advance,
Luke

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite3_exec not functioning on arm_v6 toolchain

[Umang Gupta]

I am using sqlite3_exec() to run a sql query on arm machine but I am getting
error saying : "malformed database schema error : unrecognized token " ' " . 
sqlite version is : 3.6.17.
here is the code snippet being used : 

** 
#include 
#include 
#include 

static int
callback (void *NotUsed, void *NOTUsed, char *ch_strings_p2[4],
  char *ch_ColName_p2[4])
{
 printf ("\n\n START CALLBACK  \n  ");
 return 0;

 }


int main  ()
{

  sqlite3 *db;
  char *zErrMsg = 0;
  int rc;
  const char *command = "select * from sqlite_master";  

  rc = sqlite3_open ("Mydatabase.db", );
  if (rc)
{
  printf (stderr, "Can't open database: %s\n", sqlite3_errmsg (db));
  sqlite3_close (db);
  return -1;
}


  rc = sqlite3_exec (db, command, (void  * )callback, 0, );
 printf("\n error code  is=%d\n",rc);
  if (rc != SQLITE_OK)
{
  
  printf (stderr, " SQL error: %s\n", zErrMsg);
  sqlite3_free (zErrMsg);
  return -1;
}
  sqlite3_close (db);
  return  0;
 }

The output on arm_v6 is ::: 
 
SQL error :  malformed database schema error : unrecognized token " '  "
error code = 4.

callback function is not being called at all . 
The most surprising thing is while doing sql query through command line , it
works properly . "PRAGMA integrity_check " succeeded on my Mydatabase.db . 

The same code works on x86 machine properly. 

Can anyone look into where is I am wrong here ??  Does sqlite3_exec  is
unstable on arm ?  what token is being referred in output error ?? 

The error code returned is 4 that indicates SQL_ABORT error . 



-- 
View this message in context: 
http://www.nabble.com/sqlite3_exec-not-functioning-on-arm_v6-toolchain-tp25307287p25307287.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users