Re: [sqlite] Cannot retrieve SQLite Db Data Immediately After Application Startup

2014-09-04 Thread Bob Moran
Erik, Are you implying that I must copy the text returned by qPrintable(sql) to a safe location before calling a method that uses it? I thought that the string would be valid until I return from the routine. Bob Moran On Wed, Sep 3, 2014 at 1:29 PM, Nelson, Erik - 2 <

Re: [sqlite] Problems uploading CSV into sqlite3 DB

2014-09-04 Thread David Empson
I get similar results on OS X 10.9.4 if I try to use the version of SQLite supplied with the operating system (3.7.13) to import a CSV. The simple ".mode csv" and ".import tab1" method works if I run the copy of SQLite 3.8.5 I built myself from the source code, or if I use the Mac OS X

Re: [sqlite] Problems uploading CSV into sqlite3 DB

2014-09-04 Thread Nelson, Erik - 2
Carlos A. Gorricho (HGSAS) wrote on Friday, September 05, 2014 4:17 AM >So, any ideas on how to solve this issue will be more than welcome. I have >tried several shortcuts...none works. >Latest was to install an Ubuntu 14.04 Virtual Machine on my Mac, via Parallels >software. > Maybe line

Re: [sqlite] Problems uploading CSV into sqlite3 DB

2014-09-04 Thread Carlos A. Gorricho (HGSAS)
So, any ideas on how to solve this issue will be more than welcome. I have tried several shortcuts...none works. Latest was to install an Ubuntu 14.04 Virtual Machine on my Mac, via Parallels software. Downloaded sqlite de Linux way: $ sudo apt-get install sqlite3 Ran the CSV .import protocol

Re: [sqlite] Issue in copying file

2014-09-04 Thread Stephen Chrzanowski
Chances are its Windows UAC that is coming into play. You've got three choices; - Disable UAC entirely (UAC - User Authentication Control or some jazz like that) - Have the installer put your program that is NOT in a protected directory (c:\Program Files; c:\Program Files (x86) for instance) -

Re: [sqlite] SQLite Database Decryption

2014-09-04 Thread Richard Hipp
On Thu, Sep 4, 2014 at 8:15 AM, Jude Nicolasora wrote: > Hi guys, > > I would like to ask help and some guidance on how to decrypt a database > that was encrypted by System.Data.SQLite. > > We have a database which was encrypted using System.Data.SQLite. > The

[sqlite] Issue in copying file

2014-09-04 Thread Rommel Ngo
Hi, I have created a program in VB.net and created an installer. I included the database file (sqlite) as part of the installer. My problem is that the first time I install the program to my windows 7 or 8 environment, I can no longer overwrite the file when I try to reinstall the same. I

[sqlite] SQLite Database Decryption

2014-09-04 Thread Jude Nicolasora
Hi guys, I would like to ask help and some guidance on how to decrypt a database that was encrypted by System.Data.SQLite. We have a database which was encrypted using System.Data.SQLite. Our team was supposed to decrypt the database file from our client (they gave us the password) and use the

Re: [sqlite] Index on expressions

2014-09-04 Thread Nico Williams
On Thu, Sep 4, 2014 at 3:59 AM, Dominique Devienne wrote: > On Thu, Sep 4, 2014 at 2:04 AM, Nico Williams wrote: > >> [...] but there's a gotcha: SELECT * on a table >> source with computed columns might result in much more work being done >> than the

Re: [sqlite] Index on expressions

2014-09-04 Thread Klaas V
Dominique Devienne wrote: (double-click on new version) SQLite version 3.8.5 2014-06-04 14:06:34 (terminal) SQLite version 3.7.13 2012-07-17 17:46:21 This means you downloaded the new version in a directory not in your $PATH Add it to your path: set PATH=: $PATH If you do this in your

Re: [sqlite] SQLITE_THREADSAFE question

2014-09-04 Thread Neo Anderson
Understood. Thanks! > From: d...@sqlite.org > Date: Thu, 4 Sep 2014 11:42:52 -0400 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] SQLITE_THREADSAFE question > > On Thu, Sep 4, 2014 at 11:32 AM, Neo Anderson wrote: > >> Got

Re: [sqlite] sqlite3_step and SQLITE_LOCKED/BUSY

2014-09-04 Thread Simon Slavin
> On 4 Sep 2014, at 4:21pm, Jan Slodicka wrote: > > Our C# wrapper (inspired by system.data.sqlite) uses this quasi-code: > > bool Step(stmt) > { > while(true) > { >start time measurement >rc = sqlite3_step(stmt); >if( rc == SQLITE_ROW) return true;// ...

Re: [sqlite] SQLITE_THREADSAFE question

2014-09-04 Thread Richard Hipp
On Thu, Sep 4, 2014 at 11:32 AM, Neo Anderson wrote: > Got confused. if I have SQLITE_THREADSAFE=2, do I need to implement mutex > proection around this function call? > No. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users

Re: [sqlite] SQLITE_THREADSAFE question

2014-09-04 Thread Neo Anderson
Got confused. if I have SQLITE_THREADSAFE=2, do I need to implement mutex proection around this function call? > From: d...@sqlite.org > Date: Thu, 4 Sep 2014 10:18:29 -0400 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] SQLITE_THREADSAFE question

[sqlite] sqlite3_step and SQLITE_LOCKED/BUSY

2014-09-04 Thread Jan Slodicka
I don't have any real problem this time, just wondered if our C# wrapper is programmed correctly/efficiently. Suppose we prepared a statement using sqlite3_prepare_v2(). Could please anybody explain how to treat above mentioned error codes returned by sqlite3_step()? Our C# wrapper (inspired by

Re: [sqlite] SQLITE_THREADSAFE question

2014-09-04 Thread Richard Hipp
On Thu, Sep 4, 2014 at 10:14 AM, Neo Anderson wrote: > > 2. Fuctions that do not use sqlite3* and sqite3_stmt* such as > sqlite3_mprintf do not need mutex protection. > No. sqlite3_mprintf() does require mutex protection. If you disable mutexes using SQLITE_THREADSAFE=0

Re: [sqlite] SQLITE_THREADSAFE question

2014-09-04 Thread Neo Anderson
Understood. I want to more sure of the following assumptions: 1. Trivial fucntions such as sqlite3_close, sqite3_errcode also need mutex protection even they seem so simple. 2. Fuctions that do not use sqlite3* and sqite3_stmt* such as sqlite3_mprintf do not need mutex protection. Thanks.

Re: [sqlite] SQLITE_THREADSAFE question

2014-09-04 Thread Richard Hipp
On Thu, Sep 4, 2014 at 9:59 AM, Neo Anderson wrote: > I'm building a custom library wrapper for Cocoa. I want to handle database > threading issue myself. > > From http://sqlite.org/compile.html#threadsafe: > > [quote] > When compiled with SQLITE_THREADSAFE=2, SQLite can

[sqlite] SQLITE_THREADSAFE question

2014-09-04 Thread Neo Anderson
I'm building a custom library wrapper for Cocoa. I want to handle database threading issue myself. >From http://sqlite.org/compile.html#threadsafe: [quote] When compiled with SQLITE_THREADSAFE=2, SQLite can be used in a multithreaded program so long as no two threads attempt to use the same 

[sqlite] Deleting columns in SQLite

2014-09-04 Thread Michael Leung
Hi, I posted a question on stackoverflow and like to forward it to the sqlite community. java - SQLite Ways to delete column: Using temporary table vs Renaming using ALTER TABLE - Stack Overflow java - SQLite Ways to delete column: Using temporary table vs Renaming using ALTER

Re: [sqlite] HELP sqlite3 used in vxworks has some problem

2014-09-04 Thread Andy Ling
> > > Please try the patch at > > > > http://www.sqlite.org/src/info/b0f6b91f36b503d8ba8d5257bb194f8c1afb483 > > > 3 and > > > see if that fixes the problem. > > > > > > > I think that fixes unixDelete. Running on the vxWorks dosFs disk > > everything works as before. > > > > If I use the host

Re: [sqlite] Index on expressions

2014-09-04 Thread Dominique Devienne
On Thu, Sep 4, 2014 at 2:04 AM, Nico Williams wrote: > [...] but there's a gotcha: SELECT * on a table > source with computed columns might result in much more work being done > than the user might have expected. > If that's a real concern, you can always use the existing