Hi,
sqlite as such has nothing to do with eMail.
My Thought:
I would write an application that queries a mailbox (via POP3, for
example, there are many possible ways) every n seconds, analyses the
mails it reads and performs the appropriate actions on the sqlite database.
This could be a
On 11 Jul 2009, at 5:16am, Bill Harris wrote:
Is there a way to update / synchronize an sqlite database between two
sites successfully using email?
It's not the email that's the problem, it's the synchronisation.
Suppose your database is a list of customers. There are two copies:
one at
Hello
Apart from using a table for this very purpose, is there a way to keep
internal names and beautified names for a table's column names?
Internal name = for the SQL queries, eg. id
Beautified name = as column name in a grid object, eg.
Identification
Thank you.
I would just use:
SELECT id AS Identification FROM foobar
On Sat, Jul 11, 2009 at 8:33 AM, Gilles Ganault gilles.gana...@free.frwrote:
Hello
Apart from using a table for this very purpose, is there a way to keep
internal names and beautified names for a table's column names?
Internal name
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thanks for the answers. Certainly you're right; synchronization is a
key problem. The only thing that helps this is the small size of the
database and the small number of sites, but that doesn't eliminate the
problem.
I'm still thinking about this.
On 11 Jul 2009, at 10:27pm, Derek Developer wrote:
When I launch my app the SQLite database and reads a portion of the
contents (about 30MB of a 100MB database).
On first launch it can take 50secs to load, yet subsequent loads are
as fast as 10sec. What is happening under the hood?
I