l i n u x - u s e r s - g r o u p - o f - d a v i s
L U G O D
 
Next Meeting:
April 21: Google Glass
Next Installfest:
TBD
Latest News:
Mar. 18: Google Glass at LUGOD's April meeting
Page last updated:
2008 Jan 15 17:09

The following is an archive of a post made to our 'vox-tech mailing list' by one of its subscribers.

Report this post as spam:

(Enter your email address)
Re: [vox-tech] collaborative data storage (of excel files)
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [vox-tech] collaborative data storage (of excel files)



On Tuesday 15 January 2008, Gandalf Parker wrote:
> On Tue, 15 Jan 2008, Jimbo wrote:
> > "The next step up, sorta, might be to set up a web server with a very
> > simple CGI for appending records to the CSV and committing, accessed
> > via a web form. From there you could proceed to using an low-admin
> > database if you wanted."
>
> Im glad I read thru the answers because that was the direction I was
> heading also.
>
> Apparently its a huge database (unless you are doing extensive math things
> then it should be a database instead of a spreadsheet). But the
> individuals are not working with the entire database?
>
> I would grab a LAMP book. There is even a dummies version which is usually
> great for getting a feel for something and deciding if you want to read
> further. L.A.M.P.  Linux, Apache, MySQL, and PHP (or Perl).
>
> Or you might even want to NOT go with direct updates. Use an old standard
> form CGI to retrieve data if necessary, take the changes, then process it
> by script. The script can update the database thru MySQL, AND also save
> off the original input with info on time, date, terminal, etc for tracking
> and verification purposes. If the updating of the database is done by cron
> working whats in a queue directory then it would simplify avoiding file
> access collisions.
>

YES - this is how I would approach this problem if I were in a position to 
babysit their data. I have put together several LAPP 
(linux-apache-postgres-php) projects- but only for things I was directly 
working on. I was searching for some kind of compromise between doing it 
correctly (i.e. a database) and doing it less incorrectly via SVN or the 
like.

ah well...

Cheers,

Dylan




-- 
Dylan Beaudette
Soil Resource Laboratory
http://casoilresource.lawr.ucdavis.edu/
University of California at Davis
530.754.7341
_______________________________________________
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech



LinkedIn
LUGOD Group on LinkedIn
Sign up for LUGOD event announcements
Your email address:
facebook
LUGOD Group on Facebook
'Like' LUGOD on Facebook:

Hosting provided by:
Sunset Systems
Sunset Systems offers preconfigured Linux systems, remote system administration and custom software development.

LUGOD: Linux Users' Group of Davis
PO Box 2082, Davis, CA 95617
Contact Us

LUGOD is a 501(c)7 non-profit organization
based in Davis, California
and serving the Sacramento area.
"Linux" is a trademark of Linus Torvalds.

Sponsored in part by:
Sunset Systems
Who graciously hosts our website & mailing lists!