Tag: SQL


return to all posts

People Don’t Buy Technology. They Buy Simplicity.


When I first encountered HarperDB, it was because I was trying to solve a problem related to storing and analyzing high-speed IoT sensor data on edge devices with limited resources. Traditionally, you write the data to a transactional database- often times a document store like MongoDB. Then you configure some ETL process to transform and … Continued

Drive Digital Transformation with NoSQL & SQL


We have written a lot about the technical need to combine NoSQL and SQL solutions for handling big data workloads.  That said, what are the business impacts of combining both NoSQL and SQL?  When should I use an object model vs. a query model?  What use cases require both?  Today we thought we would look at best practices for … Continued

Join Us: Let’s Talk SQL Joins


 After coming up with the worst pun ever made in the database community, this title, to talk about one of if not the most powerful features in relational databases: the SQL join. I believe that the joins are a big reason the relational databases have stayed so relevant in a world where everyone seems to … Continued

HarperDB’s Exploded Data Model


If you’ve looked around our website, talked to us at a trade show, or read an article about us, you’ve probably heard about our exploded data model. This is the keystone of HarperDB’s innovative database solution. Our exploded data model is the reason we are fully-indexed with no data duplication, it’s why we can support full SQL and … Continued

The Biggest Bottleneck in Application Development


 The other day I was thinking back to the days when I worked in custom application development. I asked myself a question: what was the biggest bottleneck that slowed your projects down? After having a wonderful conversation with myself I began asking my friends the same question. The overwhelming answer has been simple, the database. Systems don’t … Continued

HarperDB-Mixing SQL and NoSQL


Original Post by Dhruv Kanojia, can be found here Earlier this year, in February (2018), HarperDB organized a Hackathon and thanks to that I found a database I had been looking for. By mixing the NoSQL with SQL, I now have a database that will let me scale easily, while still being able to use SQL (I … Continued

SQL Queries to Complex Objects with ARRAY() Function


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 … Continued