List of differences between SQL databases
I’m not sure how comprehensive this list is, but maybe this will help – http://troels.arvin.dk/db/rdbms/
standards
Integer overflow in C: standards and compilers
Take a look at -ftrapv and -fwrapv: -ftrapv This option generates traps for signed overflow on addition, subtraction, multiplication operations. -fwrapv This option instructs the compiler to assume that signed arithmetic overflow of addition, subtraction and multiplication wraps around using twos-complement representation. This flag enables some optimizations and disables other. This option is enabled by … Read more
Why __func__, __FUNCTION__ and __PRETTY_FUNCTION__ aren’t preprocessor macros?
Expanding __func__ at preprocessing time requires the preprocessor to know which function it’s processing. The preprocessor generally doesn’t know that, because parsing happens after the preprocessor is already done. Some implementations combine the preprocessing and the parsing, and in those implementations, it would have been possible for __func__ to work the way you’d like it … Read more
Bitshift and integer promotion?
The so-called usual arithmetic conversions apply to many binary operators, but not all of them. For example they do not apply to the bit shift operators, &&, ||, comma operator, and assignment operators. This is the rule for the bit shift operators: 6.5.7 … 3 Semantics … The integer promotions are performed on each of … Read more
Why Doesn’t jQuery use JSDoc? [closed]
I’ll take a shot in the dark here since I can’t speak for the jQuery team of why I wouldn’t use JSDoc. JSDoc, at least the last time I checked, didn’t have any clean way to support method overloading (or parameter shifting…whatever name you want to give it here) and jQuery uses this all over … Read more
What should be the valid characters in usernames? [closed]
A well-designed system doesn’t necessarily need to prevent any special characters in usernames. That said, the reason underscores have traditionally been accepted, is that underscore is typically treated as a “word” character, along with letters and numbers. It is usually the only other character given this distinction. This is true in regular expressions, and even … Read more
Normalizing Human Skin Colors for User Interaction
olayforyou.com defines these skin tones alt text http://www.freeimagehosting.net/uploads/151ab0ddd7.jpg very fair fair olive dark very dark Any person using cosmetics regularly would understand these terms. These rest of us are just guessing 🙂
Is a C++ preprocessor identical to a C preprocessor?
The C++03 preprocessor is (at least intended to be) similar to the C preprocessor before C99. Although the wording and paragraph numbers are slightly different, the only technical differences I’m aware of between the two are that the C++ preprocessor handles digraphs (two-letter alternative tokens) and universal character names, which are not present in C. … Read more
Should I learn XML 1.0 or XML 1.1?
Unless you have a specific requirement to work with XML 1.1 (which is very rare), you should read the XML 1.0 Recommendation. Tim Bray, one of the original editors of the specification, has created an excellent annotated version of it which you can find at http://www.xml.com/axml/axml.html For a bit more info/opinion on XML 1.1, check … Read more
Who defines regular expressions?
Regular expressions are covered by several standard bodies, including IEEE standard 1003.1 (so called Posix): http://pubs.opengroup.org/onlinepubs/000095399/basedefs/xbd_chap09.html However, there are plenty of other approaches to regular expression syntax, the other popular one being Perl (PCRE). For a nice overview of all major regular expression implementations, including extensions, check out this useful resource: http://www.regular-expressions.info/tools.html