Thread: [Web-erp-developers] Cheap

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

I found this domain registration place that's really =
cheap...http://www.domains.ca/payment.asp

Steve
skaill wrote:

> I found this domain registration place that's really 
> cheap...http://www.domains.ca/payment.asp
>  
> Steve

Well the company I work for offer domain registrations, and I have 
spoken to the boss and he has offered a free registration if you want 
it. (A link back to our company site would be nice if it is on offer - 
we develop EGS under the GPL - http://egs.sourceforge.net).

Jake

Thanks for the offer, Jake.  I'm not sure where the domain name registration
sits right now.  Phil was going to pay for it so I found a place that is
really cheap.  Phil can respond with what he's done or would like to do when
he's back here.

I checked out EGS.  I could see WebERP and EGS being combined onto one great
solution for many companies..

Steve

----- Original Message ----- 
From: "Jake Stride" <ns...@us...>
To: <web...@li...>
Sent: Thursday, September 16, 2004 1:40 PM
Subject: Re: [Web-erp-developers] Cheap

> skaill wrote:
>
> > I found this domain registration place that's really
> > cheap...http://www.domains.ca/payment.asp
> >
> > Steve
>
> Well the company I work for offer domain registrations, and I have
> spoken to the boss and he has offered a free registration if you want
> it. (A link back to our company site would be nice if it is on offer -
> we develop EGS under the GPL - http://egs.sourceforge.net).
>
> Jake
>
>
> -------------------------------------------------------
> 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

skaill wrote:

>Thanks for the offer, Jake.  I'm not sure where the domain name registration
>sits right now.  Phil was going to pay for it so I found a place that is
>really cheap.  Phil can respond with what he's done or would like to do when
>he's back here.
>  
>

Thats OK just let me know.

>I checked out EGS.  I could see WebERP and EGS being combined onto one great
>solution for many companies..
>  
>

Exactly my thoughts, that why I first started looking at web-erp, at the 
moment we have had a massive push on development here and are just 
gearing up for a major release.

At the moment EGS runs on postgres, so I was interested in the web-erp 
to postgres port. In about a week or two I am going to take another look 
at the state of the web-erp port to postgres since I will have finished 
the dev stuff that I have to do on EGS, so if anyone has any info (Phil 
put me in touch with Danie but I have been a bit slack keeping up with 
things) I would be interested to hear.

Jake

>Steve
>
>----- Original Message ----- 
>From: "Jake Stride" <ns...@us...>
>To: <web...@li...>
>Sent: Thursday, September 16, 2004 1:40 PM
>Subject: Re: [Web-erp-developers] Cheap
>
>
>  
>
>>skaill wrote:
>>
>>    
>>
>>>I found this domain registration place that's really
>>>cheap...http://www.domains.ca/payment.asp
>>>
>>>Steve
>>>      
>>>
>>Well the company I work for offer domain registrations, and I have
>>spoken to the boss and he has offered a free registration if you want
>>it. (A link back to our company site would be nice if it is on offer -
>>we develop EGS under the GPL - http://egs.sourceforge.net).
>>
>>Jake
>>
>>
>>-------------------------------------------------------
>>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
>  
>

I think some are running webERP with postgres.

How difficult would it be to get EGS using MySQL instead of postgres?  I
would be looking at the other way around for a few customers.

Steve

----- Original Message ----- 
From: "Jake Stride" <ns...@us...>
To: <web...@li...>
Sent: Thursday, September 16, 2004 2:13 PM
Subject: Re: [Web-erp-developers] Cheap

> skaill wrote:
>
> >Thanks for the offer, Jake.  I'm not sure where the domain name
registration
> >sits right now.  Phil was going to pay for it so I found a place that is
> >really cheap.  Phil can respond with what he's done or would like to do
when
> >he's back here.
> >
> >
>
> Thats OK just let me know.
>
> >I checked out EGS.  I could see WebERP and EGS being combined onto one
great
> >solution for many companies..
> >
> >
>
> Exactly my thoughts, that why I first started looking at web-erp, at the
> moment we have had a massive push on development here and are just
> gearing up for a major release.
>
> At the moment EGS runs on postgres, so I was interested in the web-erp
> to postgres port. In about a week or two I am going to take another look
> at the state of the web-erp port to postgres since I will have finished
> the dev stuff that I have to do on EGS, so if anyone has any info (Phil
> put me in touch with Danie but I have been a bit slack keeping up with
> things) I would be interested to hear.
>
> Jake
>
> >Steve
> >
> >----- Original Message ----- 
> >From: "Jake Stride" <ns...@us...>
> >To: <web...@li...>
> >Sent: Thursday, September 16, 2004 1:40 PM
> >Subject: Re: [Web-erp-developers] Cheap
> >
> >
> >
> >
> >>skaill wrote:
> >>
> >>
> >>
> >>>I found this domain registration place that's really
> >>>cheap...http://www.domains.ca/payment.asp
> >>>
> >>>Steve
> >>>
> >>>
> >>Well the company I work for offer domain registrations, and I have
> >>spoken to the boss and he has offered a free registration if you want
> >>it. (A link back to our company site would be nice if it is on offer -
> >>we develop EGS under the GPL - http://egs.sourceforge.net).
> >>
> >>Jake
> >>
> >>
> >>-------------------------------------------------------
> >>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

skaill wrote:

>I think some are running webERP with postgres.
>
>How difficult would it be to get EGS using MySQL instead of postgres?  I
>would be looking at the other way around for a few customers.
>
>Steve
>  
>

Well once mysql supports views (in alpha at the moment for 5.0), cascade 
deletes (not sure about), foreign keys ( I know it kind of supports 
these at present) etc then no problem (it uses PEAR DB for abstraction) 
The views are a fairly major feature of the system as are the cascade 
deletes so I guess if someone was prepared to convert those then it 
would be a fairly trivial task. I would certainly be interested in 
discussing the posibility of a port.

I know lots of people like mysql, my preference is for postgres hence 
why the system uses it but I have no intentions of starting a debate on 
the merits of each and I can certainly see the value of a mysql port, 
boosting the projects popularity is a major one for starters.

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,

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

> Thanks for the offer, Jake.  I'm not sure where the domain name
registration
> sits right now.  Phil was going to pay for it so I found a place that is
> really cheap.  Phil can respond with what he's done or would like to do
when
> he's back here.
>
> I checked out EGS.  I could see WebERP and EGS being combined onto one
great
> solution for many companies..
>
> Steve
>
> ----- Original Message -----
> From: "Jake Stride" <ns...@us...>
> To: <web...@li...>
> Sent: Thursday, September 16, 2004 1:40 PM
> Subject: Re: [Web-erp-developers] Cheap
>
>
> > skaill wrote:
> >
> > > I found this domain registration place that's really
> > > cheap...http://www.domains.ca/payment.asp
> > >
> > > Steve
> >
> > Well the company I work for offer domain registrations, and I have
> > spoken to the boss and he has offered a free registration if you want
> > it. (A link back to our company site would be nice if it is on offer -
> > we develop EGS under the GPL - http://egs.sourceforge.net).
> >
> > Jake
> >
> >
> > -------------------------------------------------------
> > 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
>

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
>
>
>  
>

Integration.  You have integrated many things.  That's the most important
mission.  Sounds good.  I have seen other discussion about postgres.  Phil
may be able to tell you who.  You may find in the various discussion areas
or past lists too.

Steve

----- Original Message ----- 
From: "Jake Stride" <ns...@us...>
To: <web...@li...>
Sent: Thursday, September 16, 2004 6:07 PM
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

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

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
>  
>

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

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
>  
>

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

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
>  
>

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.

Smarty might be interesting, but I am already glad when css is optimal used.

Multiple company support is interesting.

Does it also support ldap (nds)?

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
> >

Language team,

Please check smarty for transforming decimal point locator (. or ,) and
thousands separator (, or .) and may be for more issues like dates formats.
http://www.oxyscripts.com/manuals/smarty/language.modifier.string.format.htm
l

When this helps, then we can setup a smarty template per language?

With best regards,

Dick Stins
----- Original Message -----
From: "Stins, Dick" <DR...@Zi...>
To: <web...@li...>
Sent: Monday, September 20, 2004 1:03 AM
Subject: Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap

> 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.
>
> Smarty might be interesting, but I am already glad when css is optimal
used.
>
> Multiple company support is interesting.
>
> Does it also support ldap (nds)?
>
> 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

If you guys do decide to use Smarty you will get a nice feature relating 
to translations.
With a little configuration you can get smarty to do translation when it 
compiles the templates,
this means that for static text your code just translates it once (the 
first time the template is compiled).
After a page has been accessed one time all the 'static' text will not 
need to be translated.

Having said this, using smarty properly you require quite a bit of 
refactoring of weberps code.

Hani

Stins, Dick wrote:

>*This message was transferred with a trial version of CommuniGate(tm) Pro*
>Language team,
>
>Please check smarty for transforming decimal point locator (. or ,) and
>thousands separator (, or .) and may be for more issues like dates formats.
>http://www.oxyscripts.com/manuals/smarty/language.modifier.string.format.htm
>l
>
>When this helps, then we can setup a smarty template per language?
>
>With best regards,
>
>Dick Stins
>----- Original Message -----
>From: "Stins, Dick" <DR...@Zi...>
>To: <web...@li...>
>Sent: Monday, September 20, 2004 1:03 AM
>Subject: Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap
>
>
>  
>
>>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.
>>
>>Smarty might be interesting, but I am already glad when css is optimal
>>    
>>
>used.
>  
>
>>Multiple company support is interesting.
>>
>>Does it also support ldap (nds)?
>>
>>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
>>    
>>
>
>
>
>
>-------------------------------------------------------
>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
>
>
>  
>

I suggest first to finish the current gettext coding and release it.

After that, it we might evaluate and consider smarty.

With best regards,

Dick Stins

----- Original Message -----
From: "Hani Naguib" <ha...@na...>
To: <web...@li...>
Sent: Monday, September 20, 2004 1:55 AM
Subject: Re: [Web-erp-developers] smarty multiple language

> If you guys do decide to use Smarty you will get a nice feature relating
> to translations.
> With a little configuration you can get smarty to do translation when it
> compiles the templates,
> this means that for static text your code just translates it once (the
> first time the template is compiled).
> After a page has been accessed one time all the 'static' text will not
> need to be translated.
>
> Having said this, using smarty properly you require quite a bit of
> refactoring of weberps code.
>
> Hani
>
> Stins, Dick wrote:
>
> >*This message was transferred with a trial version of CommuniGate(tm)
Pro*
> >Language team,
> >
> >Please check smarty for transforming decimal point locator (. or ,) and
> >thousands separator (, or .) and may be for more issues like dates
formats.
>
>http://www.oxyscripts.com/manuals/smarty/language.modifier.string.format.ht
m
> >l
> >
> >When this helps, then we can setup a smarty template per language?
> >
> >With best regards,
> >
> >Dick Stins
> >----- Original Message -----
> >From: "Stins, Dick" <DR...@Zi...>
> >To: <web...@li...>
> >Sent: Monday, September 20, 2004 1:03 AM
> >Subject: Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap
> >
> >
> >
> >
> >>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.
> >>
> >>Smarty might be interesting, but I am already glad when css is optimal
> >>
> >>
> >used.
> >
> >
> >>Multiple company support is interesting.
> >>
> >>Does it also support ldap (nds)?
> >>
> >>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
> >>
> >>
> >
> >
> >
> >
> >-------------------------------------------------------
> >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

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
>  
>

You'll have to excuse my naievety (and poor spelling) since most of the
native functions are similar in function but different in name for differing
DBs why does one need such a lavish abstraction layer why won't a
ConnectDB.inc calling the native C calls to connect directly for other DBs
do the trick? This way we have ultimate performance minimum overhead!

I really don't understand why such lengths are necessary - the function
calls are virtually one to one and even most of the parameters are the same.

MS SQL Server

mssql_connect
mssql_fetch_array
mssql_fetch_row
mssql_data_seek

MySql

mysql_connect
mysql_query
mysql_fetch_array
mysql_fetch_row
mysql_data_seek

Postgres

pg_connect
pg_query
pg_fetch_array
pg_fetch_row
pg_data_seek

Firebird/interbase

ibase_connect
ibase_query
ibase_fetch_assoc
ibase_fetch_row

whoops there is no
ibase_data_seek

maybe I'm answering my own question!

Phil

----- Original Message ----- 
From: "Jake Stride" <ns...@us...>
To: <web...@li...>
Sent: Monday, September 20, 2004 5:58 PM
Subject: Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap

> 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
> >
> >
>
>
>
> -------------------------------------------------------
> 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
>

Daintrees wrote:

>You'll have to excuse my naievety (and poor spelling) since most of the
>native functions are similar in function but different in name for differing
>DBs why does one need such a lavish abstraction layer why won't a
>ConnectDB.inc calling the native C calls to connect directly for other DBs
>do the trick? This way we have ultimate performance minimum overhead!
>  
>

I think the reason for it is that this works in principle but not in 
pratice.

Take for example inserting booleans into a database, postgres represents 
them as 't' and 'f' whilst I believe mysql represents them as '1' and 
'0', so already you would have to wirte a function to deal with this, 
and on it goes until you have your own abstraction layer.

If you are using auto_incrementing/serial fields for ids a database 
abstraction layer can use the native functions for those dbs that 
support it but implement its own functionality for those that don't, 
therefore using a database abstraction layer you can simply call 
$db->nextId('tablename')

I think it is 6 of one half a dozen of the other, if you do not plan on 
using to many advanced db features then the ConnectDB method is fine, on 
the other hand you can let somebody else deal with the abstraction  who 
has access to several DBs and a developer community that is working 
solely on the task of database abstraction and not have to worry about 
new features bugs etc yourself, simple upgrade the abstraction layer as 
and when.

I have taken some of my examples from 
http://creole.phpdb.org/wiki/index.php?node=8 there point about quoting 
is a good one too.

Jake

>I really don't understand why such lengths are necessary - the function
>calls are virtually one to one and even most of the parameters are the same.
>
>MS SQL Server
>
>mssql_connect
>mssql_fetch_array
>mssql_fetch_row
>mssql_data_seek
>
>
>MySql
>
>mysql_connect
>mysql_query
>mysql_fetch_array
>mysql_fetch_row
>mysql_data_seek
>
>Postgres
>
>pg_connect
>pg_query
>pg_fetch_array
>pg_fetch_row
>pg_data_seek
>
>
>Firebird/interbase
>
>ibase_connect
>ibase_query
>ibase_fetch_assoc
>ibase_fetch_row
>
>whoops there is no
>ibase_data_seek
>
>maybe I'm answering my own question!
>
>
>Phil
>
>
>----- Original Message ----- 
>From: "Jake Stride" <ns...@us...>
>To: <web...@li...>
>Sent: Monday, September 20, 2004 5:58 PM
>Subject: Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap
>
>
>  
>
>>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
>>>
>>>
>>>      
>>>
>>
>>-------------------------------------------------------
>>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
>  
>

One less complication by using char = Y or N for boolean.  Works will all
databases and ready made for reports too ;)  Ok, it wastes space (in some
implementations) but who cares about that anymore?!

ODBC (1992) met the challenges of differing DBMSs and was meant to be THE
abstraction layer.  In my mind it was ODBC that really pushed the way for a
standard sql (sag sql) to become popular.  Before this each DBMS had its
proprietary language instead of sql so people were hungry for ODBC.  The
ODBC middle layer demanded everyone use a common set of commands and a
standard sql.

The problems with ODBC included slowness, which was resolved to a large
extent over the years and having to install ODBC driver(s) for each type of
database needed on every client machine.  The database vendors had to write
the ODBC driver for their product and make it work in the Microsoft hidden
world of Windows.

So why are these other abstraction layers cropping up when ODBC exists?

Steve

----- Original Message ----- 
From: "Jake Stride" <ns...@us...>
To: <web...@li...>
Sent: Monday, September 20, 2004 3:40 AM
Subject: Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap

> Daintrees wrote:
>
> >You'll have to excuse my naievety (and poor spelling) since most of the
> >native functions are similar in function but different in name for
differing
> >DBs why does one need such a lavish abstraction layer why won't a
> >ConnectDB.inc calling the native C calls to connect directly for other
DBs
> >do the trick? This way we have ultimate performance minimum overhead!
> >
> >
>
> I think the reason for it is that this works in principle but not in
> pratice.
>
>
> Take for example inserting booleans into a database, postgres represents
> them as 't' and 'f' whilst I believe mysql represents them as '1' and
> '0', so already you would have to wirte a function to deal with this,
> and on it goes until you have your own abstraction layer.
>
> If you are using auto_incrementing/serial fields for ids a database
> abstraction layer can use the native functions for those dbs that
> support it but implement its own functionality for those that don't,
> therefore using a database abstraction layer you can simply call
> $db->nextId('tablename')
>
> I think it is 6 of one half a dozen of the other, if you do not plan on
> using to many advanced db features then the ConnectDB method is fine, on
> the other hand you can let somebody else deal with the abstraction  who
> has access to several DBs and a developer community that is working
> solely on the task of database abstraction and not have to worry about
> new features bugs etc yourself, simple upgrade the abstraction layer as
> and when.
>
> I have taken some of my examples from
> http://creole.phpdb.org/wiki/index.php?node=8 there point about quoting
> is a good one too.
>
> Jake
>
> >I really don't understand why such lengths are necessary - the function
> >calls are virtually one to one and even most of the parameters are the
same.
> >
> >MS SQL Server
> >
> >mssql_connect
> >mssql_fetch_array
> >mssql_fetch_row
> >mssql_data_seek
> >
> >
> >MySql
> >
> >mysql_connect
> >mysql_query
> >mysql_fetch_array
> >mysql_fetch_row
> >mysql_data_seek
> >
> >Postgres
> >
> >pg_connect
> >pg_query
> >pg_fetch_array
> >pg_fetch_row
> >pg_data_seek
> >
> >
> >Firebird/interbase
> >
> >ibase_connect
> >ibase_query
> >ibase_fetch_assoc
> >ibase_fetch_row
> >
> >whoops there is no
> >ibase_data_seek
> >
> >maybe I'm answering my own question!
> >
> >
> >Phil
> >
> >
> >----- Original Message ----- 
> >From: "Jake Stride" <ns...@us...>
> >To: <web...@li...>
> >Sent: Monday, September 20, 2004 5:58 PM
> >Subject: Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap
> >
> >
> >
> >
> >>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
> >>>
> >>>
> >>>
> >>>
> >>
> >>-------------------------------------------------------
> >>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

Hoi,

I think you all wouldn't miss this article:

http://www.oracle.com/technology/pub/articles/php_experts/otn_pdo_oracle5.ht
ml

With best regards,

Dick Stins
----- Original Message -----
From: "Jake Stride" <ns...@us...>
To: <web...@li...>
Sent: Monday, September 20, 2004 9:40 AM
Subject: Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap

> Daintrees wrote:
>
> >You'll have to excuse my naievety (and poor spelling) since most of the
> >native functions are similar in function but different in name for
differing
> >DBs why does one need such a lavish abstraction layer why won't a
> >ConnectDB.inc calling the native C calls to connect directly for other
DBs
> >do the trick? This way we have ultimate performance minimum overhead!
> >
> >
>
> I think the reason for it is that this works in principle but not in
> pratice.
>
>
> Take for example inserting booleans into a database, postgres represents
> them as 't' and 'f' whilst I believe mysql represents them as '1' and
> '0', so already you would have to wirte a function to deal with this,
> and on it goes until you have your own abstraction layer.
>
> If you are using auto_incrementing/serial fields for ids a database
> abstraction layer can use the native functions for those dbs that
> support it but implement its own functionality for those that don't,
> therefore using a database abstraction layer you can simply call
> $db->nextId('tablename')
>
> I think it is 6 of one half a dozen of the other, if you do not plan on
> using to many advanced db features then the ConnectDB method is fine, on
> the other hand you can let somebody else deal with the abstraction  who
> has access to several DBs and a developer community that is working
> solely on the task of database abstraction and not have to worry about
> new features bugs etc yourself, simple upgrade the abstraction layer as
> and when.
>
> I have taken some of my examples from
> http://creole.phpdb.org/wiki/index.php?node=8 there point about quoting
> is a good one too.
>
> Jake
>
> >I really don't understand why such lengths are necessary - the function
> >calls are virtually one to one and even most of the parameters are the
same.
> >
> >MS SQL Server
> >
> >mssql_connect
> >mssql_fetch_array
> >mssql_fetch_row
> >mssql_data_seek
> >
> >
> >MySql
> >
> >mysql_connect
> >mysql_query
> >mysql_fetch_array
> >mysql_fetch_row
> >mysql_data_seek
> >
> >Postgres
> >
> >pg_connect
> >pg_query
> >pg_fetch_array
> >pg_fetch_row
> >pg_data_seek
> >
> >
> >Firebird/interbase
> >
> >ibase_connect
> >ibase_query
> >ibase_fetch_assoc
> >ibase_fetch_row
> >
> >whoops there is no
> >ibase_data_seek
> >
> >maybe I'm answering my own question!
> >
> >
> >Phil
> >
> >
> >----- Original Message -----
> >From: "Jake Stride" <ns...@us...>
> >To: <web...@li...>
> >Sent: Monday, September 20, 2004 5:58 PM
> >Subject: Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap
> >
> >
> >
> >
> >>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
> >>>
> >>>
> >>>
> >>>
> >>
> >>-------------------------------------------------------
> >>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

Good stuff.  I wonder if and when their plan is for mysql and postgresql.
Sounds like they're moving pretty fast.

----- Original Message ----- 
From: "Stins, Dick" <DR...@Zi...>
To: <web...@li...>
Sent: Monday, September 20, 2004 5:52 PM
Subject: Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap

> Hoi,
>
> I think you all wouldn't miss this article:
>
>
http://www.oracle.com/technology/pub/articles/php_experts/otn_pdo_oracle5.ht
> ml
>
> With best regards,
>
> Dick Stins
> ----- Original Message -----
> From: "Jake Stride" <ns...@us...>
> To: <web...@li...>
> Sent: Monday, September 20, 2004 9:40 AM
> Subject: Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap
>
>
> > Daintrees wrote:
> >
> > >You'll have to excuse my naievety (and poor spelling) since most of the
> > >native functions are similar in function but different in name for
> differing
> > >DBs why does one need such a lavish abstraction layer why won't a
> > >ConnectDB.inc calling the native C calls to connect directly for other
> DBs
> > >do the trick? This way we have ultimate performance minimum overhead!
> > >
> > >
> >
> > I think the reason for it is that this works in principle but not in
> > pratice.
> >
> >
> > Take for example inserting booleans into a database, postgres represents
> > them as 't' and 'f' whilst I believe mysql represents them as '1' and
> > '0', so already you would have to wirte a function to deal with this,
> > and on it goes until you have your own abstraction layer.
> >
> > If you are using auto_incrementing/serial fields for ids a database
> > abstraction layer can use the native functions for those dbs that
> > support it but implement its own functionality for those that don't,
> > therefore using a database abstraction layer you can simply call
> > $db->nextId('tablename')
> >
> > I think it is 6 of one half a dozen of the other, if you do not plan on
> > using to many advanced db features then the ConnectDB method is fine, on
> > the other hand you can let somebody else deal with the abstraction  who
> > has access to several DBs and a developer community that is working
> > solely on the task of database abstraction and not have to worry about
> > new features bugs etc yourself, simple upgrade the abstraction layer as
> > and when.
> >
> > I have taken some of my examples from
> > http://creole.phpdb.org/wiki/index.php?node=8 there point about quoting
> > is a good one too.
> >
> > Jake
> >
> > >I really don't understand why such lengths are necessary - the function
> > >calls are virtually one to one and even most of the parameters are the
> same.
> > >
> > >MS SQL Server
> > >
> > >mssql_connect
> > >mssql_fetch_array
> > >mssql_fetch_row
> > >mssql_data_seek
> > >
> > >
> > >MySql
> > >
> > >mysql_connect
> > >mysql_query
> > >mysql_fetch_array
> > >mysql_fetch_row
> > >mysql_data_seek
> > >
> > >Postgres
> > >
> > >pg_connect
> > >pg_query
> > >pg_fetch_array
> > >pg_fetch_row
> > >pg_data_seek
> > >
> > >
> > >Firebird/interbase
> > >
> > >ibase_connect
> > >ibase_query
> > >ibase_fetch_assoc
> > >ibase_fetch_row
> > >
> > >whoops there is no
> > >ibase_data_seek
> > >
> > >maybe I'm answering my own question!
> > >
> > >
> > >Phil
> > >
> > >
> > >----- Original Message -----
> > >From: "Jake Stride" <ns...@us...>
> > >To: <web...@li...>
> > >Sent: Monday, September 20, 2004 5:58 PM
> > >Subject: Re: EGS/Postgresql - Was Re: [Web-erp-developers] Cheap
> > >
> > >
> > >
> > >
> > >>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
> > >>>
> > >>>
> > >>>
> > >>>
> > >>
> > >>-------------------------------------------------------
> > >>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

Thread: [Web-erp-developers] Cheap

Accounting & Best Practice Business Administration System

web-erp-developers