Blog LDAP Schema

Discussion corner for Developers of Serendipity.
Post Reply
suretec
Regular
Posts: 15
Joined: Mon Nov 26, 2007 11:53 am
Location: Aberdeen, Scotland.
Contact:

Blog LDAP Schema

Post by suretec » Tue Dec 04, 2007 1:40 pm

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/52-OpenLDAP-Weekly-News-Issue-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.

User avatar
garvinhicking
Core Developer
Posts: 30014
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Blog LDAP Schema

Post by garvinhicking » Tue Dec 04, 2007 2:54 pm

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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/

suretec
Regular
Posts: 15
Joined: Mon Nov 26, 2007 11:53 am
Location: Aberdeen, Scotland.
Contact:

Re: Blog LDAP Schema

Post by suretec » Tue Dec 04, 2007 7:47 pm

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.

User avatar
garvinhicking
Core Developer
Posts: 30014
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Blog LDAP Schema

Post by garvinhicking » Tue Dec 04, 2007 10:06 pm

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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/

suretec
Regular
Posts: 15
Joined: Mon Nov 26, 2007 11:53 am
Location: Aberdeen, Scotland.
Contact:

Re: Blog LDAP Schema

Post by suretec » Tue Dec 04, 2007 10:12 pm

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.

User avatar
garvinhicking
Core Developer
Posts: 30014
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Blog LDAP Schema

Post by garvinhicking » Tue Dec 04, 2007 10:23 pm

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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/

suretec
Regular
Posts: 15
Joined: Mon Nov 26, 2007 11:53 am
Location: Aberdeen, Scotland.
Contact:

Re: Blog LDAP Schema

Post by suretec » Tue Dec 04, 2007 10:43 pm

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.

User avatar
garvinhicking
Core Developer
Posts: 30014
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Blog LDAP Schema

Post by garvinhicking » Tue Dec 04, 2007 11:23 pm

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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/

suretec
Regular
Posts: 15
Joined: Mon Nov 26, 2007 11:53 am
Location: Aberdeen, Scotland.
Contact:

Re: Blog LDAP Schema

Post by suretec » Tue Dec 04, 2007 11:35 pm

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.

User avatar
garvinhicking
Core Developer
Posts: 30014
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Blog LDAP Schema

Post by garvinhicking » Tue Dec 04, 2007 11:40 pm

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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/

suretec
Regular
Posts: 15
Joined: Mon Nov 26, 2007 11:53 am
Location: Aberdeen, Scotland.
Contact:

Re: Blog LDAP Schema

Post by suretec » Tue Dec 04, 2007 11:49 pm

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.

User avatar
garvinhicking
Core Developer
Posts: 30014
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Blog LDAP Schema

Post by garvinhicking » Wed Dec 05, 2007 2:32 pm

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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/

suretec
Regular
Posts: 15
Joined: Mon Nov 26, 2007 11:53 am
Location: Aberdeen, Scotland.
Contact:

Re: Blog LDAP Schema

Post by suretec » Wed Dec 05, 2007 2:48 pm

garvinhicking wrote: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


I'll reply at the post ;-)

suretec
Regular
Posts: 15
Joined: Mon Nov 26, 2007 11:53 am
Location: Aberdeen, Scotland.
Contact:

Re: Blog LDAP Schema

Post by suretec » Wed Dec 05, 2007 7:37 pm

garvinhicking wrote: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


See comments.

Post Reply