Re: [sqlite] Question about memory consumption of SQLite

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 20/08/12 13:07, Tal Tabakman wrote: > how much memory on heap will the application consume (from SQLite point > of view). Why don't you ask SQLite while running your representative schema and queries?

[sqlite] Question about memory consumption of SQLite

Hi I am writing an application which creates a db in runtime (i.e. only INSERT queries are performed, indexing only by primary key...) I am running with the following pragmas: executeString("PRAGMA temp_store=MEMORY"); executeString("PRAGMA journal_mode = MEMORY;"); executeString("PRAGMA

Re: [sqlite] SQLite "Provider cannot be found" error

Thanks Joe, I'll work on converting this to ASP.NET. Thanks for pointing me in the right direction! :: Roger Rice, Senior Software Administrator :: University Information Technology Services (UITS) :: University of Massachusetts President's Office :: 774-455-7825 Phone :: 774-455-7733 Fax ::

Re: [sqlite] SQLite "Provider cannot be found" error

Rice, Roger wrote: > > dim rs,x, conn, dir > > conn=Server.CreateObject("ADODB.Connection") > 'conn.provider="Microsoft.Jet.OLEDB.4.0" > conn.provider="System.Data.SQLite" > conn.Mode = 1 > 'conn.open(server.mappath("..\pub\" & folder.name &

[sqlite] SQLite "Provider cannot be found" error

Hello, I am trying to convert and ASP page to ASP.NET on Windows 2008 R2. The program I converted previously read in data from multiple Microsoft Access databases, looping through each directory under a directory called "pub". The data in the tables is created from a software package called

Re: [sqlite] How to find table names referenced in the query, not in the result set

You can try to use authorizer (http://www.sqlite.org/c3ref/set_authorizer.html) although it seems to me SQLite won't inform you about access to table2 in the first query. Pavel On Mon, Aug 20, 2012 at 2:18 AM, Bishwa Shrestha wrote: > Hi, > > I am creating an sqlite3

Re: [sqlite] sqlite3 error

On 20 Aug 2012, at 3:05am, Sunshine Lutey wrote: > I receive an sqlite3 error (see attached) whenever I re-start my computer. You cannot attach files to messages to this list. However, the most frequent cause of this is installing iTunes on a Windows computer. If

Re: [sqlite] Transaction issues with WinRT build

On 19 Aug 2012, at 6:31pm, lukas wrote: > Simon Slavin writes: > >> Using both versions can you tell us the results of >> >> SELECT sqlite_version(),sqlite_source_id() > > Results are exactly the same for both dlls: > > 3.7.13 > 2012-06-11 02:05:22

Re: [sqlite] How to find table names referenced in the query, not in the result set

On 20 Aug 2012, at 10:18am, Bishwa Shrestha wrote: > Is there a way to get the table names that were referenced in the query > itself? I don't think so. Consider that you might do things like SELECT 1,2,3; SELECT (a.column1 + b.column1) FROM table1 AS a, table2 AS

[sqlite] sqlite3 error

Dear Support Team, I receive an sqlite3 error (see attached) whenever I re-start my computer. I don't actually know what this application is but I would like to get rid of the error. Thanks, Sunshine *Terri Sunshine Lutey* *President and Musical Director, Sunshine Performance Club* *President

Re: [sqlite] Transaction issues with WinRT build

Simon Slavin writes: > Using both versions can you tell us the results of > > SELECT sqlite_version(),sqlite_source_id() Results are exactly the same for both dlls: 3.7.13 2012-06-11 02:05:22 f5b5a13f7394dc143aa136f1d4faba6839eaa6dc The inserts are also in a transaction block.

[sqlite] How to find table names referenced in the query, not in the result set

Hi, I am creating an sqlite3 interface to an existing data model. For that purpose sqlite3 tables are dynamically loaded. I'm using /sqlite3_column_count/ and /sqlite3_column_table_name/ to load data into relevant tables only. Now, I am having problems with queries such as: SELECT

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

On 08/20/2012 11:08 AM, Bishwa Shrestha wrote: Hi, I am creating an sqlite3 interface to an existing data model. For that purpose sqlite3 tables are dynamically loaded. I'm using /sqlite3_column_count/ and /sqlite3_column_table_name/ to load data into relevant tables only. Now, I am having

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

Hi, I am creating an sqlite3 interface to an existing data model. For that purpose sqlite3 tables are dynamically loaded. I'm using /sqlite3_column_count/ and /sqlite3_column_table_name/ to load data into relevant tables only. Now, I am having problems with queries such as: SELECT