Menu
▾
▴
Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap
|
From: Jake S. <ns...@us...> - 2004-09-20 05:58:59
|
Stins, Dick wrote: >Jake, > >Thanks for your comments. > >I am not a fan of pear:db. I prefer to use standard sql. That is already a >big step for portability + the clean and mean weberp script ConnectDB.inc. >So it should not be too hard to port web-erp to another db engine. > > No to be honest neither am I, for reasons I won't bore you with it was chosen at the start of the project and has persited through. Have you had a look at http://creole.phpdb.org/ http://propel.phpdb.org/wiki/ >Smarty might be interesting, but I am already glad when css is optimal used. > > This is the case with EGS, it just allows all of the presentation logic to be removed from the code base and allows people to be a lot more flexible with the layout without having to trawl through the PHP code. >Multiple company support is interesting. > > Yes this was one of the distinctions that was used to justify it over simply contributing to an exisitng project since non of the others do it. For this reason I am not sure if one of the Application Frameworks would have worked due to its authentication system. Have you looked at http://www.binarycloud.com/ >Does it also support ldap (nds)? > > Not at present. My knowledge of ldap consists of the following: It exists It is adirectory server I have always thought that it would be good to have it working with ldap but unfortunately I have not had the time to look into it. However with the present system I believe you can use PEAR:DB to connect to ldap so may be possible. Thanks Jake >with best regards, > >Dick Stins > >----- Original Message ----- >From: "Jake Stride" <ns...@us...> >To: <web...@li...> >Sent: Sunday, September 19, 2004 7:41 PM >Subject: Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap > > > > >>Stins, Dick wrote: >> >> >> >>>Jake, >>> >>>I think that common functions which are needed in weberp and in your crm >>>software should be encapsulated in classes, so you do not need to know >>> >>> >where > > >>>the information is comming from (postgres or mysql). >>> >>> >>> >>At the moment it kind of should be in that it uses PEAR:DB for >> >> >abstraction. > > >>>When you want to >>>integrate web-erp and your crm software, you still need to integrate the >>>authentication and the address books processing and .... >>>The design of these issues should be loosely connected or we should >>> >>> >create > > >>>one big project (wegs-erp?). >>> >>> >>> >>> >>That could be interesting and worthwhile, is it something people may be >>interested in? >> >> >> >>>The same for all your code which needs views. Those should be >>> >>> >encapsulated > > >>>in classes, so it's easy to write an alternative for mysql >>>(allthough when you are able to run mysql with maxdb, then probably you >>> >>> >can > > >>>use views). >>> >>>I even recommend to develop an architecture with: >>>- front end layer >>> >>> >>> >>> >>Smarty for templating >> >> >> >>>- business rule layer >>> >>> >>> >>> >>System is written as classes >> >> >> >>>- database trigger layer >>>- database layer >>> >>> >>> >>> >>PEAR >> >> >> >>>This helps to be in control of you own code, reuse of code, increase >>>portability for you code (like porting to other databases: sql server, >>>firebird, oracle). >>> >>> >>> >>> >>EGS should work in oracle without much trouble because of PEAR:DB >> >> >> >>>An example of an architecture like this is: >>>http://sourceforge.net/projects/seagull/ >>> >>> >>> >>> >>I did have a look at these, the problem is that EGS authentication is >>more complicated that this. It is written as an ASP application so that >>several companies can use the same server/DB etc. >> >>IE in egs one company can login and create there own users and groups >>and insert data etc that another company cannot see. >> >>Jake >> >> >> >>>With best regards, >>> >>>Dick Stins >>> >>> >>> > > > > > >------------------------------------------------------- >This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 >Project Admins to receive an Apple iPod Mini FREE for your judgement on >who ports your project to Linux PPC the best. Sponsored by IBM. >Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php >_______________________________________________ >Web-erp-developers mailing list >Web...@li... >https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > |
