Re: [sqlite] Updating a database by email

2009-07-11 Thread Martin Engelschalk
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

Re: [sqlite] Updating a database by email

2009-07-11 Thread Simon Slavin
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

[sqlite] [Columns] Keeping internal + beautified names?

2009-07-11 Thread Gilles Ganault
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.

Re: [sqlite] [Columns] Keeping internal + beautified names?

2009-07-11 Thread Jim Dodgen
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

Re: [sqlite] Updating a database by email

2009-07-11 Thread Bill Harris
-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.

Re: [sqlite] 50sec Delay on first launch

2009-07-11 Thread Simon Slavin
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