[sqlite] sqlite3_open16 and flags

How would I open a database connection using UTF-16 but still be able to specify flags. Seems like there would be a sqlite3_open16_v2 but there's not. Please NOTE: This electronic message, including any attachments, may include privileged, confidential and/or

[sqlite] Index Help

Hey guys, I am writing a comment index database and need some help optimizing the indices. Here is my table schema and a list of the possible queries. Please note that they could be Ascending or Descending order by's. This will be used in an enterprise level social media app that must be

Re: [sqlite] SQLite database sync

Do you really require a local copy of the entire database? Can you not just create a service that queries the database and gives you results on demand, caching the results? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of

[sqlite] Contributing to System.Data.Sqlite

Who would I talk to if I wanted to contribute to the System.Data.Sqlite project? We use this code in an enterprise environment and would like to contribute our changes to the community. Please NOTE: This electronic message, including any attachments, may

[sqlite] Sqlite strange stack trace

Hello, I am using SQLite to keep a copy of a database in memory. On load, this database is read off disk with the Backup API. Our project is .Net and we are using the System.Data.Sqlite driver 1.0.75. I have been testing performance under load and noticed some strange behavior. Access to a

Re: [sqlite] System.Data.SQLite and pooling problem

I am seeing a similar error since upgrading to 1.0.80.0. I am still working on trying to reproduce it, but here is a stack trace: All of our Connections and Statements are wrapped in using statements and being disposed correctly. I will report with more if I am able to reproduce this with a

Re: [sqlite] System.Data.SQLite and pooling problem

? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin Sent: Saturday, April 28, 2012 9:49 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] System.Data.SQLite and pooling problem Alexander Spence wrote: >

Re: [sqlite] System.Data.SQLite and pooling problem

:29 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] System.Data.SQLite and pooling problem Joe Mistachkin wrote: > > Alexander Spence wrote: > > > > What is the purpose of these locks when Sqlite itself has been compiled as ThreadSafe? > > > >

Re: [sqlite] System.Data.SQLite and pooling problem

in visual studio. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin Sent: Monday, April 30, 2012 2:01 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] System.Data.SQLite and pooling problem Alexander