EveryBlock, the Django-powered hyperlocal news and data site, has included feeds of items recently added to the Public Library of Charlotte and Mecklenburg County online catalog. Mecklenburg county (North Carolina) residents can find out about the newest books and DVDs added to the more than 20 branches in that library system. This site, launched in [...]
databases
Finding hard-deleted parent records
November 18, 2008 By Leave a Comment
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 [...]
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 [...]
NYT to offer free archives access
September 17, 2007 By Leave a Comment
The Associated Press reports today that The New York Times will begin offering free access to portions of its online archives beginning this Wednesday, September 19th. Effective midnight on Tuesday, NYT will do away with if fee-based subscription program and allow free access to NYT articles from the last 20 years (1987 – present), as [...]
Latest Comments