Web Dev Questions That Don't Need Their Own Thread v4

[01271]

snip.

[KmartSqrl]

[QUOTE=RidingKeys;42015490]Ah so then W3 is just doing their own certificate thing, it's not a real certificate as in something like a Microsoft Masters Certificate?[/QUOTE]

w3schools certification has nothing to do with the w3c and is pretty much worthless.

[Shadow801]

[QUOTE=RidingKeys;42015490]Ah so then W3 is just doing their own certificate thing, it's not a real certificate as in something like a Microsoft Masters Certificate?[/QUOTE]

People get fooled by w3schools certifications so much, it frustrates me that they won't acknowledge they are not related to the w3c at all

[StinkyJoe]

[QUOTE=Shadow801;42019045]People get fooled by w3schools certifications so much, it frustrates me that they won't acknowledge they are not related to the w3c at all[/QUOTE]

Not to mention passing the certification is only slightly harder than wiping your ass.

[Minteh Fresh]

When I am on [url]www.johndoe.com[/url] (this forum has a shoutbox / chatbox) and I open Chrome's Console thingo (Ctrl + Shift + I) and type in [B]MGCCbEvoNS.send_chat_post("meow")[/B] it will post meow in the chatbox.

Is it possible to do the same thing, but without needing to be ON the website via URL? For example - can I use[B] www.johndoe.com/MGCCbEvoNS.send_chat_post("meow")[/B] or something like that to send a message to shoutbox?

>Not sure why you rate me dumb, this is a question - and this is a question thread.. :c

[Coment]

[QUOTE=Minteh Fresh;42019665]When I am on [url]www.johndoe.com[/url] (this forum has a shoutbox / chatbox) and I open Chrome's Console thingo (Ctrl + Shift + I) and type in [B]MGCCbEvoNS.send_chat_post("meow")[/B] it will post meow in the chatbox.

Is it possible to do the same thing, but without needing to be ON the website via URL? For example - can I use[B] www.johndoe.com/MGCCbEvoNS.send_chat_post("meow")[/B] or something like that to send a message to shoutbox?

>Not sure why you rate me dumb, this is a question - and this is a question thread.. :c[/QUOTE]

NOTICE: This domain name expired on 08/06/2013 and is pending renewal or deletion. Renew It Now!

I wonder why :v:

[Minteh Fresh]

[QUOTE=Coment;42020061]NOTICE: This domain name expired on 08/06/2013 and is pending renewal or deletion. Renew It Now!

I wonder why :v:[/QUOTE]
The website isn't actually Johndoe.com, I was just using it as an example; for I don't want to advertise.

[Maqtiah]

[QUOTE=KmartSqrl;42010243]Screenshot?[/QUOTE]

[url]http://gyazo.com/5c38396efec101d9f1e35ae9a07bdeba[/url]

[eternalflamez]

Isn't that like, part of the scrollbar though?

[editline]30th August 2013[/editline]

By zooming in an awful lot I get this, so it's there on both sides:

[img]http://puu.sh/4eJtp.jpg[/img]

That's on Chrome, btw.

[inaba]

[QUOTE=Moofy;42020090][url]http://gyazo.com/5c38396efec101d9f1e35ae9a07bdeba[/url][/QUOTE]

As far as I know, that is standard on windows browsers.
I can't say for other operating systems

[editline]30th August 2013[/editline]

Ahh, beaten by too long

[Matoking]

I've been having really severe performance problems with my pastebin site :
[url]http://bitbin.it[/url] (try it, it's probably down)

I've been hosting it on a VPS with 1 GB of RAM for a while using MySQL and Memcache. Since the site needs to keep track of unique hits (one unique hit counted as user having seen the paste at least once during the last 24 hours). In a normal case I get a cached entry from Memcache/run a SELECT * FROM query to check if user has seen the paste then INSERT an entry if he hasn't and then UPDATE it later to mark the entry as being validated as a part of some anti-bot measures.

Now, the problem is, I've been recently getting a huge load of visitors and this table has swollen to size of 420 MB with about 2.8 million entries now that I checked, even though I periodically delete entries that are older than 24 hours. I also use Memcache for a lot of things that can be cached relatively easily (paste content, stats and whether a visit record exists) but the site still slows down a lot due to this.

Should I implement this thing differently or upgrade my VPS so I can use more caching and move the "unique hits" table into RAM while occasionally copying it into the physical hard drive? Or should a 1GB VPS be able to work better than this?

[rsk_]

[QUOTE=Matoking;42030081]I've been having really severe performance problems with my pastebin site :
[url]http://bitbin.it[/url] (try it, it's probably down)

I've been hosting it on a VPS with 1 GB of RAM for a while using MySQL and Memcache. Since the site needs to keep track of unique hits (one unique hit counted as user having seen the paste at least once during the last 24 hours). In a normal case I get a cached entry from Memcache/run a SELECT * FROM query to check if user has seen the paste then INSERT an entry if he hasn't and then UPDATE it later to mark the entry as being validated as a part of some anti-bot measures.

Now, the problem is, I've been recently getting a huge load of visitors and this table has swollen to size of 420 MB with about 2.8 million entries now that I checked, even though I periodically delete entries that are older than 24 hours. I also use Memcache for a lot of things that can be cached relatively easily (paste content, stats and whether a visit record exists) but the site still slows down a lot due to this.

Should I implement this thing differently or upgrade my VPS so I can use more caching and move the "unique hits" table into RAM while occasionally copying it into the physical hard drive? Or should a 1GB VPS be able to work better than this?[/QUOTE]

Perhaps you can try using external MySQL server(s) such as those hosted by Amazon, that could speed up your application quite a bit.

[josm]

Considering I basically have no knowledge of PHP, do you guys think it would be a good idea just to start Ruby/RoR? And drop PHP completely?

[rsk_]

[QUOTE=nehkz;42030989]Considering I basically have no knowledge of PHP, do you guys think it would be a good idea just to start Ruby/RoR? And drop PHP completely?[/QUOTE]

Yes, I might get started with them soon (and maybe even transition over to them).

[Qaus]

is there any way to make this adblock (chrome) compatible?

<table id="cid:asdf" cellpadding="0" cellspacing="0" class="container-comment" width="100%" data-timestamp="1377908250">
	<tbody><tr>
		<td width="20" height="21">&nbsp;</td>
		<td rowspan="3" class="icon">

							<a href="/user/dumbass/"><img src="not important" alt="dumbass"></a>
			
		</td>
		<td>
			<div class="menu">
				<ul>
					<li>
													<b class="replyto-name">Dumbass</b>
							<ul>
								<li><a href="/user/dumbass/">User Page</a></li>
								<li><a href="/gallery/dumbass/">Gallery</a></li>
								<li><a href="/journals/dumbass/">Journals</a></li>
								<li><a href="/newpm/dumbass/">Send Note</a></li>							</ul>
											</li>
				</ul>
			</div>
		</td>
	</tr>
	<tr>
		<th width="20" class="lead">&nbsp;</th>
		<th class="lead"><h4>(<a href="#cid:asdf" title="Permalink to this comment"> <i><b>No Subject</b></i> </a>) Posted: <span title="14 hours ago" class="popup_date">August 30th, 2013 05:17 PM</span></h4></th>
	</tr>
	<tr>
		<td width="20">&nbsp;</td>
		<td class="replyto-message">
                        <strong class="bbcode bbcode_b"><span class="bbcode" style="color: #56A5EC;">dumb shit nobody wants to read</span></strong>            <br><br>
        </td>
	</tr>
		<tr>
		<td colspan="3" class="cat"><span class="reply-link"><a href="/replyto/submission/asdf/">Reply to this post</a></span></td>
	</tr>
	</tbody></table>

i don't want other comments to be blocked, and every comment has a unique timestamp and comment id that has to be ignored.

[lorde banana]

[QUOTE=Matoking;42030081]I've been having really severe performance problems with my pastebin site :
[url]http://bitbin.it[/url] (try it, it's probably down)

I've been hosting it on a VPS with 1 GB of RAM for a while using MySQL and Memcache. Since the site needs to keep track of unique hits (one unique hit counted as user having seen the paste at least once during the last 24 hours). In a normal case I get a cached entry from Memcache/run a SELECT * FROM query to check if user has seen the paste then INSERT an entry if he hasn't and then UPDATE it later to mark the entry as being validated as a part of some anti-bot measures.

Now, the problem is, I've been recently getting a huge load of visitors and this table has swollen to size of 420 MB with about 2.8 million entries now that I checked, even though I periodically delete entries that are older than 24 hours. I also use Memcache for a lot of things that can be cached relatively easily (paste content, stats and whether a visit record exists) but the site still slows down a lot due to this.

Should I implement this thing differently or upgrade my VPS so I can use more caching and move the "unique hits" table into RAM while occasionally copying it into the physical hard drive? Or should a 1GB VPS be able to work better than this?[/QUOTE]

Have you done the generic optimizations to your database? Like, setting up indexes/keys and using smart queries (ie. adding LIMIT 1 to the end of queries that should only return one result)

[Matoking]

[QUOTE=Banana Lord.;42031254]Have you done the generic optimizations to your database? Like, setting up indexes/keys and using smart queries (ie. adding LIMIT 1 to the end of queries that should only return one result)[/QUOTE]
Yes, I have added indexes where necessary and use LIMIT 1 in every SELECT query that only needs to fetch one row. I have also modified the MySQL configuration file using values suggested by [URL="https://raw.github.com/major/MySQLTuner-perl/master/mysqltuner.pl"]MySQLTuner[/URL]. The database engine I use at the moment is InnoDB.

[Richy13]

Can I get your opinion on something?
I have recently been using ServiceStack a lot for work and I quite like the way it operates, how you can create your own request and response types and it just binds them behind the scene.
I have also been looking at how RoR operates and I like how organized it is and how it manages things for you however im not a massive fan of ruby.
Im thinking of writting a web service along with a front end website, and probably use heroku therefore I cant use C#, so out of the 4 languages it supports (considering java and scala as 1) I am more geared towards java and was wondering if there are any definite alternatives to servicestack for java?
I have looked at Play and Grails and although they seem more like a RoR alternative in java Play does seem to offer features I quite like(even though I dont think its as elegant as SS but I feel like thats more a languages thing than a framework thing), but I just wanted to check if I was missing any obvious alternatives.

[KmartSqrl]

[QUOTE=Richy19;42033577]im not a massive fan of ruby.[/QUOTE]

Out of curiosity, why not? Have you spent a significant amount of time using it?

[Richy13]

[QUOTE=KmartSqrl;42034686]Out of curiosity, why not? Have you spent a significant amount of time using it?[/QUOTE]

Not a big fan of dynamic languages, plus I like the fact that you can catch a lot of errors at compile time with compiled languages

[Epiclulz762]

- snip -

[Stonecycle]

I'm completely clueless on source control. Zero experience besides knowing there's Git and Mercurial. This might be a subjective question, but which would generally be better? Can't get a straight answer from searching. What exactly is source control used for?

[CBastard]

[QUOTE=Matoking;42030081]In a normal case I get a cached entry from Memcache/run a SELECT * FROM query to check if user has seen the paste then INSERT an entry if he hasn't and then UPDATE it later to mark the entry as being validated as a part of some anti-bot measures.
[/QUOTE]

Are you actually using "SELECT *"? If so only selecting the specific columns you need in the query instead can reduce the load.

Also MySQL by default has fairly restrictive memory settings which you should be able to raise.

What is the server's memory usage?

[editline]31st August 2013[/editline]

[QUOTE=Epiclulz762;42035050]This is what I have put together with JavaScript + HTML + CSS and I am trying to avoid using HTML5.
My only current issue is I can only hover and click over every-other grid and not each individual one.
[T]http://i.imgur.com/jn6V8CS.png[/T]

Any recommendations on creating an isometric field with click-able grids?[/QUOTE]

If you need to avoid 'HTML5' There is the <map> element which lets you map links to co-ordinates on an image in whatever shape you want.

[url]https://developer.mozilla.org/en-US/docs/Web/HTML/Element/map[/url]

A better way would be to do it with Canvas or use inline/embedded SVG, both of which are HTML5.

[Epiclulz762]

- snip -

[Epiclulz762]

- snip -

[Matoking]

[QUOTE=CBastard;42035118]Are you actually using "SELECT *"? If so only selecting the specific columns you need in the query instead can reduce the load.

Also MySQL by default has fairly restrictive memory settings which you should be able to raise.

What is the server's memory usage?
[/QUOTE]
I use SELECT * FROM most of the time, but pretty much all of the rows are very light-weight except for paste content (actual text, not stats, syntax and other information) which is stored in a separate table. Still, I suppose selecting only the needed columns could help in the long end, so I'll give it a try.

As for memory usage.
[IMG]http://i.imgur.com/1t1pZUY.png[/IMG]

And these are the settings I've changed in the MySQL configuration file.

[mysqld]
table_cache=512
tmp_table_size=32M
max_heap_table_size=32M
innodb_buffer_pool_size=400M
innodb_log_file_size=90M
innodb_log_buffer_size=8M
query_cache_type=1
query_cache_limit=64M
query_cache_size=96M
thread_cache=16
long_query_time=1
max_connections=128
wait_timeout=30
table_cache=512

I also realized that I haven't installed a PHP opcode cache like Xcache. Just started looking into it.

[smithy285]

I don't really know where to post this, so I assumed here might be the correct place.

I am looking for a system where I can get the basic information from a few people's Steam accounts. I am currently using this sites; [url]http://steamapi.techieanalyst.net/[/url] sAPI signature feature, however is it slow loading.

I need something that is fast.

[Khub]

[QUOTE=smithy285;42041135]I don't really know where to post this, so I assumed here might be the correct place.

I am looking for a system where I can get the basic information from a few people's Steam accounts. I am currently using this sites; [url]http://steamapi.techieanalyst.net/[/url] sAPI signature feature, however is it slow loading.

I need something that is fast.[/QUOTE]

[noparse]http://steamcommunity.com/profiles/< SteamID 64 >/?xml=1[/noparse]

example response: [url]http://steamcommunity.com/profiles/76561198030474827/?xml=1[/url]

[01271]

[QUOTE=smithy285;42041135]I don't really know where to post this, so I assumed here might be the correct place.

I am looking for a system where I can get the basic information from a few people's Steam accounts. I am currently using this sites; [url]http://steamapi.techieanalyst.net/[/url] sAPI signature feature, however is it slow loading.

I need something that is fast.[/QUOTE]

[url]http://api.steampowered.com/ISteamUser/GetPlayerSummaries/v0002/?key=[/url] $APIKey &steamids=76561198013370444,76561198042622888,76561198008891417,&format=json

Takes up to 100 profiles as arguments.

[Matoking]

I installed Xcache (currently it's getting 142 hits per second), optimized queries and database tables and it seems to have become considerably faster, so the issue might have not been completely related to MySQL. I'm still kind of new to this, so any tips on improving web server performance would be appreciated.

I'm currently using Apache HTTP Server but I've also heard lighttpd mentioned a few times; is it any faster?