Ryan's Rambling

Friday, March 19, 2004

Stumbled onto this MySQL commentary

A list of MySQL gotcha's that really makes you do a double take when looking for a database with the robustness we have all come to expect. I have never used MySQL for anything other than little one-off's that are normally php based. I did write a neat little wrapper for a game engine that bound to MySQL though. In retrospect I would have fought using it had I know the number of weird things that go on with it. InterBase has always been a strong contender for the small databases and since it has an open source variant it is probably a better place to look so long as you can get it hosted. It seems like the free-for-all semantics of scripting languages can be applied equally well to your data storage environment - NOT.

Tuesday, March 16, 2004

Delphi 8 has integrated error reporting

Allen Bauer has provided a new IDE extension that permits the automated reporting of IDE errors to QC. This is great stuff and everyone should install it. It is quick and easy to put in place and should help out the IDE stability in the long run. I even got to send a report just a few minutes after installing it.

Labels:

Friday, March 12, 2004

QuickBlog Updates and Fixes

I have fixed up a view of the annoying bugs (deleting new posts was broken) and given the tool a decent face lift to use XP Themes and menu options.

Read about it here
QuickBlogs v0.91 (full, ~ 1MB zip)
QuickBlogs v0.91 (qb.exe only, ~ 162KB)

Labels:

Thursday, March 11, 2004

Clemens Vasters Blog

Well, I just finished reading Clemens Vasters blog. What a breath of fresh air. The text on free software and the attitudes surrounding open source are very thought provoking and well considered. Well worth the read for anyone doing software development.

The Update is Here

See the links in the previous entry. The updates are there. I have downloaded them and just running through the install.

Labels:

Delphi 8 .Net Update #2 is just about here

Just to tease us the update page is there but the links are dead. Anders blog gives us the hint it should be there before the end of the day. We are getting both a full update to Delphi as well as a much improved help file.

Here is to hoping we have a really usable tool with these fixes.

Labels:

Wednesday, March 10, 2004

Blogging with a Delphi Tool

I got tired of using the www.blogger.com web page for adding new entries. It seems like by the time I get to blogger I have lost that quick little thought or link I wanted to post.I have built a simple little blog editor using the XML-RPC blogging API and Delphi 7. It just provides the basics with the IE DHTML editor control and allows me to easily manage my blog from the system tray (and no VB or OCX's in sight). It can only handle blogger (or more correctly I have only tested it with blogger) and will only deal with a single account but I like to keep it simple.It likely has a few bugsbut if you care to give it a try you can download it below. Comments are welcome. comment

QuickBlog (all files zipped ~ 900KB)

QuickBlog (single file zipped ~ 100KB if you already have Delphi 7)

Happy Blogging

Labels: ,

Monday, March 08, 2004

Hardware upgrades and a new machine

Well, an interesting weekend. It started out with a memory upgrade (it was on sale) so I boosted my ram from 640MB to 1.2GB on my machine. We also decided to replace my oldest daughter's pc (a pentium 300MHz celeron). My youngest already has a decent machine to use (it was one I picked up for using Kylix but that would be a different story for another day). I have had a hate on for this machine since we got it for her but it continued to work through thick and thin but was really showing it's age in the past year or so. So, we bit the bullet and picked up a cheap (hmm, isn't that relative to your current mood) replacement. Well, that started off an interesting weekend...

My wife and I discussed what would be small/big enough and came to the conclusion that a celeron would be suitable for my girl's uses. My wife made the very observant comment that I had said I would never pick up another celeron again (the one I purchased for Kylix was a celeron). I conceded that I wouldn't buy another one from my use and she let me off the hook on that little bit of history.

So, all is well, my wife goes and picks a pc for my daughter, arrives home, and I start the work to get the pc on the network and get the web page blocking stuff in place. While I am sitting there enjoying the pleasures of downloading yet another service pack she mentions that she saw a decent price on a new Intel 3.0GHz with hyperthreading (for histories sake I have been trying to convince myself to purchase a dual cpu for the last 3/4 years but always end up going for a high end single instead). She mentions this because over the last three weeks I have retired two other machine (my daughter's will be the 3rd) for hardware failures and other related issues. So, I was feeling the loss of available machines for testing this and that. This ends up with her back at the store picking up this machine. While at the store she sees an 18 inch flat panel for a really good deal and give me a call (if anyone thinks I am going to say no at this point you have to be kidding). She reminds me that the memory is still on sale. The machine only came with 512MB of ram so we picked up another 1GB to give it a bit of a boost.

Alright, now, by the time my wife gets back I have my daughter's machine taken care of and she is merrily browsing www.pbskids.org so I can now get down to the nitty gritty of getting my new main machine up and running...

Up to this point everything has been a ton of fun (other then the pain of giving that money away) since it is hard to not be happy at seeing a bunch of new shiny toys. But there has to be a catch doesn't there... now my memory comes back to clearly remind me of the horror of setting up a new machine so that you actually have all the tools you need to function (and bill clients). So, I slap down Windows 2003 Server (have been looking for an excuse to really use this version), Oracle, VS.Net, SQL Server, Office Tools, and Delphi 6, 7, and 8, and any other tools I needed. Other than talking a very long time to install all that software it really went exceptionally well. No hardware errors, no OS errors, and other then Delphi 6 everything installed without a hickup. For Delphi 6 I have apparently exceeded my install attempts so now I have to call Borland to tell them to increment the # of installs I am allowed todo.

One funny point (well, actually two) during this is the machine is sitting on the floor with the cover off. It has three fans and I have two cats... one of the cats figures that while I am so involved in setting up software I wouldn't notice it stepping inside the running machine and poking around... it wasn't until I heard the 3rd "bzzzzzz" sound that I noticed the cat was having an extremely good time with the fans (whiskers and paws make a wonderful sound). I will be honest, the thought of trying to take the machine back after just a few hours because it got shorted out by my cat didn't appeal to me (and I woudn't want anything bad to happen to the cat either). After sternly getting the cat away from the box I went back to the task at hand. A few hours later I am telling my wife about the cat (that received a quick white face... I think she was more concerned about the cat then the computer). We both get a chuckle out of it and lo and behold doesn't the cat decide to do it yet one more time while we are both there just to get the point across that if I leave it open they will come.

So, to start Monday off I am on a new machine and actually getting some paying work done, the box has been secured from cat attack, both of my daughters have decent machines to surf and play on. My old machine will sit there for a while as I extract files from it on a as needed basis. I will reshape it into a linux or windows server for various purposes at some distint point in the future... for now it can relax and only needs to serve files to me. The only downturn of the weekend is my wife noting that she now has the slowed machine (and my only remaining laptop). I will have to manage expectations on that one ;).

Friday, March 05, 2004

Oracle and ISA Woes

Oracle combined ISA Server can be a real pain in the you know what. I use ISA Server in my development environment and I must connect to Oracle databases running in my primary client's office. About a month ago my connect speed to their databases really went to pot. It was the connect speed, after the inital connect everything was fine and the speed was quite acceptable. The connect, however, was in the order of about 25 seconds. If you know about TNS you probably already know that in most typical connection scenarios there are two connects each time (the first to the listener and then it gets handled over to another connection for the data connection). If I would drop outside the firewall I could have a connect time in the order of 200-250ms, right where it should be considering the number of hops required. Sounds a lot like a DNS issue based on the timeouts doesn't it.

After much poking, prodding, and web searching the only answer that seemed to there was making adjustments to the servers for the listening mode and a tweak on my ISA Server. Neither of which I was really all that keen to do.

But I found a solution that does work consistently and requires only a minor change on my part. The solution wasn't related to using Oracle but the relationship between the DNS resolution was the key. The DNS entries in the client site aren't published to the outside world (so I put them in my pc's local hosts file). For a lark, I placed the name into the local hosts file on the ISA Server and to my massive pleasure the connect time was returned to the 200-250ms connect time once again.

I do have access to the internal dns server on the client site so I may try having my dns server forward to it as well but for now I am just glad to have the issue resolved. It certainly is a pain to test software when there is such a massive delay between each connect. Really felt like part of my life was simply disappearing into the void.

Tuesday, March 02, 2004

Delphi8 and Crystal Reports solution coming

Anders has noted a newsgroup posting that indicates that update 2 for Delphi 8 will include a fix for using the .NET Crystal Report solution. See the blog entry at the bottom of the page for the post by Danny Thorpe.

Labels: