Tag: SQL


return to all posts

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 patent-pending exploded data model is the reason we are fully-indexed with no data duplication, it’s why we can support full SQL … 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

Dynamic Schema: The HarperDB Way


How can you possibly have a dynamic schema? Isn’t the purpose of a schema to provide structure to your data? Well, yes, schemas exist to contain objects and define structure. But what happens if I know my data will continue to evolve, as it tends to do? Should you have to constantly rely on developers … Continued