[sqlite] [SQLite]Basic queries
Hi, Can anyone tell me answers against below my queries? Since I'm beginner of SQLite, please forgive me about so basic queries. 1) For Windows platform, there are 2 dlls on SQLite download page. means, for 32bits and 64bits Windows OS. However, in my understanding, the dll for win 32bits can work also on 64bits win OS with WOW64 as it is. Is there any special reason why there are 2 dlls on the page? And the dll for win 32bits doesn't work on win 64bits OS in spite of exsistance of WOW64? 2) I have compiled the amalgamation source code on win7 32bits OS. Though I haven't specified any compile option, in this case, For which OS platform is the generated binary? for 32bits win OS or 64bits win OS? Thanks, Dekochan. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] [SQLite]Basic queries
Thank you for your explanation!. I understood. 2014-11-14 9:33 GMT+09:00 Igor Tandetnik <i...@tandetnik.org>: > On 11/13/2014 7:27 PM, Shinichiro Yoshioka wrote: > >> 1) For Windows platform, there are 2 dlls on SQLite download page. >> means, for 32bits and 64bits Windows OS. >> However, in my understanding, the dll for win 32bits can work >> also on 64bits win OS with WOW64 as it is. >> >> Is there any special reason why there are 2 dlls on the page? >> > > A 32-bit application can only load 32-bit DLLs, and a 64-bit application > can only load 64-bit DLLs. Windows can run both kinds of applications, but > each must have a matching flavor of DLLs it uses. > > 2) I have compiled the amalgamation source code on win7 32bits OS. >> Though I haven't specified any compile option, in this case, >> For which OS platform is the generated binary? >> for 32bits win OS or 64bits win OS? >> > > Depends on which compiler you built it with - 32-bit or 64-bit. > -- > Igor Tandetnik > > > ___ > 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]Basic queries
Thank you for your promt answer! I understood. 2014-11-14 9:33 GMT+09:00 <sql...@charles.derkarl.org>: > On Thursday, November 13, 2014 04:27:02 PM Shinichiro Yoshioka wrote: > > Is there any special reason why there are 2 dlls on the page? > > And the dll for win 32bits doesn't work on win 64bits OS > > in spite of exsistance of WOW64? > > While a 32 bit version will work on a 64 bit Windows as you said, it will > not > work when linked to a 64 bit application. The 64-bit version is supplied > for > developers of 64-bit applications. > > > > > 2) I have compiled the amalgamation source code on win7 32bits OS. > > Though I haven't specified any compile option, in this case, > > For which OS platform is the generated binary? > > for 32bits win OS or 64bits win OS? > > 32 bits. > > Charles > ___ > 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]Basic query
Hi, I'm about to use sqlite-amalgamation(sqlite3.c) on Visual C++. But although the compiling was successfully finished, even if I set break point on the source code, I can't trace the working line in sqlite3.c correctly. I suspected that the sqlite3.c was optimized, but there is no opiton like that. Always the active line doesn't match to source code in debug mode. Is the code optimized automatically? if so, how can I deactivate it? If anyone knows above phenomenon, then could you please answer me?? Thanks, ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] [SQLite]Basic query
Hi, Clemens and Martin, Thank you for your prompt responses. >How exactly are you using SQLite in your program? If you are not using >the SQLite C API (sqlite3_* functions) directly, I'm using sqlite APIs for calling from C source code directly. >which Version of VC++ do you use? I'm using Visual studio express 2010. >why do you want to debug into the sqlite.c file? Since opening database API is failed, I'm trying to figure out the cause. >The file sqlite.c is just another source file for your compiler; optimizations would occcur > only if you set them in your compiler options. Yeah.. I completely agree with you, but I can't find such setting in VC++ property, So I'm asking this query... Thanks, 2014-12-08 18:14 GMT+09:00 Clemens Ladisch <clem...@ladisch.de>: > Shinichiro Yoshioka wrote: > > I'm about to use sqlite-amalgamation(sqlite3.c) on Visual C++. > > But although the compiling was successfully finished, even if I set break > > point > > on the source code, I can't trace the working line in sqlite3.c > correctly. > > How exactly are you using SQLite in your program? If you are not using > the SQLite C API (sqlite3_* functions) directly, it is likely that there > is a second copy of the SQLite library inside that other database driver. > > > Regards, > Clemens > ___ > 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]Basic query
Thank you everyone! I'll try to solve this case with your replies! Thanks, 2014年12月9日火曜日、Richard Hipp<d...@sqlite.org>さんは書きました: > On Mon, Dec 8, 2014 at 12:20 PM, Scott Robison <sc...@casaderobison.com > <javascript:;>> > wrote: > > > On Dec 8, 2014 2:10 AM, "Shinichiro Yoshioka" <dekochan...@gmail.com > <javascript:;>> > > wrote: > > > > > > Hi, > > > > > > I'm about to use sqlite-amalgamation(sqlite3.c) on Visual C++. > > > But although the compiling was successfully finished, even if I set > break > > > point > > > on the source code, I can't trace the working line in sqlite3.c > > correctly. > > > > As someone else said, the problem is that the Visual C++ debugger doesn't > > play nice with files in excess of 64KiB lines. When I had this need a > > couple years ago, I carefully split the sqlite3.c file into several > pieces > > and compiled them separately. > > > > > From the canonical SQLite source code you can type "make sqlite3-all.c" and > it will generate a version of the amalgamation that #includes a handful of > separate files (named sqlite3-N.c for N=1,2,3,), each less than 32K > lines in size. > > drh@bella:~/sqlite/bld$ make sqlite3-all.c > tclsh /home/drh/sqlite/sqlite/tool/split-sqlite3c.tcl > drh@bella:~/sqlite/bld$ wc sqlite3-*.c > 32314 165952 1228350 sqlite3-1.c > 30892 145495 1098859 sqlite3-2.c > 32729 144742 1091870 sqlite3-3.c > 32481 150359 1198841 sqlite3-4.c > 23259 100070 768733 sqlite3-5.c > 32 2371518 sqlite3-all.c > 151707 706855 5388171 total > > Include all these files in your project, but compile against just > sqlite3-all.c. > -- > D. Richard Hipp > d...@sqlite.org <javascript:;> > ___ > sqlite-users mailing list > sqlite-users@sqlite.org <javascript:;> > 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
