John Sample

Bits and Bytes
posts - 103, comments - 354, trackbacks - 16


The geocoding project keeps plugging along.

Its getting hard to maintain this thing in a blog format, I may have to switch to something else soon.
There is a fix for zero distance chains that will be up soon, probably tomorrow. If you ever get a divide by zero error this is the problem.
The cause is a few Type 1 lines that have no length.

I'm thinking of changing some of the architecture.
Porting the code between embedded SQL platforms is really slowing me down. I may just release the .NET code and let the user specify the platform.
This way I only have to port the db structure and tweak the queries. A port to JAVA, etc. would be easier at the same time.
In process right now: SQLite and MySql.

Also, one of the things I'm working on is the address parsing. Its coming together, but its probably still a week away.


posted on Monday, August 22, 2005 7:25 PM


# re: Plans

This is a powerful project that you've started. Keep up the good work!

I was able to get it installed and integrated to an application with relative ease.

I would love to see a Java friendly port. What version of MySQL are planning on supporting? Will it take advantage of MySQL 5 stored procedure support?

Thanks for this very helpful project!
8/22/2005 11:18 PM | Brandon Burk

# re: Plans

Thanks Brandon.

I'm using MySql 5, but I'm not sure whether it will be stored procedures or not.
Some of the things I'm trying to do, like address parsing, are getting tough with stored procs. Its even harder when I find a bug to have to update more than one set of code. I may have to pull the logic out of the embedded SQL stuff and keep it in the dll making things like fall through address finding and adding extra return data easier. Getting these other platforms out the door will be a much quicker process at that point.

8/23/2005 7:19 AM | John Sample

Post Comment

Enter the code you see: