Thoughts on TypeScript – Link List

Differences between TypeScript and Dart
What is the motivation behind TypeScript?
both on programmers.se.com

Thoughts on TypeScript

Rover Code

If you were ever curious about the software driving the Mars rovers, I came across a good question on Programmers today.

The JPL LaRS lab provides a couple of documents on coding standards and monitoring, and NODIS has a document on Software Engineering Requirements. The Workshops on Spacecraft Flight Software also offers a couple of slideshow presentations.

I find this topic very interesting (how would you debug a piece of code that is executing on a different planet?), but unfortunately there are not that many related questions (and answers!) on Programmers.

What about the Soviet space program?

404

I admit it was very tempting to celebrate the 404th post on this blog, rather than the 400th. Just like 1024 instead of 1000.

Incidentally however, recent events mean that the 404 jokes may turn into reality as two proposed bills are discussed and probably passed in the US.

Normally we stay away from from politics here at the official WordPress project

but the proposals of SOPA and PIPA have serious impacts on the way we can use the internet. From the Wikipedia article:

Threat to online freedom of speech

Negative impact on websites that host user content

Weakening of “safe harbor” protections for websites

General threat to web-related businesses

Threat to users uploading content

Threat to internal networks

Threat to free and open source software

Ineffectual against piracy

Deep-packet inspection and invasion of privacy

Negative impact on DNS, DNSSEC and Internet security

No doubt that in recent days SOPA is covered more frequently in online tech magazines:

Help Stop SOPA/PIPA

Reddit is ready for SOPA and PIPA protest

Fighting Internet piracy: CES takes on SOPA vs. OPEN debate

Is a pro-PIPA lobbying group guilty of e-mail “content theft?”

Congress considers anti-piracy bills that could cripple Internet industries

How SOPA would affect you: FAQ

Over 40 Internet Companies Come Out Publicly Against SOPA (Including Us)

Anonymous will shut down to protest SOPA

reddit going dark for a day to protest SOPA online censorship bill

See Ars Technica for stories about some supporters of the bill

MPAA attacks Ars for “challenging efforts to curb content theft”

Smoking guns, dark secrets aplenty in YouTube-Viacom filings

At least one of the upcoming episodes of The Daily Show promises some fun. Can’t wait for January 18.

Open Data

When I developed my YuJisho online dictionary web application, I was looking for freely available fonts and dictionary data related to CJK languages.

For my dbscript database schema management application, I tried to find as many database schema samples as possible to test the application against.

There is a lot of data (raw, processed and visualized) available on the Internet, but occasionally it is hard to find. This raised the idea of providing a collection of references to free data sets on the web like the Guardian Data Store, and I was thinking about a platform to provide such links.

Now news is out that data.gov plan to release their platform as open source software (GitHub), but the code is still labeled as alpha. (data.gov HTML says it is based on Socrata, which also provides lots of links to open data).

Let me know what’s your experience with OpenData, or similar platforms.

TSQL String Functions

While searching for appropriate string comparison functions in TSQL, I came across these pages implementing a couple of

string functions: Capitalize, Center, Count Substring in String, EndsWith, ExpandTabs, IsAlnum, IsAlpha,
IsDigit, IsLower, IsTitle, IsSpace, LJust, LStrip, RFind, RJust, RStrip, Strip, SwapCase, Title, Zfill

and string tuple functions: Split, SplitLines, Within, EndsWith, StartsWith, Contains, Join, Parts, Partition, RPartition

See here for more TSQL articles by the authors.

CSS Link List

In a web application with its custom CSS that also defined hyperlinks, Internet Explorer would render disabled hyperlinks greyed-out, whereas Firefox showed them as normal text.

Tracking down this different behavior, I found that you can define CSS styles not only by class and tag, but also by attributes using the [attribute] notation:

*[disabled], a[disabled]:hover, a[disabled]:visited
{
color:gray;
}

If you are looking for CSS definitions for fixed headers, footers and sidebars, take a look at these sample CSS. I’m thinking about including them in the next version of dbscript.

Link List: SQL Server and Collations

Recent posts covered collation support and Unicode in SQL Server.

Just a couple of links with more information on this topic:

• Qingsong Yao’s blog Collation, DateTime, SParse Column and XML
• especially the article on Unicode References
• Michael Kaplan’s Sorting it all Out
• his articles on SQL Server and Collations