Everything posted by atomiku
-
Coding a Facebook Wall / Feed type script. A question of best methods, efficiency and scaling.
Alright. Thanks djitsz. Thread marked as solved. I'll query the tables separately and join the data I need with PHP to be displayed in one feed. I did a benchmark. I selected from the posts table with a size of 1.3M, with a WHERE clause with 1000 IDs in the list. Query took 0.0298 sec. This is good enough. Perhaps in the future I will need to look into sharding, but this will scale for the time being.
-
Coding a Facebook Wall / Feed type script. A question of best methods, efficiency and scaling.
Bump, cause I could really do with some advise on this. Cheers.
-
pastebin.pw - a clean, minimal place for pasting code
Thanks for the feedback. I have updated the design to incorporate Flat UI colours/ideas. Let me know what you think!
-
pastebin.pw - a clean, minimal place for pasting code
Hey - I updated the template + colors last night. @Flay: It is looking much better than the old design. Is there anything more I can do to this now? I plan to make some nice looking custom dropdowns for the Expiry/Privacy.
-
Coding a Facebook Wall / Feed type script. A question of best methods, efficiency and scaling.
I am creating my own. Thanks
-
pastebin.pw - a clean, minimal place for pasting code
Well I had a dark navy-ish blue background in mind, so we're on the same path! There isn't much UI on confessium for me to get inspired from, I'm not really a designer. Does anybody have a design to show me that I could use?
-
Coding a Facebook Wall / Feed type script. A question of best methods, efficiency and scaling.
Hi Web Designer Forum. One of my upcoming tasks is that I will need to create a page that contains a feed, which will be displaying posts from various MySQL tables, but with certain conditions based on the users friends/connections/preferences. Now originally I thought of using a query such as this: SELECT * FROM articles, groups, posts WHERE articles.category = <a category a user has subscribed to> OR groups.id = <a group the user has joined> OR groups.id = <another group the user has joined> OR posts.posted_by = <a person the user is following> AND posts.posted_by = <someone the user has blocked> That's horribly inefficient and the site will grind to a halt once more people start using it, so instead I'm thinking that each user's feed should be a MySQL table that the CMS would add a row to, as a new post or article is added, if the conditions are met. So instead we would just be doing: SELECT * FROM feed_<userID> ORDER BY added DESC I could delete rows from the feed older than two months to keep the table sizes down. Is this the most efficient way I can do this? Will this scale well with 1 million rows? Or is it 1000 rows for each user's own feed table? I can imagine facebook is doing something similar, I just don't know how exactly. Thanks in advance for any advice. atomiku
-
Coding a 'Facebook Wall' type script. A question of efficiency and scaling.
Hi Web Designer Forum. One of my upcoming tasks is that I will need to create
-
pastebin.pw - a clean, minimal place for pasting code
Well thank you very much for your feedback. The first bit of progress I intend to make would be to change the design around to make it look slicker. I might go for dark colours this time round. Forking is a good idea too. I'll add that to the todo list in my original post. I see that as a top priority now so I will complete the forking functionality as I redesign the site. Thanks!
-
How can I dynamically take some content and put it into equal columns?
No worries, guys. What I'm trying to do is use CSS3's columns but then also have these columns to be responsive. It's just not going to work. I'll have to code a jQuery solution to do it manually. I'll post the code up here if I get around to coding it. Cheers.
-
How can I dynamically take some content and put it into equal columns?
I don't mind using CSS columns. But how can it be split into 2 columns (divs) where each of the DIVs has its own class/id? Look at my original post, I'd like a .slot-0-1 and .slot-2-3 class.
-
How can I dynamically take some content and put it into equal columns?
With due respect, I disagree. I have an idea how this would be done with jQuery. Cycle through all the elements that you want to split (images, paragraphs, etc), work out the heights of all these elements, and then calculate which elements to move over into its own column. I could do this myself but I am looking for a solution that's already out there. Mainly because an existing plugin would already have had a lot of time and effort put into it to ensure it works nicely without any bugs. The same bugs that I would most likely encounter while trying to do something like this myself. Basically, I'm not looking to reinvent the wheel here. If I do happen to find a good solution to this before anyone here does, I'll make sure to report back incase anyone finds this thread in the future. Regards ~atomiku
-
How can I dynamically take some content and put it into equal columns?
Hey there, I'm using a CSS responsive grid system and I have something like below: <div class="grid"> <div class="slot-0-1"></div> <div class="slot-2-3"></div> <div class="slot-4-5" style="text-align:right;"> <img src="/includes/img/aboutinfo.png" alt"" /> </div> </div> I'd like to take some dynamic content (paragraphs of text) and split it equally into the two div columns: .slot-0-1 and .slot-2-3. I really can't think how I might do this, I'd like to use CSS3's column feature but I don't think it will work with the responsive grid system I am using. Are there any decent jQuery solutions out there I can use? Thanks! ~atomiku
-
I have 6 inline-block fixed width divs, but the container is fluid. How can I split the inline-blocks evenly based on width?
Thanks D4Y0. I will stick with your solution as I think it will work fine. If I encounter any problems implementing it into the design I'll have to code up a jQuery solution. FYI: The boxes may not be pre-defined widths, but regardless they will always be the same width as each other. Whether it may be 150 or 200.
-
I have 6 inline-block fixed width divs, but the container is fluid. How can I split the inline-blocks evenly based on width?
Almost! Now lets say I might not know the width of the inline-blocks, and I can't manually define a max-width media query, then what would I do? Your solution is almost working, but as the browser sizes down even more, I get this below: Really, it should be arranged into 3 rows of 2, so everything is even. I'm guessing that if I don't know the width of the divs, I'll probably need a jQuery solution.
-
I have 6 inline-block fixed width divs, but the container is fluid. How can I split the inline-blocks evenly based on width?
Pretty much, yes. The whole design is responsive. Just at certain widths I get 'widow' divs, which looks absolutely horrible!
-
Maths problem! I have a range of -1000 to 0. When percent is 100 I need value of 0, when percent is 0 I need value of -1000
Thanks guys. The below code was working perfectly for me: function theValue(percent, min, max) { return min + (max - min) * percent / 100; } Probably similar to D4Y0's solution
-
I have 6 inline-block fixed width divs, but the container is fluid. How can I split the inline-blocks evenly based on width?
Hey guys. I have something similar to the below code: <div class="container" style="width:100%;"> <div style="display:inline-block;width:100px;height:100px;border:2px red solid;">One</div> <div style="display:inline-block;width:100px;height:100px;border:2px red solid;">Two</div> <div style="display:inline-block;width:100px;height:100px;border:2px red solid;">Three</div> <div style="display:inline-block;width:100px;height:100px;border:2px red solid;">Four</div> <div style="display:inline-block;width:100px;height:100px;border:2px red solid;">Five</div> <div style="display:inline-block;width:100px;height:100px;border:2px red solid;">Six</div> </div> Now, as the container div sizes down, the 6th inline-block div would move down a line on its own. But how can I split all these inline-blocks evenly? For example, if the sixth div can't fit, it would split the inline-blocks by 2 rows of 3. And then 3 rows of 2. And then, eventually, 6 rows of 1. Many thanks! I was thinking of a javascript solution perhaps, but maybe there's a clever way to do it in pure CSS. ~atomiku
-
Maths problem! I have a range of -1000 to 0. When percent is 100 I need value of 0, when percent is 0 I need value of -1000
So essentially I need a function that takes three arguments: min, max, percent func(-1000, 0, 50) should return -500, func(-1000, 0, 100) should return 0 and func(-1000, 0, 0) should reutrn -1000. I've been stuck on this for hours now! Anybody know how I could do this? Problem is im using a negative range. Thanks in advance. ~atomiku
-
pastebin.pw - a clean, minimal place for pasting code
Hello! Was just browsing through the forums, seeing as there is a place to show off websites I thought I'd take the opportunity to show a pastebin website I created a year back, http://pastebin.pw/ There are a few features I have planned, for when I have the time: - Ability to upload a file instead of pasting it - Trending Pastes (which pastes are most popular right now?) - Upvote/Downvote - Diff Comparison - The ability to leave comments on pastes - User Registration - Search - Password protected posts Any feedback and suggestions would be highly appreciated. Pastebin. Regards, ~atomiku
-
Explaining Google, backlinks and link buidling
Hey, well I certainly feel left in the dark with what google have been doing. I've lost confidence in doing SEO for clients now, and refuse to take on any more SEO jobs. It'd be handy to get a direct link to the article you posted up though. I had a look at the link in your signature but the section I looked at pertaining to Google/SEO didn't really seem to explain what I am looking for... which is: the do's and dont's of SEO strategies in relation to the recent google algorithm updates.
-
Change in URL Structure
Jack, it's possible you could do something like /latest-news/ to /news/2013/... but I might need an example of your URLs. /latest-news/news-post-title/ /latest-news/first-post-hello-world/ If you wanted to forward those to /news/2013/post-title/ instead, you could use the following rewrite rule: RewriteEngine On RewriteRule ^latest-news/(.*)(/|)$ http://foo.com/news/2013/$1/ [R=301,L,NC] Now, the (/|) after the (.*) will optionally match a trailing slash at the end. http://foo.com/latest-news/post-title would now redirect to http://foo.com/news/2013/post-title/ --- This is assuming all your new post URLs are to have 2013 in them, and not 2012 or 2011! If this won't work for you, there is the option of forwarding latest-news/(.*)/ to a PHP script, which would look up the post and then redirect to the correct URL via a 301 redirect. Below is a quick example: RewriteEngine On RewriteRule ^latest-news/(.*)(/|)$ http://foo.com/redirect.php?post=$1 [R=301,L,NC] ~atomiku
-
A separate copy of the site for each office, duplicate content, question about canonical tags
Hi BlueDreamer, thanks for your reply. This time round it's the designer's approach rather than the client's. The idea is that the customer would find the London Office or Scotland Office via Google, and then if he or she is coming to the landing page via a 'regional' google result, then the customer is sort of locked into that office while navigating around. Although there is a dropdown for 'Other Offices' on the main menu. I understand that it may have sounded confusing but the idea works quite well in this case because of how the design and sitemap are. If you guys reckon canonical will be okay, then great, I'll go ahead and use that. ~atomiku
-
Change in URL Structure
Hey Jack, I recently did something similar. You can use Google Webmaster Tools if you need to figure out which URLs are currently active. Then, yes, use 301 redirects with .htaccess. Here is an example of what I did: RewriteEngine On RewriteRule ^old_url.html$ http://foo.com/new_url.html [R=301,L] RewriteRule ^contact/$ http://foo.com/contact.html [R=301,L] You will need to specify full URLs for your rewrite rules. Note the ^ and $. If you do not use them, and use old_url.html instead of ^old_url.html$, then the rule would also match anythingold_url.htmlanything. ~atomiku
-
A separate copy of the site for each office, duplicate content, question about canonical tags
Hello Web Designer Forum. First post here, so hi! I am currently redeveloping a website for a client and they would like a separate version of their website for each of their offices. This is mainly for navigation + contact information purposes, as the contact information for the office would be visible throughout the website as they are navigating through the content. For instance, lets say they are offering Service A and Service B. Depending on which office they are within, the URLs would be as such: http://foo.com/london-office/service-a/ http://foo.com/london-office/service-b/ http://foo.com/scotland-office/service-a/ http://foo.com/scotland-office/service-b/ The service a and service b pages are identical, except for the primary navigation which varies depending which office you are within. I would like search engines not to see this as separate content. So would it be okay to set the canonical tags as: http://foo.com/service-a/ http://foo.com/service-b/ Thanks in advance for your help, hopefully I can get some advice about duplicate content and canonical tags. And check out http://pastebin.pw/ if you need somewhere to paste code. Regards, ~atomiku