Menu
▾
▴
Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap
|
From: Jake S. <ns...@us...> - 2004-09-19 17:41:07
|
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 > >----- Original Message ----- >From: "Jake Stride" <ns...@us...> >To: <web...@li...> >Sent: Saturday, September 18, 2004 1:08 PM >Subject: Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap > > > > >>In what sense? you can replicate the database of several servers with >>postgres. >> >>The problem with running to seperate databases is that you then have 2 >>seperate address books/user authentication etc. I tmight be OK in some >>situations but ideally i would like to see them running from the same >>database. >> >>Jake >> >>Stins, Dick wrote: >> >> >> >>>Hoi Jake, >>> >>>I do not know much about postgres, but does it have also replication >>>facilities like mysql? >>> >>>Did you consider running postgres and mysql together at one server? At my >>>server does it run fine. >>> >>>That might be a good alternative for your integration problem. >>> >>>with best regards, >>> >>>Dick Stins >>> >>>----- Original Message ----- >>>From: "Jake Stride" <ns...@us...> >>>To: <web...@li...> >>>Sent: Friday, September 17, 2004 11:00 AM >>>Subject: Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap >>> >>> >>> >>> >>> >>> >>>>Yes the people that host it are having a few issues at the moment and >>>>have blocked the ports on which it run (the problems aren't due to EGS >>>>:-) ). >>>> >>>>I am trying to sort out another demo at the moment so hopefully it will >>>>be back up soon. >>>> >>>>I have a demo running on my adsl box at home and could give you a login >>>>for that if you want a quick look at it (for obvious reasons I don't >>>>publish the details on sf.net) just contact me off list and I can give >>>>you a login. >>>> >>>>Jake >>>> >>>>Stins, Dick wrote: >>>> >>>> >>>> >>>> >>>> >>>>>Jake, >>>>> >>>>>Sounds promishing, but I wasn't able to evealute your demo because it >>>>> >>>>> >was > > >>>>>not active. >>>>> >>>>>I will try it later. >>>>> >>>>>With best regards, >>>>> >>>>>Dick Stins >>>>>----- Original Message ----- >>>>>From: "Jake Stride" <ns...@us...> >>>>>To: <web...@li...> >>>>>Sent: Friday, September 17, 2004 12:07 AM >>>>>Subject: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>>>Stins, Dick wrote: >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>>>When you want web-erp be enhanced with crm, then >>>>>>>it might be easier to integrate a mysql crm product. >>>>>>>Like: >>>>>>>xrms >>>>>>>covide >>>>>>>tutos >>>>>>>sugarcrm >>>>>>>vtiger >>>>>>> >>>>>>>with best regards, >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>Not to be to protective, but EGS is not just a CRM tool, it offers >>>>>>project management, ticketing, and calendaring too, the whole point >>>>>> >>>>>> >of > > >>>>>>it is to have a single system from which to run a business as a posed >>>>>> >>>>>> >to > > >>>>>>several disparate systems. It is not just a salesforce.com clone as >>>>>> >>>>>> >the > > >>>>>>majority of those above seem to be, and I have been trying to work on >>>>>>weberp integration for some time >>>>>>(http://sourceforge.net/mailarchive/message.php?msg_id=8517406) >>>>>> >>>>>> >although > > >>>>>>have stalled somewhat at present working on other functionality. >>>>>> >>>>>>Of course integration with some of these tools may be easier and of >>>>>>course everyone has to weigh up the pros and cons of what they want >>>>>> >>>>>> >from > > >>>>>>the integration (integration with the above products may suit some >>>>>>people down to the ground), but when I last looked most of the >>>>>> >>>>>> >projects > > >>>>>>above did not have any intentions to add any functionality above that >>>>>>required of the CRM, and this is where EGS is different. >>>>>> >>>>>>At present EGS is in a state between CRM and weperp. All of the CRM is >>>>>>linked into the project management and has some job costing and time >>>>>>tracking facilities present (it is this functionality we have been >>>>>>working on for a client, and why we paused looking at weberp for a >>>>>>while), it is on this that we would like to expand by adding the >>>>>> >>>>>> >ability > > >>>>>>to run accounting/erp etc from the system. With the possibility of >>>>>>weberp running on postgres it seems to be the best system for us to >>>>>>integrate (we have looked at sql-ledger too) and that is why we >>>>>>appraoched weberp to find out more ( I was unaware of any other >>>>>> >>>>>> >projects > > >>>>>>looking to do this too). >>>>>> >>>>>>Obviously I am biased since a lot of my blood, sweat and tears have >>>>>> >>>>>> >gone > > >>>>>>into EGS, but I for one will continue to look at integrating web-erp >>>>>>with EGS since I believe it to be a fairly trivial task (famous last >>>>>>words) once I have gotten web-erp to run on postgresql due to the way >>>>>>out database is laid out. >>>>>> >>>>>>So my slightly ranting email aside, if anyone has gotten web-erp to >>>>>> >>>>>> >work > > >>>>>>on postgresql I would be most interested to your experiences. >>>>>> >>>>>>Thanks >>>>>> >>>>>>Jake >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>>>Dick Stins >>>>>>>----- Original Message ----- >>>>>>>From: "skaill" <sk...@ro...> >>>>>>>To: <web...@li...> >>>>>>>Sent: Thursday, September 16, 2004 7:58 PM >>>>>>>Subject: Re: [Web-erp-developers] Cheap >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>------------------------------------------------------- >>>>>>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 >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>------------------------------------------------------- >>>>>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 >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>------------------------------------------------------- >>>>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 >>>> >>>> >>>> >>>> >>> >>> >>>------------------------------------------------------- >>>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 >>> >>> >>> >>> >> >>------------------------------------------------------- >>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 >> >> > > > > >------------------------------------------------------- >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 > > |
