On 6/6/06, Jason Dimberg <[EMAIL PROTECTED]> wrote:
I am working on an application where data will be collected on laptops
and then uploaded to a central database once the laptop is able to
connect to the network after being in the field.  I was initially
thinking of using MS Access as a front end with linked tables through
MySQL ODBC.  I am now considering running WAMP on each machine with a
web interface because there will be no interoperability issues if MySQL
is the db server on both ends, but I am 1.) looking for any
recommendations for the laptop interface (MS Access/WAMP or whatever
other options might be available) and 2.) want to know what is the
actual command for updating a table across two servers (this is NOT
replication, but merely updating new data to an existing table).

Data transfered will include binary objects and possibly GIS data.

For example, Laptop 1 might have 10 rows of data from todays activities
that need to be added to the main Server.  Laptop 2 might have 30 rows
of data that need to be added to the main Server.  Neither laptop needs
to have the data from the other, but the Server will contain data from
both Laptops at the end of the day.  The Server will then offer the data
through a web interface.

Server:
Linux/MySQL 5.0

Laptops
MS Access 2003 OR
MySQL 5.0/ PHP 5/ Apache 2


Don't use ACCESS to deal with MySQL Data, you'll probably meet
inconsistencies, along with bugs and problems with field types,
besides, MS sucks...

To sync the laptop with the actual database, you can use a Web
Interface, or simply upload data via ftp or any other protocol (check
for security) and write a script to add this data to MySQL. Are you
sure you're not better served using the filesystem to store the data
and simply indexing names, sizes, maybe a hash for security reasons
(md5 or whatever) and timestamps so you can use the database to
quickly search or organize files but offer them via HTTP or FTP? A
simple app can get info about the file, upload it to the server and
add a row to MySQL with the info and the location of the file in the
filesystem.

You would get something like:

filesystem:
/home/ftp/file1.bin

mysql:
name: file1.bin
location: /home/ftp
size: 1024 bytes
hash: 78687hhg89686578h786
uploaded: 06/06/2006 14:30
from: laptop1

A simple web interface written in PHP or whatever can search this
database, filter data, sort stuff and simply offer links to the ftp
site...


Just a suggestion...

--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to