Pro Bono On The Accounting Side…

October 10, 2007

Maintaining a site for keeping lecture notes and solutions to exercises and problems takes about eight to twelve hours a week. That’s because a lot of new pages need to be set up,  prepped for the first time. It could could go down to eight hours a week as things move forward.

In tandem with maintenance, I’ve also set up a database backend specifically for the exercises. What this basically means is I’ve partially created a database-backend app with a web front-end for automating some of the accounting procedures. It’s not up-and-running yet, but it will be ready in the coming week or two.

I’ll open this project to the public once it is ready. This one is going to be Pro-Bono (free) as this will greatly help me in my studies, going forward. So, if you want a free-ride on your accounting system, especially if you’re a mom-and-pop store, a team-operating-on-a-dime, or even a smallbiz who wants to save that penny. My suggestion is to get on this project once it is ready.

I’ll take care of the nut-and-bolts, you basically plug-in the numbers and run reports. That’s basically the deal. It’s as easy as any accounting firm, except this one is free.

Send me an email, if you’re curious enough to know what’s going-on behind this weblog, though.

 OK, see you later.


Writing About A Domain Specific Topic Can Be Interesting.

October 5, 2007

Recently, a new webpage opened-up basically for posting lecture notes and solutions to exercises and problems. My initial expectation was to have an online repo for all things related to the subject, and it turned out to be wonderful thing. So, I kept on posting more notes and solutions, then one thing I noticed something about the page.

Stats showed most of the queries that landed into the page were mostly questions about finding a solution to a problem. That got my cells firing, though.

Anyway, I really don’t care about who is looking into these solutions or what kind of benefit will they be getting out from it. In my case, I’ll just populate the webpage with all the lecture notes and solutions for a specific book that we use in the class.

If it turns out the page to be a source of information for other students who are into the the same path as mine, well, welcome aboard and give a squawk.

quo vadis?

Book: Math/Physics For Game Developers

October 4, 2007

I bought this book several months back thinking it will fill-in big gaps needed to complete my understanding about the subject. At last, after painstakingly going over pages and working-through the combinations, I can finally say this book did the job in bringing me nearer to enlightenement, though.

So, what is this book I’m writing about. Well, let me tell you more about this book more before I give it off to you right away.  You have to stay in that chair a little longer. So stay!

Chapter One was basically intro with a clear start on points and lines. Typical high school material was covered in this section. Stuff like point-slope and slope-intercept were discussed to the bone here. You will surely end up feeling like a slope genius when you finally reach the last sentence, though.

Well, let’s see there’s about 14 chapters in the book and if I write 14 paragraphs describing each, that will probably blow-up my entry. I guess I really need to just write about my favorite part, the one that really brought it home.

Ok, the most interesting topic went to…drumroll…matrix operations! Followed by newtonian mechanics including energy and rotational equations.

So here it is: Click this line to see The Book

Cursors Can Be Deadly

October 4, 2007

When planning on writing SQL code, especially stored procedure code, you really need to think twice about employing the use of cursors. Here’s why:

  1. A single cursor will do just fine, provided you don’t mix it up with joined tables/views.
  2. A nested cursor will surely bring your server down to its knees. Mix it up with temptables and it will even slow down to a crawl.

At first, when you get it coded and tested, make sure that code runs against 10 gigabyte logfile. You will surely reward yourself for doing this test first before the code goes to prod, though.

In my case, the DB broke the 1Gigabyte barrier very early, by about 2 to 3 weeks after rollout. At that rate, we’ll be maintaining a huge DB soon, perhaps it will morph into a VLDB within 2 years.

Google Docs

I’ve never heard or read about Google Docs, what it does or what advantage it has over the competition, until I got into this odd situation.

I was firing-through the given assignments and noticed something not right with the way I was using technology in setting-up a repo for my assignments. it turns out Google has these nifty small tools for creating and publishing docs online. So I fired-up the browser and started using the following:

  • Presentation – Most of the lecture notes were converted into this format. I was able to convert all my notes in one sitting. it’s all online now, presentation format. Man, I’m telling you, this is cool.
  • Spreadsheet – This tool is a time saver, I simply entered all the numbers. Did all the standard steps in setting up the financial statements like Income Statement, Statement of Owner’s Equity and the Balance Sheet. Google Spreadsheet handled it very nicely. The cool thing about it is–it’s now available online.