Page 1 of 1
Blog LDAP Schema
Posted: Tue Dec 04, 2007 12:40 pm
by suretec
Hi All,
I'm part of the OpenLDAP project and use s9y for our company blog (
The Suretec Blog).
As you can probably guess, I love LDAP, and I would like to work on an RFC for a Blog LDAP Schema.
See
http://blog.suretecsystems.com/archives ... sue-6.html
I'd like to discuss what would be generic and modern attributes to work on, then speak to folks like Wordpress/SixApart etc. to work towards a stardard and then submit an RFC.
Off the top of my head, things like:
- title
entry
tags
categories
rss feeds
comments
If anyone is interested, please reply
Thanks,
Gavin.
Re: Blog LDAP Schema
Posted: Tue Dec 04, 2007 1:54 pm
by garvinhicking
Hi!
I'm not exactly sure if I understood you correctly. You want to store the blog contents inside a LDAP container?
If that's the case, I highly think this is impossible, because you cannot perform the extensive SQL joins which are needed for s9y's or wordpress' flexibility in LDAP space, I'd think?
Regards,
Garvin
Re: Blog LDAP Schema
Posted: Tue Dec 04, 2007 6:47 pm
by suretec
garvinhicking wrote:Hi!
I'm not exactly sure if I understood you correctly. You want to store the blog contents inside a LDAP container?
If that's the case, I highly think this is impossible, because you cannot perform the extensive SQL joins which are needed for s9y's or wordpress' flexibility in LDAP space, I'd think?
Regards,
Garvin
I'm thinking of a new configuration engine for posting and finding entries. Of course a directory server is not an RDBMS, but blog entires are highly suited for a directory server. Write once (or twice), very high reads.
Re: Blog LDAP Schema
Posted: Tue Dec 04, 2007 9:06 pm
by garvinhicking
Hi!
I think you'd have to built serendipity from scratch to support that. I also highly doubt you could push WP into that direction.
You should create a new blog engine for that specific goal, IMHO. It's much more hassle to integrate a fake RDBMS on LDAP-scope than to build a fresh one with a very reduced feature set.
If you refer to a blog system as only posting and reading entries, that can be done with LDAP. But s9y is much more, it's a complex CMS-like architecture with high SQL and relation interaction that IMHO cannot be done with LDAP.
Best regards,
Garvin
Re: Blog LDAP Schema
Posted: Tue Dec 04, 2007 9:12 pm
by suretec
garvinhicking wrote:Hi!
I think you'd have to built serendipity from scratch to support that. I also highly doubt you could push WP into that direction.
You should create a new blog engine for that specific goal, IMHO. It's much more hassle to integrate a fake RDBMS on LDAP-scope than to build a fresh one with a very reduced feature set.
If you refer to a blog system as only posting and reading entries, that can be done with LDAP. But s9y is much more, it's a complex CMS-like architecture with high SQL and relation interaction that IMHO cannot be done with LDAP.
Best regards,
Garvin
I know s9y is much more than that, but there is nothing wrong about moving entires out of the db.
Re: Blog LDAP Schema
Posted: Tue Dec 04, 2007 9:23 pm
by garvinhicking
Hi!
But entries are joined with variable entryproperties, possible freetag DB tables, other statistical karma things. Entries can be fetched depedning on read/write privileges of the categories, and thus are joined with user and category tables.
I imagine you are thinking on the very basic blog level. Serendipity is much more than "title + body".
Regards,
Garvin
Re: Blog LDAP Schema
Posted: Tue Dec 04, 2007 9:43 pm
by suretec
garvinhicking wrote:Hi!
But entries are joined with variable entryproperties, possible freetag DB tables, other statistical karma things. Entries can be fetched depedning on read/write privileges of the categories, and thus are joined with user and category tables.
I imagine you are thinking on the very basic blog level. Serendipity is much more than "title + body".
Regards,
Garvin
Not at all

That's why collaboration was requested.
A blog entry is a DN. Attached to that DN can be the body, extended body, freeTag attributes. A new plugin might come with new custom Schema definitions for new attributes, but they wouldn't be part of an RFC.
Privileges are LDAP ACLs, and catagoies are LDAP groups.
Comments can be children of the entry. Eveerything is tied to 1 entry, and that can be a member of any group.
It just a case of defining what would be generic requirements;
Tags
Cataegries
Trackbacks
etc.
Re: Blog LDAP Schema
Posted: Tue Dec 04, 2007 10:23 pm
by garvinhicking
Hi!
I still think that you'd need to rewrite all of Serendipity's database queries and all plugins that execute those - so I think creating a new blog engine to support that in a clear way would be much better.
Sadly I don't "do" LDAP, so I suppose I'm not really well equipped to help with an RFC for such a project.
Best regards,
Garvin
Re: Blog LDAP Schema
Posted: Tue Dec 04, 2007 10:35 pm
by suretec
garvinhicking wrote:Hi!
I still think that you'd need to rewrite all of Serendipity's database queries and all plugins that execute those - so I think creating a new blog engine to support that in a clear way would be much better.
Sadly I don't "do" LDAP, so I suppose I'm not really well equipped to help with an RFC for such a project.
Best regards,
Garvin
Yeah, looks like that's the way. Thanks for your input though.
Gavin.
Re: Blog LDAP Schema
Posted: Tue Dec 04, 2007 10:40 pm
by garvinhicking
Hi!
If you make progress in the RFC though, maybe I can give you some feedback or input from the views of a RDBMS-blog developer's sight? There might at least be some help in that.
Regards,
Garvin
Re: Blog LDAP Schema
Posted: Tue Dec 04, 2007 10:49 pm
by suretec
garvinhicking wrote:Hi!
If you make progress in the RFC though, maybe I can give you some feedback or input from the views of a RDBMS-blog developer's sight? There might at least be some help in that.
Regards,
Garvin
Well, since this is m favourite Blog software and I can code, maybe I'll invest some time to learn s9y internals and break it
I will post progress here.
Re: Blog LDAP Schema
Posted: Wed Dec 05, 2007 1:32 pm
by garvinhicking
Hi!
Kristian Köhntopp has taken some thoughts about this here:
http://mysqldump.azundris.com/archives/ ... ional.html
I don't get most of it, but it sure sounds sophisticated
Regards,
Garvin
Re: Blog LDAP Schema
Posted: Wed Dec 05, 2007 1:48 pm
by suretec
I'll reply at the post

Re: Blog LDAP Schema
Posted: Wed Dec 05, 2007 6:37 pm
by suretec