Re: [sqlite] SQLite: Porting to another Operating system.

D. Richard Hipp wrote: > On Jul 24, 2009, at 8:37 AM, CityDev wrote: > > >> I'm new to SQLite. I would assume you would dump the tables to an >> external >> format and then load them into the new database. I can't however see >> where >> the documentation is for this kind of database managem

[sqlite] SQLite: Porting to another Operating system.

there any doc that offers guidelines for successfully porting SQLite to another operating system. Regards, chandan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] writing images to an SQLite database using SQLite command line program.

s into the "img" column? Regards, chandan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Value returned by sqlite3_column_bytes for strings

Thanks for the reply! Simon Davies wrote: > 2009/7/3 chandan : > >> Hi all, >>Consider the following scenario, >>1. A table contains a column of type "text". >>2. The value of this column for the first row is say "linux". >&g

[sqlite] Value returned by sqlite3_column_bytes for strings

Hi all, Consider the following scenario, 1. A table contains a column of type "text". 2. The value of this column for the first row is say "linux". If we execute the SQL statement: "select name from some_tbl where id = ?" using sqlite3_step() API, then what is the value returned by sq

Re: [sqlite] unable to write the string "1.0" into a database table

tmt); if (ret != SQLITE_OK) { fprintf(stderr, "sqlite3_finalize: %s", sqlite3_errmsg(db)); } out2: ret = sqlite3_close(db); out1: exit(1); } /*/ Simon Slavin wrote

Re: [sqlite] unable to write the string "1.0" into a database table

(ret != SQLITE_OK) { fprintf(stderr, "sqlite3_finalize: %s", sqlite3_errmsg(db)); } out2: ret = sqlite3_close(db); out1: exit(1); } // Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > ch

[sqlite] unable to write the string "1.0" into a database table

ing anything wrong in the program? Regards, chandan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Reducing the size of executable linked with sqlite3.c

Hi, I am using the "Amalgamation" version of SQLite. I wanted to know the compile time options (if any) to reduce the size of the executable that is linked with sqlite3.c file. Regards, chandan ___ sqlite-users mailing list sqlite-users@

[sqlite] Difference between sqlite3_bind_zeroblob & sqlite3_bind_blob( , , , 0, )

); goto out3; } - Thanks & Regards, chandan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Checking if an "integer" column is set to NULL

Thanks a lot!. The solution works :-) Hamish Allan wrote: > On Mon, May 25, 2009 at 1:15 PM, chandan > wrote: > > >>I have used sqlite3_bind_null() API to bind an integer column with >> NULL. When I read the value of that integer column I get the value as 0 >&

[sqlite] Checking if an "integer" column is set to NULL

Hi, I have used sqlite3_bind_null() API to bind an integer column with NULL. When I read the value of that integer column I get the value as 0 (zero). Is there any way I can check if the column is set to NULL? Regards, chandan. ___ sqlite-users

[sqlite] Using amalgamation *.[ch] files on different architectures

Hi, I have generated the amalgamation file using the command "make sqlite3.c". This was done on an x86 machine running Linux. Can I use the generated sqlite3.[ch] files on a different architecture machine running Linux? Regard

[sqlite] sqlite3_exec(): errmsg parameter

, &err_msg); if (ret != SQLITE_OK) { if (err_msg != NULL) { /* is this checking necessary? */ /* print err_msg */ sqlite3_free(err_msg); } } Regards, chandan ___ sqlite-users mailing list sqlite-users@sqlite.org http://s

[sqlite] memory occupied by columns with NULL value

Hi, I would like to know how much memory is used for a record field whose value is NULL. Regards, chandan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite performance issues on Linux running on MIPS (BIG ENDIAN)

Hi, I am planning to use sqlite in an application program. The application will be running in Linux environment on MIPS processor (BIG ENDIAN). Are there any sqlite performance issues when running on MIPS processor with Linux as the OS. In particular are there any issues regarding non-aligned m

RE: [sqlite] unaligned access with sqlite 3.3.3 on IA64

Thanks for the fix, every thing seems to work fine with sqlite-3.3.4 Regards Chandan Dutta Chowdhury -Original Message- From: Chowdhury, Chandan Dutta Sent: Saturday, February 11, 2006 12:32 PM To: [EMAIL PROTECTED]; sqlite-users@sqlite.org Subject: RE: [sqlite] unaligned access with

RE: [sqlite] unaligned access with sqlite 3.3.3 on IA64

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, February 10, 2006 7:41 PM To: sqlite-users@sqlite.org; Chowdhury, Chandan Dutta Subject: Re: [sqlite] unaligned access with sqlite 3.3.3 on IA64 "Chowdhury, Chandan Dutta" <[EMAIL PROT

[sqlite] unaligned access with sqlite 3.3.3 on IA64

cess to 0x6008e134, ip=0x239503e0 python(26534): unaligned access to 0x6008e1f4, ip=0x239503e0 Is this a bug in sqlite. Thanks in advance for the help. Regards Chandan Dutta Chowdhury