SWDb 3.0 (our massive 2022/2023 project)

The cat’s out of the bag! I have decided to name the upcoming changes to the site “SWDb 3.0”. It will be one of the most substantial updates to the SWDb in many years, but at the same time not a lot of it will actually be visible. What will be visible will depend to some degree on how we can edit the content of the website so it will make use of the technologies that power the SWDb (or will power it once implemented).

I will need everyone’s help for testing and feedback before we can go through with it. So please bear with me for this longer post

In a nutshell, what’s changing:

  • the website will look just slightly different (and it will hide the technical stuff to those not logged in) and have a sidebar
  • improved responsiveness (will work and look better on all devices)
  • more support for nice looking icons, tabs, accordions and other display options to make complex content easier on the eyes
  • we will use this to give all film pages a major overhaul, see below.

There will be a lengthy forum topic on the changes once it’s all accomplished as well, so no worries.

BUT first and foremost, before we really kick it off, I would like to ask those interested in helping out to use the new foundations of SWDb 3.0 for a few more weeks and give it a real life test drive. We need to iron out all its kinks and test the nuts and bolts. I have been doing that already, own my own, for a few months now, some of the editors have too, and I am fairly happy, but some work is still ahead before we can throw this in front of the entire world.

Please (and mille grazie for doing that)

  1. go to the site “Special:Preferences” once logged into the SWDb (instructions for those without an editors account, see further below): Log in - The Spaghetti Western Database

  2. go to “Appearance” and selekt “Tweeki”.

  3. Make sure responsive mode is checked.

  4. Hit save.

  5. Delete temporary files or “cache” of your browser just to be on the safe side. Please also do that on any mobile device you may be using the SWDb from, and I want to encourage you to use the SWDb from any crappy device you have. The better we test it from stuff people may be using, the better.

  6. Use the SWDb as before, work with it, browse it, edit it. And report every problem, glitch, weird thing or annoyance to me as precisely as possible, so I can try and have it fixed / or fix it myself / or tell you why it’s meant to be like that on purpose haha.

Non-login option instruction for anyone to see a specific site on the SWDb in the “new look” (which is still under development): simply add an “?useskin=Tweeki” to any URL, for example if you want to see Roy’s Deadly Trackers review in the new look:

What do we want to accomplish before we give a final “green light” and start working on it all?

  1. We need to do more test driving before we let thousands of people enjoy this every day.
  2. Some things to test out for you: browsing around, searching, editing, uploading pictures, selecting categories, using the site on different sized screens and operating systems, printing pages, sharing content online, modernizing older content pages, etc…
  3. The centerpiece will be the new film pages, because that is what most people will use. My test page is this “fake” Django page (https://www.spaghetti-western.net/index.php/Main_Page/filmseite ). Questions for you: Does this cover all kinds of information a film page can have? What’s missing? Does it make sense? Is the order ok? Does this look okay on huge screens and small cell phones? Can you imagine any other film’s page be designed this way? One nagging thing is that posters have different formats, and sometimes there are less AKA titles, so the way this site will look if you resize your screen isn’t yet perfect…
    Once we have that one page perfect, but only then (!), this is gonna be our template to roll it out across over 700 pages in the SWDb, and that is going to be the major work to be done until the end of the year, potentially.
  4. But, before we do that, I’ll compile a checklist so we can divide out the work and nobody forgets anything. I still need to make some technical changes to that page, too, so it works better on mobile, that is still being worked on. You may notice that it is not exactly perfect if you resize your browser window from full screen to a small window, or use it on your cell phone, etc, but I am getting closer.
  5. Does the new main menu cover what the main menu should cover? What is content that is linked to from the main menu that urgently needs updating, improvement and expansion before we prominently send people in that direction?
  6. Are you okay with what is in the website’s footer? Is something missing anywhere in the user interface of the website that is urgently needed?
  7. Are you okay with the width of the sidebar, or could it be a bit wider? We will design some new graphics and buttons for it. Those currently visible there are placeholders.
  8. For editors, I have made a new profile page, how do you like it? See it here (remember above, how to add the new look to it
  9. Are there any other things you notice that should need fixing?

Many thanks for helping test and improve the SWDb.

Once everything feels right, we can move to implementation, and this will be the greatest change to the SWDb in years. People will really like it I am sure. I will need your help, because the SWDb is all of us - together, but I will do my best to assist and help us all divide up the work and since this is just for fun and a hobby, we will do it as fast as we can, but there is no need to go faster than that :slight_smile:

Until then, enjoy test-driving SWDb 3.0 and please report everything in here.

Coming soon: Once the changes are implemented, there’ll be a 💡 What's new in SWDb 3.0 topic outlining all the new things.

1 Like

Update: I went ahead and gave the Essential Top 20 a quick update. Now, this may not look right unless you have SWDb 3.0 enabled, but I thought we need to speed things up a bit :slight_smile:


Looks good on 3.0
The others will obviously need changing. Shall I go ahead and do the Alternative Top 20 using this as a template?

Maybe not quite yet, I haven’t given the top20 enough testing, it was a rather spontaneous thing yesterday. More important are the other things described above, such as whether the film pages cover what they need to cover. I still puzzle over how to design them so they look nice with regular posters and with the rather vertical locandinas. We could of course try to not use these… but I wonder if that’s a sustainable option for all movies in the database?


No locandina:

Yes, that is tricky as the Locandine are often more plentiful and also look great when some other countries posters do not

haven’t found a way for the rest of the stuff to just wrap around the poster no matter the height, unfortunately. I also want to preserve the responsiveness. As you can see when you resize your browser window arbitrarily down to cell phone size and back, it should adapt rather well, but it works with columns…

I fixed a few more things. It is a lot of jumbly HTML code, which will make it a bit of a hassle to apply to the other pages. But from what I can tell it now looks fine no matter the browser window size or device used, have another look, and if you don’t spot any funny business, we can apply it to the other lists. Bear in mind though, that SWDb 3.0 is still not active for 99.9999 % of folks looking at it, so we can also still hold off until we have all things ironed out.

Made some smaller tweaks to the Main page today and in some other places. I will definitely have to redo the Podcast archive, as it uses tabs no longer supported.

Still messing with the film pages and haven’t figured out a good way to do these. Open for suggestions on how to make them look totally different, too…

Implemented the “accordion” on the latest season of the Podcast archive. That should work. Also made a minor tweak to the main page, to make it easier on the eyes.

I would really really love to get more feedback though, I know I am begging, but the SWDb doesn’t fall out of the sky, it needs a plurality of people chiming in, if only with some thoughts and feedback :slight_smile: Thanks

I have been using 3.0now for a while and all seems good. Uploaded some pictures, made some small edits, used forum from laptop and phone. All good.

The bigger issue would seem to be difficulty of finding a practical and versatile layout template for film pages where different format images (i.e. locandine) are used.


I’ll give it a shot this month. Haven’t checked it out yet, as the last time I uploaded about 500 posters and haven’t recovered from the trauma of it yet. But I’ll test it and give some feedback then.

1 Like

Bulk upload is on my list of things to implement

1 Like

Should we switch on SWDb 3.0 for everyone even without having solved the film page puzzle?

  • Yes
  • No
  • What’s 3.0

0 voters

What’s done

  • :white_check_mark: Redo Main Page
  • :white_check_mark: Find a suitable design for the top lists
  • :white_check_mark: Redo Alt Top 20 (thanks, @Phil_H )
  • :white_check_mark: Redo Tarantino Top 20
  • :white_check_mark: Redo Explosive Media catalog , Koch Films catalog, Wild East catalog, Arrow Video catalog, Kino Lorber catalog, DSX Films, Blue Underground
  • :white_check_mark: Design a user page that others can use
  • :white_check_mark: I implemented a plugin that will save a the “best” picture of any page and make it the picture shown when that page is shared on social media etc.
  • :white_check_mark: Found a way to display the podcast archive
  • :white_check_mark: New way to make all kinds of country flags accessible to editors (see below)
  • :white_check_mark: Find a suitable design for the film pages (does not work so well with the locandina format, so we avoid that for the film main pages)
  • :white_check_mark: Redo the whole of the podcast archive
  • :white_check_mark: Redo all the user pages (so far the main ones)
  • :white_check_mark: “Browse all” page (mainly just to make it nicer, use some icons, etc)
  • :white_check_mark: Redo all film pages (done, bar a few exceptions)

What’s still in progress

  • :hourglass_flowing_sand: Redo all other catalogs (in progress)
  • :hourglass_flowing_sand: Redo all other top lists (in progress)
  • :hourglass_flowing_sand: Book pages (in progress)
  • :hourglass_flowing_sand: Books category, articles category, reviews category etc look rather bland
  • :hourglass_flowing_sand: Redo Hall of Fame (in progress: redesign that works on mobile pages; open: new graphics)
  • :hourglass_flowing_sand: Overhaul the links page (content and design)

Question to the poster nerds: are there good quality non-locandina format posters for ALL movies we have in the database? I am asking because if we can count out this super vertical format, designing the film pages might get just a tad easier.

I have uploaded a batch of posters, modified a number of pages and haven’t encountered any issue on my end. Everything seems to be working just fine.

1 Like