Bruce Robertson wrote:
>> We use a system of updating an Sqlite database buit use port 80 to send
>> data in XML format.
>>
>> Is there a reason you have access to the email port and not the HTTP
>> port 80? It is very complex to identify a missing email but using port
>> 80 and HTTP the process
> We use a system of updating an Sqlite database buit use port 80 to send
> data in XML format.
>
> Is there a reason you have access to the email port and not the HTTP
> port 80? It is very complex to identify a missing email but using port
> 80 and HTTP the process is almost trivial
>
> Our
We use a system of updating an Sqlite database buit use port 80 to send
data in XML format.
Is there a reason you have access to the email port and not the HTTP
port 80? It is very complex to identify a missing email but using port
80 and HTTP the process is almost trivial
Our system
... sorry, I forgot to mention to have an updatedBy column also having the
computer name as a distinct valuefor knowing who updated the last one (and
eventually an updatedTime to know when)
Cheers,
Sylvain
On Sun, Jul 12, 2009 at 5:06 PM, Sylvain Pointeau <
sylvain.point...@gmail.com> wrote:
>
what about to use a unique identifier for each row?but a unique identifier
like UUID in sqlserver or Quuid in Qt?
as it is unique over the world it could be enough?
at the worst case, prefix an id by the name of your machine if you have only
2 machines.
then merge the records together?
cheers,
On 11 Jul 2009, at 8:03am, raf wrote:
> you could also send individual sql statements via email but
> email doesn't always arrive. that is a major problem. you
> would need an acknowledgement and retry mechanism. perhaps
> there's an april fool's RFC for implementing TCP/IP via email :)
>
> once
Jim Dodgen wrote:
> On Fri, Jul 10, 2009 at 9:16 PM, Bill Harris <
> bill_har...@facilitatedsystems.com> wrote:
>
> > I have to coordinate a task list between two sites, and my only
> > convenient connection between the two is email. MS Access 2007 offers
> > an email insert and update feature,
-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 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
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
not beyond the realm of possibilities. I back up via email, a nice
protocol.
I dump > tar > gzip > and email a small but important database to 6 people
each day via a cron job.
I don't remember exactly how but on unix boxes I have created user accounts
that receive emails automatically
and then
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have to coordinate a task list between two sites, and my only
convenient connection between the two is email. MS Access 2007 offers
an email insert and update feature, but it's not quite doing what I
need.
Is there a way to update / synchronize an
12 matches
Mail list logo