[sqlite] C Extensions to SQLite

My company is using SQLite. We need to do some formatting to the data before posting it to a webpage. What we want to do are simplier tasks such as zero padding, limiting placess to the right of the decimal etc. We are thinkng about writing C Extensions to SQLite to do this. But I was wonde

[sqlite] Inserting into an empty table

I am having problems inserting a record into a table that is empty. I get back an error. Is there any special issues involving this? Bart ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-

[sqlite] Update vs Insert

Hello, I am having problems with the update command (through the interface library). In most databases if you issue an update to a record that does not exist, it simply adds a new record. When I try this in SQLite I get an error back. Is the SQLite update restricted to a record you know alr

Re: [sqlite] Date comparisons

Thanks. I can make this work as desired. Bart From: sqlite-users-boun...@sqlite.org on behalf of Igor Tandetnik Sent: Mon 9/21/2009 9:09 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Date comparisons Barton Torbert wrote: > What you suggested s

Re: [sqlite] Date comparisons

Subject: Re: [sqlite] Date comparisons Barton Torbert wrote: > Even though this is a bit more complicated, it does seem to work > correctly. > > SELECT t1.realdate1, > t2.realdate2 > from test_table_1 t1 left outer join test_table_2 t2 where > strftim

Re: [sqlite] Date comparisons

inutes') ) and strftime ('%s', datetime(t1.realdate1, '+1 minutes') ) I guess there are parts of SQLite that work better in different usages. Bart From: sqlite-users-boun...@sqlite.org on behalf of Barton Torbert Sent: Mon 9/21/2009

Re: [sqlite] Date comparisons

-13T12:18:00.000 Bart From: sqlite-users-boun...@sqlite.org on behalf of D. Richard Hipp Sent: Mon 9/21/2009 6:17 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Date comparisons On Sep 21, 2009, at 8:00 PM, Barton Torbert wrote: &g

Re: [sqlite] Date comparisons

something like it ) work? Bart From: sqlite-users-boun...@sqlite.org on behalf of Simon Davies Sent: Mon 9/21/2009 4:21 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Date comparisons 2009/9/21 Barton Torbert : > Hello, > > I am hav

[sqlite] Date comparisons

Hello, I am having trouble doing a rather odd data comparison. I have two table, each with a DateTime field. The timestamps in these fields do not match exactly. I want to find the row in the second table that is within a specific time period around the time period to the DateTime in the f

Re: [sqlite] SQLite Tools recommended: SQLite Manager

ures do get implemented from time to time. Give it a try if you use Firefox. cheers, Joe Glassy On Tue, Aug 25, 2009 at 8:37 AM, Barton Torbert wrote: > I saw all the tools listed on the SQLite wiki. I was hoping that I could > solicit opinions on the various ones there to save me the time of

Re: [sqlite] SQLite Tools

: sqlite-users@sqlite.org Subject: Re: [sqlite] SQLite Tools On Tue, 25 Aug 2009 09:00:46 -0500, "Barton Torbert" wrote: > Hello, > > I have just started to use SQLite and am looking for > tools to manage my databases with. > > Right now my development group is man

[sqlite] SQLite Tools

Hello, I have just started to use SQLite and am looking for tools to manage my databases with. Right now my development group is manually importing our SQLite databases into Access so to use the latter to document table relationships, create ERDs, etc. This is the painful way to do this, so