Computer Programming

Yes, a bit specific, but I need to store some links!

MS Access: Comparing Queries Between Two Databases (a query diff)

Often, when you have MS Access in a small office, and have done the right thing and split the database into a backend of tables and frontend of queries, reports, and forms, you end up with changes to the objects in multiple files. The trickiest is comparing queries, because the query object is modified if even a column width is changed. You need to dig deeper and compare queries.

Create SQL tables from CSV headers

Not sure where this goes, but it's a page that will generate MySQL code from the header line from a CSV file.

Link to mini app.

Heuristics are Nice : (working toward) Facebook-style Previews

I was thinking about how facebook updates parse out the url, then construct a nice looking preview. I think what it takes is scanning the textarea for a url, and then using ajax to tell the server to fetch a summary of the page at the url. get the data back, and insert it into a template, and reveal it.

Making the Tumblr "Well" Layouts with CSS

So I was puzzling over how to make the "Well" style layout in Tumblr without Javascript.

PNG Colors are Wrong in Firefox (and how to deal with non-sRGB wide gamut monitors at work)

I created a PNG that was bright red, but in Firefox, it is a duller red. The fix was to remove the color profile from the PNG by using the tool TweakPNG.

Haskell Name Game

Main> nameGame "alonzo"
"alonzo, alonzo bo blonzo bonana fanna fo flonzo fee fy mo mlonzo, alonzo"
Main> nameGame "haskell"
"haskell, haskell bo baskell bonana fanna fo faskell fee fy mo maskell, haskell"
LOLz. Here's some real beginner-level source code for a version of the "Name Game". The Name Game was a song from way back. It's silly.
Sources after the jump.

Formatting Mobile HTML Email

While writing a template for spam, I learned the following about mobile email formatting.

Reused a Variable Name

I accidentally reused the variable name $count twice in a function.

WordPress: Exporting Articles into WordPress Extended RSS (WXR)

This is an example template file that will export articles from your bespoke CMS to and XML file that WordPress version 3.5 will import.

Haskell Notes 2

I found a good tutorial at Wikibooks, Haskell. It's beginner level like these notes, but is way more organized.

Haskell Learning Notes

A couple years ago I tried to learn Haskell and dropped the study. I'm not sure what happened, but it's really hard to find a solid block of time to study it.

Strike Network Postmortem

Strike Network started as a mobile site similar to 4square.

Javascript Delayed Hiding of an Element, Delayed Function Calls in Different Contexts

So I'm working on a small "speech bubble" library, and needed to delay hiding of the bubble. It's not that it was required, but it was a pain in the butt figuring out how to arrange the event handlers on the different elements so that you don't end up with a situation where you get a flickering bubble because you hide the bubble, and that fires a mouseover event that, in turn, displays the bubble again. That fires a mouseout event that causes the bubble to be hidden.

All Your Parsers Are Belong to Us

Getting Started with Exploratory Parsing. Describes a system where you can write your parser by analyzing huge bodies of text. In short, a system for writing all the parsers required to analyze the text on the internet. (In English.) (Ward Cunningam invented the idea of the Wiki.)

.


Syndicate content