[Therion] Database use

Martin Sluka martinsluka at mac.com
Mon Jan 10 19:10:07 CET 2011


Nice work, Andrew. Please, add the units (I know you think in feets) :)

m.


On 10.1.2011, at 17:59, Andrew Atkinson wrote:

> Hello
>
> Well Bruce you spurred me into action, and I have produced some web  
> pages, that allow users to search the database.
>
> It can be a little slow, especially the passage height query. Even  
> the form is slow to load, and no indication is given that it is  
> working. Finding the heights are quite quick it is the checking to  
> see if they are underground that take the time, oh well probably can  
> be optimised, but someone better than me.
>
> It is set up so that more searches can be easily added.
>
> Known problems
>
> Passage height gives meaningless results if one or both of the  
> heights given are between the min and max.
> AJAX menu does not work on all browsers.
>
> Which brings me back to the where this all started, it would be more  
> user-friendly to do searches on passage names as people call them.  
> IE how long is 'Route 66' Currently to do this they would have to  
> know that 'Route 66' was made up of the second half of Diesel Duck  
> plus Onion and the first half of 'hall of time'. The first and last  
> of these is not searchable?
>
> Have a look at
>
> http://wotcc.org.uk/Cheddar/
>
> (the style is stolen from ubss.org.uk)
>
> If people think that it is useful, I'll add the code to the wiki,  
> you should be able to edit the config file and it should then drop  
> in to any site. Extra Searches can be added to the Searches  
> Directory, so it should be adaptable.
>
> Works with mySQL.
>
> Andrew
>
> _______________________________________________
> Therion mailing list
> Therion at speleo.sk
> http://mailman.speleo.sk/mailman/listinfo/therion




More information about the Therion mailing list