How many times have you run into a situation where you wish you could do a SQL join without getting duplicate rows back? What if we could get a list“column” returned instead? HarperDB’s ARRAY() function enables just that. In this blog post we’re going to take a look at a basic example of people with addresses and phone numbers.
After discussing HarperDB with the developer community this past fall one of the most commonly asked questions was“Do you have an ORM?” The simple answer is, no, but the reason behind this answer is more nuanced and in depth than we typically would have time to discuss. Our, no, is not because we hadn’t had development cycles to create or integrate with an ORM. Our, no, is because we believe an ORM is a conveniently flawed design pattern in building applications and in the way some databases handle data.