[OFBiz] Users - MySQL

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

[OFBiz] Users - MySQL

michal-2
Hello Ofbiz users,
 
Iam new to ofbiz, just downloaded it about week ago. I tested it on my RHEL machine with demo data. It is working fine and Iam all happy with all the features and functionality. I want to move to next step which would be integrating ofbiz with mysql database. Can you guys give me some instructions on where I should start or maybe there are "How to's" on this subject.
Thanks
Mike 

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: [OFBiz] Users - MySQL

Si Chen-2
Let me know if this works.  (These were tested with MySQL 5.0)

http://sequoiaerp.org/index.php?option=com_content&task=view&id=37&Itemid=62

michal wrote:

> Hello Ofbiz users,
>  
> Iam new to ofbiz, just downloaded it about week ago. I tested it on my
> RHEL machine with demo data. It is working fine and Iam all happy with
> all the features and functionality. I want to move to next step which
> would be integrating ofbiz with mysql database. Can you guys give me
> some instructions on where I should start or maybe there are "How
> to's" on this subject.
> Thanks
> Mike
>
>------------------------------------------------------------------------
>
>
>_______________________________________________
>Users mailing list
>[hidden email]
>http://lists.ofbiz.org/mailman/listinfo/users
>
 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: [OFBiz] Users - MySQL

MPF-2

Mike

Wy dont you use postgres? Be sure to check the Relational Database Section  on the the wiki

http://ofbizwiki1.go-integral.com/Wiki.jsp?page=OnlineAdministrationManual

Michael

[hidden email] wrote on 31.10.2005 20:43:50:

> Let me know if this works.  (These were tested with MySQL 5.0)
>
> http://sequoiaerp.org/index.php?option=com_content&task=view&id=37&Itemid=62
>
> michal wrote:
>
> > Hello Ofbiz users,
> >  
> > Iam new to ofbiz, just downloaded it about week ago. I tested it on my
> > RHEL machine with demo data. It is working fine and Iam all happy with
> > all the features and functionality. I want to move to next step which
> > would be integrating ofbiz with mysql database. Can you guys give me
> > some instructions on where I should start or maybe there are "How
> > to's" on this subject.
> > Thanks
> > Mike
> >
> >------------------------------------------------------------------------
> >
> >
> >_______________________________________________
> >Users mailing list
> >[hidden email]
> >http://lists.ofbiz.org/mailman/listinfo/users
> >
>  
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: [OFBiz] Users - MySQL

michal-2
I was thinking about Mysql because I have experience with it and I have never been working with postgres. I might give it a shoot to learn something new. Is the installation simpler then on Mysql ? How about tools for managing postgres ?
Mike
 
----- Original Message -----
Sent: Monday, October 31, 2005 3:23 PM
Subject: Re: [OFBiz] Users - MySQL


Mike

Wy dont you use postgres? Be sure to check the Relational Database Section  on the the wiki

http://ofbizwiki1.go-integral.com/Wiki.jsp?page=OnlineAdministrationManual

Michael

[hidden email] wrote on 31.10.2005 20:43:50:

> Let me know if this works.  (These were tested with MySQL 5.0)
>
> http://sequoiaerp.org/index.php?option=com_content&task=view&id=37&Itemid=62
>
> michal wrote:
>
> > Hello Ofbiz users,
> >  
> > Iam new to ofbiz, just downloaded it about week ago. I tested it on my
> > RHEL machine with demo data. It is working fine and Iam all happy with
> > all the features and functionality. I want to move to next step which
> > would be integrating ofbiz with mysql database. Can you guys give me
> > some instructions on where I should start or maybe there are "How
> > to's" on this subject.
> > Thanks
> > Mike
> >
> >------------------------------------------------------------------------
> >
> >
> >_______________________________________________
> >Users mailing list
> >[hidden email]
> >http://lists.ofbiz.org/mailman/listinfo/users
> >
>  
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users



_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: [OFBiz] Users - MySQL

Si Chen-2
It's always hard to answer a question about that.  I've worked with both
and found that if you're used to one, you'll find the other odd.  After
you get familiar with them, though, you'd find that they're about the
same thing.

One thing I would point out though--there are a lot more people on this
list familiar with PostgreSQL than MySQL.  Not necessarily because MySQL
is bad, but because PostgreSQL has been traditionally the preferred open
source database for enterprise applications, whereas MySQL did not
really support things like transactions and foreign keys for a long time.

michal wrote:

> I was thinking about Mysql because I have experience with it and I
> have never been working with postgres. I might give it a shoot to
> learn something new. Is the installation simpler then on Mysql ? How
> about tools for managing postgres ?
> Mike
>
>      
>     ----- Original Message -----
>     *From:* [hidden email] <mailto:[hidden email]>
>     *To:* OFBiz Users / Usage Discussion <mailto:[hidden email]>
>     *Sent:* Monday, October 31, 2005 3:23 PM
>     *Subject:* Re: [OFBiz] Users - MySQL
>
>
>     Mike
>
>     Wy dont you use postgres? Be sure to check the Relational Database
>     Section  on the the wiki
>
>     http://ofbizwiki1.go-integral.com/Wiki.jsp?page=OnlineAdministrationManual
>
>
>     Michael
>
>     [hidden email]
>     <mailto:[hidden email]> wrote on 31.10.2005 20:43:50:
>
>     > Let me know if this works.  (These were tested with MySQL 5.0)
>     >
>     >
>     http://sequoiaerp.org/index.php?option=com_content&task=view&id=37&Itemid=62
>     >
>     > michal wrote:
>     >
>     > > Hello Ofbiz users,
>     > >  
>     > > Iam new to ofbiz, just downloaded it about week ago. I tested
>     it on my
>     > > RHEL machine with demo data. It is working fine and Iam all
>     happy with
>     > > all the features and functionality. I want to move to next
>     step which
>     > > would be integrating ofbiz with mysql database. Can you guys
>     give me
>     > > some instructions on where I should start or maybe there are "How
>     > > to's" on this subject.
>     > > Thanks
>     > > Mike
>     > >
>     >
>     >------------------------------------------------------------------------
>     > >
>     > >
>     > >_______________________________________________
>     > >Users mailing list
>     > >[hidden email]
>     > >http://lists.ofbiz.org/mailman/listinfo/users
>     > >
>     >  
>     > _______________________________________________
>     > Users mailing list
>     > [hidden email]
>     > http://lists.ofbiz.org/mailman/listinfo/users
>
>     ------------------------------------------------------------------------
>
>     _______________________________________________
>     Users mailing list
>     [hidden email]
>     http://lists.ofbiz.org/mailman/listinfo/users
>
>------------------------------------------------------------------------
>
>
>_______________________________________________
>Users mailing list
>[hidden email]
>http://lists.ofbiz.org/mailman/listinfo/users
>
 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: [OFBiz] Users - MySQL

MPF-2
Michal,

> have never been working with postgres.

Give yourself time! You'll learn alot :-)

Regarding Tools:
There are some notes and script attachments of tools for postgres in the
ofbizwiki!
If you give postgres a shoot I would appreciate sharing your expieriences
especially tool-releated ones on the list.

I would really like to see the postgres section of the ofbitwiki to become
somthing like a standard operating procedure (SOP) for ofbiz on postgres.
SOPs can save the DBAs alot of time if they are not hardcore postgres
admins.

And since there are common ofbiz specific tasks the wiki is a perfect
place for that and the quality of that section will improve the acceptance
of ofbiz. Its not

Michael

Is the installation simpler then on Mysql ? How
> > about tools for managing postgres ?
[hidden email] wrote on 01.11.2005 19:57:38:

> It's always hard to answer a question about that.  I've worked with both

> and found that if you're used to one, you'll find the other odd.  After
> you get familiar with them, though, you'd find that they're about the
> same thing.
>
> One thing I would point out though--there are a lot more people on this
> list familiar with PostgreSQL than MySQL.  Not necessarily because MySQL

> is bad, but because PostgreSQL has been traditionally the preferred open

> source database for enterprise applications, whereas MySQL did not
> really support things like transactions and foreign keys for a long
time.

>
> michal wrote:
>
> > I was thinking about Mysql because I have experience with it and I
> > have never been working with postgres. I might give it a shoot to
> > learn something new. Is the installation simpler then on Mysql ? How
> > about tools for managing postgres ?
> > Mike
> >
> >
> >     ----- Original Message -----
> >     *From:* [hidden email] <mailto:[hidden email]>
> >     *To:* OFBiz Users / Usage Discussion
<mailto:[hidden email]>

> >     *Sent:* Monday, October 31, 2005 3:23 PM
> >     *Subject:* Re: [OFBiz] Users - MySQL
> >
> >
> >     Mike
> >
> >     Wy dont you use postgres? Be sure to check the Relational Database
> >     Section  on the the wiki
> >
> >     http://ofbizwiki1.go-integral.com/Wiki.jsp?
> page=OnlineAdministrationManual
> >
> >
> >     Michael
> >
> >     [hidden email]
> >     <mailto:[hidden email]> wrote on 31.10.2005
20:43:50:

> >
> >     > Let me know if this works.  (These were tested with MySQL 5.0)
> >     >
> >     >
> >     http://sequoiaerp.org/index.php?
> option=com_content&task=view&id=37&Itemid=62
> >     >
> >     > michal wrote:
> >     >
> >     > > Hello Ofbiz users,
> >     > >
> >     > > Iam new to ofbiz, just downloaded it about week ago. I tested
> >     it on my
> >     > > RHEL machine with demo data. It is working fine and Iam all
> >     happy with
> >     > > all the features and functionality. I want to move to next
> >     step which
> >     > > would be integrating ofbiz with mysql database. Can you guys
> >     give me
> >     > > some instructions on where I should start or maybe there are
"How

> >     > > to's" on this subject.
> >     > > Thanks
> >     > > Mike
> >     > >
> >     >
> >
>
>------------------------------------------------------------------------
> >     > >
> >     > >
> >     > >_______________________________________________
> >     > >Users mailing list
> >     > >[hidden email]
> >     > >http://lists.ofbiz.org/mailman/listinfo/users
> >     > >
> >     >
> >     > _______________________________________________
> >     > Users mailing list
> >     > [hidden email]
> >     > http://lists.ofbiz.org/mailman/listinfo/users
> >
> >
------------------------------------------------------------------------

> >
> >     _______________________________________________
> >     Users mailing list
> >     [hidden email]
> >     http://lists.ofbiz.org/mailman/listinfo/users
> >
>
>------------------------------------------------------------------------
> >
> >
> >_______________________________________________
> >Users mailing list
> >[hidden email]
> >http://lists.ofbiz.org/mailman/listinfo/users
> >
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users