Tag: SQL


return to all posts

Deep Dive: NewSQL Databases


Overview One of my colleagues, Margo McCabe, recently posted a great article“Database Architectures & Use Cases – Explained” on dev.to. In response a user asked for a deeper dive on NewSQL databases, so I thought I would put one together. The term NewSQL was coined in 2011 by 451 Group analyst Matthew Aslett. Wikipedia defines … Continued

Database Architectures & Use Cases


With over 300 databases on the market, how do you determine which is right for your specific use case or skill set? We continue to see the common debate of SQL vs. NoSQL and other database comparisons all over social media and platforms like dev.to. In most cases, it’s not that one database is better … Continued

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