Zikula Community

• dits
  
  

  • Rank: Developer
  • Registered: Feb 17, 2005
  • Last visit: May 21, 2010
  • Posts: 684

  Posted: Jun 24, 2009 - 01:47 AM

  Hi,
  
  Need to write a proposal for a web based system in Tanzania. Internet connectivity is not always reliable and part of the functionality and data needs to be available offline. The client requests a desktop application, but is open to other suggestions.
  
  I've been reading up a bit about (Google) Gears today. Gears uses SQlite, Adodb supports SQlite, Zikula supports Adodb. I guess you get my drift.
  
  I'm thinking of building Zikula modules that do their standard things when offline and have some kind of offline equivalents. Does this sound ridiculous? Should I rather turn to Cake or Symphony for something like this? What are your thoughts?
  
  Thanks,
  Bert

  • 
  •  
• slam
  
  

  • Rank: Team Member
  • Registered: May 03, 2004
  • Last visit: May 31, 2010
  • Posts: 511

  Posted: Jun 24, 2009 - 04:36 AM

  Having done some Zikula stuff with SQLite I can just confirm that your idea is far from being ridiculous. It's a reliable and extremely easy to handle database system, and will do what you expect. Just do not expect perfect performance under high load. I played with Pagesetter stuff on a SQLite setup, and did like it.
  
  You know our Cozi, which is Trac based. Trac comes with a simply SQLite setup by default, which seems to be very successful for smaller sites all around the world. So, go on - and please stay tuned with us.
  
  Greetings,
  chris
  
  --
  an operating system must operate
  development is life
  my repo

  • 
  •  
• planetenkiller
  
  

  • Rank: Team Member
  • Registered: Jul 15, 2008
  • Last visit: Sep 26, 2009
  • Posts: 23

  Posted: Jun 24, 2009 - 07:42 AM

  I think you can't use Adodb because Google Gears SQlite database runs on the web browser and Adodb on the web server.
  
  You must access the Google Gears SQlite database with javascript ( http://code.google.c…s/api_database.html ).
  
  
  
  edited by: planetenkiller, Jun 24, 2009 - 08:45 PM

  • 
  •  
• dits
  
  

  • Rank: Developer
  • Registered: Feb 17, 2005
  • Last visit: May 21, 2010
  • Posts: 684

  Posted: Jun 24, 2009 - 07:38 PM

  Thanks for the comments. I guess you're right about Adodb not being an option (specifically not when you require any return information from the query).
  
  I did run into something interesting here: http://www.phil-tayl…a-1.5-Admin-Console. Doesn't help me but might be an interesting idea for Zikula as well (though I'm in doubt about the real need).
  
  Will try and do some tesing of very simple ideas.

  • 
  •  
•  
•  

Users on-line

• rgasch

This list is based on users active over the last 60 minutes.