This is the sort of thing that seems really easy in hindsight, but it took me a little while to get right.
There are lots of things that I don’t like about PL/SQL, but I often prefer to do spatial operations at the table level inside the database, rather than using ArcPy or ArcObjects; I think that it’s easier to reuse queries like this, the code tends to be more readable and concise, and performance is almost always significantly better.
I’ve been thinking a lot lately about the idea of convention in software development. The more I’ve worked with the ASP.NET MVC framework and nHibernate, and dabbled with Django, the more I’ve been able to see the benefits of designing and coding this way. It’s also made me consider my own biases and background, and realize why I’ve struggled with the idea in the past.
I started out as an embedded developer, and for a long time, everything I wrote was in C or some flavor of assembler.
My car broke down the other night; I had dinner with a friend, and left the restaurant to find that my car wouldn’t start. I ran back around the building, just in time to see my buddy driving off. Chased him five or six blocks, across the street, up a hill. When I got to the top, he was gone. Walked back to the parking lot, flagged down a helpful passer-by, and tried a jump-start; nothing.
"There are too many languages today, and it would be a good idea to choose just one." Richard Feynman, Nishina Memorial Lecture "The Computing Machines in the Future," Tokyo, Japan, 1985 (from Selected Papers of Richard Feynman) A couple weeks ago, I started thinking about writing a simple blogging framework, and, I guess, a blog? Of course, there is approximately zero need for more blogs, or more software for making blogs–there are plenty of great platforms out there, if all you want to do is write down some thoughts that no one will ever read.