Re: [sqlite] How to connect to an in-memory, shared cache db via SQLiteConnection

Ah, there you go. I'd assumed the latest nuget package would have this already. Thanks. > From: kevin.m.ben...@gmail.com > Date: Fri, 17 Aug 2012 22:54:58 -0400 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] How to connect to an in-memory, shared cache db via > SQLiteConnection > > On

Re: [sqlite] How to connect to an in-memory, shared cache db via SQLiteConnection

On Fri, Aug 17, 2012 at 8:51 PM, Wayne Bradney wrote: > > > > I'm using System.Data.SQLite version 1.0.81.0, and I'm trying the > following connection string: FullUri='file::memory:?cache=shared; when I > Open() the SQLiteConnection, I get: Invalid ConnectionString format

Re: [sqlite] How to connect to an in-memory, shared cache db via SQLiteConnection

the ":memory:" is the old format and not a uri format It should be something like: file:mymemorydb.db?mode=memory=shared From: Wayne Bradney To: General Discussion of SQLite Database Sent: Saturday, August

Re: [sqlite] How to connect to an in-memory, shared cache db via SQLiteConnection

Sorry, I'd already removed the quote - still doesn't work. Here's what I've tried: const string connectionString = @"FullUri=file::memory:"; gives: Data Source cannot be empty. Use :memory: to open an in-memory database const string connectionString =

Re: [sqlite] How to connect to an in-memory, shared cache db via SQLiteConnection

On 18 Aug 2012, at 1:51am, Wayne Bradney wrote: > I'm using System.Data.SQLite version 1.0.81.0, and I'm trying the following > connection string: FullUri='file::memory:?cache=shared; when I Open() the > SQLiteConnection, I get: Invalid ConnectionString format for

[sqlite] How to connect to an in-memory, shared cache db via SQLiteConnection

I'm using System.Data.SQLite version 1.0.81.0, and I'm trying the following connection string: FullUri='file::memory:?cache=shared; when I Open() the SQLiteConnection, I get: Invalid ConnectionString format for parameter "FullUri" What am I doing wrong?

[sqlite] Problem with SQLite on client machine under .net framework 4 client profile

Hello, I'm trying to launch our application .exe on a client machine. We've rebuilt the project under .NET framework 4 client profile. I have this error on launch: "The specified store provider cannot be found in the configuration, or is not valid". Do you have an idea of what to do?

Re: [sqlite] Encryption using System.Data.SQLite.dll

On Fri, Aug 17, 2012 at 1:20 PM, John Grasmeder wrote: > I agree, I am trying to find a way of getting the System.Data.SQLite.dll > to use AES-128 in CCM mode which is the type used by Adobe AIR. > The only way to do that is to purchase an SEE license, giving you

Re: [sqlite] Encryption using System.Data.SQLite.dll

I agree, I am trying to find a way of getting the System.Data.SQLite.dll to use AES-128 in CCM mode which is the type used by Adobe AIR. Currently all I can find is that it uses "Encrypted databases are fully encrypted and support both binary and cleartext password types" from

Re: [sqlite] Encryption using System.Data.SQLite.dll

John, The internal Adobe Air SQLite is built to not accept extensions, so, either the System.Data.SQLite.dll or the SQLite Encryption Extension from hwaci could only be used with a an external native extension application. Carlos. Em 17/08/2012 09:48, John Grasmeder escreveu: Carlos, My

Re: [sqlite] Encryption using System.Data.SQLite.dll

Carlos, My statements must have misled you, Adobe Air already contains an implementation of SQLite. I am currently using it with several 'tool' applications along with my client application that my customer will use which all process encrypted databases the same way. I am hoping not to get into a

Re: [sqlite] Error: database disk image is malformed

On Fri, Aug 17, 2012 at 8:08 AM, Tal Tabakman wrote: > > 7. file system is NFS. > Consider using the "unix-dotfile" VFS instead of the standard "unix" VFS. (Add the string "unix-dotfile" as the 4th argument to sqlite3_open_v2().) The unix-dotfile VFS will use dot-file

[sqlite] MultiThread Performance Gain Attempts

Hi, I am using sqlite version 3.7.13 in a multithreaded application (transactions with writes and reads will be called from different parallel threads within one process), and I am trying to gain performance. I would also like in some way to keep an on disk record of the database as the program

[sqlite] Assertion failure when sqlite3_bind_blob is passed a negative length

With SQLite 3.7.13 (the current version), if you pass a negative length to sqlite3_bind_blob, you get an assertion failure: sqlite3.c:59949: sqlite3VdbeMemSetStr: Assertion `enc!=0' failed. Here is the relevant source code: ... if( nByte<0 ){ assert( enc!=0 ); if(

Re: [sqlite] How to know what terms were created using FTS

Mohit Sindhwani wrote: > Hi Ralf, > > > > On 17/8/2012 3:50 PM, Ralf Junker wrote: >> >> On 17.08.2012 09:30, Mohit Sindhwani wrote: >> >>> We're using FTS4 and it works well for many things. One of the things >>> that we'd like to do is to see what terms are being created by

Re: [sqlite] How to know what terms were created using FTS

Hi Ralf, On 17/8/2012 3:50 PM, Ralf Junker wrote: On 17.08.2012 09:30, Mohit Sindhwani wrote: We're using FTS4 and it works well for many things. One of the things that we'd like to do is to see what terms are being created by the tokenizer in use. What would be the easiest way to do that?

[sqlite] How to know what terms were created using FTS

Hi, We're using FTS4 and it works well for many things. One of the things that we'd like to do is to see what terms are being created by the tokenizer in use. What would be the easiest way to do that? I tried looking through the fts_aux table and the segments and content tables, but