Author Topic: What's happening at PlaymoDB  (Read 17311 times)

Offline sbblabotw

  • Mistress of PlaymoDB
  • Playmo Addict
  • ****
  • Posts: 889
  • Gender: Female
    • PlaymoDB ... the UNOFFICIAL online database for Playmobil® toys
What's happening at PlaymoDB
« on: April 15, 2013, 14:01:09 »
Well, I'm back from my travels, and tackling all the backlog in the rest of my life as well as the big problem of PlaymoDB. I'll do a little explaining here.

When the whole site went down April 1st, it was because the server it was on was actually crashing because of PlaymoDB, so they shut down the whole thing until I could fix the problem. It's a shared server that I pay for space on (like most hobby and small-business websites) so they had every right to do so. I worked with their tech support to identify that it was the set-pages and part-pages that were causing the most trouble, so I turned them off, and they re-instated the rest of the site. The remaining functions are still causing slowdowns, though. It may be suspended again at any time.

The cause of the overload is that the amount of data is growing well beyond what I wrote the original search functions to handle. I had no idea in 2004 that I'd someday have 30,000 parts and 3000 sets to deal with! Searching through this huge pile to show all the set inventories and part- and klicky-information is what's giving the server the heart-attack. The whole site has to be re-written to be more efficient - not a quick fix.

And here's my problem with this. I'm one person, with a full-time job and heavy family and community commitments that have nothing to do with PlaymoDB. I'm not a "they", I'm a "she". I might have a few hours to spend on it daily if nothing else takes priority. Moreover, I receive no income or other benefits from it except the goodwill of the users - indeed, I pay for the server out of my own pocket, but the TIME is what costs the most.

I can't see a big enough chunk of time in the near future to devote to re-writing PlaymoDB so it will be able to keep running. I might be able to do a little bit. I'm receiving dozens of emails and personal messages wondering when the site will be back, and I don't have anything to tell them. I had to consciously ignore the email on my very special trip last week to avoid the mess ruining the whole trip for me - if I can't maintain enough life balance to do that without PlaymoDB interfering, then it's PlaymoDB that I'll have to give up. It's as simple as that.

I've written to the Playmobil Company in hopes of starting discussion about them taking over my data repository - no more specifics than that, no idea how they might want to go about it, what form it will take, whether I'll stay involved past a certain time period, no details and no expectations at all at this point. Maybe they won't want anything to do with it, but since they do use it and benefit the most from it, they're the logical ones to take it over, so I hope some arrangements can be made. Don't pester Playmobil just yet with suggestions, demands or requests on my behalf - let them figure it out. I'll do my best to keep everyone informed, but, again... TIME. I just don't have enough of it.

I'd like to acknowledge and thank all the volunteers who have sent me loads of instruction plans, photos, inventories, corrections, comments over the years. It's been great working with you. But really? Thank each other. You've benefited yourselves, and thousands of visitors that never show their faces here or anywhere else, so much more than me. It's been fun for a long time. I hope I can continue to have fun with it - we'll just have to wait and see.

Cheers, Heather
PlaymoDB.org has catalogued over FIFTY-FIVE THOUSAND parts in more than 6100 sets. Come and visit to find any set or part numbers you need to know!

Offline henry_martini

  • Playmo Addict
  • ****
  • Posts: 595
Re: What's happening at PlaymoDB
« Reply #1 on: April 15, 2013, 14:44:45 »
Sad news indeed.  :o

No matter how this ends thank you for what you have done for us during the last years.  :)

I am still hoping for a solution.

H_M
@geobra: Thanks a lot! :-)

Offline bonniebeth

  • playmo zoo architect
  • Playmo Guru
  • ******
  • Posts: 11811
  • Gender: Female
    • my youtube channel
Re: What's happening at PlaymoDB
« Reply #2 on: April 15, 2013, 14:50:54 »
This is very sad news. Hopefully it will all work out in the end. But no matter what happens, as much as we all love and depend on playmodb, I'm sure we all understand that we can't expect it to rule your life forever. It's a huge project for one person to keep up alone. Thanks for all the hard work you have done through the years!
My playmobil zoo: http://www.youtube.com/watch?v=E-0grq9acog
In the end, we will conserve only what we love. We will love only what we understand. We will understand only what we are taught.

Offline baboune

  • Playmo Enthusiast
  • *
  • Posts: 76
  • Gender: Male
Re: What's happening at PlaymoDB
« Reply #3 on: April 15, 2013, 15:10:24 »
Hi Heather,

First of all many thanks for all the work you've done for everyone here.  Your site is a bible for us and I can only imagine all the hours you've spent building this wonderfull site which is so helpfull for everyone.  Again.... THANK YOU VERY MUCH!

As for trying to find a solution to keep this site alive & kicking, would it be foolish to think that this site could be available through a membership with a small fee that could cover the costs of maintaining this unique site that is so valuable to everyone...

Being a father of three myself, I fully understand that you can't spend all these hours on this site while having other priorities in your life and it's perfectly legit...... You've done it till now, on your own time, precious time that you've given to all of us, so maybe you feel that it's time to pass the torch so you can find a balance in all of this.....

Another part of the solution might be to find a way to dispatch the work between volunteers by taking each one a select theme and be responsible for the updating..... Someone picks western, another the pirates, another one the dollhouse..... etc..... Technically I don't know how this can work, but it might be an avenue worth thinking...

These are a few ideas to discuss, so feel free to leave any constructive comments so we can find a solution to help Heather, so all of her work lives forever!

Uncle Dan :wave:

Offline Indianna

  • Playmo Detective
  • Playmo Master
  • *****
  • Posts: 1379
  • Gender: Female
Re: What's happening at PlaymoDB
« Reply #4 on: April 15, 2013, 15:39:27 »
Hi Heather -

Thanks for the update.  I have feared for a while that Playmodb might eventually face such a crisis - the site is so popular and so successful and, as you say, you are just one person with a limited amount of time - something that money donations alone cannot alter.  I hope that you were able to enjoy your vacation without stressing out about Playmodb's issues.   :yup: 

It is exciting to think about the possibility that Playmobil may take over management of the site and I wish you good luck with that.  If that doesn't work out, perhaps we can put together a group of fans who can either work closely with you or even take it over completely - there seem to be a lot of tech-savvy folks here at PF.  Unfortunately, I cannot count myself in their number but I would definitely offer financial support for such an enterprise as I am sure others would, too. 

Whatever happens, you will have the eternal gratitude of thousands of Playmobil fans.  You have always managed Playmodb graciously and generously and maybe now it is time for us to let you off the hook!   ;D
U.S.A.      Massachusetts

Offline henry_martini

  • Playmo Addict
  • ****
  • Posts: 595
Re: What's happening at PlaymoDB
« Reply #5 on: April 15, 2013, 18:53:25 »
If I understood correctly the main issue atm is the shared server hosting which means that it might be still working on a faster dedicated server. 30000 entries are maybe not that amount of data when on a server with sufficient capabilities. Even in the present state before the last crash I normally had a smooth experience.
Of course it would be more expensive and hence some kind of reliable crowdfounding would have to be organized.
@geobra: Thanks a lot! :-)

Offline bonniebeth

  • playmo zoo architect
  • Playmo Guru
  • ******
  • Posts: 11811
  • Gender: Female
    • my youtube channel
Re: What's happening at PlaymoDB
« Reply #6 on: April 15, 2013, 19:11:41 »
Yes, but the hitch there is that geobra may not permit the site to exist if any money were made from it. I wonder if it were not-for-profit, though? Like if the funding were only enough to keep the site running? I'm sure we'd all be willing to pay a membership fee to use the site, it's just how to get geobra to allow it.
My playmobil zoo: http://www.youtube.com/watch?v=E-0grq9acog
In the end, we will conserve only what we love. We will love only what we understand. We will understand only what we are taught.

Offline playmofire

  • Klicky Firemeister
  • Playmo Guru
  • ******
  • Posts: 10924
  • Gender: Male
    • Copt Hewick Volunteer Fire Brigade - probably the world's smallest fire brigade!
Re: What's happening at PlaymoDB
« Reply #7 on: April 15, 2013, 19:15:13 »
I'd like to add my thanks to Heather for all the time and money she has put into playmoDB to our benefit.  I also hope that either Heather can get Geobra to help (by funding her or by taking over the running of playmoDB, hopefully with Heather still in control, if that's what she wants) or it will be possible to finance the site for Heather, whether it is by contributions from supporters or money from advertising.
“Today well-lived makes every yesterday a day of happiness to remember and every tomorrow a vision of hope.”

Offline bonniebeth

  • playmo zoo architect
  • Playmo Guru
  • ******
  • Posts: 11811
  • Gender: Female
    • my youtube channel
Re: What's happening at PlaymoDB
« Reply #8 on: April 15, 2013, 19:19:46 »
I was thinking about advertising, too. Since the income would be from ads, and not technically from any use of playmobil, it should be allowable, I would think.
My playmobil zoo: http://www.youtube.com/watch?v=E-0grq9acog
In the end, we will conserve only what we love. We will love only what we understand. We will understand only what we are taught.

Offline Tiermann

  • Playmo Master
  • *****
  • Posts: 9009
  • Gender: Male
  • Playmosaurus friendus
    • Animobil
Re: What's happening at PlaymoDB
« Reply #9 on: April 15, 2013, 19:49:16 »
It's a difficult situation. I think money is less the problem than time is. Memberships or just having a donation option could bring in enough to cover hosting costs. It's the time to do the coding and data entry that creates a more long term bottle neck I expect. I know that the only reason I have been able to keep up with Animobil is because it is such a narrow range of things to keep track of. That and having a site creation software that automates a lot of the detaily bits for me is what's allowed me to keep up. I have let other aspects of my sites slide though, with the shields/heraldry section being out of date for now and my other collecting pages even more so. It might be worth talking to David Donachie about the database issues. He's dealt with a lot of that from the coding side in keeping the Grophland online game going.