I’m building an infrastructure on a grid using AppLogic, which is a grid OS that provides both GUI and command line interfaces to build your infrastructure. I use both interfaces, depending on the task I’m trying to perform at the time. One thing I have discovered is that there are a lot of somewhat nebulous…
Category: Database
Holy Crap I’m Busy
I feel guilty that I’m even taking this little bit of time to post this. I’m *BUSY*. I’m simultaneously: learning how to deploy a fully-virtualized, production infrastructure on a grid using AppLogic planning and scripting the bits and pieces that need to happen to migrate an infrastructure to a grid architecture. Doing code review for…
Using TRUNCATE to empty a PostgreSQL database
This is not something that’s any big hack or secret, but emptying a database of all data without dropping the structure along with it is one of those tasks that I do just often enough in my development work to be annoying. If you ask me, there should just be a big ol’ “EMPTY” statement…
Freebase: Your database is ready!
This is going to be really frickin’ cool. There’s just no other way to put it. Maybe I’m a little too much of a data geek, because I can’t seem to sit still since receiving my email letting me know that Freebase is now in alpha, and the account I requested months ago can now…
View Vindication
So, about 9 months ago, I worked with a team of researchers. They were building a pretty hardcore global distributed system, and associated management infrastructure. My job was to simply advise them on issues revolving around how they use their database back end. For the most part, I just made suggestions here and there about…
Trying to make friends with Python… again
I like the idea of Python. I have diverse interests, technically, and I like to think that there’s a language out there that I can use to write small script, a large website, a stored procedure, or a distributed system. The same language is used to write a very large chunk of systems code on…
How to replace a view, a cursor loop, and a few other queries with one SQL statement
I had a stored procedure that defined a cursor using a crazy query, and then a LOOP that did a FETCH and went row-by-row and performed updates and inserts to 3 or 4 different tables. I was having some trouble completing the very last thing the procedure needed to do. So I figured I’d take…