Tag: SQL


return to all posts

HarperDB vs. MongoDB vs. PostgreSQL


Many people learn or understand new things relative to things they already know. This makes sense, it’s probably a natural instinct. When it comes to products and technology, a lot of people ask “how are you different,” but different from what? You need some sort of baseline to start from, so you can say, “Similar … Continued

SQL Explained (By a Non-Developer)


Welcome to the second installment of Developer lingo explained by a non-developer. How do you follow up with a term so widely used and intricate to modern development, like JavaScript? I decided to take it back to a more tried and true function within software development, SQL. SQL stands for Structured Query Language and is used … Continued

Your Hackathon Project NEEDs a Pretzel Necklace


October is upon us… and along with pumpkin spice lattes (or pumpkin beer) I’m seeing a lot of buzz around upcoming hack events in the dev world! Such as Hacktoberfest, API World Hackathon, and the launch of the 2021 Major League Hacking season. Just like Octoberfest wouldn’t be complete without your favorite pretzel necklace, a great hack project needs something … Continued

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

AlaSQL in Action: The JavaScript SQL Database


What’s AlaSQL? For starters, this open source project garners 11k weekly downloads off npm and has over 5K stars on GitHub. I was surprised to see that there aren’t more posts about this popular lightweight client-side in-memory SQL database across different platforms besides this awesome article I found. However, AlaSQL’s website gets straight to the point: JavaScript SQL database for browser and Node.js. … 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