Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 version andlater

2013-01-11 Thread ajm 

Problem (partially) solved:

Using MS Windows 8; MS Visual Studio 2012 for desktop, and SQLite 3.7.15.1 I 
get consistently the following behavior for the application:

Running in Debug-mode, fails as reported in the OP.

Running in Release-mode (without debugging), fails as reported.

Starting the resulting executable as stand-alone -from the desktop or from the 
CLI-, run as expected without error.

HTH to some one else.

--
Adolfo J.Millan
Zator Systems.


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

Re: [sqlite] showwal.c to find WAL file differences? (trying to analyze some lost commits)

2013-01-11 Thread Clemens Ladisch 
Simon Slavin wrote:
> I looked into ways of checking that the file was being accessed locally
> rather than on a network share and totally failed.  There didn't seem
> to be any way of doing this under Windows which worked all the time.

So GetDriveType didn't work?



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

Re: [sqlite] showwal.c to find WAL file differences? (trying to analyze some lost commits)

2013-01-11 Thread Simon Slavin 

On 11 Jan 2013, at 11:01am, Clemens Ladisch  wrote:

> Simon Slavin wrote:
>> I looked into ways of checking that the file was being accessed locally
>> rather than on a network share and totally failed.  There didn't seem
>> to be any way of doing this under Windows which worked all the time.
> 
> So GetDriveType didn't work?
> 

That looks like it would be an excellent solution now.  Back when I did this 
was 20 years ago and I never found a call like that for the version of Windows 
we were using.  Certainly USB drives hadn't been invented.

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

Re: [sqlite] How to decrease IO usage

2013-01-11 Thread Bebel 
Hi Michael,

Thanks for your feed back, but as far as I understand the pragma cache size,
it's only increase the cache size during the session.
But the cache is deleted when the database is close.

In my case, I only make short transaction on the database, like open, read
and immediately close. I can't maintain the session active.

But, one of my possible solution is to put database in memory, with vmstat
for example. It will produce something similar, because all the data will be
in memory.

However, I'm looking for sqlite solutions. I can get around of my latence
problem with system solution, but if I can optimize my solr usage, it will
be better. I feel that my usage is not as optimal as it could be.



--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/How-to-decrease-IO-usage-tp66474p66494.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

Re: [sqlite] How to decrease IO usage

2013-01-11 Thread Bebel 
Hi Igor,

Well it's a interesting solution, and I already explored this possibility.
Now, it will be too expansive and complicated for us to migrate data from
sqlite to nosql solution.

We choose sqlite about 5 years ago, when nosql was not an industrial
solution. Sqlite was the best choice.

Now we "must" use sqlite, and we need to the best with it !





--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/How-to-decrease-IO-usage-tp66474p66497.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

Re: [sqlite] How to decrease IO usage

2013-01-11 Thread Bebel 
Hi Simon,

I include all the operation made by my action (so open/close are included).

I create one base per user, so I prefer not to merge database to make one
bigger.

Thanks for your help.



--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/How-to-decrease-IO-usage-tp66474p66502.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] convert a .sql file to a .db file

2013-01-11 Thread kevnm67 
Hey everyone!

I'm new to sql and having trouble figuring out how can I convert my .sql
file to a .db file?

I originally had the database made by someone who ran a python script on my
.csv file and parsed the info into a .db file. Running this script has been
inconsistent for me - yesterday AM it worked but late afternoon it did not. 
I'd rather use a GUI for SQLite to deal with the database ….unless y'all
have some suggestions?

The database is for my iOS application.

Thanks for any help y'all can provide!

Kevin



--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/convert-a-sql-file-to-a-db-file-tp66516.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

Re: [sqlite] How to decrease IO usage

2013-01-11 Thread Simon Slavin 

On 10 Jan 2013, at 2:42pm, Bebel  wrote:

> I include all the operation made by my action (so open/close are included).
> 
> I create one base per user, so I prefer not to merge database to make one
> bigger.

Okay.  This means that your enquiry is not the standard one of "faster 
operations at all costs" that we get, you are unusual in that you want to open 
and close databases very quickly and answers to other people's queries probably 
won't consider that.

I suppose you could always look at faster hardware.  For example I have found 
that opening a SQLite file on SSD is far faster than doing the same thing on a 
spinning drive.

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

Re: [sqlite] convert a .sql file to a .db file

2013-01-11 Thread Simon Slavin 

On 11 Jan 2013, at 11:52am, kevnm67  wrote:

> I'm new to sql and having trouble figuring out how can I convert my .sql
> file to a .db file?

Use a SQLite tool to dump to .csv format, then use a DB tool to import the .csv 
to DB format.  Since this is a SQLite list, we can help with a good SQLite tool:

http://www.sqlite.org/sqlite.html

You might want ".mode csv".

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

Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 version andlater

2013-01-11 Thread Igor Tandetnik 

On 1/11/2013 5:34 AM, a...@zator.com wrote:

Problem (partially) solved:

Using MS Windows 8; MS Visual Studio 2012 for desktop, and SQLite 3.7.15.1 I 
get consistently the following behavior for the application:

Running in Debug-mode, fails as reported in the OP.

Running in Release-mode (without debugging), fails as reported.

Starting the resulting executable as stand-alone -from the desktop or from the 
CLI-, run as expected without error.


Current working directory is different in these cases. I bet you are 
using relative paths in your statements. In which case it's a simple 
matter of SQLite using the right database file sometimes, but creating a 
blank new one other times.

--
Igor Tandetnik

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

Re: [sqlite] sqlite version of android 4.0.3

2013-01-11 Thread sqlitekyounoii 
thank you

using emulator,
after adb shell login, sqlite3 command was displayed that's version.

2013/01/10 10:53、Yongil Jang  のメッセージ:

> ~Android gingerbread: 3.6.22
> Honeycomb~ICS: 3.7.4
> Jellybean~:3.7.11
> On Jan 10, 2013 9:23 AM, "sqlitekyounoii" 
> wrote:
> 
>> I want to know sqlite version of android 4.0.3
>> 
>> It's bundle, so version is not know.
>> ___
>> 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-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Don't passes next tests on FreeBSD: atof1-*

2013-01-11 Thread Pavel Volkov 
Hello.

On a 64 bit system, all the tests running are successful.

log compilation
https://docs.google.com/file/d/0Bz0ZXsXvwY_gc09EeWk1VEktRVk/edit

log testing
https://docs.google.com/file/d/0Bz0ZXsXvwY_geDlIRWlUSTZTMFE/edit

My operating system:
FreeBSD fb2.localhost 9.1-PRERELEASE FreeBSD 9.1-PRERELEASE #1
r244644: Tue Dec 25 10:11:44 MSK 2012
root@fb2.localhost:/usr/obj/usr/src/sys/ext  amd64

and compiler:
gcc (GCC) 4.2.1 20070831 patched [FreeBSD]

and "cpp -dM" output:

#define _LONGLONG 1
#define _LP64 1
#define __CHAR_BIT__ 8
#define __DBL_DENORM_MIN__ 4.9406564584124654e-324
#define __DBL_DIG__ 15
#define __DBL_EPSILON__ 2.2204460492503131e-16
#define __DBL_HAS_DENORM__ 1
#define __DBL_HAS_INFINITY__ 1
#define __DBL_HAS_QUIET_NAN__ 1
#define __DBL_MANT_DIG__ 53
#define __DBL_MAX_10_EXP__ 308
#define __DBL_MAX_EXP__ 1024
#define __DBL_MAX__ 1.7976931348623157e+308
#define __DBL_MIN_10_EXP__ (-307)
#define __DBL_MIN_EXP__ (-1021)
#define __DBL_MIN__ 2.2250738585072014e-308
#define __DEC128_DEN__ 0.1E-6143DL
#define __DEC128_EPSILON__ 1E-33DL
#define __DEC128_MANT_DIG__ 34
#define __DEC128_MAX_EXP__ 6144
#define __DEC128_MAX__ 9.9E6144DL
#define __DEC128_MIN_EXP__ (-6143)
#define __DEC128_MIN__ 1E-6143DL
#define __DEC32_DEN__ 0.01E-95DF
#define __DEC32_EPSILON__ 1E-6DF
#define __DEC32_MANT_DIG__ 7
#define __DEC32_MAX_EXP__ 96
#define __DEC32_MAX__ 9.99E96DF
#define __DEC32_MIN_EXP__ (-95)
#define __DEC32_MIN__ 1E-95DF
#define __DEC64_DEN__ 0.001E-383DD
#define __DEC64_EPSILON__ 1E-15DD
#define __DEC64_MANT_DIG__ 16
#define __DEC64_MAX_EXP__ 384
#define __DEC64_MAX__ 9.999E384DD
#define __DEC64_MIN_EXP__ (-383)
#define __DEC64_MIN__ 1E-383DD
#define __DECIMAL_DIG__ 21
#define __DEC_EVAL_METHOD__ 2
#define __ELF__ 1
#define __FINITE_MATH_ONLY__ 0
#define __FLT_DENORM_MIN__ 1.40129846e-45F
#define __FLT_DIG__ 6
#define __FLT_EPSILON__ 1.19209290e-7F
#define __FLT_EVAL_METHOD__ 0
#define __FLT_HAS_DENORM__ 1
#define __FLT_HAS_INFINITY__ 1
#define __FLT_HAS_QUIET_NAN__ 1
#define __FLT_MANT_DIG__ 24
#define __FLT_MAX_10_EXP__ 38
#define __FLT_MAX_EXP__ 128
#define __FLT_MAX__ 3.40282347e+38F
#define __FLT_MIN_10_EXP__ (-37)
#define __FLT_MIN_EXP__ (-125)
#define __FLT_MIN__ 1.17549435e-38F
#define __FLT_RADIX__ 2
#define __FreeBSD__ 9
#define __FreeBSD_cc_version 91
#define __GNUC_GNU_INLINE__ 1
#define __GNUC_MINOR__ 2
#define __GNUC_PATCHLEVEL__ 1
#define __GNUC__ 4
#define __GXX_ABI_VERSION 1002
#define __INTMAX_MAX__ 9223372036854775807L
#define __INTMAX_TYPE__ long int
#define __INT_MAX__ 2147483647
#define __KPRINTF_ATTRIBUTE__ 1
#define __LDBL_DENORM_MIN__ 3.64519953188247460253e-4951L
#define __LDBL_DIG__ 18
#define __LDBL_EPSILON__ 1.08420217248550443401e-19L
#define __LDBL_HAS_DENORM__ 1
#define __LDBL_HAS_INFINITY__ 1
#define __LDBL_HAS_QUIET_NAN__ 1
#define __LDBL_MANT_DIG__ 64
#define __LDBL_MAX_10_EXP__ 4932
#define __LDBL_MAX_EXP__ 16384
#define __LDBL_MAX__ 1.18973149535723176502e+4932L
#define __LDBL_MIN_10_EXP__ (-4931)
#define __LDBL_MIN_EXP__ (-16381)
#define __LDBL_MIN__ 3.36210314311209350626e-4932L
#define __LONG_LONG_MAX__ 9223372036854775807LL
#define __LONG_MAX__ 9223372036854775807L
#define __LP64__ 1
#define __MMX__ 1
#define __NO_INLINE__ 1
#define __PTRDIFF_TYPE__ long int
#define __REGISTER_PREFIX__
#define __SCHAR_MAX__ 127
#define __SHRT_MAX__ 32767
#define __SIZE_TYPE__ long unsigned int
#define __SSE2_MATH__ 1
#define __SSE2__ 1
#define __SSE_MATH__ 1
#define __SSE__ 1
#define __STDC_HOSTED__ 1
#define __STDC__ 1
#define __UINTMAX_TYPE__ long unsigned int
#define __USER_LABEL_PREFIX__
#define __VERSION__ "4.2.1 20070831 patched [FreeBSD]"
#define __WCHAR_MAX__ 2147483647
#define __WCHAR_TYPE__ int
#define __WINT_TYPE__ int
#define __amd64 1
#define __amd64__ 1
#define __k8 1
#define __k8__ 1
#define __unix 1
#define __unix__ 1
#define __x86_64 1
#define __x86_64__ 1
#define unix 1
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Using SQLite on a networkshare

2013-01-11 Thread Stephen Chrzanowski 
It boils down to that SQLite is working as intended as it can only rely on
what the OS feeds it.  As stated, the developers of SQLite are not going to
be looking at network sharing as the responsibility of file locking is on
the OS, not SQLite.  Network sharing is tricky, and it "seems" seamless
when used with SMB, Windows Client, and all that, however, there are
workarounds in the back end (SMB/MSC) that gets around the limitations,
such as writing files.  Latency, even on a GigE network isn't nearly that
of what is local.  SQLite is NOT a full out database management system.
This isn't its purpose in life.  I think even MySQL recommends that its
data stores not be put on a remote share.

In *MY* experience, I'm either randomly -reading- random bits of data from
a file over a share, or, bulk transferring data in either direction by
means of a file copy, or, watching a movie, listening to audio, etc,
however, I'm only doing one operation on the file at once, not reading and
writing to the same file from multiple sources.  I don't recall ever
randomly writing bits of data directly over a share, then expecting
multiple remote machines to properly handle file locking since that is the
responsibility of the machine holding the data.  In all cases of data
transfer I've done via network, its been a one-on-one communication.  Heck,
even back in the DOS days when relying on SHARE.EXE for proper file sharing
between processes (Remember Desqview anyone?) even THAT was quite the pain!

As of late, however, I've been trying to formulate a plan about how I can
share data over the network in this regard, and the only one that I seem to
have come up with is to backup or copy the file locally (Either by a
standard file copy, or, SQLites Backup command), then when done, copy the
file back.  The problem starts hitting home when multiple sessions, or
machines start poking at the data remotely and making changes.  Whoever
last writes the data wins, and that isn't exactly the best of environments.
;)  I've also looked at making a client/server application for SQLite, but
I end up going to MySQL at that point since I already have the ODBC
installed locally.

On Tue, Jan 8, 2013 at 5:36 AM, Raymond Meester wrote:

> Hi JCHD,
>
> Thnx for your notice. Of course I checked the AutoIt forum first. There is
> indeed some discussion on this topic, but no solution that worked for me. I
> also checked the solution by atensoft (actually I used this for a while,
> but couldn't find out how to properly write a wrapper for it in
> server/client configuration). Anyway I wrote with the default sqlite dll
> and the default tcp Autoit libraries a server/client solution. As I said in
> my first post this worked.
>
> The question however remains how can I keep using sqlite serverless on a
> networkshare. The current implementation relies on calling directly the OS.
> This doesn't work, so I wonder if the devs will make changes to avoid these
> errors, instead of warning users the avoid a common use case scenario.
>
> Simon wrote
>
>
> 2013/1/8 Jean-Christophe Deschamps 
>
> > Raymond,
> >
> >
> >  So I checked some server/client solutions from
> >> http://www.sqlite.org/cvstrac/**wiki?p=SqliteNetwork<
> http://www.sqlite.org/cvstrac/wiki?p=SqliteNetwork>.
> >> But as there wasn't a
> >> solution that supported my script
> >> language (Autoit) I ended up writing my own server/client solution. This
> >> worked for me, but I still have some questions regarding this issue:
> >>
> >
> > I'm the de-facto maintainer of the SQLite AutoIt UDF. While the UDF
> > currently relies on the standard SQLite .dll file I believe you could try
> > using a variant library enriched with a TCP/IP client/server layer like
> > this one:
> > http://www.atensoft.com/dev/**sqlite3.php<
> http://www.atensoft.com/dev/sqlite3.php>
> >
> > I never looked at it closely but I guess it would be fairly easy to make
> a
> > compatible wrapper around this version.
> >
> > Anyway I advise you browse the US AutoIt forum as there have been some
> > discussions about such shared use. You can join me there as jchd (MVP)
> and
> > also on the french AutoIt forum (also jchd).
> >
> >
> > __**_
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<
> 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-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] memsubsys1-8.4...Assertion failed: (EIGHT_BYTE_ALIGNMENT(p)) with --enable-debug

2013-01-11 Thread Pavel Volkov 
Hello.
I'm found next error in tests

memsubsys1-8.3... Ok
memsubsys1-8.4...Assertion failed: (EIGHT_BYTE_ALIGNMENT(p)), function
sqlite3Malloc, file sqlite3.c, line 18891.
*** [test] Signal 6

when compiling sqlite with options

CONFIGURE_ARGS+=--enable-debug
CPPFLAGS+=  -Wall

compilation log
https://docs.google.com/file/d/0Bz0ZXsXvwY_gUlpJQ2M1cGtnRHM/edit

testing log
https://docs.google.com/file/d/0Bz0ZXsXvwY_gU1J2Mk41OXJQYUk/edit

FreeBSD fb2.localhost 9.1-PRERELEASE FreeBSD 9.1-PRERELEASE #1
r244644: Tue Dec 25 10:11:44 MSK 2012
root@fb2.localhost:/usr/obj/usr/src/sys/ext  amd64

gcc (GCC) 4.2.1 20070831 patched [FreeBSD]

cpp -dM /dev/null | sort

#define _LONGLONG 1
#define _LP64 1
#define __CHAR_BIT__ 8
#define __DBL_DENORM_MIN__ 4.9406564584124654e-324
#define __DBL_DIG__ 15
#define __DBL_EPSILON__ 2.2204460492503131e-16
#define __DBL_HAS_DENORM__ 1
#define __DBL_HAS_INFINITY__ 1
#define __DBL_HAS_QUIET_NAN__ 1
#define __DBL_MANT_DIG__ 53
#define __DBL_MAX_10_EXP__ 308
#define __DBL_MAX_EXP__ 1024
#define __DBL_MAX__ 1.7976931348623157e+308
#define __DBL_MIN_10_EXP__ (-307)
#define __DBL_MIN_EXP__ (-1021)
#define __DBL_MIN__ 2.2250738585072014e-308
#define __DEC128_DEN__ 0.1E-6143DL
#define __DEC128_EPSILON__ 1E-33DL
#define __DEC128_MANT_DIG__ 34
#define __DEC128_MAX_EXP__ 6144
#define __DEC128_MAX__ 9.9E6144DL
#define __DEC128_MIN_EXP__ (-6143)
#define __DEC128_MIN__ 1E-6143DL
#define __DEC32_DEN__ 0.01E-95DF
#define __DEC32_EPSILON__ 1E-6DF
#define __DEC32_MANT_DIG__ 7
#define __DEC32_MAX_EXP__ 96
#define __DEC32_MAX__ 9.99E96DF
#define __DEC32_MIN_EXP__ (-95)
#define __DEC32_MIN__ 1E-95DF
#define __DEC64_DEN__ 0.001E-383DD
#define __DEC64_EPSILON__ 1E-15DD
#define __DEC64_MANT_DIG__ 16
#define __DEC64_MAX_EXP__ 384
#define __DEC64_MAX__ 9.999E384DD
#define __DEC64_MIN_EXP__ (-383)
#define __DEC64_MIN__ 1E-383DD
#define __DECIMAL_DIG__ 21
#define __DEC_EVAL_METHOD__ 2
#define __ELF__ 1
#define __FINITE_MATH_ONLY__ 0
#define __FLT_DENORM_MIN__ 1.40129846e-45F
#define __FLT_DIG__ 6
#define __FLT_EPSILON__ 1.19209290e-7F
#define __FLT_EVAL_METHOD__ 0
#define __FLT_HAS_DENORM__ 1
#define __FLT_HAS_INFINITY__ 1
#define __FLT_HAS_QUIET_NAN__ 1
#define __FLT_MANT_DIG__ 24
#define __FLT_MAX_10_EXP__ 38
#define __FLT_MAX_EXP__ 128
#define __FLT_MAX__ 3.40282347e+38F
#define __FLT_MIN_10_EXP__ (-37)
#define __FLT_MIN_EXP__ (-125)
#define __FLT_MIN__ 1.17549435e-38F
#define __FLT_RADIX__ 2
#define __FreeBSD__ 9
#define __FreeBSD_cc_version 91
#define __GNUC_GNU_INLINE__ 1
#define __GNUC_MINOR__ 2
#define __GNUC_PATCHLEVEL__ 1
#define __GNUC__ 4
#define __GXX_ABI_VERSION 1002
#define __INTMAX_MAX__ 9223372036854775807L
#define __INTMAX_TYPE__ long int
#define __INT_MAX__ 2147483647
#define __KPRINTF_ATTRIBUTE__ 1
#define __LDBL_DENORM_MIN__ 3.64519953188247460253e-4951L
#define __LDBL_DIG__ 18
#define __LDBL_EPSILON__ 1.08420217248550443401e-19L
#define __LDBL_HAS_DENORM__ 1
#define __LDBL_HAS_INFINITY__ 1
#define __LDBL_HAS_QUIET_NAN__ 1
#define __LDBL_MANT_DIG__ 64
#define __LDBL_MAX_10_EXP__ 4932
#define __LDBL_MAX_EXP__ 16384
#define __LDBL_MAX__ 1.18973149535723176502e+4932L
#define __LDBL_MIN_10_EXP__ (-4931)
#define __LDBL_MIN_EXP__ (-16381)
#define __LDBL_MIN__ 3.36210314311209350626e-4932L
#define __LONG_LONG_MAX__ 9223372036854775807LL
#define __LONG_MAX__ 9223372036854775807L
#define __LP64__ 1
#define __MMX__ 1
#define __NO_INLINE__ 1
#define __PTRDIFF_TYPE__ long int
#define __REGISTER_PREFIX__
#define __SCHAR_MAX__ 127
#define __SHRT_MAX__ 32767
#define __SIZE_TYPE__ long unsigned int
#define __SSE2_MATH__ 1
#define __SSE2__ 1
#define __SSE_MATH__ 1
#define __SSE__ 1
#define __STDC_HOSTED__ 1
#define __STDC__ 1
#define __UINTMAX_TYPE__ long unsigned int
#define __USER_LABEL_PREFIX__
#define __VERSION__ "4.2.1 20070831 patched [FreeBSD]"
#define __WCHAR_MAX__ 2147483647
#define __WCHAR_TYPE__ int
#define __WINT_TYPE__ int
#define __amd64 1
#define __amd64__ 1
#define __k8 1
#define __k8__ 1
#define __unix 1
#define __unix__ 1
#define __x86_64 1
#define __x86_64__ 1
#define unix 1
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users