Dog Fooding

time to read 2 min | 257 words

I love O/RM, but I depise XML. That can be a problem.

I solved that a while ago by writing NQA, so I don't have to remember NHibernate's 350Kb(!) schema in my head. Then I discovered Active Record and Castle and realized that neither XML nor SQL is not mandatory for having fun with databases.

Recently I had two seperate occations where I had to pull NQA from the dusty shelf on my tool shed and use it. The first was to create complex mapping ( and I really like the ability to just explore the possibilities that I have, rather then search for them ). Check out the screen shot, I had zero idea until today what composite-index is (or that it even existed). Knowing the basic of NHibernate, I wa able to figure out what it mean (and when I headed to the documentation, I knew what to look for).

 

The second was doing some queries that used aggregation, which I didn't deal with much. I was able to trail ג€“ and ג€“ error the query using the query analyzer far more quickly than with any other possibility.

 

Thinking about it, I invested roughly 9 months in NQA, and looking at its feature set, it's pretty nice, even if I say so myself.