[sqlite] System.Data.SQLite version 1.0.85.0 released

System.Data.SQLite version 1.0.85.0 (with SQLite 3.7.16.2) is now available on the System.Data.SQLite website: http://system.data.sqlite.org/ Further information about this release can be seen at http://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

Putting them in your /debug folder was just to troubleshoot. Since it worked, you can move the files to any final folder, and add a reference to System.Data.SQLite.dll And add your folder to PATH, to find SQLite.Interop.dll For the end-user you can keep it simple and put the files in the same

[sqlite] [Question] SQLITE_FCNTL_CHUNK_SIZE

Dear all, I have a qustion about using chunk size on VFS. AFAIK, chunk size means that increasing and reducing file size has dependency on chunk size. For example, with chunk size of 32KB, DB file size can be 32KB, 64KB, 96KB and so on... However, when I tested with my own test scripts that

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

On Thu, 18 Apr 2013 13:36:54 -0400, markus diersbock wrote: >Put SQLite.Interop.dll in the same folder as your VB assembly (ie >/debug or /release) Thanks for the tip. But it's kind of a pain to have to copy SQLite.Interop.dll + System.Data.SQLite.dll in \debug with every

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

Sorry... replied to the wrong message. :( -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Marc L. Allen Sent: Thursday, April 18, 2013 1:40 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] [SQLite.Net] Right

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

It has around 500 context switches per second.. so I'm thinking MosYield. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of markus diersbock Sent: Thursday, April 18, 2013 1:37 PM To: General Discussion of SQLite Database

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

Put SQLite.Interop.dll in the same folder as your VB assembly (ie /debug or /release) On Thu, Apr 18, 2013 at 9:22 AM, Gilles Ganault wrote: > Hello, > > I'm having a problem getting VB Express to find SQLite .Net: > > 1. I went to... >

Re: [sqlite] Variable-length records

On 18 Apr 2013, at 10:38am, Bk wrote: > can some one tell me which of the tcl test script tests below two points of > SQLite ? > > 1) Variable-length records If you're using the term 'variable length' because you're used to a different SQL engine, then there's a paradigm shift: almost all

Re: [sqlite] Cygwin compilation error

On 4/17/2013 08:06, Fulvio Esposito wrote: I'm trying to use sqlite (tried 3.6 and the latest) in a project using cygwin I just released SQLite 3.7.16.2-1 to the Cygwin repo mirrors a few days ago. If your mirror of choice is in sync, you can download it now. Is there some reason you can't

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

On Thu, 18 Apr 2013 16:10:48 +0200, Gilles Ganault wrote: >It did work finally by using > >sqlite-netFx45-static-binary-bundle-Win32-2012-1.0.84.0.zip I wanted to edit the FAQ to spare other newbies, but even after logging on as "anonymous" and typing the one-time

Re: [sqlite] RTree Documentation Error?

Hi Richard, et al, I'm sorry that it's bad manners for me to raise an issue and then disappear, but I didn't get a chance to check the list till a few minutes ago... On 17/4/2013 9:36 PM, Richard Hipp wrote: On Wed, Apr 17, 2013 at 9:25 AM, Michael Black wrote:

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

It doesn't work either with sqlite-netFx45-binary-bundle-Win32-2012-1.0.84.0.zip whether System.Data.SQLite.dll is located in .\Externals or some other location. It did work finally by using sqlite-netFx45-static-binary-bundle-Win32-2012-1.0.84.0.zip Could it be due to VC++ dependency?

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

On Thu, 18 Apr 2013 15:32:02 +0200, Gilles Ganault wrote: >Does it mean that we have to copy the two files in each and every >application, instead of just putting them in eg. C:\Windows? Still no go. 1. Per the FAQ

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

On Thu, 18 Apr 2013 09:27:00 -0400, Kevin Benson wrote: >http://sqlite.1065341.n5.nabble.com/Newbie-issues-with-SQLite-amp-C-td65823.html Thanks. "In order for this to work successfully, it must be able to locate that file at runtime, which means the

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

http://sqlite.1065341.n5.nabble.com/Newbie-issues-with-SQLite-amp-C-td65823.html -- -- -- --Ô¿Ô-- K e V i N On Thu, Apr 18, 2013 at 9:22 AM, Gilles Ganault wrote: > Hello, > > I'm having a problem getting VB Express to find SQLite .Net: > > 1.

[sqlite] [SQLite.Net] Right way to install precompiled binaries?

Hello, I'm having a problem getting VB Express to find SQLite .Net: 1. I went to... http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki ... to download sqlite-netFx45-binary-Win32-2012-1.0.84.0.zip 2. Unzipped file in C:\Downloads\SQLite\.Net\1.0.84.0\ 3. Launched VB Express

Re: [sqlite] Cygwin compilation error

What version gcc do you have? Mine works. D:\SQLite>gcc --version gcc (GCC) 4.7.3 20121102 (prerelease) D:\SQLite>gcc -o shgcc.exe shell.c sqlite3.c D:\SQLite>shgcc SQLite version 3.7.16.2 2013-04-12 11:52:43 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite>

Re: [sqlite] Potential problem in SQLite 3.7.16.2

Mario M. Westphal wrote: > The INSERT statement which takes only a few seconds with previous builds > now does not return, at least not within several minutes. Please show the output of EXPLAIN QUERY PLAN for the SELECT part of the query in both versions. Regards, Clemens

[sqlite] Variable-length records

can some one tell me which of the tcl test script tests below two points of SQLite ? 1) Variable-length records 2) Internal or temporary databases: load the data into an in-memory SQLite database and use queries with joins and ORDER BY clauses to extract the data in the form and order needed

[sqlite] Using sqlite as a parallel computation benchmark?

Hi folks, I'm looking into using sqlite for benchmarking performance of a glibc feature based on hardware based transactional memory that is a new feature of new Intel and Ibm (and other) cpus. The glibc feature is described here: https://lwn.net/Articles/534758/ In short, glibc attempts

[sqlite] Potential problem in SQLite 3.7.16.2

This is a SQL Script /* Application linking to SQLite using the Amalgation. Build Tool: C++, Visual Studio 2012, Windows 7 64-Bit The table schema and the query enclosed below are in use for over one year and various SQLite versions. After downloading and compiling in the SQLite 3.7.16.2, we

[sqlite] Cygwin compilation error

Hi all, I'm trying to use sqlite (tried 3.6 and the latest) in a project using cygwin (the latest version), but I cannot manage to compile it. I also tried to compile the shell.c file but the same errors come up: gcc shell.c sqlite3.c -lpthread -ldl sqlite3.c:30467: error: initializer element

Re: [sqlite] sqlite3_column_blob does not return the size of the blob?

http://www.sqlite.org/c3ref/column_blob.html sqlite3_column_bytes should do what you need. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Paolo Bolzoni Sent: Thursday, April 18, 2013 7:02 AM To: sqlite-users@sqlite.org

[sqlite] sqlite3_column_blob does not return the size of the blob?

I need to save some blob (arbitrary precision numbers representations) on my sqlite3 database. And confused by the function: const void *sqlite3_column_blob(sqlite3_stmt*, int iCol); I would expect an output parameter (example type size_t*) to get the size of the blob, but it is not there. How