Blog LDAP Schema

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

Blog LDAP Schema

Post 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.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Blog LDAP Schema

Post 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
# 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 10:53 am
Location: Aberdeen, Scotland.
Contact:

Re: Blog LDAP Schema

Post 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.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Blog LDAP Schema

Post 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
# 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 10:53 am
Location: Aberdeen, Scotland.
Contact:

Re: Blog LDAP Schema

Post 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.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Blog LDAP Schema

Post 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
# 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 10:53 am
Location: Aberdeen, Scotland.
Contact:

Re: Blog LDAP Schema

Post 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.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Blog LDAP Schema

Post 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
# 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 10:53 am
Location: Aberdeen, Scotland.
Contact:

Re: Blog LDAP Schema

Post 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.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Blog LDAP Schema

Post 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
# 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 10:53 am
Location: Aberdeen, Scotland.
Contact:

Re: Blog LDAP Schema

Post 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.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Blog LDAP Schema

Post 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
# 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 10:53 am
Location: Aberdeen, Scotland.
Contact:

Re: Blog LDAP Schema

Post by suretec »

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 10:53 am
Location: Aberdeen, Scotland.
Contact:

Re: Blog LDAP Schema

Post by suretec »

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