While doing further development work today on the customer service module for our Grails-based web site administration tool, I encountered hibernate object retrieval failure exceptions when trying to access the Show views for some of our users. The console indicated these exceptions are due to rows referencing non-existent identifiers, or foreign keys. A look into [...]
database development
Our new e-commerce schema released
November 15, 2008 By Leave a Comment
Our redesigned web site launched late last night, which includes an entirely new inverted e-commerce application. Our original site was built upon a hybrid e-commerce framework (part in-house Java, and part open source PHP-based osCommerce), implemented purely for expediency’s sake to make our holiday shopping season 2007 launch date. However, this temporary solution quickly proved [...]
Database migration challenges
August 23, 2008 By Leave a Comment
I’ve spent most of this past month at work investigating and rectifying some of the challenges encountered during our big database migration this year. We had to launch the initial site so fast that its database architecture did not ever really meet our business needs, or satisfy my personal and professional data integrity standards. Now [...]
The SQL queen
February 8, 2008 By Leave a Comment
Yes, that’s me now… the SQL Queen! I pretty much live, breath, eat, and sleep in SQL code now, thanks to the web developer job. I’ve always been a database nut. I love using them and building them. Searchable full-text databases are what made me decide to become a librarian. When i first went away [...]
Latest Comments