Every week here and in our newsletter, we feature a new developer/blogger from the DZone community to catch up and find out what he or she is working on now and what's coming next. This week we're talking to Eric Schabell, JBoss Technology Evangelist for Red Hat and guest lecturer.
Recently, the author needed to update the last inserted row of a table but didn't have any way of knowing what the highest ID in the table was. He can easily do this by using the max() function to select the highest ID in the table.
Git is magic, but sometimes it drives my crazy with all that power causing strange situations and clean-up work. The magic of git is that it is (nearly?) always possible to clean up the mess and get back to a good state.
The author not recommend any kind of Heap table in database. Why do we do it? But when you have no option for a primary key we can use the surrogate key. The problem is when a Heap table is highly fragmented.
In the author's previous post, he showed some new MySQL 5.6 features which can be very helpful when creating geo-enabled applications. In this post he will show how we can obtain open-source GIS data, convert it to MySQL, and use it in our GEO-enabled applications.
There is a lot of hype about in-memory computing and in-memory real-time analytics. SAP HANA has used savvy marketing and experimental projects to create a storm of interest. Now, everyone wants in. Let’s walk through what you need to consider when deciding if you need in-memory computing.
It is often tempting to mark something as done when it's not quite done. However this sets the wrong expectation with the client, and also confuses development. Wait until all criteria has been met, every last bit.
All projects the author has been working on have used database connection pooling, and that’s for very good reasons. Sometimes we might forget why we are employing one design pattern or a particular technology, so it’s worth stepping back and reason on it.
Haven’t we all been wondering: "How can I do this? I have these data in Excel and I want to group / sort / assign / combine..." While you could probably pull up a Visual Basic script doing the work or export the data to Java or any other procedural language of your choice, why not just use SQL?