323-546-9164 info@sunsprinkle.com

AWS Aurora Serverless

AWS now offers Aurora Serverless [1] a new version of its MySQL compatible database that scales up or down on-demand or automatically based on load. It is very cost-effective with per-second billing and ideal for intermittent, unpredictable workloads. The significance of this cannot be overstated. Scaling databases used to be a lengthy

0 Comments

Amazon S3 in 3 Minutes

AWS S3 (Simple Storage Service) is an Amazon foundational service for easy management of any size data. This 3-minute read explains the nuances of the four different flavors of S3. S3 Standard S3 Standard is the default option upon which entire companies are built. It is used for image storage, content distribution,

0 Comments

Choosing between DynamoDB vs MongoDB

This post compares DynamoDB vs. MongoDB, the two most popular noSQL databases. NoSQL databases are developer friendly because data is stored in JSON-like documents that easily map to objects of a programming language. The documents (rows in SQL) can be of different structure each because no upfront definition of a schema

0 Comments

Embedded Analytics Dashboard

Powered by Looker is the term coined by Looker for embedding entire analytics dashboards into your proprietary software, i.e. white labeling Looker as your own solution. A lot of SaaS systems, especially enterprise grade, need a reporting layer. Analytics and Reporting is an important if not the most essential aspect of a

0 Comments

MongoDB 3.6 New Features

1. MongoDB Change Streams https://docs.mongodb.com/manual/changeStreams http://plusnconsulting.com/post/MongoDB-Change-Streams/ Change streams can benefit architectures with reliant business systems, informing downstream systems once data changes are durable. For example, change streams can save time for developers when implementing Extract, Transform, and Load (ETL) services, cross-platform synchronization, collaboration functionality, and notification services, for any real-time

0 Comments

Data Pipelines in the Cloud

This post is a musing on data pipeline tools. A high-level discussion is followed by three commercial products: StitchData, Alooma, and FiveTran. The list is incomplete and only represents the opinion of the author.  A data pipeline is software that integrates with diverse internal and external data sources for the

0 Comments