Latest Publications

RO-DB – CAP Theorem Schmap Theorem

RO-DB, the Read Only Database

Administering and running a database can be expensive and time consuming. It can get really bad as your app scales to require thousands, tens of thousands, or even hundreds of thousands of clients. Are you tired of having to choose between consistency, availability, and partition tolerance? Don’t you wish there were a better way?

Now there is! RO-DB, the Read Only Database!

Fast under load

No matter how many clients you have, the response is always identical.

Never inconsistent

All changes are instantly replicated to all nodes.


All writes are 100% ACID compliant, all changes are instantly and permanently recorded!

Zero Maintenance*

*Except for maintaining the hardware it’s running on, RO-DB is 100% maintenance free!

Instantaneous Backup

RO-DB consistently demonstrates the smallest backup window ever measured. All data is backed up in the blink of an eye! (Before you can say Anbesol.)

Horizontal Scalability

If you want to add capacity to support more connections, simply add another box!

Zero Config Replication and Clustering

And perhaps the most spectacular feature of RO-DB is that you get replication for free! Joining a new node to the cluster requires no configuration, whatsoever!

Perfectly Equitable Partitioning

RO-DB is able to be partitioned among an infinite number of nodes, and the storage and query load is always distributed 100% equitably, automatically. NO OTHER DATABASE CAN MAKE THIS CLAIM!

How does it all work?

RO-DB isn’t magic! It uses highly advanced Read Only technology that disallows any writes from being made to the database, EVER! This optimizes the system for replication, backup, availability, scalability and consistency! This exciting new technology will revolutionize the internet, computing, and will probably end up running your toaster someday on the Internet of Things! Contact us to find out how you can start leveraging RO-DB in your enterprise!

Fast Forward a few Years – MacVim

Ok I’m still alive, believe it or not, and I’m working for a well known Marketing Web Portal. After a decade or more of Microsoft.NET, I switched gears into Ruby on Rails. Now, I can barely remember how to find the Windows key anymore. And that’s the way I like it! That’s not what I’m writing about, though.

I’m actually writing to brag a little bit. I finally did it! I have switched from ‘quiche-eater’ text editors like Notepad++ and Sublime Text 2/3 and TextMate to Vim. MacVim actually, so I’m not exactly a guru or anything, but I’m pretty happy about it. This is just one of those things that I was meaning to get to for so long and never did. Until now.

I started with the base Janus plug-in package with ctags and Ack.

I can’t really give anyone too many pointers on how to get started in Vim for yourself, except for one thing: Keep a Vim annoyance journal. Write down all of the things that frustrate you, like navigating files or opening buffers, or closing them without moving things around, etc, and google the answer. Then write it down. You will have something far better than any cheat-sheet (personalized just for you.)

Some of the misadventures that made my Vim Annoyance Journal:

Problem: ctags are annoying to keep up to date.

Yes, ctags are brilliant little things that let you leap tall files in a single bound by typing

:tag some_identifier

But as soon as you add a new file or files, you have to regenerate the darned things. That gets old! So, in the true spirit of automation I present you with the solution that I used: git hooks. I completely stole this guy’s gist script to do it. I did make one modification though, since I’m using rbenv to switch ruby versions per-project. I changed the


to the relatively standard

#!/usr/bin/env ruby

Anyway the tl;dr on this issue is, now ctags are automatically regenerated upon commit, checkout, and merge actions in git.

Another issue I found particularly pesky: Closing a buffer when i’m done editing a file, even an unsaved one, and starting with a fresh one. If you do this ‘by hand’ with a series of native commands, like saving it, and quitting it, you’ll end up with a big hole in your workspace unless you still have some other buffers on the stack. That can be a pain in the butt if you use splits (and ironically, I am not using splits very much at all now, but still, the following point…)

Kinda like a regular ‘close/new’ command in ‘quiche-eater’ editors. There is nothing in the native Vim command litany to do just this one thing, so I mapped Leader+d to it.

In your .vimrc (or .vimrc.after if you’re using janus!) add the following line:

nmap <leader>d :bp<bar>sp<bar>bn<bar>bd!<CR>

Then, when you’re “done” with a buffer, go into normal mode and \d (or ,d depending on what your leader character is.)

Hopefully someone finds those useful. Anyway, I didn’t disable the arrow keys, or turn off the mouse, but I did find that banishing “NERDTree” in favor of the Command+T plugin, Ack, and ctags navigation (all of which come bundled with Janus,) is a much nicer way to get around. Your mileage may vary, though, so good luck if you go down that route.

I did want to give a shout out to an absolutely BRILLIANT way to learn the basic Vim keys. And it’s SO brilliant that it’s very nearly sick and twisted. At least sick. Vim-Adventures is a game where you use the Vim keyboard commands to solve puzzles navigating your way around the world, like the Legend of Zelda meets Mavis Beacon. Even if it were not educational, it would still be a masterpiece! A very big thanks to Doron Linder for cooking that one up! Do check it out!

Screen Shot 2014-06-16 at 11.17.56 PM

Solved! Moving the ECB to the Title column in a Document Library without breaking it

I’ve been searching around, and apparently so have a few other people for a way to move the link/menu from the File Name column in a Document Library to another column and preserve all of the integration functionality.

There were SharePoint Designer based hacks that SORT of did this by letting you move it by setting the ListItemMenu property of a particular column… but this broke two things:
1) Clicking on the document takes you to the properties instead of the document.
2) The Open with “Microsoft Word | Excel | etc” part didn’t work.

No solution had thus been forthcoming so I buckled down and did it. Instead of posting it here, I put it on Check it out.

Not only did I enable the Title column with the ECB, but it defaults back to the file name if there is no title.

Hopefully someone finds it useful. In my case it was useful because I was dealing with a couple of thousand imported documents whose file names had no bearing on their human readable Titles.

SPUtility.TransferToSuccessPage : Here is The Missing Documentation

Ok, so the SPUtility class is chock full of useful little doodads and widgets that try to make life easier for SharePoint developers. Actually, scratch that, it’s there to make life easier for the Microsoft team who develops SharePoint itself, but they’ve kindly let us have a bunch of public methods. One of the nifty features is the TransferToSuccessPage method and as you can see here, it’s very poorly documented. On top of that, it has some less than obvious behavior, so that lack of documentation is sometimes painful. There are millions of blog posts out there that touch on it, mention it, and complain about its lack of official documentation, so I won’t belabor that point; however, here’s the things you have to know when using it (specifically, the four string overload):

SPUtility.TransferToSuccessPage(message, nextUrl, linkText, linkUrl);

I typically use it like this

                    "Successfully fooed your bar." +
                    " Click {0} to go back to the web root." + "
                    " Click Ok to proceed back to the list.",

      // +s in the strings are for
      // your viewing pleasure, I don't 
      // usually do that
  • The ‘nextUrl,’ which is where you go when you click ‘OK’ needs to be relative to the site (SPWeb) root, NOT the site collection root, and NOT the server root, and NOT full URL. You can see above I’ve taken a server-relative URL and stripped out the server relative URL of the site. This is because the ‘next url’ is crafted like this, (with the + operator) in the code:

    currentSPContext.Web.Url + nextUrl;

  • The {0} in the ‘message’ parameter is what is replaced by the generated link. It specifically creates an a-tag like this

    <a href="{linkUrl}">{linkText}</a>

    You can specify a full URL, but if you specify a relative URL it will be relative to ~/_layouts/success.aspx. In case you didn’t notice, ~ is the WEB APPLICATION root. Not the site collection root. (They may be the same on your dev box, throwing some confusion your way when you go to production.) This is because SPUtility actually just straight up calls Server.Transfer(“~/_layouts/success.aspx”) which has no knowledge of SharePointyness like site collections and such.

  • If you do not include a {0} in your message string, the last two parameters, linkText and linkUrl, are ignored (for all intents and purposes that is. Success.aspx still fiddles with them but it doesn’t affect your output)

  • This will NOT work in a workflow or a SharePoint event handler because it requires an HttpContext, and those things don’t usually have one.

  • Because it calls Server.Transfer, It WILL throw a first-chance ThreadAbortException so don’t call it from within a “catch-all” try block unless you plan to ignore the ThreadAbortException. See the MSDN Docs on Server.Transfer for info.

There you have it.

SPFile.Checkout() and modifying meta data properties

It seems like it should be pretty straightforward. (But then again, nothing ever is when it comes to SharePoint development.) You check a file out, modify its metadata properties and check it back in. I spent something on the order of three hours trying to figure out why that kept blowing up on me when I found a subtle stupid thing that, of course, isn’t explicitly documented.

I thought this code should have worked…


    var list = Web.Lists[listName];
    var item = list.GetItemByUniqueId(new Guid(uniqueId));

    Web.AllowUnsafeUpdates = true;
    var folder = item.File.ParentFolder;

    var checkoutRequired = list.ForceCheckout;

    if (checkoutRequired) {

    var file = folder.Files.Add(listItem.File.Name, 
        listItem.File.OpenBinaryStream(), true,
        "Published by the system after approvals, Pending check-in.", true);

    if (checkoutRequired) {
         file.CheckIn("Automated Go Live Check-in by the Workflow Process");

   // todo: set all the metadata here
   var linkUrlValue = new SPFieldUrlValue();
   linkUrlValue.Description = "Log Link";
   linkUrlValue.Url = WorkflowInformation.EventLogLink;
   item["LogLink"] = linkUrlValue;

   // explode! "document modified by 'domain\username' at {Now}"
       file.CheckIn("Automated Go Live Check-in by the Workflow Process", 
   Web.AllowUnsafeUpdates = false;

…But it didn’t. It kept blowing up. I tried various different things, and I couldn’t figure out what was going on. Then I noticed something subtle that all of the examples out there did: They used the file.Item property of the checked out document instead of the original item. I still don’t know why this makes a difference, but if you use it, it works. If you use the ‘original’ item reference instead of the file.Item, it yaks. Below is the only slightly different, yet infinitely more ‘working’ code.


     var list = Web.Lists[listName];
    var item = list.GetItemByUniqueId(new Guid(uniqueId));

    Web.AllowUnsafeUpdates = true;
    var folder = item.File.ParentFolder;

    var checkoutRequired = list.ForceCheckout;

    if (checkoutRequired) {

    var file = folder.Files.Add(listItem.File.Name, 
        listItem.File.OpenBinaryStream(), true,
        "Published by the system after approvals, Pending check-in.", true);

    if (checkoutRequired) {
         file.CheckIn("Automated Go Live Check-in by the Workflow Process");

   // the CRAZY thing here is you can't use another 
   // reference to the item if the place requires a checkout, even if 
   // it's the one from whence you originally got the file reference 
   // in the first place.
   // You MUST use the file.Item reference to the item or it breaks when 
   // you set the metadata.

   // Your humble author and narrator spent 3 hours trying to figure this out.

   // todo: set all the metadata here
   var linkUrlValue = new SPFieldUrlValue();
   linkUrlValue.Description = "Log Link";
   linkUrlValue.Url = WorkflowInformation.EventLogLink;
   file.Item["LogLink"] = linkUrlValue;
       file.CheckIn("Automated Go Live Check-in by the Workflow Process",   
   Web.AllowUnsafeUpdates = false;

The end of the world?

Back when I was a kid, I remember having something called, (astonishingly politically incorrectly,) the “Indian Weather Rock.” It was a knick-knack that sat on a shelf somewhere and the trick was that it would tell you about the weather. You put it outside when you wanted a reading: if the rock was wet, it’s raining. If it’s white, it was snowing… etc. It was an amazing piece of human engineering.

I thought, with all of the tumultuous events of today, be they financial systems collapsing, Mayan calendars running out of squares into which we can write the year, famous people changing careers, a potential vodka embargo, disastrous political machinations taking shape left and right, what the world needs is a digital way to understand exactly what kind of mess we’re in. So, I’ve put together what may be the most comprehensive computing device I’ve ever made, and let me tell you, it’s almost NEVER wrong. Go here (click) and check out some of it’s unequivocal magic.

B+ Trees for the masses

Roger has done, in the generic, what nobody I’ve found to date has: He’s implemented an open sourced, B+ Tree library for .NET that scales well and is completely thread safe. I’ve tried making one myself, and while I did manage to implement a b+ tree, it wasn’t threadsafe and linear scaling into the hundreds of millions of items… this one is.

I’ve chatted with another Mr. Mehdi Gholam who has his own working but not-so-generic version of a B+ Tree in RaptorDb, and seen countless people asking for one all over the place in message boards and forums. Well there it is. I know it’s not much hearing me say it, but free software isn’t free for the guy who writes it, so… thanks, Roger. Great work!

Bring on the rocks.

If you’ve worked hard to acquire a talent, or you’ve busted your rear end in the gym, if you’ve spent hours, days, or weeks creating some kind of art or a kickass computer game, I have no problem with you telling me about it. There’s nothing wrong with being labelled ego-centric or being called a ‘show off’ by the people who haven’t done these things themselves. It should be inspiring to other people, not cause them to throw rocks. Jealousy is a lot uglier than pride. Bring on the proud people, and the rocks.

Runaround: An old school puzzle game (My first XNA game.)

This is actually a rewrite of a game I made when I was 13 on my good old Mac Classic (it was black and white.) It plays the same in this version, except back then my brother was designing the levels so they were a lot harder and cooler.

Click here to try it out


It automatically checks for updates, so when I get around to writing new ones, they’ll come down automatically.

I made it easy to modify the levels, and if you’re enterprising enough to create an 18 line text file, you can make your own:


Get all of the jewels (gold for now, the tiles suck) and get to the exit (which will open once you have all of them.) Push blocks into holes to fill them in so you can cross. Blocks can also go through one way doors if there is something acceptable on the other side.


Arrows: Move

Space: Kill yourself

Adding new maps:

Map files are simple text files of 18 lines with 18 characters per line. Each character corresponds to a tile.
The tile to character map is listed below.

Copy the template below into a new text file, name it where X is the number of level it is. (like for level 12.) They have to be in sequence. Put the in the Content folder. It’s a clickonce app so I’ll have to figure out where the content folder is. An easy way to find it is search for from the start menu. Yeah kids, it’s XNA so windows only.

Edit each of the characters in the map file as shown in the chart below. Just change the one in the template to be whatever you want it to be. Note, it IS possible to make a map that you can’t beat, so that part is up to you.

chr	title		  
(.) Empty         
(N) PlayerUp      
(S) PlayerDown    
(W) PlayerLeft    
(E) PlayerRight   
(T) Tree 
($) Jewel 
(@) Rock   
(-) Hole          
(+) MovableBlock   
(L) OneWayLeft     
(R) OneWayRight    
(U) OneWayUp       
(D) OneWayDown    
(O) ClosedExit    
(X) OpenExit     

Map File Template (MUST be 18x18)  (this is an example map template)


Email me your cool map files to dave dotdolan at gmail, or post them in the comments.

Recent Changes:

Made map files be 18×18 (previously was 16×16)
Fixed a bug in pushing bricks through one way doors.
Refactored the code so that it’s closer to an MVCish pattern -> still not quite there
new rock tile
added sounds other than system beeps

Status screen -> Number of moves, Crystals Left, current level, (death count?)
Opening splash screen (pick your level -> level preview/selection screen)
transition effects (pushing the block, dying, getting some gold)
animated tiles

level editor that looks nicer than text files.
scrollable boards that exceed 18 x 18

I’m going to eventually post the source somewhere but it’s nothing really interesting. Email me if you want it.

The Whole Shebang: Implementing a general purpose language interpreter using GOLD Parser Builder and the new BSN Engine

Update: The source code for this project has been added to a Google Code repository and will be updated there.

Second update: The article appears, further updated, on CodeProject. Go check it out there! (I’ve removed it from this site.)