This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
2866
The Pub / Re: Skin showdown
« on August 29th, 2012, 06:47 PM »
Huh, it is on. What about the server error log then?
2867
The Pub / Re: Skin showdown
« on August 29th, 2012, 02:24 PM »But debugging won't show anything -- because the page is empty in the first place. Completely blank.
2868
The Pub / Re: Skin showdown
« on August 28th, 2012, 08:10 PM »Oh, and once again, your post didn't bring up a warning on my side when I posted my message!
And what do you think of the crash bug?
2869
The Pub / Re: Skin showdown
« on August 28th, 2012, 08:01 PM »Because there's only so many ways you can present a list of messages with a userbox next to it...
2870
The Pub / Re: Getting ready for an alpha release...
« on August 28th, 2012, 05:07 PM »I don't see the point of using youtube-nocookie, really..? Aren't you being a bit paranoid? What's in that cookie anyway?
It's either iframe or flash, not both. Although I did keep the flash version in a comment and explained how to reset it... And you could just as well include a new sitelist entry with the flash version, so that you could choose from the admin area, but that would imply you can't have both enabled at the same time obviously, and that would be confusing to do by default.
sorry for taking some time off from time to time!
So I can estimate that an English-speaking community of decent size could easily surpass the 64K limit in a few months time. You just need a few people to keep creating and then deleting their own albums or blogs because 'they don't know how to manipulate this stuff'
Still, if you have lots of boards and albums, the first thing you want to do is buy more computing power... More RAM, more disk space, etc. You can't have everything for free. If your site is slow, then maybe your hosting isn't suitable for you. See what I mean...?
So, I'm keeping a low figure and suggesting to switch both 'id_board' and 'id_group' from smallint(5) unsigned to mediumint(8) unsigned. (Well, signed for id_group.)
Or is it still too much...?
I was talking about the MySQL side. I mean, MySQL also has to parse the query before executing it... We're providing a string, not binary code
Under the first stage you're dealing with:
SELECT fields
FROM table
INNER JOIN table
WHERE field IN (list of values)
vs
SELECT fields
FROM table
INNER JOIN table
WHERE (SELECT value FROM table WHERE field = something)
From a pure parsing stage it almost doesn't make any difference, but it's because parsing is very quick anyway. The real grunt is how that query is actually executed, not how it is parsed.
Privacy settings will eventually be on their own tables anyway...? (I'm thinking of committing at least the table structures -- privacy_thoughts, privacy_boards and privacy_topics.)
This is the only way that we can realistically allow for multiple privacy settings on a single element, e.g. "allow my friends and my co-workers on my blog, but not my family." Well, other than having a comma-separated field of groups, of course... (?!)
Err... Modders WILL have to rewrite their code entirely to fit Wedge anyway... Might as well ask them to re-learn everything at the same time, eh.
Telling modders that if they want to adhere to board privileges, they just have to use {query_enter_board} or whichever one it is, is nice and easy. Telling them that to do it with an extra join and whatnot is a lot more complicated to explain.
To use a join, you mean?
And faster?/quote]
Yes, a join will typically be faster when you're getting into thousands of rows.
2871
The Pub / Re: Skin showdown
« on August 26th, 2012, 08:07 PM »Anyhow, I'd like to know.
(I see also you're as bad as I was about leaving/never returning.)
The key was to balance the two: being innovate and staying mainstream.
this is not to boast, but just look around and check
Whether that actually made it less than it could be, that if I had made, or someone else, had made a more vb-like theme..would SMF2 be MORE popular?
So your argument about it not being fun is wrong I am afraid, as well as Curve being like the others out there..IMHO its quite distinct, for bad or for worse.
But it also has a lot of similarities, because form follows function. The structure of the board, message and thread indexes follow the same structure as 1.1 and 1.0 and back. And I still believe that is because that is what is expected. You can do unique designs for unique sites but you have to return to the conventions for the base.
(If you're going to argue with what I'm saying, argue the points I'm making, not side points. I was wrong about it being fun. It's different, no argument, but the point I'm making is that its function follows all the others, and that there ARE a lot of design consistencies with other systems, like the fact there's still a lot of blue in it, even if it is accented with orange, it's still primarily blue.)
Blue is a calm color, it gives off a sense of stability and strength that no other color can match. I think its just a color-choice made from that angle - not to suit every site as such.
And...adding a sidebar isn't really that innovative, despite what you might think
Hence, people like changes - but in small doses and applied evenly.
2872
The Pub / Re: Getting ready for an alpha release...
« on August 26th, 2012, 04:31 PM »Still, do we want Wedge to be used only on small forums? Do we want to have people complain that we didn't see the bigger picture?
The most insane SMF board I have seen in the wild had 700 boards, the most insane I've ever made had 2000 boards. And believe me when I say that performance is screwed so very badly once you get into those realms.
Of course it's easy enough for an admin to change their field sizes... But I just wanted to do it now. Otherwise, we could just as well limit the id_member field to a smallint, because, well, most forums have a dozen members anyway...!
It's all about what is practical, and where it is likely to grow. I accept that boards are in the future more likely to grow than before, due to the intentions of using boards for albums and so on. But even at this point in time I cannot realistically expect sites to go over that. Yes, there are going to be sites that do, but I don't want to penalise everyone for the sake of the minority.
People are going to want to run Wedge on shitty hosting. It's a fact of life, and that no matter how shitty their hosting is, they're going to want to run Wedge on it. And it's going to mean people are going to run into issues. It's hard enough with the number of people who have trouble with SMF on shitty hosting - and we're going to have more issues, not less, by making it bigger.
I'm not sure a subselect would be any slower than a very long query, which Wedge always has to parse anyway...
Then, if we start from this, there's also no way we can have privacy settings for topics, posts, etc...
IN() is essentially a shortcut for OR clauses. column IN (1,2,3) is functionally equivalent to (column = 1 OR column = 2 OR column = 3) (brackets for the purposes of precedence etc.)
On a few values, like privacy, it's fine. But when you're talking about hundreds or thousands of values, it's going to suck however you do it. And not because of the parsing in the DB layer to get it into the query, it's going to suck once the thousands of rows are figured out in the subselect.
Not that complicated. Noisen does have that... Joins instead of subselects for privacy settings.
It just requires to rewrite all queries, which is annoying, but it wouldn't be a first.
It does have other consequences, too, not just rewriting all the queries which use query_see_board and all its friends, but on top of that you also have to consider the ball-ache it's going to create for modders on top. Yay.[1]
So, last time we discussed join vs subselect, I think you came to the conclusion that performance benefits were not obvious..?
Privacy is so cool.
| 1. | And no, this isn't just a case of 'The only winning move is not to play', not really. There are no good solutions. The current one is tolerable, leaning on it harder is going to cause a lot of trouble. I need to go away and think about what's really best here. |
2873
The Pub / Re: Getting ready for an alpha release...
« on August 26th, 2012, 02:52 PM »Leaving id_board as a smallint means limiting ourselves to a forum that doesn't have successful boards, successful blogs and successful galleries... (and especially, not all three of them!)
If they have that much stuff, they're likely going to run into other problems too.
Here's the fundamental question: do you make life easier for the select few truly huge sites at the cost of making it slower for every other user? You cannot have it both ways.
Well... Again and again: what is wrong with using a subselect..?
Right now the clause evaluates to 1=1 for admins and WHERE b.id_board IN (...) AND b.id_board NOT IN (...) (the last part is not all the time, but it can be, put it that way)
IN() clauses are not efficient, because internally they are evaluated to WHERE value = 1 OR value = 2 OR value = 3 etc.
Now, wrapping it in a subselect won't solve anything at all because all you end up doing is making it WHERE b.id_board IN (SELECT ...) - which ultimately becomes the same thing, except that you're not even making use of any cache this time.
As far as I can figure out, the only way to make it more efficient is to rewrite all the queries not to use a subselect and to force the board stuff to be conventionally joined, and conventionally excluded (where you have deny) which makes all queries that use query_see_board and its friends all get a way lot more complicated.
Just search for the ManagePlugins history (and install.sql), at some point you added three new fields (username, password and another) to the package_servers table. Don't ask me why...
2874
The Pub / Re: Getting ready for an alpha release...
« on August 26th, 2012, 01:17 AM »What about we just set id_board to a mediumint, and same for id_group..? We can increase their size again later... No? Because I really don't see myself leaving id_group be like that... Increasing its size will be an incentive for early release of contact lists.
Hmm, yeah, yeah...
There are already lots of changes btw... I'm sure the old packman no longer works, here. I know that it crashed my local install because of a few missing fields.
* Arantor is all out of ideas for the other stuff, going through the social services paperwork is thoroughly draining :(
2875
The Pub / Re: Getting ready for an alpha release...
« on August 26th, 2012, 12:23 AM »Couldn't we at least update the most crucial ones, like the id_group stuff..?
What could be done, sorta, is getting the new install.sql file, and doing a pseudo installation, i.e. running it with a setting of db_prefix = db_prefix + 'temp_install_whatever', and then compare the tables... (Or whatever.)
That's why I want to be sure that it works as is, right now...
This would allow skinners to create index.mobile.css files for mobile devices.
However, all devices go through the mobile path, and thus are usually redirected to the Wireless skin, so it might be a bit overkill to additionally offer this keyword...
2876
The Pub / Re : Re: More thoughts on SMF 2.1
« on August 25th, 2012, 11:44 PM »
I like both but I've become somewhat used to the one on the right.
2877
Off-topic / Re: Nexus 7
« on August 25th, 2012, 01:29 PM »
Home > Settings > General > About > Diagnostics & Usage > Diagnostic & Usage Data > each crash is a separate plist entry.
2878
Off-topic / Re: PHPSESSID Brute force
« on August 25th, 2012, 01:24 PM »That's all I'm saying... An option, disabled by default ;)
(Removing the ban system? You mean the IP ban system, right...?)
2879
The Pub / Re: Skin showdown
« on August 25th, 2012, 05:26 AM »Thanks for getting back Pete, very sorry if Ive offended it was'nt my intention.
Have done - remark was tongue in cheek - drawing on pun, I suppose not in the best of taste.
That may be the case but I was under the impression what you were doing with Wedge WAS different to the norm - socialization, board structure the whole package.
Yes there are reasons why you branched from SMF but the underlying motivation was surely one that was centred on improvement. Why create Wedge if change wasn't required?
Change for the sake of improvement is great. And there is a lot of change for the sake of improvement. However, change for the sake of change is not improvement.
A forum has certain functional requirements that have to be adhered to. There's only so far you can go from those functional requirements and still remain generically usable for a lot of sites. As I demonstrated on Game Memorial, you can do some very nice customisation but that customisation is simply not suitable for every single site. I applied a setup that turned a board into a blog. But it won't suit most forums. It will make a difference for blog boards, sure, but I guarantee that what I did on GM will likely not be suitable for most sites if any others. (I'm not entirely sure it works on GM at this point, but hey, it's experimental.)
Its impossible to believe Wedge falls in the category of a huge customisation. You have invested so much energy and sacrifice into something that was for purely for supposed personal use? The vibe im getting is your striving for so much more than a streamlined 10 year old system that works.
That said, can you really convince me that the thoughts/conversation system will be suitable for most sites, for example? It's basically reimplementing what's on Noisen, however it's likely to be usable enough for a lot more sites, so it got included.
Also note that there's not a great lot of code that's actually original from 10 years ago ;)
Personally, the whole exercise seems like a new beginning in forum software hence my remarks on endeavouring to create a fresh approach with themes, not as an adjunct but a marketing ploy which coincides with the release of Wedge.
Let's take Bloc as a classic example. How enthusiastic do you think he was when designing Curve, as opposed to all the other creative themes he's done? Can you also imagine *ANY* of Bloc's newer themes being the default for ANY forum package, which by definition has to be a base, rather than the end product?
1. Yes people are resistant to change but theres a whole world out there thats also receptive to it. I feel your not comparing apples with apples where Wedge and Facebook is concerned - Theyre @ different stages of development.
There is a whole world receptive to change. Except they're by far the minority. And even then, they're not receptive to change for the sake of change, they're receptive to change when they're aiming for a specific change or improvement - or getting anyway from a specific bug or issue.
Consideration to UI would have taken place well in advance of its emergence onto the marketplace. With the release of any new product there is an overall focus on design/function first and foremost, then brandname.
Yes, there is an overall focus on design/function first and foremost. And that's the crux of this debate. We have a fundamental functional requirement to meet. Major UI overhauls will not change that fact, and there's a reason why forum UI has not significantly altered in over a decade - no-one has yet been able to improve upon it in a meaningful way for the majority of users. Yes, individual users and individual sites might have specific improvements but we simply can't just include major UI shifts in the base software, no matter how much people complain.
Although they are separate entities they are inextricably linked. Before release to public the product passes through prototype phase which Wedge is currently in.
From a user experience standpoint, we're iterating on top of what is in SMF 2.0. There's a lot of iteration in some places, less in others.
Wedge is not really prototyping user experience, it's mostly a technical phase of prototyping. I fully expect way more iteration to occur in response to user feedback - because it's a constant iterative process, not the conventional product evolution process that physical products have.
Which is what Im concentrating in my own way. Facebook would certainly have gone down this road as its an essential ingredient of the products makeup. It defines it as too does its packaging.
There's an addage that I draw on from time to time and it holds true - namely, "form follows function" but it has to be remembered they go hand in hand.
Form follows function, quite right. The function of a forum hasn't changed in decades. Small parts of the process have. Specific implementations might also have changed. But the bulk of operations have not changed. As a result, the theme in Wedge needs to follow that approach. There is really very little major change we can do to the form of Wedge as a consequence.
The first analogy I would have expected in relation to Wedge and Facebook is "What are the reasons for its popularity". Facebook was certainly a new concept in social media as indeed Wedge is in its realm - You guys have that area covered but and its a big one - Consideration to UI is not wasted and is equally important in Wedges case
2. By now you will have realized that I disagree with you on your latter point - Im feeling much happier that ive got it all off my chest though.
Point of interest: why do all the forum software packages out there at present have a default theme based around the colour blue? Why do they do this, I wonder? Could it be that they have to be carefully neutral across all the different uses that their software will generate and that they have to remain neutral to allow users to customise for their specific site?
2880
The Pub / Re: Skin showdown
« on August 25th, 2012, 03:29 AM »
Um, Weaving is the default skin of Wedge itself, that means Wedge = Weaving from your post...