Index Types in TypeScript

When working on dksfight, I needed to make some global maps to cache various things. Some of these maps were indexed by an integer, and others were indexed by strings. The values stored in the maps were various different types, doesn't matter. The keys presented a problem, though.

When is an UPDATE actually a SELECT?

While I was working on dksfight, which was built with the mssql NodeJS package and Microsoft SQL server, I had a few places that used an UPDATE statement to modify some rows in the table. This is a short post about a snag I hit with these UPDATE statements in mssql.

Into the Blue Clouds

It's nice to get feedback from your peers. I made a thing a while back, but I didn't tell many people about it because I had reservations. I solicited feedback from my peers about it, and I decided the thing I made had problems I needed to resolve before I felt good about releasing it. Well, I've now solved those problems, so I'm ready to tell the world about the thing I originally created, the feedback I got, and how I incorporated it to make something neat.

ES6 Promise Types and Errors

I've been working on a new project using NodeJS. Again, I'm using TypeScript for added safety, which means I have to (and want to) play nice with the type system. This code also uses ECMAScript 6 Promises for asynchronous database queries, and I ran into some funny (like funny uh-oh) problems here. But also solutions, so I thought I'd share.

MySQL vs T-SQL Syntax Differences

I'm working on a web app project that uses a SQL backend. I wrote it originally using Ruby and MySQL, and I've been porting it to Azure and Microsoft SQL Server. You'd hope that creating the database schema would be the same for both, because it's all SQL, but nope, that's just wishful thinking. SQL has many flavors, and each of them support certain different things. T-SQL (which is what's used on Microsoft SQL Server) seems to lack some nice features MySQL had, which makes me sad.

Babbling with Babadoobot

Guys, I did it again. I made another Twitter bot. This one absolutely crushes all my others on the "ridiculous idea" scale. I'm almost too embarrassed to share it with you. Almost.

I was walking to my bus the other day, and for some reason, the word "adobado" popped into my head--you know, the Mexican meat seasoning. I thought, "I wonder if I have that spelt right. It seems easy to mess up." Fittingly, as I wrote this blog, I got it wrong at first. I wrote "abodabo" and had to look it up and correct myself. Anyway, I kept thinking, "hehe, that word sounds funny... you know, I could probably write a program to generate funny sounding words like that."

Ruby MySQL Concurrency

I lamented the other day that there is a paucity of information out there about Ruby+MySQL. Really, I was able to find basically one decent site, and even that seemed to gloss over some details in the area of concurrency and transactions. I wanted to know a bit more about how this works, so I ran some experiments.