Re: [Savannah-hackers-public] PHP developer for savanah

[Sylvain Beucler]

Hi,

This is a good start.

One issue is that the cache is not invalidated when `people_job` is
changed, which means Savannah can return inconsistent results for 5
minutes.

P.S.: please keep address@hidden in Cc: so that other
people in the team can see what's going on :)

-- 
Sylvain


On Wed, Apr 30, 2008 at 09:24:06PM +0200, Sahid Ferdjaoui wrote:
> Hello Sylvain
> 
> i have developed Cache abstract class
> http://pastebin.funraill.org/ee9d39ff874d1adeca7653b9630e7af7/
> 
> for the database, I think it, add two new functions :
> db_cache_fetch (); and db_cache_row ();
> view source : http://pastebin.funraill.org/73497bfce7ede4fa0d0fb5700de7e506/
> 
> i have review people_show_category_table () with new function
> http://pastebin.funraill.org/96c162c4fd92eca6cb718c366c216c8c/
> 
> I wait your suggestion sylvain :)
> 
> also i have add new memched debug's in init.php
> 
> (sorry for my bad english)
> 
> On Tue, Apr 29, 2008 at 7:40 PM, Sylvain Beucler <address@hidden> wrote:
> > Hi,
> >
> >  Reviewing /people is a good idea; we'll see and discuss how you
> >  envision introducing memcache support in the code.
> >
> >  (A priori I think that memcache'd data need to be properly
> >  encapsulated (getter+setter) to avoid differences between MySQL and
> >  the memcache, and update the memcache whenever the data changes.)
> >
> >
> >  For the most often used queries: I enabled $sys_debug_sqlprofiler (as
> >  seen in include/database.php) at Savannah. The results are viewable
> >  through https://savannah.gnu.org/xcache/?type=1 (sort by 'Hits').
> >
> >  --
> >  Sylvain
> >
> >
> >
> >  On Tue, Apr 29, 2008 at 06:42:57PM +0200, Sahid Ferdjaoui wrote:
> >  > Hello Sylvain
> >  >
> >  > OK, I can try reduce MySQL load
> >  >
> >  > for begin, i try reviewing "/people", OK ?
> >  > or you can tell me, what are the primaries modules load MySQL.
> >  >
> >  >
> >  > On Tue, Apr 29, 2008 at 12:29 AM, Sahid Ferdjaoui <address@hidden> wrote:
> >  > > OK Sylvain thank,
> >  > >
> >  > >  I try to install savannah and i try understand the actualy code :)
> >  > >
> >  > >  good night
> >  > >
> >  > >
> >  > >
> >  > >
> >  > >
> >  > >
> >  > >  On Mon, Apr 28, 2008 at 8:30 PM, Sylvain Beucler <address@hidden> 
> > wrote:
> >  > >  > Hi,
> >  > >  >
> >  > >  >  Thanks for contributing to GNU :)
> >  > >  >
> >  > >  >  We've assembled a list of "help needed" tasks at:
> >  > >  >  http://savannah.gnu.org/maintenance/SavaneTasks
> >  > >  >
> >  > >  >  Can you read it and tell us what you are interested in?
> >  > >  >
> >  > >  >
> >  > >  >  Since you already used memcached, here's another idea just for you:
> >  > >  >  we'd like Savane to use memcached to reduce the MySQL load; the
> >  > >  >  criticil points are (IMHO):
> >  > >  >  - the code is not well encapsulated
> >  > >  >  - a lot of queries use JOINs, which I believe won't be easy to 
> > replace
> >  > >  >   with similar memcached calls
> >  > >  >  Suggestions/code appreciated ;)
> >  > >  >
> >  > >  >  Hear from you soon,
> >  > >  >
> >  > >  >  --
> >  > >  >  Sylvain
> >  > >  >
> >  > >  >  > Subject: [gnu.org #360924] PHP developer for savanah
> >  > >  >  > From: Sahid Ferdjaoui via RT <address@hidden>
> >  > >  >  > Date: Sun, 27 Apr 2008 08:21:26 -0400
> >  > >  >  > Hello,
> >  > >  >  >
> >  > >  >  > I'm french, i'm 23 years, i'm passionte by open sources projects 
> > in
> >  > >  >  > particulary gnu project.
> >  > >  >  > Currently i'm computer programmer for comunity web site, 
> > developed
> >  > >  >  > with PHP, Apache, MySQL and Memcached.
> >  > >  >  > i have developed for this web site, a MySQL and Memcached 
> > abstracts
> >  > >  >  > classes,  a secure payment's API with GUI's admin, SOAP and REST 
> > web
> >  > >  >  > services.
> >  > >  >  >
> >  > >  >  > if you want my CV contact me.
> >  > >  >  > you can see my french blog http://sahid.funraill.org
> >  > >  >  >
> >  > >  >  > Thanks