When doing an ALTER TABLE statement in MySQL, the whole table is read-locked (allowing concurrent reads, but prohibiting concurrent writes) for the duration of the statement. If it's a big table, INSERT or UPDATE statements could be blocked for a looooong time. Is there a way to do a "hot alter", li...

... The general rule is that popup blockers will engage if window.open or similar is invoked from javascript that is not invoked by direct user action. That is, you can call window.open in response to a button click without getting hit by the po...

... Try this markdown:  I think you can link directly to the raw version of an image if it's stored in your repository. i.e. ![alt text](https://github.com/[username]/[reponame]/blob/[branch]/image...

Is there a way to select a parent element based on the class of a child element in the class? The example that is relevant to me relating to HTML output by a nice menu plugin for http://drupal.org . The output renders like this: ...

... Another approach is to just ask PhantomJS to wait for a bit after the page has loaded before doing the render, as per the regular rasterize.js example, but with a longer timeout to allow the JavaScript to finish loading additional resources: ...

... Combine the strategies to reduce the disadvantages of a single approach. I work in embedded systems so the following solution is based on the fact that integer and bitwise operators are fast, low memory & low in flash usage. Place the enum in a namespace to ...

What is a good complete regular expression or some other process that would take the title: 21 Answers ...

...y reason why a text column should not have a default value. No explanation is given by the MySQL documentation. It seems illogical to me (and somewhat frustrating, as I want a default value!). Anybody know why this is not allowed? ...

... object returned, if it would resolve to the same file. The situation is different when a.js, b.js and app.js are in different npm modules. For example: [APP] --> [A], [B] [B] --> [A] In that case the require('a') in app.js would resolve to a different copy of a.js than require('a') ...

...tered Index Only one per table Faster to read than non clustered as data is physically stored in index order Non Clustered Index Can be used many times per table Quicker for insert and update operations than a clustered index Both types of index will improve performance when select data with...