UKBouldering.com

the shizzle => bouldering => Topic started by: EdGowSmith on April 11, 2020, 02:14:21 pm

Title: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 11, 2020, 02:14:21 pm
In these circumstances of being stuck at home with not much to do, I have built a website:
https://www.betadb.org/

The idea is to have a database of videos for boulder problems that allows you to find beta for any problem quickly. 
It currently works with YouTube, Vimeo, and Instagram videos, and the first two can be timestamped which means, for longer videos especially, it should save time in finding beta.
The site only covers problems in the UK currently.
There are some videos on there already but the usefulness hopefully comes in the ability for anyone to add videos.
It's pretty basic at the moment and there are still some things I want to implement but the bare-bones functionality is all working (I hope).
Any feedback would be much appreciated!



Title: Re: BetaDb - Website for finding videos of problems
Post by: Will Hunt on April 11, 2020, 02:37:47 pm
Good idea. Being able to catalogue Instagram posts is a great idea. So much beta out there and none of it searchable. Drives me mad.
I'll try and contribute.
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 11, 2020, 02:48:57 pm
Good idea. Being able to catalogue Instagram posts is a great idea. So much beta out there and none of it searchable. Drives me mad.
I'll try and contribute.

Thank you!
Yeah, being unable to search for Instagram videos was one of the big motivators for making this - sort of a black hole for beta...
Title: Re: BetaDb - Website for finding videos of problems
Post by: remus on April 11, 2020, 04:09:35 pm
Ace! Friggin love it! The search is refreshingly well done (compared to UKC, peakbouldering etc.)

One small suggestion, when you search I thought that the problems list was a bit sparse at first but didnt realise things only show up if they have a video. Might make sense to include all problems in the list and add number of videos for that problem in to the text so you can see if it's worth clicking.
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 11, 2020, 04:28:46 pm
Ace! Friggin love it! The search is refreshingly well done (compared to UKC, peakbouldering etc.)

One small suggestion, when you search I thought that the problems list was a bit sparse at first but didnt realise things only show up if they have a video. Might make sense to include all problems in the list and add number of videos for that problem in to the text so you can see if it's worth clicking.

Thanks!
Yeah this does need changing, I realised the search is unintuitive but couldn't think of a better alternative.
I think maybe splitting the search results into two could work? Having one category for problems with videos, and another for problems without? Will have a think.
Title: Re: BetaDb - Website for finding videos of problems
Post by: macca7 on April 11, 2020, 06:24:53 pm
 :agree: superb i have registered and started to add a few links.

The new split search is clean and very easy to use

Good effort look forward to it growing

Cheers macca
Title: Re: BetaDb - Website for finding videos of problems
Post by: shark on April 11, 2020, 08:53:51 pm
Anyway you can link ukb beta threads Ed?
Title: Re: BetaDb - Website for finding videos of problems
Post by: kingholmesy on April 11, 2020, 10:38:31 pm
Cool idea.  Is there any way you can lookup a crag, then browse through to see which problems have got videos?
Title: Re: BetaDb - Website for finding videos of problems
Post by: Will Hunt on April 11, 2020, 10:40:59 pm
I've uploaded all my various Instagram, Vimeo and Youtube. I'll do my best to add more of other people's as I come across them. Very easy to do and this will be so worthwhile if people contribute.
Waddage.

Where does the list of problems come from? I found it had some really obscure stuff in it but some stuff (not very much) was missing. Couldn't figure out a pattern. The Gemenid Trail on the Satellite Boulder was probably the most significant thing.
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 11, 2020, 10:59:28 pm
Anyway you can link ukb beta threads Ed?

Yeah could do! Got some other things I want to sort out first though.

Cool idea.  Is there any way you can lookup a crag, then browse through to see which problems have got videos?

Thanks. Not currently but I will do this at some point.

I've uploaded all my various Instagram, Vimeo and Youtube. I'll do my best to add more of other people's as I come across them. Very easy to do and this will be so worthwhile if people contribute.
Waddage.

 I found it had some really obscure stuff in it but some stuff (not very much) was missing. Couldn't figure out a pattern. The Gemenid Trail on the Satellite Boulder was probably the most significant thing.

Great!
I just looked up The Geminid Trail, seems to be on there?
If you tell me what other problems are missing I'll look into it.
Title: Re: BetaDb - Website for finding videos of problems
Post by: Will Hunt on April 11, 2020, 11:04:08 pm
I just looked up The Geminid Trail, seems to be on there?

I was spelling it wrong  :slap:

Just went to add my vid and got this error message. No idea why.
"There was an error with the problems, please ensure you delete any blank entries"
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 11, 2020, 11:08:19 pm
I just looked up The Geminid Trail, seems to be on there?

I was spelling it wrong  :slap:

Just went to add my vid and got this error message. No idea why.
"There was an error with the problems, please ensure you delete any blank entries"

Okay ha, I think there will undoubtedly be some things missing.
Um not sure on that error, it doesn't like it when there are additional blank entries, is it throwing this error with just 1 problem?
Title: Re: BetaDb - Website for finding videos of problems
Post by: UnkArl on April 11, 2020, 11:11:56 pm
WOW! This is SO good. Well done that man!
Title: Re: BetaDb - Website for finding videos of problems
Post by: Will Hunt on April 11, 2020, 11:14:20 pm
I just looked up The Geminid Trail, seems to be on there?

I was spelling it wrong  :slap:

Just went to add my vid and got this error message. No idea why.
"There was an error with the problems, please ensure you delete any blank entries"

Okay ha, I think there will undoubtedly be some things missing.
Um not sure on that error, it doesn't like it when there are additional blank entries, is it throwing this error with just 1 problem?

Yeah. This Instagram link:
https://www.instagram.com/p/BocVhlwjHrG/
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 11, 2020, 11:15:18 pm
I just looked up The Geminid Trail, seems to be on there?

I was spelling it wrong  :slap:

Just went to add my vid and got this error message. No idea why.
"There was an error with the problems, please ensure you delete any blank entries"

Okay ha, I think there will undoubtedly be some things missing.
Um not sure on that error, it doesn't like it when there are additional blank entries, is it throwing this error with just 1 problem?

Yeah. This Instagram link:
https://www.instagram.com/p/BocVhlwjHrG/

I can't access this link, so maybe it's a private account? In which case it won't like it.
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 11, 2020, 11:21:29 pm
I just looked up The Geminid Trail, seems to be on there?

I was spelling it wrong  :slap:

Just went to add my vid and got this error message. No idea why.
"There was an error with the problems, please ensure you delete any blank entries"

Okay ha, I think there will undoubtedly be some things missing.
Um not sure on that error, it doesn't like it when there are additional blank entries, is it throwing this error with just 1 problem?

Yeah. This Instagram link:
https://www.instagram.com/p/BocVhlwjHrG/

I can't access this link, so maybe it's a private account? In which case it won't like it.

Actually on second thought it shouldn't matter, not sure what's going on there.
Title: Re: BetaDb - Website for finding videos of problems
Post by: Yoof on April 11, 2020, 11:39:57 pm
Brilliant idea Ed, good job!

A nested site structure based on geography would be great, maybe taking county and crag level data so crags and areas are easily navigable

Psyched on this
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 11, 2020, 11:45:36 pm
Brilliant idea Ed, good job!

A nested site structure based on geography would be great, maybe taking county and crag level data, again from UKC, so crags and areas are easily navigable

Psyched on this

Thank you!

I do want to implement something like this, just wasn't my priority for version 1.0. The crags are already on there so navigation by crag will be easy to make happen. Maybe can then split by England, Wales, Scotland, Northern Ireland?
Title: Re: BetaDb - Website for finding videos of problems
Post by: haydn jones on April 11, 2020, 11:49:46 pm
I can't access the Instagram link either. I also couldn't access the Instagram link Will linked to in the covid thread so maybe there's something off with how will's linking them?
Title: Re: BetaDb - Website for finding videos of problems
Post by: Will Hunt on April 12, 2020, 12:01:51 am
Oops. That was meant to be a Twitter link but the Instagram thing was still on my clipboard. Think I'd better go to bed.
Title: Re: BetaDb - Website for finding videos of problems
Post by: old cheese on April 12, 2020, 08:52:16 am
This does look like a great idea. Personally not sure why you would need to browse by crag but it might look better. Just being able to type in what you want and it’s there is great.

I too noticed some obscurities where there and lesser obscurities were not. Stanton in the woods seems to be missing for example
Title: Re: BetaDb - Website for finding videos of problems
Post by: BenF on April 12, 2020, 10:12:21 am
This is brilliant. In concept, creation and then the effort from people to add videos. Thanks.
Title: Re: BetaDb - Website for finding videos of problems
Post by: JamieG on April 12, 2020, 10:15:17 am
I really like this. Fantastic work.

Noticed one small bug (maybe) when searching for Fish Arete just to try it out. It only appeared in the search after I added a space after 'Fish', is that because it only displays the top so many results. Just confused me a little at first, but maybe that is the only way it could work.
Title: Re: BetaDb - Website for finding videos of problems
Post by: shark on April 12, 2020, 10:34:30 am
Just tested it. Worked really well when a problem is on the list but there isn’t the capability to add a problem that isn’t (doesn’t include Bens Roof for example)
Title: Re: BetaDb - Website for finding videos of problems
Post by: Duma on April 12, 2020, 10:35:55 am
Needs the apostrophe to get Ben's roof
Title: Re: BetaDb - Website for finding videos of problems
Post by: Duma on April 12, 2020, 10:37:37 am
Though would be really handy if punctuation could somehow be ignored in the search?
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 12, 2020, 10:44:29 am
Though would be really handy if punctuation could somehow be ignored in the search?

Yeah can sort this out.

This does look like a great idea. Personally not sure why you would need to browse by crag but it might look better. Just being able to type in what you want and it’s there is great.

I too noticed some obscurities where there and lesser obscurities were not. Stanton in the woods seems to be missing for example

I've just added the missing Stanton in the Woods climbs.
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 12, 2020, 10:46:03 am
I really like this. Fantastic work.

Noticed one small bug (maybe) when searching for Fish Arete just to try it out. It only appeared in the search after I added a space after 'Fish', is that because it only displays the top so many results. Just confused me a little at first, but maybe that is the only way it could work.

Cheers. Yeah it only displays the top 5 results, will try and make this more obvious.
Title: Re: BetaDb - Website for finding videos of problems
Post by: kingholmesy on April 12, 2020, 11:39:02 am

Personally not sure why you would need to browse by crag but it might look better. Just being able to type in what you want and it’s there is great.

Living in the South West and climbing in esoteric areas most stuff doesn’t have videos.  It’s a bit tiresome searching one problem after another, only for each of them to come up as having no video.

It would be great if you could click on a crag, then scan down the list of problems to see which do and do not have videos - would save loads of time and (for me at least) mean that I am much more likely to use the site.
Title: Re: BetaDb - Website for finding videos of problems
Post by: old cheese on April 12, 2020, 12:15:10 pm

Personally not sure why you would need to browse by crag but it might look better. Just being able to type in what you want and it’s there is great.

Living in the South West and climbing in esoteric areas most stuff doesn’t have videos.  It’s a bit tiresome searching one problem after another, only for each of them to come up as having no video.

It would be great if you could click on a crag, then scan down the list of problems to see which do and do not have videos - would save loads of time and (for me at least) mean that I am much more likely to use the site.

I Guess in areas such as yours this makes sense but would it just honeypot the problems already done? I guess you South Westies need to get your cameras out a bit more!!
Title: Re: BetaDb - Website for finding videos of problems
Post by: db79 on April 12, 2020, 12:21:26 pm
Absolutely blinding idea. I'm adding my videos right now.
Title: Re: BetaDb - Website for finding videos of problems
Post by: JamieG on April 12, 2020, 12:56:54 pm
Another improvement suggestion. I was searching for a problem called Isis at Sheigra in Scotland. But it is only finding things called 'Crisis' and displaying them. I'm sure its there because other problems in the area are there too, but there are too many problems with Crisis in the name. Maybe have exact matches come up first?

Edit - still a really great effort and hopefully grows into a brilliant resource.
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 12, 2020, 01:27:42 pm
I've added missing problems. Should be pretty extensive now. Let me know if you find anything missing and I'll look into it.

Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 12, 2020, 01:35:24 pm
Another improvement suggestion. I was searching for a problem called Isis at Sheigra in Scotland. But it is only finding things called 'Crisis' and displaying them. I'm sure its there because other problems in the area are there too, but there are too many problems with Crisis in the name. Maybe have exact matches come up first?

Edit - still a really great effort and hopefully grows into a brilliant resource.

Yeah good suggestion have changed the search so the results are ranked. Should work a bit better hopefully.
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 12, 2020, 01:47:14 pm
Absolutely blinding idea. I'm adding my videos right now.

 :)

Though would be really handy if punctuation could somehow be ignored in the search?

Should ignore punctuation now.
Title: Re: BetaDb - Website for finding videos of problems
Post by: remus on April 12, 2020, 02:39:14 pm
For the search, could it instant display the top x results, then if you hit enter (and maybe add a 'search' button) it'd take you to a search results style page with all the available results?
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 12, 2020, 03:21:22 pm
For the search, could it instant display the top x results, then if you hit enter (and maybe add a 'search' button) it'd take you to a search results style page with all the available results?

Yeah good idea, will add a "view all results" if there are more than those shown.
Title: Re: BetaDb - Website for finding videos of problems
Post by: Coops_13 on April 12, 2020, 03:25:37 pm
Accidentally added a video twice and don’t see a remove video button?
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 12, 2020, 03:27:37 pm
Accidentally added a video twice and don’t see a remove video button?

I didn't want to put a remove button that anybody can use, but I can do it so if you are the uploader of the video you can remove it?

(Edit: In the meantime I've removed the duplicate)
Title: Re: BetaDb - Website for finding videos of problems
Post by: M1V0 on April 12, 2020, 03:31:35 pm
Good idea! I've added what small offerings I have.
Title: Re: BetaDb - Website for finding videos of problems
Post by: JamieG on April 12, 2020, 03:34:09 pm
Is there anyway the database could handle problems with multiple names? I'm thinking at Wimberry, for example, a lot of problems have two names. Enhancing hero = elephant slab, take cover = flakes of concern etc.
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 12, 2020, 04:11:26 pm
Accidentally added a video twice and don’t see a remove video button?

Okay has an edit and remove button for things you've added now.
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 12, 2020, 04:13:18 pm
Is there anyway the database could handle problems with multiple names? I'm thinking at Wimberry, for example, a lot of problems have two names. Enhancing hero = elephant slab, take cover = flakes of concern etc.

It's possible to do but think in practice would be hard to get the data for this? Guess it'd just have to be added by hand.
Title: Re: BetaDb - Website for finding videos of problems
Post by: Coops_13 on April 12, 2020, 04:13:49 pm
Thanks, this is great! Shame I live stateside now. Any intention to expand over here in future. So many of the beta videos in Colorado are on Instagram...
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 12, 2020, 04:18:15 pm
Thanks, this is great! Shame I live stateside now. Any intention to expand over here in future. So many of the beta videos in Colorado are on Instagram...

Yeah for sure! Will see how it goes for just the UK first though...
Title: Re: BetaDb - Website for finding videos of problems
Post by: yetix on April 13, 2020, 01:50:22 am
This is great!
Title: Re: BetaDb - Website for finding videos of problems
Post by: tomtom on April 13, 2020, 07:28:32 am
Brilliant. Easy to upload. Easy to search.
Title: Re: BetaDb - Website for finding videos of problems
Post by: monkey boy on April 13, 2020, 08:37:32 am
Great effort! Can we add problems or just videos?
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 13, 2020, 09:49:23 am
Great effort! Can we add problems or just videos?

Thanks. Just videos for now, but being able to add problems is on the list of things to do!
Title: Re: BetaDb - Website for finding videos of problems
Post by: Sidehaas on April 13, 2020, 10:07:46 am
Great idea, I've just added my videos
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 13, 2020, 10:48:28 am
Great idea, I've just added my videos

Cheers!

Noticed one small bug (maybe) when searching for Fish Arete just to try it out. It only appeared in the search after I added a space after 'Fish', is that because it only displays the top so many results. Just confused me a little at first, but maybe that is the only way it could work.

For the search, could it instant display the top x results, then if you hit enter (and maybe add a 'search' button) it'd take you to a search results style page with all the available results?

I've added a way to view full search results now.
Title: Re: BetaDb - Website for finding videos of problems
Post by: remus on April 13, 2020, 01:33:43 pm
Nice one, thanks!

I don't know what language you've written it in, but if it's python based I'd love to get involved if there was some way for me to help out.  Just drop me a message on here.
Title: Re: BetaDb - Website for finding videos of problems
Post by: SA Chris on April 13, 2020, 03:48:11 pm
beta version suggestion - rating / voting of videos in order of most useful for beta, so best comes up first? Some are great, some are no use at all!

Otherwise, brilliant job!
Title: Re: BetaDb - Website for finding videos of problems
Post by: Coops_13 on April 13, 2020, 03:51:45 pm
beta version suggestion - rating / voting of videos in order of most useful for beta, so best comes up first? Some are great, some are no use at all!

Otherwise, brilliant job!
Or maybe a best lanky / short arse version?
Title: Re: BetaDb - Website for finding videos of problems
Post by: SA Chris on April 13, 2020, 03:58:00 pm
lol
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 13, 2020, 04:03:32 pm
beta version suggestion - rating / voting of videos in order of most useful for beta, so best comes up first? Some are great, some are no use at all!

Otherwise, brilliant job!

Yep on the list of things to do!
Title: Re: BetaDb - Website for finding videos of problems
Post by: JamieG on April 13, 2020, 04:11:03 pm
Is there anyway the database could handle problems with multiple names? I'm thinking at Wimberry, for example, a lot of problems have two names. Enhancing hero = elephant slab, take cover = flakes of concern etc.

It's possible to do but think in practice would be hard to get the data for this? Guess it'd just have to be added by hand.

I guess it is not going to be that many problems overall. Just noticeable at certain crags. Probably half the problems at Wimberry have an alternative name.
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 13, 2020, 04:26:11 pm
Is there anyway the database could handle problems with multiple names? I'm thinking at Wimberry, for example, a lot of problems have two names. Enhancing hero = elephant slab, take cover = flakes of concern etc.

It's possible to do but think in practice would be hard to get the data for this? Guess it'd just have to be added by hand.

I guess it is not going to be that many problems overall. Just noticeable at certain crags. Probably half the problems at Wimberry have an alternative name.

Okay well once I've added the ability to add problems that are not in the database I'll look into it properly.
Title: Re: BetaDb - Website for finding videos of problems
Post by: monkoffunk on April 13, 2020, 05:04:05 pm
In a similar way to bleau info, would there be a way to have a time stamp for videos with multiple problems?
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 13, 2020, 05:10:20 pm
In a similar way to bleau info, would there be a way to have a time stamp for videos with multiple problems?

There is this already! (Hopefully working!)
Title: Re: BetaDb - Website for finding videos of problems
Post by: Andy W on April 13, 2020, 05:31:32 pm
Good job Ed, I'll upload some Cornwall stuff, should have time  ;)

I'm sure it won't be an issue, but I notice with 8A.nu when people log a problem, new or otherwise, but with different spellings it will show up as different problems. Could this be an issue with your site?
Title: Re: BetaDb - Website for finding videos of problems
Post by: a13c on April 13, 2020, 06:13:55 pm
Hi Ed, if I'm putting a video off YouTube that has two (or more) problems on it, how do I identify those problems? In my techno ignorance I was about to put the same vid up twice...
Sorry if this is a daft question.
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 13, 2020, 06:19:30 pm
Hi Ed, if I'm putting a video off YouTube that has two (or more) problems on it, how do I identify those problems? In my techno ignorance I was about to put the same vid up twice...
Sorry if this is a daft question.

On the "Add Video" page you can add as many problems as you want for one video by clicking the "add another problem" button.
If you select a problem with no videos from the searchbar it will take you to the add video page with the first problem already filled out.
Hope that helps, I tried to make it intuitive but if I can change something to make it more obvious let me know.
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 13, 2020, 07:35:38 pm
Cool idea.  Is there any way you can lookup a crag, then browse through to see which problems have got videos?

A nested site structure based on geography would be great, maybe taking county and crag level data so crags and areas are easily navigable

I've added crag pages.
You can search for crags in the search bar now and then see what problems at a crag have videos.
Can maybe do country/region too, will think about it.
Title: Re: BetaDb - Website for finding videos of problems
Post by: tomtom on April 13, 2020, 07:58:56 pm
Hi Ed, if I'm putting a video off YouTube that has two (or more) problems on it, how do I identify those problems? In my techno ignorance I was about to put the same vid up twice...
Sorry if this is a daft question.

On the "Add Video" page you can add as many problems as you want for one video by clicking the "add another problem" button.
If you select a problem with no videos from the searchbar it will take you to the add video page with the first problem already filled out.
Hope that helps, I tried to make it intuitive but if I can change something to make it more obvious let me know.

I figured that out no probs Ed.
Title: Re: BetaDb - Website for finding videos of problems
Post by: a13c on April 13, 2020, 08:20:23 pm
Hi Ed, if I'm putting a video off YouTube that has two (or more) problems on it, how do I identify those problems? In my techno ignorance I was about to put the same vid up twice...
Sorry if this is a daft question.

On the "Add Video" page you can add as many problems as you want for one video by clicking the "add another problem" button.
If you select a problem with no videos from the searchbar it will take you to the add video page with the first problem already filled out.
Hope that helps, I tried to make it intuitive but if I can change something to make it more obvious let me know.

That's great, thank you.
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 13, 2020, 08:27:17 pm
Hi Ed, if I'm putting a video off YouTube that has two (or more) problems on it, how do I identify those problems? In my techno ignorance I was about to put the same vid up twice...
Sorry if this is a daft question.

On the "Add Video" page you can add as many problems as you want for one video by clicking the "add another problem" button.
If you select a problem with no videos from the searchbar it will take you to the add video page with the first problem already filled out.
Hope that helps, I tried to make it intuitive but if I can change something to make it more obvious let me know.

That's great, thank you.

No worries.

Hi Ed, if I'm putting a video off YouTube that has two (or more) problems on it, how do I identify those problems? In my techno ignorance I was about to put the same vid up twice...
Sorry if this is a daft question.

On the "Add Video" page you can add as many problems as you want for one video by clicking the "add another problem" button.
If you select a problem with no videos from the searchbar it will take you to the add video page with the first problem already filled out.
Hope that helps, I tried to make it intuitive but if I can change something to make it more obvious let me know.

I figured that out no probs Ed.

That's good to know -  I definitely worry that things only make sense to me because I designed it and have been stuck in my own bubble of ideas, so any feedback is either reassuring or useful!

Title: Re: BetaDb - Website for finding videos of problems
Post by: kingholmesy on April 13, 2020, 09:27:19 pm
I'll upload some Cornwall stuff, should have time  ;)


Please do!  Always good to have some local videos for inspiration and beta.
Title: Re: BetaDb - Website for finding videos of problems
Post by: kingholmesy on April 13, 2020, 09:30:42 pm

I've added crag pages.
You can search for crags in the search bar now and then see what problems at a crag have videos.


Great - thanks!
Title: Re: BetaDb - Website for finding videos of problems
Post by: SA Chris on April 13, 2020, 09:32:05 pm
over 1800 vids on the first day is impressive, good job everyone, esp Ed.
Title: Re: BetaDb - Website for finding videos of problems
Post by: Fultonius on April 14, 2020, 08:26:25 am
Great work Ed, nice and simple looking.

2 things that would maybe add something?

1. The top 5 new videos on the front page - maybe show the problem name and crag? (if it's instabang it doesn't show).
2. If you've found a problem by searching, but don't know where it it is, a way if navigating up to the crag page would be good.
Title: Re: BetaDb - Website for finding videos of problems
Post by: m.cooke.1421 on April 14, 2020, 09:33:11 am
Is there any way in which videos could be automatically muted when they start playing?

If a video contains more than one problem, and assuming that they have been added to the site, is there a way to see what the other problems are?
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 14, 2020, 09:51:17 am
Great work Ed, nice and simple looking.

2 things that would maybe add something?

1. The top 5 new videos on the front page - maybe show the problem name and crag? (if it's instabang it doesn't show).
2. If you've found a problem by searching, but don't know where it it is, a way if navigating up to the crag page would be good.

1. Yeah good idea, will do something like this
2. You can do this, but I've made the crag name more obviously clickable now.
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 14, 2020, 09:53:55 am
Is there any way in which videos could be automatically muted when they start playing?

If a video contains more than one problem, and assuming that they have been added to the site, is there a way to see what the other problems are?

I'll look into muting, but on desktop you can mute the whole site through the browser to stop anything from having sound. Is this a problem on mobile?

Not currently, but want to do this.


Title: Re: BetaDb - Website for finding videos of problems
Post by: RobK on April 14, 2020, 10:47:13 am
This is great! Is there any way to handle instagram posts with multiple videos? E.g. https://www.instagram.com/p/B9XFJw-DbCm/

Could maybe just add it as a comment.
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 14, 2020, 10:50:51 am
This is great! Is there any way to handle instagram posts with multiple videos? E.g. https://www.instagram.com/p/B9XFJw-DbCm/

Could maybe just add it as a comment.

I have looked into it and I think not easily unfortunately, probably commenting "second video" or something is best.
Title: Re: BetaDb - Website for finding videos of problems
Post by: SA Chris on April 14, 2020, 10:57:39 am
Lesson here in IT development and having a robust functional spec produced upfront ;)
Title: Re: BetaDb - Website for finding videos of problems
Post by: remus on April 14, 2020, 11:21:13 am
Lesson here in IT development and having a robust functional spec produced upfront ;)

...which then gets thrown in the bin as soon as some real users get their hands dirty and it turns out the person who wrote the spec had no idea what they were doing  ;D
Title: Re: BetaDb - Website for finding videos of problems
Post by: Kermit on April 14, 2020, 11:35:54 am
This is brilliant good work!  :goodidea:


Just a couple of ideas?

I noticed whilst uploading my videos that if you have clicked add problem but don't add any details when you click Add Video it tells you to remove blanks but it actually removes everything and goes back to the blank add video form. Just a bit annoying when you have added a couple of problems with time stamps etc.

Just personal habit but i am pasting the URL in then hitting tab, it goes to the problem name box but you can't start typing you have to click in the box first. Tiny thing really I just have a habit of using key board nav rather than mouse especially on a laptop with a track pad.

Otherwise seems good.

Thanks again
Title: Re: BetaDb - Website for finding videos of problems
Post by: Will Hunt on April 14, 2020, 11:52:31 am
This is great! Is there any way to handle instagram posts with multiple videos? E.g. https://www.instagram.com/p/B9XFJw-DbCm/

Could maybe just add it as a comment.

I have looked into it and I think not easily unfortunately, probably commenting "second video" or something is best.

I was wondering the same thing. The added comment is a good fix. Could be worth putting in some guidance text in the comments box (the kind that appears in grey and disappears when the user clicks the box to start typing?).


Also, what I'd love to see is a catalogue of what's been uploaded. It's really useful now for finding beta for a specific problem, but if I wanted to scan down a list of what there was at a particular crag to see what piques my interest, that would be useful. Maybe have an index page of simple text which groups the problems with videos into crags and orders the crags in alphabetical order?
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 14, 2020, 11:57:39 am
This is brilliant good work!  :goodidea:


Just a couple of ideas?

I noticed whilst uploading my videos that if you have clicked add problem but don't add any details when you click Add Video it tells you to remove blanks but it actually removes everything and goes back to the blank add video form. Just a bit annoying when you have added a couple of problems with time stamps etc.

Just personal habit but i am pasting the URL in then hitting tab, it goes to the problem name box but you can't start typing you have to click in the box first. Tiny thing really I just have a habit of using key board nav rather than mouse especially on a laptop with a track pad.

Otherwise seems good.

Thanks again

Cheers. Yeah both of these need sorting, will get on it.
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 14, 2020, 11:58:13 am
This is great! Is there any way to handle instagram posts with multiple videos? E.g. https://www.instagram.com/p/B9XFJw-DbCm/

Could maybe just add it as a comment.

I have looked into it and I think not easily unfortunately, probably commenting "second video" or something is best.

I was wondering the same thing. The added comment is a good fix. Could be worth putting in some guidance text in the comments box (the kind that appears in grey and disappears when the user clicks the box to start typing?).

Yeah will do this!
Title: Re: BetaDb - Website for finding videos of problems
Post by: AMorris on April 14, 2020, 12:20:45 pm
great idea! I will get linking problems when I see them
Title: Re: BetaDb - Website for finding videos of problems
Post by: m.cooke.1421 on April 14, 2020, 04:20:48 pm
Is there any way in which videos could be automatically muted when they start playing?

If a video contains more than one problem, and assuming that they have been added to the site, is there a way to see what the other problems are?

I'll look into muting, but on desktop you can mute the whole site through the browser to stop anything from having sound. Is this a problem on mobile?

Not currently, but want to do this.

Forgot to mention in my last post but this is great, well done for putting this together.

Muting the site works for desktop chrome but sadly doesn't appear to for the mobile version. I was only wishing to avoid accidentally blasting someones questionable musical choice whilst at the crag/alerting anyone else present at the crag that I was cheating.

Is there any problem with adding a video that someone else has already added if they have missed problems off when adding it?
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 14, 2020, 04:37:46 pm
Is there any way in which videos could be automatically muted when they start playing?

If a video contains more than one problem, and assuming that they have been added to the site, is there a way to see what the other problems are?

I'll look into muting, but on desktop you can mute the whole site through the browser to stop anything from having sound. Is this a problem on mobile?

Not currently, but want to do this.

Forgot to mention in my last post but this is great, well done for putting this together.

Muting the site works for desktop chrome but sadly doesn't appear to for the mobile version. I was only wishing to avoid accidentally blasting someones questionable musical choice whilst at the crag/alerting anyone else present at the crag that I was cheating.

Is there any problem with adding a video that someone else has already added if they have missed problems off when adding it?

Ah cheers, glad you like it.
Yeah will look into muting.
Nope shouldn't be a problem in doing that.
Title: Re: BetaDb - Website for finding videos of problems
Post by: dunnyg on April 14, 2020, 04:45:04 pm
Ace idea, and website works well for me on chrome  :2thumbsup:
Title: Re: BetaDb - Website for finding videos of problems
Post by: tomtom on April 14, 2020, 05:56:32 pm
This might be a stretch - but when adding a vid - if when pasting in the url, it could look up the vid and auto suggest the problem (assuming the video title starts with the problem name) then that would be neat!
Title: Re: BetaDb - Website for finding videos of problems
Post by: old cheese on April 14, 2020, 07:07:21 pm
A small question. I have great footage of the beta on Danny’s problem original at the plantation. Sadly the friend didn’t quite finish it instead falling out of the gaston move. I wondered whether I should post it up and the beta is sound? What would you lot do?

As a slight justification for adding it whilst looking at the plantation I watched the videos for the Joker and one chap didn’t even top it out (there was a little snow on the top mind)!!
Title: Re: BetaDb - Website for finding videos of problems
Post by: shark on April 14, 2020, 07:33:11 pm
A small question. I have great footage of the beta on Danny’s problem original at the plantation. Sadly the friend didn’t quite finish it instead falling out of the gaston move. I wondered whether I should post it up and the beta is sound? What would you lot do?

As a slight justification for adding it whilst looking at the plantation I watched the videos for the Joker and one chap didn’t even top it out (there was a little snow on the top mind)!!

Yes - it’s useful. Maybe write something in the comments to say that its incomplete
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 14, 2020, 08:43:45 pm
Just personal habit but i am pasting the URL in then hitting tab, it goes to the problem name box but you can't start typing you have to click in the box first. Tiny thing really I just have a habit of using key board nav rather than mouse especially on a laptop with a track pad.

So there is a problem with tabs on the Add Video page.
I can get it so you can type automatically without selecting but you can't tab to the next input.
This is apparently a known bug in the autocomplete plugin I'm using, will look into it further.

I've sorted a few things out, working on various suggestions, some might take a little while to get working.
Title: Re: BetaDb - Website for finding videos of problems
Post by: Will Hunt on April 14, 2020, 09:24:11 pm
When I try and tag Jess's Roof in a video it doesn't seem to come up in the drop down options? I did check how it was spelled this time!
Title: Re: BetaDb - Website for finding videos of problems
Post by: Grady on April 14, 2020, 10:30:18 pm
Great idea! I'll definitely add any vids I have.

If we're doing feature requests, any chance of a search api / predictable urls? I'm currently building a site for my local area and it would be cool to link through to the relevant problems. Be nice to be able to do this programmatically and not have to hardcode all the links.
Title: Re: BetaDb - Website for finding videos of problems
Post by: macca7 on April 14, 2020, 11:45:16 pm
When I try and tag Jess's Roof in a video it doesn't seem to come up in the drop down options? I did check how it was spelled this time!
Get the same with boomerang at clodgy?
Title: Re: BetaDb - Website for finding videos of problems
Post by: Paul B on April 15, 2020, 09:41:24 am
In these circumstances of being stuck at home with not much to do, I have built a website:
https://www.betadb.org/

Good effort!
Title: Re: BetaDb - Website for finding videos of problems
Post by: Kermit on April 15, 2020, 10:18:39 am
Just personal habit but i am pasting the URL in then hitting tab, it goes to the problem name box but you can't start typing you have to click in the box first. Tiny thing really I just have a habit of using key board nav rather than mouse especially on a laptop with a track pad.

So there is a problem with tabs on the Add Video page.
I can get it so you can type automatically without selecting but you can't tab to the next input.
This is apparently a known bug in the autocomplete plugin I'm using, will look into it further.

I've sorted a few things out, working on various suggestions, some might take a little while to get working.

Nice one!


Another thing I noticed earlier, either i've been a bit of a numpty and uplaoded the same video twice or someone else has uploaded one of mine (someone else has, I just checked and can only edit one of them). It was for help the young. It therefore looks like there are more videos for that climb than there actually are, maybe it can filter out videos that have already been uploaded?

Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 15, 2020, 10:50:01 am
When I try and tag Jess's Roof in a video it doesn't seem to come up in the drop down options? I did check how it was spelled this time!

Have sorted this now.
Title: Re: BetaDb - Website for finding videos of problems
Post by: tomtom on April 15, 2020, 10:51:02 am
Coming up to 2k videos now Ed. You should be chuffed. Effort.
Title: Re: BetaDb - Website for finding videos of problems
Post by: Paul P on April 15, 2020, 01:27:22 pm
Have sorted this now.

That works better now. I don't mind sharing how we do the name matching on UKC but would appreciate a reply to our emails first  ;)
Title: Re: BetaDb - Website for finding videos of problems
Post by: SA Chris on April 15, 2020, 01:37:19 pm
2K reached!!
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 15, 2020, 02:02:03 pm

Nice one!


Another thing I noticed earlier, either i've been a bit of a numpty and uplaoded the same video twice or someone else has uploaded one of mine (someone else has, I just checked and can only edit one of them). It was for help the young. It therefore looks like there are more videos for that climb than there actually are, maybe it can filter out videos that have already been uploaded?

So I think the problem with this is if someone has uploaded a video but not tagged all the climbs, it'd  be good to have the ability to add the video again with the remaining climbs. I guess the best solution is to be able to add a problem to an existing video.
Title: Re: BetaDb - Website for finding videos of problems
Post by: petejh on April 15, 2020, 02:09:15 pm
Great resource, nice work :2thumbsup:


Another suggestion - how about recruiting a few volunteers to keep it tidy before it grows much larger (when it'll become harder to keep in order). For e.g. when I search by area: 'Wales' most stuff (e.g. Parisellas) doesn't come up.

(haven't read the thread so apols if this is already happening)
Title: Re: BetaDb - Website for finding videos of problems
Post by: Will Hunt on April 15, 2020, 02:10:42 pm

Nice one!


Another thing I noticed earlier, either i've been a bit of a numpty and uplaoded the same video twice or someone else has uploaded one of mine (someone else has, I just checked and can only edit one of them). It was for help the young. It therefore looks like there are more videos for that climb than there actually are, maybe it can filter out videos that have already been uploaded?

So I think the problem with this is if someone has uploaded a video but not tagged all the climbs, it'd  be good to have the ability to add the video again with the remaining climbs. I guess the best solution is to be able to add a problem to an existing video.

I ran into this last night when I was going through some of Dave Sutcliffe's Vimeo videos. Some of his videos are documenting new problems or other things that haven't been picked up by the scraper for whatever reason. So for the one that I linked to with Jess's Roof in it, I still put it up but just referenced Dick Hymen. Does this mean I now can't add the video again but link to Jess's Roof? Or I could do but if I link to Dick Hymen again the video will appear twice in the Dick Hymen entry? Seems like an issue that should be fixable with some validation processes.


BTW, if you're contributing videos and not putting the time stamp on, then  :chair: :jab: :whip: :spank:
We have in our hands a great opportunity to skip sponsors logos, morning coffees, and driving to the crag montages. Let's not fuck this up (it's a nightmare to sift through this stuff when at a crag with crap data reception).
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 15, 2020, 02:32:02 pm
Great resource, nice work :2thumbsup:


Another suggestion - how about recruiting a few volunteers to keep it tidy before it grows much larger (when it'll become harder to keep in order). For e.g. when I search by area: 'Wales' most stuff (e.g. Parisellas) doesn't come up.

(haven't read the thread so apols if this is already happening)

"area" here is roughly equivalent to "crag". Don't have countries added yet but considering doing so.
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 15, 2020, 02:34:17 pm
Quote from: Will Hunt

I ran into this last night when I was going through some of Dave Sutcliffe's Vimeo videos. Some of his videos are documenting new problems or other things that haven't been picked up by the scraper for whatever reason. So for the one that I linked to with Jess's Roof in it, I still put it up but just referenced Dick Hymen. Does this mean I now can't add the video again but link to Jess's Roof? Or I could do but if I link to Dick Hymen again the video will appear twice in the Dick Hymen entry? Seems like an issue that should be fixable with some validation processes.


You can add the video again if you want. There's no check on duplicate urls at the moment. I do want to sort this out though.
Title: Re: BetaDb - Website for finding videos of problems
Post by: a13c on April 15, 2020, 10:19:22 pm



BTW, if you're contributing videos and not putting the time stamp on, then  :chair: :jab: :whip: :spank:
We have in our hands a great opportunity to skip sponsors logos, morning coffees, and driving to the crag montages. Let's not fuck this up (it's a nightmare to sift through this stuff when at a crag with crap data reception).

So I was guilty of this... Sorry.
I've just been going through and putting time stamps on them though and I see someone had already done some for me. (the beaver ones) Cheers!
Title: Re: BetaDb - Website for finding videos of problems
Post by: a13c on April 15, 2020, 10:21:33 pm
It appears my "quoting" could do with some work too...
Title: Re: BetaDb - Website for finding videos of problems
Post by: Kermit on April 16, 2020, 10:20:01 am

Nice one!


Another thing I noticed earlier, either i've been a bit of a numpty and uplaoded the same video twice or someone else has uploaded one of mine (someone else has, I just checked and can only edit one of them). It was for help the young. It therefore looks like there are more videos for that climb than there actually are, maybe it can filter out videos that have already been uploaded?

So I think the problem with this is if someone has uploaded a video but not tagged all the climbs, it'd  be good to have the ability to add the video again with the remaining climbs. I guess the best solution is to be able to add a problem to an existing video.

Agreed in this case there was only one problem on the video albeit being done by 2 people.
Title: Re: BetaDb - Website for finding videos of problems
Post by: tomtom on April 16, 2020, 10:34:34 am
Noticed one (could be more) IG posts that were uploaded that were pictures not videos..
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 16, 2020, 11:04:27 am
Noticed one (could be more) IG posts that were uploaded that were pictures not videos..

It might be possible to check for this, but it's not obvious how to do it. Something for further down the line I reckon!
Title: Re: BetaDb - Website for finding videos of problems
Post by: yetix on April 16, 2020, 11:34:04 am
Noticed one (could be more) IG posts that were uploaded that were pictures not videos..

If the post has a picture and a video assigned but the picture first in the post it will show the picture first, but have the option to scroll to the video is there (noticed this on one of my housemates videos which had been uploaded) is this the case on the one you noticed?
Title: Re: BetaDb - Website for finding videos of problems
Post by: sdm on April 16, 2020, 11:47:34 am
On the homepage where recently uploaded videos are shown, is it possible to add a link to the problem(s), crag(s) and any timestamps for each video?

Instagram posts typically don't include the problem name or location unless you leave the site and open the original post in Instagram.
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 16, 2020, 12:04:14 pm
On the homepage where recently uploaded videos are shown, is it possible to add a link to the problem(s), crag(s) and any timestamps for each video?

Instagram posts typically don't include the problem name or location unless you leave the site and open the original post in Instagram.

Yep going to do this!
Title: Re: BetaDb - Website for finding videos of problems
Post by: Will Hunt on April 16, 2020, 12:13:00 pm
The thing I mentioned before - the index of problems with videos is actually already addressed in kind. If you search for a crag you can pull up a list of the problems ordered into those with vids and those without which is dead useful.

Is there a way to link to Instagram stories - sometimes people upload beta that way.
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 16, 2020, 02:33:30 pm
Is there a way to link to Instagram stories - sometimes people upload beta that way.

I think stories are only viewable if you have an account?
Title: Re: BetaDb - Website for finding videos of problems
Post by: old cheese on April 16, 2020, 02:37:02 pm
I was just looking at Robin Hoods Stride videos and on the vid of Picallis pickle won’t play saying that there is a copyright issue.

Also, in the same area the video for the ‘dynamic cave problem’ says it needs a password. Are people uploading videos that cannot be viewed?
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 16, 2020, 02:40:13 pm
I was just looking at Robin Hoods Stride videos and on the vid of Picallis pickle won’t play saying that there is a copyright issue.

Also, in the same area the video for the ‘dynamic cave problem’ says it needs a password. Are people uploading videos that cannot be viewed?

Have removed both.
Title: Re: BetaDb - Website for finding videos of problems
Post by: remus on April 16, 2020, 02:41:43 pm
Is there a way to link to Instagram stories - sometimes people upload beta that way.

I think stories are only viewable if you have an account?

And don't stories generally disappear after 24hrs?
Title: Re: BetaDb - Website for finding videos of problems
Post by: Will Hunt on April 16, 2020, 03:08:16 pm
Is there a way to link to Instagram stories - sometimes people upload beta that way.

I think stories are only viewable if you have an account?

And don't stories generally disappear after 24hrs?

Some of them seem to get archived into different categories (food I ate; photos of me sunbathing; look at me climbing; etc) which can be reviewed for longer.
Title: Re: BetaDb - Website for finding videos of problems
Post by: gardinrm on April 19, 2020, 02:35:50 pm
Just to say well done for this ace site! Great job. This will be so useful and I really like the slick and simple layout.

Will you refresh the problems list fairly regularly? For example, I just uploaded a bunch of stuff to UKC that I did in Sheigra in the North-West of Scotland.

Keep up the good work.
Title: Re: BetaDb - Website for finding videos of problems
Post by: monkoffunk on April 19, 2020, 03:26:29 pm
Also will it always be indexed to UKC? I guess that’s a way of trying to keep consistency with names. Have also just added a new problem to UKC although not yet verified.
Title: Re: BetaDb - Website for finding videos of problems
Post by: remus on April 19, 2020, 07:33:17 pm
Also will it always be indexed to UKC? I guess that’s a way of trying to keep consistency with names. Have also just added a new problem to UKC although not yet verified.

Wouldn't want to speak for Ed, but I think it'd be very tricky to merge another problems list so sticking with UKC as a source seems sensible.
Title: Re: BetaDb - Website for finding videos of problems
Post by: monkoffunk on April 19, 2020, 07:54:30 pm
Makes sense!
Title: Re: BetaDb - Website for finding videos of problems
Post by: EdGowSmith on April 22, 2020, 12:07:53 pm
I'm sorry to say that I've shut down the site.
UKC were not happy with me using their data and I was not happy with the collaboration they were wanting.
I have other things that need my attention now and the stress of dealing with it all was taking a big toll on my mental health, which I just cannot sacrifice further by dealing with legal action.
Thanks to everyone who took time to contribute and provide feedback, I'm really sorry that it's had to end like this - it's not a decision I've taken lightly.

Ed

Title: Re: BetaDb - Website for finding videos of problems
Post by: SA Chris on April 22, 2020, 12:25:49 pm
What a shame Ed, it was brilliant while it lasted.

Pity they were not being amenable, especially as the data is not technically "theirs" as it has been sourced from many different places.

It was a brilliant effort anyway
Title: Re: BetaDb - Website for finding videos of problems
Post by: Paul P on April 22, 2020, 12:39:23 pm
Sorry to hear that Ed, we think this is a real shame. I was looking forward to working with you on this.

We first approached Ed last week after we became aware of the project. Since it was similar to something we have been working on for the UKC logbooks, we were keen to see if we could combine efforts, however we did need to establish permission to use our database. Ed was slow to respond but, when he did, we explained the situation and increased our offer to open up our database. This was inline with what many have requested on this thread: to link the database so that new problems only need to be entered in one location. It would have also maintained consistent names and areas. Unfortunately Ed didn't want to collaborate although we have never had a discussion as to what shape the collaboration would take since we have only received two short emails from Ed despite making ourselves fully available for discussion.

If you have a change of heart and want to get it going again then we would be happy to work with you and the offer we made remains open.

For people's information, The Copyright and Rights in Databases Regulations 1997 - https://www.legislation.gov.uk/uksi/1997/3032/contents/made assigns copyright to the effort of creating the database, not the data itself, which is mostly uncopyrightable facts like route names. At UKC we have never claimed we own data, just the database it is assembled in. It also assigns responsibility to protecting that database in both upkeep and when and where it is used. In this case we bent over backwards to try and make something that would work but we had to do something since, if we didn't, we would have been neglecting our responsibility to our database which would have left it open to use by significantly more commercial concerns than Ed.
Title: Re: BetaDb - Website for finding videos of problems
Post by: tomtom on April 22, 2020, 12:58:09 pm
Well done anyway Ed. You should be well proud of what you’ve done and achieved 👍👍
Title: Re: BetaDb - Website for finding videos of problems
Post by: AMorris on April 22, 2020, 01:59:53 pm
that's a shame, it is a great idea and held promise. Well done regardless Ed, fantastic effort  :2thumbsup:
Title: Re: BetaDb - Website for finding videos of problems
Post by: yetix on April 22, 2020, 02:09:42 pm
Sorry to hear that Ed. Take a break from it and have a look back once you've had some time to decompress. Hope you're alright.
Title: Re: BetaDb - Website for finding videos of problems
Post by: spidermonkey09 on April 22, 2020, 02:23:31 pm
Sorry to hear that Ed, we think this is a real shame. I was looking forward to working with you on this.

We first approached Ed last week after we became aware of the project. Since it was similar to something we have been working on for the UKC logbooks, we were keen to see if we could combine efforts, however we did need to establish permission to use our database. Ed was slow to respond but, when he did, we explained the situation and increased our offer to open up our database. This was inline with what many have requested on this thread: to link the database so that new problems only need to be entered in one location. It would have also maintained consistent names and areas. Unfortunately Ed didn't want to collaborate although we have never had a discussion as to what shape the collaboration would take since we have only received two short emails from Ed despite making ourselves fully available for discussion.

If you have a change of heart and want to get it going again then we would be happy to work with you and the offer we made remains open.

For people's information, The Copyright and Rights in Databases Regulations 1997 - https://www.legislation.gov.uk/uksi/1997/3032/contents/made assigns copyright to the effort of creating the database, not the data itself, which is mostly uncopyrightable facts like route names. At UKC we have never claimed we own data, just the database it is assembled in. It also assigns responsibility to protecting that database in both upkeep and when and where it is used. In this case we bent over backwards to try and make something that would work but we had to do something since, if we didn't, we would have been neglecting our responsibility to our database which would have left it open to use by significantly more commercial concerns than Ed.

For what it's worth I found that a thoroughly reasonable post, obviously without knowing Ed's side or the details.

Ed, great effort setting it up, hope you stay well and you can always look at it again down the line.
Title: Re: BetaDb - Website for finding videos of problems
Post by: a13c on April 22, 2020, 02:53:55 pm
That's a real shame Ed, the site was great and it was only getting bigger and better.
Take care of yourself.
Title: Re: BetaDb - Website for finding videos of problems
Post by: macca7 on April 22, 2020, 07:00:20 pm
Well that is a real shame and I can't help but feel really disappointed for Ed and all of the hard work he put in.

The BetaDB site is surely what UKC have been wanting to add to their site since video was added to the photo section for each crag and presumably ultimately to each problem/route.

It does feel a little bit of sour grapes on UKC part that a young man on his own managed to get it up and running before they did and they were worried that the BetaDB site would be receiving a lot of traffic that they feel they should be receiving.

As has been said a lot of those problem names were added by a fair amount of the users of this site.

Ed could you not just have the site that we as users populate with vids and the names of the problems as well. I know more room for error and miss-spelt problems and duplicates etc but if you grouped them by crag it might be a bit easier for people to scan through. Just feels like the big losers are the climbers that would have saved a load of time and effort by having the page and Ed maybe missing out on some advertising revenue.

Good luck Ed take care there is certainly enough to be worrying about at the minute and Paul if UKC aren't going to let anyone else do it, bloody hurry up and get on with it or employ Ed to do it!

Gutted! :wavecry:BetaDB

Macca
Title: Re: BetaDb - Website for finding videos of problems
Post by: Alan James, Rockfax on April 22, 2020, 08:11:40 pm
... or employ Ed to do it!

That was part of the offer we made to Ed.

Alan
Title: Re: BetaDb - Website for finding videos of problems
Post by: tomtom on April 22, 2020, 08:14:35 pm
Probably too late - but one of my suggestions I didn’t post last week would ha w been a BetaDB search widget or embedable search box. So sites like UKC could have the functionality but within a search box or frame from/for the BetaDB site. Or something like that...
Title: Re: BetaDb - Website for finding videos of problems
Post by: mrjonathanr on April 22, 2020, 08:34:44 pm
Wouldn’t a collaboration with Peakbouldering.info have been viable?
Title: Re: BetaDb - Website for finding videos of problems
Post by: macca7 on April 22, 2020, 10:38:26 pm
Alan

I thought it might have been, shame it didn't work out but im sure Ed has his reasons.

Over to you  :goodidea:
Title: Re: BetaDb - Website for finding videos of problems
Post by: Coops_13 on April 23, 2020, 01:59:14 am
Just found this which is the same idea but US focused. Has an international section where you can add climbs and crags so no cross-site infringement. Works with ig and youtube/Vimeo:
https://www.betacache.com/
Title: Re: BetaDb - Website for finding videos of problems
Post by: remus on April 23, 2020, 08:36:43 am
Wouldn’t a collaboration with Peakbouldering.info have been viable?

Would be good for the peak (obviously) but I think you'd run in to problems pretty quickly if you wanted to expand the scope. Trying to merge lists of problem names is hard (misspellings, different names from different guidebooks, differences between crags etc).

Also I don't think Ed is based in the peak, so kinda annoying to run this cool tool that doesn't have any of his local problems in it.
SimplePortal 2.3.7 © 2008-2024, SimplePortal