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?
Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone. This week's best include Revolv's move from NoSQL to PostgreSQL, a Q&A on Heartbleed, tips on how JOIN order can increase performance in SQL queries, and more.
While writing applications using Angular JS, sometimes we need to define our own validators. Custom validations in Angular JS are created as directives with a dependency on the ng-model directive. At times, key part of the validation depends on controller of the ng-model directive.
Dart comes with a high-performance virtual machine. This controversial decision led to questions if it is going to break the Web. In this article I want to look at why we need this virtual machine, and how it can be added to Chrome without breaking the Web.
This is an update to "Two very useful open source SQL editors." A year later and the author has added one more SQL editor to his first list. He keeps this post updated to give context to lists of Open Source SQL front ends.
NewSQL is growing in popularity because it preserves the value accumulated over the last 30 years of database development and deploys that capability on modern architectures and configurations. But SQL is dead, right? Not even close.
The traditional gap impedes system integration, user acceptance testing, visibility into project progress, and corporate governance. ALM PaaS bridges the development gap between corporate IT and distributed outsourced development activities.