About GuidGenerator

The Origin of GuidGenerator.com

I'm Greg, an application architect based in Calgary, and owner of GuidGenerator.com. It started, like most useful tools do, out of a very specific problem I ran into on a client project.

For several years I worked in a tech environment built around two massive core databases - somewhere north of 3,500 tables and 20,000+ columns, holding hundreds of millions of rows of production data. It was, without exaggeration, the best education I've ever gotten in data architecture at scale. Nothing teaches you the real-world consequences of a design decision quite like watching it play out across thousands of interconnected tables over years of evolution. One of the things that stood out immediately was the sheer inconsistency in how keys were handled - text keys, timestamp-based keys, GUIDs, all coexisting, along with a similar mix of natural, composite, and surrogate key strategies scattered across the schema depending on who designed what and when.

Living inside that complexity for long enough, a pattern emerged: GUIDs, more often than not, were the right call. They weren't perfect - there are real tradeoffs around index fragmentation, storage size, and human readability - but for distributed generation, merge-friendly architecture, and avoiding the coordination overhead that natural and composite keys demand, they won out in the majority of cases I encountered.

That understanding became directly useful on a line-of-business application I was building - a substantial one, around 70 screens and 60 reports running against roughly 80 tables. I needed a way to bulk-generate GUIDs quickly for test data and test cases, so I wrote a small console app to do exactly that. It did its job well enough that I figured other developers were probably solving the same tiny annoyance over and over, so I turned it into a website and put it out there for anyone to use.

That was many years ago now, and the site has quietly run ever since, generating GUIDs millions of times over for developers around the world. I hope you all continue to find this tool useful.

Cheers!