[sqlite] System.Data.SQLite version 1.0.85.0 released

[Joe Mistachkin]

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 SQLite mailing list (sqlite-users at sqlite.org) if you
encounter any problems with this release.

--
Joe Mistachkin

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

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

[markus diersbock]

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
folder as the assembly.



On Thu, Apr 18, 2013 at 6:49 PM, Gilles Ganault  wrote:
> 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 new project.
>
> Why can't we just keep the two files in a central directory, and just
> add a reference through "Project > Add Reference"?
>
> Since the static-bundle version allows this, what is the added value
> of the other two (bundle and no-bundle, with dynamic linking to the
> VC++ runtime)?
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



-- 

Markus Diersbock
SwingNote
Marblehead, MA

C 781.929.0693
F 888.654.6068

This e-mail is intended solely for the person or entity to which it is
addressed and may contain confidential information. If you have
received this e-mail in error, please contact the sender immediately
and delete the material from any computer. Any review, dissemination,
copying, printing or other use of this e-mail by persons or entities
other than the addressee is prohibited.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] [Question] SQLITE_FCNTL_CHUNK_SIZE

[Yongil Jang]

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 inserts single record
to a database file, file size increased with single page size. (ex: 4KB
page size)
In case of multiple insertion or update with transaction calls fallocate
with chunk size.

It would not be a big problem, but I will be happy if I can get some
description about this.

Best regards,
Yongil Jang.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Gilles Ganault]

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 new project.

Why can't we just keep the two files in a central directory, and just
add a reference through "Project > Add Reference"?

Since the static-bundle version allows this, what is the added value
of the other two (bundle and no-bundle, with dynamic linking to the
VC++ runtime)?

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

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

[Marc L. Allen]

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 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
Subject: 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...
> 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 2010 to create new Windows Form project
>
> 4. Project > Add Reference: Navigated to 
> "C:\Downloads\SQLite\.Net\1.0.84.0\" and pointed to 
> System.Data.SQLite.dll
>
> 5. Wrote SQLite test code:
>
> Dim SQLconnect As New SQLite.SQLiteConnection()
> Dim SQLcommand As SQLiteCommand
>
> 'Note: Non-admin app cannot write to c:\
> SQLconnect.ConnectionString = "Data 
> Source=c:\users\fred\test.sqlite;"
> SQLconnect.Open()
>
> 'SQLcommand = SQLconnect.CreateCommand
>
> 'SQLcommand.CommandText = "CREATE TABLE IF NOT EXISTS Item 
> (type)"
> 'SQLcommand.ExecuteNonQuery()
>
> 'SQLcommand.CommandText = "INSERT INTO Item (type) VALUES 
> ('something')"
> 'SQLcommand.ExecuteNonQuery()
>
> 'SQLcommand.Dispose()
> SQLconnect.Close()
>
> 6. Launched app: "Unable to load DLL 'SQLite.Interop.dll': The 
> specified module could not be found. (Exception from HRESULT:
> 0x8007007E)"
>
> What is the right way to install SQLite.Net so that applications can 
> find it?
>
> Thank you.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



-- 

Markus Diersbock
SwingNote
Marblehead, MA

C 781.929.0693
F 888.654.6068

This e-mail is intended solely for the person or entity to which it is 
addressed and may contain confidential information. If you have received this 
e-mail in error, please contact the sender immediately and delete the material 
from any computer. Any review, dissemination, copying, printing or other use of 
this e-mail by persons or entities other than the addressee is prohibited.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


This email and any attachments are only for use by the intended recipient(s) 
and may contain legally privileged, confidential, proprietary or otherwise 
private information. Any unauthorized use, reproduction, dissemination, 
distribution or other disclosure of the contents of this e-mail or its 
attachments is strictly prohibited. If you have received this email in error, 
please notify the sender immediately and delete the original.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


This email and any attachments are only for use by the intended recipient(s) 
and may contain legally privileged, confidential, proprietary or otherwise 
private information. Any unauthorized use, reproduction, dissemination, 
distribution or other disclosure of the contents of this e-mail or its 
attachments is strictly prohibited. If you have received this email in error, 
please notify the sender immediately and delete the original.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Marc L. Allen]

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
Subject: 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...
> 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 2010 to create new Windows Form project
>
> 4. Project > Add Reference: Navigated to 
> "C:\Downloads\SQLite\.Net\1.0.84.0\" and pointed to 
> System.Data.SQLite.dll
>
> 5. Wrote SQLite test code:
>
> Dim SQLconnect As New SQLite.SQLiteConnection()
> Dim SQLcommand As SQLiteCommand
>
> 'Note: Non-admin app cannot write to c:\
> SQLconnect.ConnectionString = "Data 
> Source=c:\users\fred\test.sqlite;"
> SQLconnect.Open()
>
> 'SQLcommand = SQLconnect.CreateCommand
>
> 'SQLcommand.CommandText = "CREATE TABLE IF NOT EXISTS Item 
> (type)"
> 'SQLcommand.ExecuteNonQuery()
>
> 'SQLcommand.CommandText = "INSERT INTO Item (type) VALUES 
> ('something')"
> 'SQLcommand.ExecuteNonQuery()
>
> 'SQLcommand.Dispose()
> SQLconnect.Close()
>
> 6. Launched app: "Unable to load DLL 'SQLite.Interop.dll': The 
> specified module could not be found. (Exception from HRESULT:
> 0x8007007E)"
>
> What is the right way to install SQLite.Net so that applications can 
> find it?
>
> Thank you.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



-- 

Markus Diersbock
SwingNote
Marblehead, MA

C 781.929.0693
F 888.654.6068

This e-mail is intended solely for the person or entity to which it is 
addressed and may contain confidential information. If you have received this 
e-mail in error, please contact the sender immediately and delete the material 
from any computer. Any review, dissemination, copying, printing or other use of 
this e-mail by persons or entities other than the addressee is prohibited.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


This email and any attachments are only for use by the intended recipient(s) 
and may contain legally privileged, confidential, proprietary or otherwise 
private information. Any unauthorized use, reproduction, dissemination, 
distribution or other disclosure of the contents of this e-mail or its 
attachments is strictly prohibited. If you have received this email in error, 
please notify the sender immediately and delete the original.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[markus diersbock]

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...
> 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 2010 to create new Windows Form project
>
> 4. Project > Add Reference: Navigated to
> "C:\Downloads\SQLite\.Net\1.0.84.0\" and pointed to
> System.Data.SQLite.dll
>
> 5. Wrote SQLite test code:
>
> Dim SQLconnect As New SQLite.SQLiteConnection()
> Dim SQLcommand As SQLiteCommand
>
> 'Note: Non-admin app cannot write to c:\
> SQLconnect.ConnectionString = "Data
> Source=c:\users\fred\test.sqlite;"
> SQLconnect.Open()
>
> 'SQLcommand = SQLconnect.CreateCommand
>
> 'SQLcommand.CommandText = "CREATE TABLE IF NOT EXISTS Item
> (type)"
> 'SQLcommand.ExecuteNonQuery()
>
> 'SQLcommand.CommandText = "INSERT INTO Item (type) VALUES
> ('something')"
> 'SQLcommand.ExecuteNonQuery()
>
> 'SQLcommand.Dispose()
> SQLconnect.Close()
>
> 6. Launched app: "Unable to load DLL 'SQLite.Interop.dll': The
> specified module could not be found. (Exception from HRESULT:
> 0x8007007E)"
>
> What is the right way to install SQLite.Net so that applications can
> find it?
>
> Thank you.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



-- 

Markus Diersbock
SwingNote
Marblehead, MA

C 781.929.0693
F 888.654.6068

This e-mail is intended solely for the person or entity to which it is
addressed and may contain confidential information. If you have
received this e-mail in error, please contact the sender immediately
and delete the material from any computer. Any review, dissemination,
copying, printing or other use of this e-mail by persons or entities
other than the addressee is prohibited.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Variable-length records

[Simon Slavin]

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 SQLite records are 
variable-length.  SQLite does not support fixed-length text fields: all text 
fields can be of any length.  It even uses variable numbers of bytes to encode 
integer values.  So almost all testing you do of SQLite will be testing 
variable length fields.



> 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 distinguishes between 'memory' and 'temporary'.  The two things do 
different things.  You can even have something which combines the two.  This is 
how you do memory:



You create TEMPORARY TABLES using "CREATE TEMPORARY TABLE".

Temporary tables are usually stored on disk.  The only difference is that 
closing the database automatically deletes those tables.  (Actually, I'm not 
sure how multiple connections to a temporary TABLE may or may not work.)

There are numerous tests in the test suites which test memory and/or temporary 
features.  If you run the whole test suite, you'll get them all.

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

Re: [sqlite] Cygwin compilation error

[Warren Young]

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 use that, or were you just not aware that 
I'd finally gotten around to replacing the 3.7.13-1 release?



I cannot manage to compile it.


I didn't have any trouble on 32-bit Cygwin.

64-bit Cygwin required a bit of hand massaging before compilation since 
upstream is shipping outdated autoconf outputs, however.


(Richard, if you're reading this, you should upgrade Automake to at 
least 1.10.  Previous releases don't understand 64-bit Cygwin, so we 
have to replace config.guess.  Additionally, Autoconf 2.69 doesn't like 
some outdated constructs in your configure.ac file.  If the syntax were 
up to date, that would have allowed a second choice for fixing this 
portability problem.)



sqlite3.c:30467: error: initializer element is not constant
sqlite3.c:30467: error: (near initialization for `aSyscall[0].pCurrent')
sqlite3.c:30467: error: initializer element is not constant
sqlite3.c:30467: error: (near initialization for `aSyscall[0]')
sqlite3.c:30479: error: initializer element is not constant
sqlite3.c:30479: error: (near initialization for `aSyscall[1]')
sqlite3.c:30487: error: initializer element is not constant


I'd guess you have a competing definition for the SYSCALL macro 
somewhere.  It's easy to test.  Add this at line 30445:


#else
#  error Fix your toolchain!

If you get the new error on retrying the compile, I'm right, and you 
need to find out where it is and why it's being invoked.


Do you have multiple gcc's on your system?  If so, are you *certain* 
you're using Cygwin's gcc, and not, say, MinGW's, or some 
cross-compilation toolchain?

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

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

[Gilles Ganault]

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 password, there's no
Edit link anywhere.

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

Re: [sqlite] RTree Documentation Error?

[Mohit Sindhwani]

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:


Correct -- no results for the "real" 2nd query


I see.  I ran two queries together in my script so what I thought was the
2nd query was really the 3rd.

The SQLite HQ coordinates are fixed in
http://www.sqlite.org/draft/rtree.html now.


Thanks for the fix!  It all works now like it says it should.  We had a 
bit of a moment when we tried the query and it didn't seem correct :)


Best Regards,
Mohit.


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

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

[Gilles Ganault]

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?

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

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

[Gilles Ganault]

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
(http://system.data.sqlite.org/index.html/doc/trunk/www/faq.wiki#q8),
created .\Externals, and copied whole ZIP there:

===
\bin
\Externals
\My Project
\obj
Form1.resx
WindowsApplication1.vbproj.user
Form1.vb
Form1.Designer.vb
WindowsApplication1.vbproj
===

2. Added reference to "System.Data.SQLite.dll" in \Externals

3. Ran app: "Unable to load DLL 'SQLite.Interop.dll': The specified
module could not be found. (Exception from HRESULT: 0x8007007E)"

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

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

[Gilles Ganault]

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 "SQLite.Interop.dll" file must
reside in the binary directory itself or in the architecture-specific
sub-directory therein.  The download page also covers this setup in
more detail."

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?

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

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

[Kevin Benson]

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. 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 2010 to create new Windows Form project
>
> 4. Project > Add Reference: Navigated to
> "C:\Downloads\SQLite\.Net\1.0.84.0\" and pointed to
> System.Data.SQLite.dll
>
> 5. Wrote SQLite test code:
>
> Dim SQLconnect As New SQLite.SQLiteConnection()
> Dim SQLcommand As SQLiteCommand
>
> 'Note: Non-admin app cannot write to c:\
> SQLconnect.ConnectionString = "Data
> Source=c:\users\fred\test.sqlite;"
> SQLconnect.Open()
>
> 'SQLcommand = SQLconnect.CreateCommand
>
> 'SQLcommand.CommandText = "CREATE TABLE IF NOT EXISTS Item
> (type)"
> 'SQLcommand.ExecuteNonQuery()
>
> 'SQLcommand.CommandText = "INSERT INTO Item (type) VALUES
> ('something')"
> 'SQLcommand.ExecuteNonQuery()
>
> 'SQLcommand.Dispose()
> SQLconnect.Close()
>
> 6. Launched app: "Unable to load DLL 'SQLite.Interop.dll': The
> specified module could not be found. (Exception from HRESULT:
> 0x8007007E)"
>
> What is the right way to install SQLite.Net so that applications can
> find it?
>
> Thank you.
>
> ___
> 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.Net] Right way to install precompiled binaries?

[Gilles Ganault]

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 2010 to create new Windows Form project

4. Project > Add Reference: Navigated to
"C:\Downloads\SQLite\.Net\1.0.84.0\" and pointed to
System.Data.SQLite.dll

5. Wrote SQLite test code:

Dim SQLconnect As New SQLite.SQLiteConnection()
Dim SQLcommand As SQLiteCommand

'Note: Non-admin app cannot write to c:\
SQLconnect.ConnectionString = "Data
Source=c:\users\fred\test.sqlite;"
SQLconnect.Open()

'SQLcommand = SQLconnect.CreateCommand

'SQLcommand.CommandText = "CREATE TABLE IF NOT EXISTS Item
(type)"
'SQLcommand.ExecuteNonQuery()

'SQLcommand.CommandText = "INSERT INTO Item (type) VALUES
('something')"
'SQLcommand.ExecuteNonQuery()

'SQLcommand.Dispose()
SQLconnect.Close()

6. Launched app: "Unable to load DLL 'SQLite.Interop.dll': The
specified module could not be found. (Exception from HRESULT:
0x8007007E)"

What is the right way to install SQLite.Net so that applications can
find it?

Thank you.

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

Re: [sqlite] Cygwin compilation error

[Michael Black]

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> .quit

-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] 
On Behalf Of Fulvio Esposito
Sent: Wednesday, April 17, 2013 9:06 AM
To: sqlite_us...@googlegroups.com
Subject: [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 is not constant
sqlite3.c:30467: error: (near initialization for `aSyscall[0].pCurrent')
sqlite3.c:30467: error: initializer element is not constant
sqlite3.c:30467: error: (near initialization for `aSyscall[0]')
sqlite3.c:30479: error: initializer element is not constant
sqlite3.c:30479: error: (near initialization for `aSyscall[1]')
sqlite3.c:30487: error: initializer element is not constant
[...]

and it goes the same until aSyscall[73]

Any insight about why I'm getting those errors?


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

Re: [sqlite] Potential problem in SQLite 3.7.16.2

[Clemens Ladisch]

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-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Variable-length records

[Bk]

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


Thank you



--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/Variable-length-records-tp68277.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] Using sqlite as a parallel computation benchmark?

[Dominik Vogt]

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 automatically to avoid ("elide") using
pthread mutexes and rwlocks and use hardware transactions instead.

The plan (or rather: vague idea) is to run a multi-threaded C
program that creates an in-memory database and runs a parallel
workload on that database in multiple threads.  Now I'm missing
two things:

1. Figuring out the amount, granularity and duration of locking
   that sqlite does using the pthread_mutex_... functions.  Can
   someone help me out here, or is my only chance to dig through
   the source code?

2. Finding a suitable workload for the test, preferrably already
   written in C, but since I'll have to do some coding anyway,
   that's not mandatory.  Other requirements:

- The workload must be sufficiently big to run for several
  seconds even on a high end server with eight or more cpus.
- It must be possible to dynamically distribute the workload
  across a random number of threads of the test program.
- The workload must create a decent amount of contention on
  database objects.  Thas is because hardware transactions
  cannot speed code with locks that does not create any
  contention on the database.

   I'm sure such a workload must be available on the net, but I
   just cannot find it.  Isn't there a suitable test data set for
   testing sqlite's parallel performance anyway?

Any hints or pointers would be greatly appreciated.

Ciao

Dominik ^_^  ^_^

-- 

Dominik Vogt
IBM Germany

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

[sqlite] Potential problem in SQLite 3.7.16.2

[Mario M. Westphal]

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 have a problem.

The INSERT statement which takes only a few seconds with previous builds
now does not return, at least not within several minutes.
It's hard to debug the amalgation in Visual Studio but it looks like
SQLite would be caught in an internal loop inside the step() function call.

Replacing the latest version of SQLite with 3.7.15.1 (which was the one we
used before)
and re-compiling our application solves the problem. The INSERT works again
in a few seconds.

We can provide a sample database etc. on request.
*/


/* Create */

CREATE VIRTUAL TABLE md_fts_core USING
fts4(group_oid,tag_oid,file_oid,lang,data);

CREATE TABLE md_fts_core_tag (oid INTEGER PRIMARY KEY, type INTEGER);
CREATE INDEX idx_md_fts_core_tag_type ON md_fts_core_tag(type);

CREATE TABLE md_tag (oid INTEGER PRIMARY KEY, class INTEGER, group_oid
INTEGER, id TEXT, tag TEXT, idx INTEGER, dtype INTEGER, ntype TEXT, cnt
INTEGER, repeat INTEGER, flags INTEGER, FOREIGN KEY(group_oid) REFERENCES
md_tag_group(oid) ON DELETE CASCADE);
CREATE INDEX idx_md_tag_tag ON md_tag(tag);

CREATE TABLE md_tag_group (oid INTEGER PRIMARY KEY, src INTEGER, id TEXT);

CREATE TABLE md_tag_data (oid INTEGER, tag_oid INTEGER, tdata TEXT, rdata
TEXT, lang TEXT, flags INTEGER, FOREIGN KEY(tag_oid) REFERENCES md_tag(oid)
ON DELETE CASCADE);
CREATE INDEX idx_md_tag_data_flags ON md_tag_data(flags);
CREATE INDEX idx_md_tag_data_oid ON md_tag_data(oid);
CREATE INDEX idx_md_tag_data_oid_tag_oid ON md_tag_data(oid,tag_oid);
CREATE INDEX idx_md_tag_data_tag_oid ON md_tag_data(tag_oid);


/* This insert does not return (at least not within several minutes in
3.7.16.2, but takes about 5-10 seconds with build 3.7.15.1 */ 

INSERT INTO md_fts_core (group_oid,tag_oid,file_oid,lang,data) 

SELECT 
g.oid, d.tag_oid, d.oid, d.lang, d.tdata from md_tag_data d 
INNER JOIN
md_tag t ON d.tag_oid = t.oid 
INNER JOIN
md_tag_group g ON t.group_oid = g.oid 
INNER JOIN
md_fts_core_tag ct ON ct.type = 0 AND ct.oid = d.tag_oid  /* which
tags to include */ 
WHERE
d.oid IN
(1,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,3
4,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59
,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,
85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107
,108)  
AND d.tag_oid IN (2157,7309,16265,16579)  

UNION 

SELECT
/* We use group_concat to fold multiple values for one tag into one
value for FTS */
g.oid, d.tag_oid, d.oid, d.lang, group_concat(d.tdata,' ') 
FROM
md_tag_data d 
INNER JOIN
md_tag t ON d.tag_oid = t.oid 
INNER JOIN
md_tag_group g ON t.group_oid = g.oid 
INNER JOIN
md_fts_core_tag ct ON ct.type = 1 AND ct.oid = d.tag_oid /* which
tags to include */ 
WHERE
d.oid IN
(1,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,3
4,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59
,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,
85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107
,108)  
AND d.tag_oid IN (2157,7309,16265,16579)  
GROUP BY
d.tag_oid,d.oid
 

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

[sqlite] Cygwin compilation error

[Fulvio Esposito]

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 is not constant
sqlite3.c:30467: error: (near initialization for `aSyscall[0].pCurrent')
sqlite3.c:30467: error: initializer element is not constant
sqlite3.c:30467: error: (near initialization for `aSyscall[0]')
sqlite3.c:30479: error: initializer element is not constant
sqlite3.c:30479: error: (near initialization for `aSyscall[1]')
sqlite3.c:30487: error: initializer element is not constant
[...]

and it goes the same until aSyscall[73]

Any insight about why I'm getting those errors?

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

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

[Michael Black]

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
Subject: [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 can I know the length of the blob to read it correctly?

Thanks,
Paolo
___
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] sqlite3_column_blob does not return the size of the blob?

[Paolo Bolzoni]

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 can I know the length of the blob to read it correctly?

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