Re: [sqlite] Creation and modification timestamps with "insert or replace" possible?

On 10 Mar 2011, at 7:57am, Mohd Radzi Ibrahim wrote: > So, that's explain why my column ID INTEGER PRIMARY KEY, changes when I use > REPLACE. I could not rely on the ID with this command. Yes. You explicitly said 'REPLACE' so that's what it's doing. If you want to modify an existing

Re: [sqlite] memory usage after VACUUM

On 9 Mar 2011, at 15:23, Nick Hodapp wrote: > I'm using sqlite in an iOS app, via the popular FMDB wrapper. > > My profiling tool is showing me that the app is using 2.5 MB of memory > before a VACUUM, and nearly 6MB after. The tool shows that the extra memory > was allocated by

Re: [sqlite] duplicate a prepared statement?

On 9 Mar 2011, at 21:29, Nick Hodapp wrote: > Is it possible to duplicate a prepared statement? Yes, if the original statement used sqlite3_prepare_v2: DBrc = sqlite3_prepare_v2(db,sqlite3_sql(original),-1,,NULL); > I have a need to run the same query multiple times with different >

[sqlite] sqlite :: calculating with dates: compare current date minus 6 months with stored record

Hi folks I have a table with name, date in format DD.MM.. nameexpiry date example CA 04.05.2013 example Sub-CA 01.09.2012 I need to something like this (I try to explain in pseudo code) if SYSDATE (current date) minus 6 months > $expiry date print OK else

Re: [sqlite] sqlite :: calculating with dates: compare current date minus 6 months with stored record

Sven Aluoor wrote: > I have a table with name, date in format DD.MM.. If at all possible, switch to one of the formats that SQLite date functions understand, e.g. -MM-DD - see http://www.sqlite.org/lang_datefunc.html . This format has the advantage that a simple

[sqlite] Rowids, bit-arrays, recycling, and performance

We are considering using rowids as a unique and stable ID for all records. I know that in order to do this, we need to prevent recycling by using "primary key autoincrement". The concern is that over time, as records are added and removed, there will appear large gaps in the rowids of a

Re: [sqlite] Rowids, bit-arrays, recycling, and performance

On Thu, Mar 10, 2011 at 10:31 AM, Dave White wrote: > > We are considering using rowids as a unique and stable ID for all records. > I know that in order to do this, we need to prevent recycling by using > "primary key autoincrement". > > The concern is that over time,

Re: [sqlite] Rowids, bit-arrays, recycling, and performance

On 10 Mar 2011, at 3:31pm, Dave White wrote: > 1. Do I understand this correctly? Not for SQLite. It doesn't do keying arrays so don't worry about gaps in arrays or anything like that. > 2. If necessary, I can manually recycle rowids to fill in these gaps, > and maintain a

[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] Location of net 4.0 System.Data.SQLite driver release.

Hello, I'm trying to find the location of the release for the .net 4.0 System.Data.SQLite driver. I've searched this site, http://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki but found nothing, pertaining to the where the code is hosted. That's assuming of course, that

Re: [sqlite] sqlite3_open16 and flags

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 03/10/2011 09:44 AM, Alexander Spence wrote: > 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. Indeed. If you look at the code for

Re: [sqlite] duplicate a prepared statement?

On Thu, Mar 10, 2011 at 11:33:28AM +, Philip Graham Willoughby scratched on the wall: > On 9 Mar 2011, at 21:29, Nick Hodapp wrote: > > Is it possible to duplicate a prepared statement? > > Yes, if the original statement used sqlite3_prepare_v2: > DBrc =

Re: [sqlite] Rowids, bit-arrays, recycling, and performance

On Thu, Mar 10, 2011 at 10:37:14AM -0500, Richard Hipp scratched on the wall: > On Thu, Mar 10, 2011 at 10:31 AM, Dave White wrote: > >1. Do I understand this correctly? > > No. I think you may be confusing SQLite and PostgreSQL. And even > PostgreSQL

Re: [sqlite] Rowids, bit-arrays, recycling, and performance

On Thu, Mar 10, 2011 at 11:01 AM, Jay A. Kreibich wrote: > On Thu, Mar 10, 2011 at 10:37:14AM -0500, Richard Hipp scratched on the > wall: > > On Thu, Mar 10, 2011 at 10:31 AM, Dave White >wrote: > > > >1. Do I understand this correctly? > > >

[sqlite] .import FILE TABLE

Hello, Unbelievably active user group! I have been unable to import a CSV text file from MS Access to sqlite: 1. Created a small table (3 fields and 1 record) in Access and exported it to a CSV text file named "myCSVfile.txt" 2. Transferred from PC to Mac. Opened file "myCSVfile.txt"

Re: [sqlite] .import FILE TABLE

Make sure your separator is the "," http://www.sqlite.org/sqlite.html On 3/10/2011 12:28 PM, jcilibe...@comcast.net wrote: > Hello, > > > Unbelievably active user group! > > > I have been unable to import a CSV text file from MS Access to sqlite: > 1. Created a small table (3 fields and 1 record)

Re: [sqlite] .import FILE TABLE

On 3/10/2011 1:28 PM, jcilibe...@comcast.net wrote: > Hello, > > > Unbelievably active user group! > > > I have been unable to import a CSV text file from MS Access to sqlite: > 1. Created a small table (3 fields and 1 record) in Access and exported it to > a CSV text file named "myCSVfile.txt" >

Re: [sqlite] .import FILE TABLE

Thanks, but doesn't seem to work: I used command > - Original Message - From: "Gerry Snyder" To: "General Discussion of SQLite Database" Sent: Thursday, March 10, 2011 12:39:33 PM Subject: Re: [sqlite] .import FILE TABLE On

Re: [sqlite] .import FILE TABLE

.separator "," .import myPath/myCSVfile myTable We use a "import" file with these commands. On 3/10/2011 2:32 PM, jcilibe...@comcast.net wrote: > Thanks, but doesn't seem to work: > > > I used command> > - Original Message - > From: "Gerry Snyder" > To: "General