mySQL Integration with Plone

[kesteban]

Hi guys,

I am in the process of creating a parts database using mySQL and I would like to use Plone as my html/frontend client. I was wondering if there is a solution to querying/editing mySQL tables within plone? Would Plone be a good choice to display these queries or should I use a different solution? Thanks again in advanced!

[ajung]

Why do you want use Plone?  Plone is a CMS and not a web-frontend for relational databases in the first place. Please describe your usecase in detail.

-aj

kesteban wrote:

Hi guys,

I am in the process of creating a parts database using mySQL and I would like to use Plone as my html/frontend client. I was wondering if there is a solution to querying/editing mySQL tables within plone? Would Plone be a good choice to display these queries or should I use a different solution? Thanks again in advanced!

[Derek Broughton-3]

ajung wrote:

>
> Why do you want use Plone?  Plone is a CMS and not a web-frontend for
> relational databases in the first place. Please describe your usecase in
> detail.
>

Humbug.  Plone can be a very useful front-end to relational databases, and I
don't imagine you yourself would have put so much effort into the interfaces
if you didn't think so.
--
derek


------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Plone-Users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/plone-users

[ajung]

Nonsene.

Choose the right tool for the right purpose.  You don't need Plone with a stack of more than 100 packages under hood for building a web frontend for databases if this is the single purpose. We have more light-weight web-framework for bringing a database into the web.

-aj

Derek Broughton-3 wrote:

ajung wrote:



Humbug.  Plone can be a very useful front-end to relational databases, and I
don't imagine you yourself would have put so much effort into the interfaces
if you didn't think so.

[Derek Broughton-3]

ajung wrote:

>
> Nonsene.

You are _soo_ polite.
>
> Choose the right tool for the right purpose.  You don't need Plone with a
> stack of more than 100 packages under hood for building a web frontend for
> databases if this is the single purpose.

Of course you don't.  otoh, we have a content management system, and we also
want to show lots of data from relational databases.  It just makes sense to
provide an interface inside Plone.  It must make sense to far more than me,
as so many packages (yours included) exist to do this.

Perhaps it doesn't make sense for the OP's particular case, but when you
already have your users using Plone, it _does_ often make sense to avail
yourself of its infrastructure for content outside the ZODB.
--
derek


------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Plone-Users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/plone-users

[Rakotomandimby Mihamina-3]

10/30/2009 06:18 PM, Derek Broughton:
>> Nonsene.
> You are _soo_ polite.

That's the way Andreas is.

>> Choose the right tool for the right purpose.  You don't need Plone with a
>> stack of more than 100 packages under hood for building a web frontend for
>> databases if this is the single purpose.
> Of course you don't.  otoh, we have a content management system, and we also
> want to show lots of data from relational databases.

Well, the database entries are the content.
That could be OK to manipulate it through Plone.

--
       Architecte Informatique chez Blueline/Gulfsat:
    Administration Systeme, Recherche & Developpement
                                    [phone]

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Plone-Users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/plone-users

[ajung]

Rakotomandimby Mihamina-3 wrote:

10/30/2009 06:18 PM, Derek Broughton:
>> Nonsene.
> You are _soo_ polite.

That's the way Andreas is.

Perhaps you should re-read the thread and figure out who
shouted out "humbug" first? Not me :-)

Rakotomandimby Mihamina-3 wrote:

>> Choose the right tool for the right purpose.  You don't need Plone with a
>> stack of more than 100 packages under hood for building a web frontend for
>> databases if this is the single purpose.
> Of course you don't.  otoh, we have a content management system, and we also
> want to show lots of data from relational databases.

Well, the database entries are the content.
That could be OK to manipulate it through Plone.

There is no suitable solution for treating existing external database as primary content in Plone (comparable to AT-based content). If you have a suitable solution, please come up with it
(don't come up SQLStorage or collective.tin).

Repeating myself like an idiot for the third time: there are smaller, easier and faster frameworks building a front-end for an existing relation database than Plone. If Plone is your only recommendation then I am sorry that your personal  toolbox is so limited :-)

-aj
 

[Derek Broughton-3]

ajung wrote:

>> Well, the database entries are the content.
>> That could be OK to manipulate it through Plone.

> There is no suitable solution for treating existing external database as
> primary content in Plone (comparable to AT-based content). If you have a
> suitable solution, please come up with it
> (don't come up SQLStorage or collective.tin).
>
> Repeating myself like an idiot for the third time: there are smaller,
> easier and faster frameworks building a front-end for an existing relation
> database than Plone. If Plone is your only recommendation then I am sorry
> that your personal  toolbox is so limited :-)

Only you have ever suggested this.  All I said was that Plone can make an
excellent front-end for a SQL database when you're already using Plone.  
Martin Aspeli has written a marvellous book around a Plone implementation
that does so. If you think doing so is so pointless, why have you put so
much effort into SQL tools?  

Generally speaking, it doesn't make much sense to require your users to log
into multiple different systems, with wildly different user interfaces, if
you don't have to.  If they're using Plone now, it _may_ make sense to
implement a front-end to a SQL database.  Maybe it won't, but you dismiss it
without consideration.

As for treating an external database as "primary content", I rather doubt
anybody was suggesting so (though I do have an implementation using
collective.tin quite successfully for exactly that, I agree that it's far
from ideal).
--
derek


------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Plone-Users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/plone-users

[ajung]

ajung wrote:



Only you have ever suggested this.  All I said was that Plone can make an
excellent front-end for a SQL database when you're already using Plone.  
Martin Aspeli has written a marvellous book around a Plone implementation
that does so. If you think doing so is so pointless, why have you put so
much effort into SQL tools?  


What has an integration layer like z3c.sqlalchemy or SQLAlchemyDA to do with the issue?
Those developments where driven by non-Plone projects. Of course you can integrate external database into Plone but not as primary content - there is no issue to discuss about but I strongly argue against advices for (mis-)using Plone as a framework for that is has not been designed for. I have seen enough of such mis-uses while doing consulting work over the last year.

Here my favorite examples: customer mis-used Plone as a front-end for enterprise-critical task. Peak performance: 2-3 requests/second (was Plone 2.5)..so how to scale such an app with Plone with some hundred users? Throwing more hardware into the setup...possible...our solution: throw away Plone and re-implemented the solution on top of CMF giving you ten-times better performance without new hardware.  With even smaller frameworks you will
get an ootb-performance of several hundred requests (when your DB backend is fast enough).

Derek Broughton-3 wrote:

Generally speaking, it doesn't make much sense to require your users to log
into multiple different systems, with wildly different user interfaces, if
you don't have to.  If they're using Plone now, it _may_ make sense to
implement a front-end to a SQL database.  Maybe it won't, but you dismiss it
without consideration.

See above. We must not recommend Plone as a framework for all and everything. Plone is a CMS application in the first place that can be bended for some usecases but we must not promote it as a general web-application platform.

Derek Broughton-3 wrote:

As for treating an external database as "primary content", I rather doubt
anybody was suggesting so (though I do have an implementation using
collective.tin quite successfully for exactly that, I agree that it's far
from ideal).

For my experience there is no suitable way for storing Plone content within a RDBMS
except using Relstorage with is a different thing compared to SQLStorage and collective.tin.
SQLStorage and the AT storage layer is broken-by-design and not usable for real-world
deployments. collective.tin is much cleaner but also more a workaround  solution (and it introduces some more unwanted complexity).

Frameworks like Django, Turbogears or repoze.bfg are the better choices the DB-only apps where content-management in the sense of Plone is not the primary focus of your app.

-aj