Menu
▾
▴
Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap
|
From: Stins, D. <DR...@Zi...> - 2004-09-19 14:29:04
|
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). 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?). 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 - business rule layer - database trigger layer - database layer 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). An example of an architecture like this is: http://sourceforge.net/projects/seagull/ 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 |
