SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Guru toasti's Avatar
    Join Date
    Feb 2004
    Location
    Grahamstown
    Posts
    634
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    A Distributed CMS which users can user on their local machine

    I am pitching for a job publishing journals in Africa. A big selling point which i want to offer is the ability for people to download a client program (written in either Java or even a Flash application), then do inputting locally (internet is very slow in Africa!).

    The way i am thinking of doing it is to provide them with the inputting interface similar to what would be on the web, which will create SQL batch files which they would then upload to the web, syncronizing their local work with the live version on the web.

    There are obviosly a number of complications. the 1st and most important would be security. obviously one would have to be very careful letting people run batch scripts. so i was thinking of letting them email it to me/the web administrator and then i would do the actual merging, but this might become a bit labour intensive! i suppose i could automate it on my side...

    The above issue is my primary concern. does anyone have any good ideas about how one could deal with this? or any other things i should think about before trying to implement this system?

  2. #2
    SitePoint Wizard stereofrog's Avatar
    Join Date
    Apr 2004
    Location
    germany
    Posts
    4,324
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You actually need two programs: offline client, which saves data in some easy 'parseable' format (xml seems to be a best choice) and server-side application, which can interpret this data and update the database. The client can periodically connect server side via http and transfer data in a usual way. Of course, you shouldn't give them ability to access database directly (like sql batch files etc) and your server script should be password protected.

  3. #3
    SitePoint Guru toasti's Avatar
    Join Date
    Feb 2004
    Location
    Grahamstown
    Posts
    634
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    XML would be a much better way of handling it! Thanks


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •