[geeklog-devtalk] Feature Req: Sub-topics, RDF limit

[Tony Bibbs]

Steve Sloan wrote:


>There are two features that I would love to have in GeekLog.  I'm prepared to

>implement them myself,

>


<grin> we like to hear that </grin>


>The best implementation I can think of would be to add a "parent topic" field

>for each topic in the DB.  When the articles from a particular topic are 

>displayed, all articles from all sub-topics would also be displayed.  The

>only

>downside to this is that I can think of no good way to handle a

>hierarchical

>SQL query.  At best, it would require N SELECTs to get all the topics that

>are

>N levels deep in the hierarchy.

>  

>

Actually, you should be able to grab all the topics in one query and 
then have some data structure you can organize them in for quick 
access.  Some of this depends on the UI a bit but I think you can do 
this in one query...which is preferred as we all know GL already taxes 
MySQL enough.  The parent ID is  no-brainer.


>The other feature, though minor, would be to add a field to portal blocks to

>limit the number of RSS headlines listed.  I added Fark to my collection of

>news blocks, but their RSS contains a bazillion entries, making the page 

>stretch out further than I'd like.  This would seem to be fairly easy to

>add.

>

>  

>

Code both ideas, feel free to submit a patch for each and we'd be more 
than happy to test it out.

Looking forward to seeing the code.

--Tony