Re: [sqlite] Virtual table API performance

2014-03-04 Thread J. Merrill
rather than many xColumn callbacks? This would reduce the number of calls across the VM boundary. Applications that don't implement xMultiColumns (and request its use) would see no change; those that do would get the performance boost. J. Merrill -- View this message in context: http://sq

Re: [sqlite] windows 2012 server having problems loading sqllite dll

2014-01-08 Thread j . merrill
oad. Good luck... J. Merrill -Original Message- Date: Wed, 8 Jan 2014 16:10:01 + From: Jill Taylor To: "sqlite-users@sqlite.org" Subject: [sqlite] windows 2012 server having problems loading sqllite dll Hi I hope someone has ran across this and can give me some poi

Re: [sqlite] sqlite download for 64 bit

2013-12-09 Thread j. merrill
Use the 32-bit DLL. If you use that, your application will run on both 32- and 64-bit versions of Windows. If you use the 64-bit DLL, it will only work on 64-bit versions of Windows. Krishna Chaitanya Konduru wrote > at the sqlite download page there is download for win 32 x86 what abut > 64bit o

Re: [sqlite] SELECT statement failure

2013-12-09 Thread j . merrill
ry_fee)-subtotal); (To reverse this to an "it's equal" test, change <= to > rather than != to =.) Using a value slightly less than 0.01 (e.g. 0.008) might prevent truly fringe cases from giving the wrong answer. J. Merrill -Original Message- Date: Fri, 06 De

Re: [sqlite] Could not load file or assembly 'System.Data.SQLite.dll' or one of its dependencies on Windows XP. Ideas?

2013-11-14 Thread j . merrill
ndows XP (unless you ALSO build a separate 32-bit version) -- something that apparently is/was not obvious to the people who decided that. J. Merrill -Original Message- Date: Wed, 13 Nov 2013 22:39:04 -0800 From: "Andreas Hofmann" To: "'General Discussion of SQLite

Re: [sqlite] SQLite Exception

2013-11-12 Thread j . merrill
One possibility has to be that your one problem user is on 32-bit Windows. Are you sure that's not the case? Did you try using the sxstrace tool? Here's good documentation for how to do so -- http://www.fundootech.com/2013/01/how-to-use-sxstraceexe.html J. Merrill -Origin

Re: [sqlite] sqlite db getting corrupt on power outage scenarios

2013-11-11 Thread j . merrill
file system) when non-database applications are writing to files on the flash drive when a power outage occurs? J. Merrill Date: Fri, 8 Nov 2013 06:41:15 + From: "Mayank Kumar (mayankum)" To: General Discussion of SQLite Database Subject: Re: [sqlite] sqlite db getting corrup

Re: [sqlite] sqlite-users Digest, Vol 69, Issue 10

2013-09-10 Thread j . merrill
-Original Message- Date: Tue, 10 Sep 2013 15:15:35 + From: Harmen de Jong - CoachR Group B.V. To: General Discussion of SQLite Database Subject: Re: [sqlite] Query preperation time does not scale linearly withgrowth of no. of tables Message-ID: Content-Type: text/plai

Re: [sqlite] Query preperation time does not scale linearl with growth of no. of tables

2013-09-09 Thread j . merrill
On Fri, 6 Sep 2013 17:29:25 Harmen de Jong - CoachR Group B.V. wrote > [Explaining why there can be 10,000 tables referencing one table] ... users > can create highly customized research forms with varying number of columns, > varying field types and a lot of specific restrictions, which we stor

Re: [sqlite] UPDATE question

2013-09-06 Thread j . merrill
you wanted to, you could have your initial "open the database" code check for duplicates across those columns (and that 1 is the lowest Sequence for each Name) -- then at least you'd know that you'd had one of those bugs. J. Merrill -Original Message- From: Peter H

Re: [sqlite] to encrypt sqlite db

2013-08-31 Thread j . merrill
If Windows RT supports the "encrypted files and folders" option of the NTFS file system -- I could not find anything that said explicitly that it either was or was not supported, and I don't have a Windows RT device to test with -- that would definitely be the way to go. It would require only th

Re: [sqlite] Is REAL the best universal data type?

2013-07-23 Thread j . merrill
On 07/23/2013 02:52 PM, Max Vlasov wrote: > I've created a kind of triple storage base with Sqlite db as the container. > Basically it's several tables implementing Object-Propery-Value metaphor. > There's only one field for data so thinking about generality I assumed that > the type for the data f

Re: [sqlite] Is there a way to return the row number? (NOT the rowid)

2013-07-06 Thread j . merrill
Date: Fri, 05 Jul 2013 02:04:04 +0200 From: Olaf Schmidt To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is there a way to return the row number? (NOT the rowid) Message-ID: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Am 03.07.2013 14:50, schrieb Keith Medcalf: > >> Given all

Re: [sqlite] escape quote for csv import

2013-06-19 Thread j . merrill
The fact that there's no "official CSV standard" doesn't mean that there isn't "common practice" that SQLite should support (but I can't say that I know that it does; it should be easy to change if it doesn't). The "common practice" is to double each embedded double-quote. "abc","the char in

Re: [sqlite] Getting Started with Sqlite

2013-05-22 Thread j . merrill
(I think Fehmi diagnosed the problem, that you should not use the "sqlite3" command when you are already in the "sqlite3" program. This is about something completely different.) If you are using a recent version of Windows, you do not want to be trying to create your database in the c:\windo

Re: [sqlite] Unhandled Exception: on System.TypeInitializationException

2013-04-09 Thread j . merrill
hat you used for development) that probably will solve the problem. J. Merrill -Original Message- Date: Fri, 5 Apr 2013 15:19:50 -0500From: Don V Nielsen <[https://apps.rackspace.com/versions/webmail/8.15.18-RC/popup.php?wsid=8777ef068db87b15a20a9e46b13314f4c1a2db7c] donvniel...@gmai

Re: [sqlite] [Question] How can I recognize arguments are dynamic binding values in user defined function?

2013-04-03 Thread j . merrill
he example) and the value to search for. It would then be your code that builds and runs the SQL statement using parameters. J. Merrill -Original Message- Date: Wed, 3 Apr 2013 22:41:01 +0900 From: Yongil Jang To: General Discussion of SQLite Database Subject: Re: [sqlite] [Questio