ZDatabaseTool - does this still exist?
Hi Does anyone know if this still exists? I'd like to have an easier way to manage the Zope database. The page at http://www.zope.org/Members/aeg/ZDatabaseTool doesn't provide any downloads. Are there any other database manager tools for the ZODB? like the one that mySQL has over the web. Thanks
michael nt milne wrote at 2005-8-8 17:49 +0100:
... Are there any other database manager tools for the ZODB?
To do what? There is a "Database Manager" in the "Control_Panel" -- but (of course), the ZODB is very easy to manage. That's why the "Manager" is so simple... -- Dieter
I'm looking for a phpmyadmin type tool for managing the ZODB.The control panel view in zope doesn't let you do anything apart from the basics. Obviously I could use python to access the db but looking for something easier. On 8/10/05, Dieter Maurer <dieter@handshake.de> wrote:
michael nt milne wrote at 2005-8-8 17:49 +0100:
... Are there any other database manager tools for the ZODB?
To do what?
There is a "Database Manager" in the "Control_Panel" -- but (of course), the ZODB is very easy to manage. That's why the "Manager" is so simple...
-- Dieter
On 11 Aug 2005, at 10:31, michael nt milne wrote:
I'm looking for a phpmyadmin type tool for managing the ZODB.The control panel view in zope doesn't let you do anything apart from the basics. Obviously I could use python to access the db but looking for something easier.
What exactly do you want to do that "zope doesn't let you do"? The ZODB is not a relational database, in case that isn't already clear. You cannot compare the tasks you can do using tools like phpmyadmin with tasks that make sense for the ZODB. jens
Hi I've already made it clear in this thread exactly what I want to do! It doesn't to be a relational db to be able to easily add fields.The database browser tools in the ZMI are ok but basic. On 8/11/05, Jens Vagelpohl <jens@dataflake.org> wrote:
On 11 Aug 2005, at 10:31, michael nt milne wrote:
I'm looking for a phpmyadmin type tool for managing the ZODB.The control panel view in zope doesn't let you do anything apart from the basics. Obviously I could use python to access the db but looking for something easier.
What exactly do you want to do that "zope doesn't let you do"?
The ZODB is not a relational database, in case that isn't already clear. You cannot compare the tasks you can do using tools like phpmyadmin with tasks that make sense for the ZODB.
jens
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
On 11 Aug 2005, at 15:01, michael nt milne wrote:
Hi I've already made it clear in this thread exactly what I want to do! It doesn't to be a relational db to be able to easily add fields.The database browser tools in the ZMI are ok but basic.
No you haven't. First of all, the application you point to at the beginning of the thread is a tool for managing a relational database, but your wording sounds like you assume it is a tool for managing the ZODB. That tool has exactly zilch to do with the ZODB, apart from the fact that it runs on Zope. The ZODB is not a relational database. You don't "add fields". You add objects and manipulate them. The ZMI and code you write are all you need. jens
Whether you call them objects or fields it's still clear what I want to do and there's no easy way to do it. Surprised someone hasn't developed a product tn do this. I'm looking at CMFMember and perhaps it will fit the bill. On 8/11/05, Jens Vagelpohl <jens@dataflake.org> wrote:
On 11 Aug 2005, at 15:01, michael nt milne wrote:
Hi I've already made it clear in this thread exactly what I want to do! It doesn't to be a relational db to be able to easily add fields.The database browser tools in the ZMI are ok but basic.
No you haven't. First of all, the application you point to at the beginning of the thread is a tool for managing a relational database, but your wording sounds like you assume it is a tool for managing the ZODB. That tool has exactly zilch to do with the ZODB, apart from the fact that it runs on Zope.
The ZODB is not a relational database. You don't "add fields". You add objects and manipulate them. The ZMI and code you write are all you need.
jens
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
On 11 Aug 2005, at 15:15, michael nt milne wrote:
Whether you call them objects or fields it's still clear what I want to do and there's no easy way to do it. Surprised someone hasn't developed a product tn do this. I'm looking at CMFMember and perhaps it will fit the bill.
Maybe I'm too dense, but "fields" are not "objects". If you expect help from a group you should try to utilize a terminology the group shares. And if your description cannot be understood you will get blank stares, if anything. jens
Hi Michael, michael nt milne wrote:
Whether you call them objects or fields it's still clear what I want to do and there's no easy way to do it. Surprised someone hasn't developed a product tn do this. I'm looking at CMFMember and perhaps it will fit the bill.
There are a bunch of things to say here - first of all, it may be clear to /you/, but it's not clear to /us/! You do need to respect the fact that others may use different terms (or consider different things implicit), to communicate usefully. I've become frustrated myself whilst getting to grips (to the extent that I have!) with these tools, but it doesn't help...what helps is chipping away at it with a positive attitude until you arrive at some common ground. Now you mention CMFMember, it seems that you want to add "fields" (attributes?) to the Member "record" (object?). If you think of the ZODB as a database, and Zope as an application server, you are now getting into the specifics of an /application/ (CMF/Plone), and in that context your needs are perhaps more complex than you think: You need to store your data, yes, but you also need to integrate the capture and updating of that data into an existing application. So you are not really asking for a database management tool but a product which does that and more besides - which goes to show that the terminology /is/ important! -- Regards, PhilK Email: phil@xfr.co.uk PGP Public key: http://www.xfr.co.uk Voicemail & Facsimile: 07092 070518 "You'll find that one part's sweet and one part's tart: say where the sweetness and the sourness start." - Tony Harrison
Hi Michael, michael nt milne wrote:
I've already made it clear in this thread exactly what I want to do! It doesn't to be a relational db to be able to easily add fields.The database browser tools in the ZMI are ok but basic.
I'm as puzzled as other readers, but now you have said "add fields", I'm even more puzzled! What do you want to add fields to? Do you mean to add properties to an object? What sort of object? If so, arguably the whole ZMI is your database tool, and the "database tools" elements are just some maintenance utilities... N.B. Am not trying to needle you - am trying to get some traction on your problem! :-) -- Regards, PhilK Email: phil@xfr.co.uk PGP Public key: http://www.xfr.co.uk Voicemail & Facsimile: 07092 070518 "You'll find that one part's sweet and one part's tart: say where the sweetness and the sourness start." - Tony Harrison
michael nt milne wrote at 2005-8-11 10:01 -0400:
It doesn't to be a relational db to be able to easily add fields
There are no tables to add fields to. As someone else already pointed out: Zope objects often use so called properties as "field" emulation. Unlike for a relational database where you specify the fields of a table (and all rows inherit these fields), properties are on individual objects (which are somehow like rows). Zope has a feature where you can define properties not for individual objects but for whole collections of them: "ZClass"es. Adding properties to a property sheet of a ZClass ensures that all instances of the class have these properties (with the default value defined by the class). -- Dieter
Thanks for the help here. Yes I do want to capture extra information about a user who is registering with a site. First name, last name and company, phone number etc. And then to be able to to display this in a membership display tool. Just about to check out CMFMember. Hope it works ok on 2.05. On 8/11/05, Dieter Maurer <dieter@handshake.de> wrote:
michael nt milne wrote at 2005-8-11 10:01 -0400:
It doesn't to be a relational db to be able to easily add fields
There are no tables to add fields to.
As someone else already pointed out:
Zope objects often use so called properties as "field" emulation.
Unlike for a relational database where you specify the fields of a table (and all rows inherit these fields), properties are on individual objects (which are somehow like rows).
Zope has a feature where you can define properties not for individual objects but for whole collections of them: "ZClass"es. Adding properties to a property sheet of a ZClass ensures that all instances of the class have these properties (with the default value defined by the class).
-- Dieter
PS I also subscribed to the collective-CMFMember list and got some help there: which I include below....... Alec Mitchell <apm13@columbia.edu> to collective-cmf. More options 3:39 pm (6 hours ago) On Thursday 11 August 2005 06:19 am, michael nt milne wrote:
I've tried a few products in 2.1 -CMFQuestionnaire for example and it produced errors.Also CMFNewsletter didn't work.
I'd rather wait until the bugs are ironed out.
These are probably not bugs in CMFPlone, but simply products which haven't caught up to the few major changes in 2.1. Unfortunately, they are very unlikely to catch up if you don't report the errors you found with full tracebacks to the authors of those products. It may be helpful to additionally post them to the plone bug tracker as it may point out incompatibilities of which we were unaware.
Can CMFMember add totally new fields to registration? What v of plone do you have it working with?
CMFMember 1.0 was designed for plone 2.0, and should work. It will allow you to add new fields to the registration by subclassing the Member type and adding new fields to the schema. For greater details you may want to look at Rob's Samplex product and tutorial: http://svn.plone.org/view/collective/Samplex/trunk/docs/SamplexTutorial.stx CMFMember 1.1 (currently unreleased) is the ideal version for working with plone 2.1 (which as Martin says is much improved), but may not at present work with plone 2.0. On 8/11/05, michael nt milne <michael.milne@gmail.com> wrote:
Thanks for the help here. Yes I do want to capture extra information about a user who is registering with a site. First name, last name and company, phone number etc. And then to be able to to display this in a membership display tool. Just about to check out CMFMember. Hope it works ok on 2.05.
On 8/11/05, Dieter Maurer <dieter@handshake.de> wrote:
michael nt milne wrote at 2005-8-11 10:01 -0400:
It doesn't to be a relational db to be able to easily add fields
There are no tables to add fields to.
As someone else already pointed out:
Zope objects often use so called properties as "field" emulation.
Unlike for a relational database where you specify the fields of a table (and all rows inherit these fields), properties are on individual objects (which are somehow like rows).
Zope has a feature where you can define properties not for individual objects but for whole collections of them: "ZClass"es. Adding properties to a property sheet of a ZClass ensures that all instances of the class have these properties (with the default value defined by the class).
-- Dieter
--On 11. August 2005 20:30:37 +0200 Dieter Maurer <dieter@handshake.de> wrote:
Zope has a feature where you can define properties not for individual objects but for whole collections of them: "ZClass"es. Adding properties to a property sheet of a ZClass ensures that all instances of the class have these properties (with the default value defined by the class).
But don't consider using ZClasses in any way...they are an ancient culprit of Zope. DON'T USE. -aj
michael nt milne wrote at 2005-8-11 05:31 -0400:
I'm looking for a phpmyadmin type tool for managing the ZODB.The control panel view in zope doesn't let you do anything apart from the basics. Obviously I could use python to access the db but looking for something easier.
Then again my question: what non basic management tasks do you want to do with the ZODB? Keep in mind, that the ZODB is not a relational database system but an object oriented one. Its model is much more general as relations of elementary fields. Therefore, it is much more difficult to standardize management. -- Dieter
participants (5)
-
Andreas Jung -
Dieter Maurer -
Jens Vagelpohl -
michael nt milne -
Philip Kilner