Re: [sqlite] My 1st C++ SQLite3 program

Pardon my abject ignorance of C and C++. But just a quick naive observation. Does it have anything to do with the fact that the string is declared "database_name", but the invocation uses "databese_name". ??? > > Chris. ___ sqlite-users mailing list sql

Re: [sqlite] Difference between localtime and utc is 8 hours, but should be 4

As Stephen observed when replying to your query, time math is fraught with problems. So I think it will be nothing to do with SQLite per se. I'm guessing it will be in the time offset specification you have entered somewhere, for your environment. You are in what is termed time zone utc -4. Ti

[sqlite] Handling the whole select query from an index

that postcode will not be unique, if Australia Post's version of this is typical. One postcode covers several suburbs. I guess this will fundamentally alter the approach. A blisteringly fast lookup retrieving the wrong result may not be all that useful. Chris Waters

Re: [sqlite] Message: 9 Date: Thu, 20 Mar 2014 T Problem with Update from associated table.

Thanks Keith Medcalf. Your solution solves my problem. I don't know at what stage my brain lost contact with reality, but I bounded off into fields of increasing complexity rather than pausing and regrouping. After 45+ years developing systems I still fall for this devilish plunge. Updating refere

[sqlite] Problem with Update from associated table.

Hi folks, I have a problem! The scripts below are are partly based on guidance I found on the web, and as I started iterating to try to get a resolution. They are not elegant! But here 'tis. Using 3.8.3.1 - could not see any issues related to my problem in later updates so haven't yet upgraded c

[sqlite] Bug report: shell only supports dumping a single table at a time

Hi, In the documentation for the .dump command for the sqlite3 shell (http://www.sqlite.org/sqlite.html) there is an ellipsis after the name of the table, implying that it is possible to specify multiple tables and have more than one table dumped at once. However in the shell.c source code, the li

[sqlite] Implementing LISTEN

Hi, I need the ability to tell if changes have been made in the database. Kind of like the LISTEN capability in Postgresql. In particular I need to know if: * A row was inserted. * A row was deleted. * A row was modified. I would like to implement this through a callback that an application coul

RE: [sqlite] vers 3.0 concurrency issues

> > [U]se the right tool for the job. If you require concurrent > > readers/writer(s), then you may be better off using a full blown > > client/server database, especially in a distributed > environment. SQLite is > > designed to be embedded, don't just use it because you can. > > > > Concurre

RE: [sqlite] Updating with a Cursor

Actually I just discovered that sqlite4delphi uses exactly the technique that I want. It parses the original query to extract the table name then constructs a new update statement. Turns out it isn't too hard. Regards, Chris. > -Original Message- > From: Chris Waters [ma

RE: [sqlite] Updating with a Cursor

y, April 18, 2004 12:04 PM > To: [EMAIL PROTECTED] > Cc: Chris Waters > Subject: Re: [sqlite] Updating with a Cursor > > > On Sun, Apr 18, 2004 at 11:04:14AM -0700, Chris Waters wrote: > > > The idea is that I can iterate through a set of records with the cursor, >

[sqlite] Updating with a Cursor

nce I have found that the parser already dominates sqlite performance for my tests (in-memory DB with many different queries using indexes). I am currently investigating sqlite internals to see if I can extract this information in a better way. Any ideas would be welcomed. BTW, performance is my pri

[sqlite] Performance of query using rowid

Hi, If I use rowid as the sole criteria in a where clause is this the fastest way to retrieve a single row? In other RDBMSes that I have used rowid is always the best way to address rows (assuming you know what the rowid is). Thanks, Chris Waters