Re: xnote links

Hello hello

Markus Hoenicka wrote:

> The current svn version appears to
> work ok with the data and the procedure that you described.

Thanks Markus, cool - I can't get svn to work across my network and I'm 
a bit lazy so I'll wait for the next pre-release. No rush.

> 
>  > Incidentally, what are the chances of getting note-note links working so 
> 
> (afait it boils down to allowing an additional type string in one of
> the fields).

I think I know what you mean - you'd allow presumably a NOTE string in 
the xnote_type field of the t_xnote table. Though I think that would 
only allow for unidirectional links unless you were happy to let your 
backend try to keep two links updated (I believe this is sort of frowned 
upon in the relational DB world) or to search two indices, note_id and 
xref_id for a particular note_id (maybe okay but seems clumsy).

I could handle non-directional links outside of RefDB by automatically 
generating dummy references to group notes with but it's kind of messy, 
particularly as there's no real reason to group notes in groups bigger 
than 2 (since you could then group notes by linking them all to another, 
group note, anyway).

On the other hand, while non-directional links would be nice, 
unidirectional links would be just fine as far as I'm concerned. It 
would be up to the DB user to specify if he/she wanted a link going both 
ways.

As far as a GUI tree view on the data is concerned, well it may recurse 
sometimes, but that's just a consequence of choosing a tree to view a 
potentially cyclic directed (or undirected) graph.

Feel free to talk me out of it!

Peace
Damien

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV