Insights and Updates

Read the HarperDB teams’ thoughts on database technology topics such as SQL, NOSQL, Edge Computing, IoT, Industry 4.0, and more

SQL Queries to Complex Objects with the ARRAY() Function

March 20, 2018

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 listcolumn” 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. 

Read More

ORM Madness 

February 27, 2018
 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.
Read More