Company1 min Read

We all share the virtue of wanting to love and to be loved. That’s a good thing. We should accept and celebrate love in all of its many for…
Read Post
Database3 min Read

You did it again—you just blinked. According to the Harvard Database of Useful Biological Numbers, a  blink of a human eye  lasts roughly 100 milliseconds. Not a long period of time, but a relative eternity compared to SingleStore use cases such as: (i) A large ride-sharing company executing 40,000 concurrent transactions with an SLA of two milliseconds, (ii) Real-time fraud detection for a top-tier bank, running several analytic queries within their 50-millisecond service level agreement (SLA…
Read Post
Database2 min Read

Modern applications provide responsive, data-driven user experiences, and their analytic queries present a constant challenge for SaaS application developers. If you’re an app developer, you are probably already familiar with the intense pressure to scale data infrastructure without slowing services, or showing your customers the dreaded spinning pinwheel.  Speed matters . In a competitive market, ludicrously fast customer experience (CX) is everything. SingleStore’s new eBook tells the story of…
Read Post
Engineering6 min Read

SingleStore's frontend-focused development team works on all sorts of interesting challenges to simplify the User Experience of our product. In this blog post, we talk about how we hire engineers for this team. SingleStore’s Hiring Process for Frontend-Focused Engineers We're actively hiring frontend-focused software engineers, and I thought it'd be a good idea to write about our interview process. Not only will this be helpful for potential candidates, but I also think it'll be useful for me to…
Read Post
Database3 min Read

MySQL has tens of thousands of users leveraging it for complex technical challenges, but single-box database systems still reach their limits when pushed. In this blog post, we summarize three of the most common errors users see on MySQL and some tips and tricks on how to approach them, as well as what to look for when seeking a more scalable alternative. Feeling like you’ve maxed out MySQL? Let’s dive in and learn more.  Error #1: Too Many Connections When building applications, you may find…
Read Post
Analytics2 min Read

Jordan Tigani is the Chief Product Officer at SingleStore. He was the co-founding engineer on Google BigQuery. He also led engineering teams then product teams at BQ.  Overview of HumAIn Podcast Season 5  |Posted on  May 5, 2021 |Posted in: # data science , # fast analytics ,  # intelligent applications , # jordan tigani , # singlestore SingleStore powers Comcast with their streaming analytics to drive proactive care and real-time recommendations for their 300K events per second. Since switching…
Read Post
Database5 min Read

Everybody has heard of the KISS principle -- Keep It Simple, Stupid. When applied to data management technology, it implies that you should use a simple solution when it works. Developers often believe that means using a single-node DBMS like MySQL, PostgreSQL, or SQL Server. So, what is a “single-node” database? Essentially, it’s a database designed for a single machine. The capacity of a single machine dictates the resource constraints of processing power, connections, and storage. If you need…
Read Post
Performance3 min Read

Linus Torvalds had some interesting things to say about AVX512: “I hope AVX512 dies a painful death… I absolutely detest FP benchmarks, and I realize other people care deeply. I just think AVX512 is exactly the wrong thing to do…”. Having had the unique opportunity of migrating a portion of SingleStore’s library of SIMD kernels from AVX2 to AVX512/VBMI over the last few months, I disagree. For one thing, AVX512 is not designed solely for floating-point workloads. SingleStore’s code fundamentally…
Read Post
Analytics6 min Read

Everyone remembers their first experience in a Tesla. Mine was in Las Vegas with a good friend and CIO. I was in town for a tech conference and that provided a good opportunity to reconnect and discuss a new project. He offered to pick me up at my hotel. That was the moment I was first introduced to Tesla’s unique Ludicrous mode. It was exhilarating. The Strip became one long, breathless blur. If you haven’t experienced zero to 60 mph in 2.2 seconds, take a look at the “Tesla reactions” genre of…
Read Post
Announcement2 min Read

Today, Martin Luther King Jr. (MLK) is celebrated, honored and remembered as one of America’s greatest leaders for his transformative ability to move the needle forward in regard to the civil rights movement in the United States and throughout the world. King sought equality and human rights for African Americans, the economically disadvantaged, and all victims of injustice through peaceful protest. Commitment. Determination. Clarity. Vision. Inspiration. Transformational Mindset. These words…
Read Post
Data Strategy6 min Read

On this National Cut your Energy Costs Day, it’s a good time to think about our carbon footprints at home and at work as data professionals. Since the first home was electrified in Manhattan in the 1880s, our home electricity usage has grown dramatically. According to Energy.gov, residential homes now account for 22% of all electricity consumption in the U.S. Roughly 63% of this electricity is still generated by nonrenewable fossil fuel sources in the U.S. according to the Energy Information…
Read Post
Data Strategy4 min Read

With the world still recovering and reorganizing from COVID-19 and How the Global Pandemic has reshaped supply chains, infrastructure, and the way that business is processed, 2021 is anticipated to be a year to make big gains for companies that embrace and implement strategic Digital First Strategies. Whether Mobile First, Tablet First, or Laptop First strategies are at the forefront of your organization, data will continue to reign supreme as 5G continues its global roll-out. What strategies…
Read Post
Engineering4 min Read

SingleStore introduced an APPROX_PERCENTILE function to estimate percentiles for a distribution of values. This function is faster and near-exact as compared to the analogous functions that calculate exact percentiles. Read more to learn about this feature and see the performance and accuracy comparisons between approximations and precise values on a sample dataset. Please check this demo video to learn more about the approx_percentile function in SingleStore: If you have a sizable numeric…
Read Post
Announcements4 min Read

SingleStore is proud to announce the general availability of SingleStore DB 7.3 for immediate download. SingleStore DB 7.3 is also available today on SingleStore Managed Service, the company’s elastic cloud database, available on public cloud providers around the world. At SingleStore, we are building the next great database platform. SingleStore DB is a distributed operational database that delivers speed and scale. As the leading NewSQL platform for real-time analytics and augmented…
Read Post
Announcements4 min Read

SingleStore Universal Storage technology is a dramatic evolution of our columnstore data format that allows it to support both operational and analytical workloads with low total cost of ownership (TCO). People love our rowstores for OLTP-style access patterns because of our great performance based on memory-optimized data structures and compilation of queries to machine code. But for users with large data sets, the cost of providing servers with enough RAM to hold all the data started to be…
Read Post
Machine Learning4 min Read

Abstract Many organizations today are looking for ways to run Machine Learning (ML) models in operational systems at scale. Data Scientists can now take models that they build in SageMaker and deploy them as user-defined functions within our general purpose, relational database. Read more about how you can accelerate the execution of your models against real time data. You can also find in-depth notebooks detailing how to implement this on GitHub . Setting the Stage AWS SageMaker has quickly…
Read Post
Engineering4 min Read

I once heard that a “book worth reading is worth reading twice”, and I’ve found this to be true about other things as well. There’s a documentation page that’s been with me for the majority of my professional career; a page that I keep coming back to and that I’ve read from start to finish, without skipping a word, more than a few times in the last few years. This document is GitLab’s Embracing Asynchronous Communication guide , a section of GitLab’s public handbook that goes over their…
Read Post
fastboards4 min Read

When I joined an integration company in late ‘99, I didn’t think data and integration would be my focus and passion. But here I am coming up to 2021, more than 20 years later, in a market that has only gotten more exciting and more relevant to the business. In the early 2000s, it was all about the “connected enterprise”, getting your apps working together. Then it was the “intelligent enterprise” and we saw the rise of the enterprise data warehouse and analytics. In the early 2010s, Big Data…
Read Post
real-time4 min Read

Business is about serving the needs of customers. But customer expectations are changing quickly, and most organizations are not truly aware of how fast that’s happening. Most businesses are moving in slow motion relative to their customers. That means they miss out on opportunities to make decisions about and act on the moments that matter. In the past, lag time was accepted. Nielsen called people on the phone to understand their TV viewing habits. Broadcast TV networks set advertising rates…
Read Post
SingleStore2 min Read

Today is Veterans Day, a time to recognize and thank our military servicemen and servicewomen. As a civilian, my frame of reference for the kind of sacrifice these individuals make is limited. In my efforts to better understand and appreciate their experiences – and enormous contributions – I have relied on a few movies that I find extremely inspirational. Amid the pandemic, people are subscribing to streaming services and watching movies more than ever . Movies bring history to life…
Read Post
Industry4 min Read

As a follow-up to our recent webinar with SingleStore Field CTO Domenic Ravita and our guest Forrester VP Principal Analyst Noel Yuhanna, we take a deeper dive into market-facing pandemic-relevant questions. Noel shares some of his key learnings over the past eight months. He talks about how businesses are learning to leverage data and analytics during COVID-19, the suddenly urgent need for real-time data, the benefits of a multi-cloud data and analytics strategy, and why companies must focus…
Read Post
Case Study9 min Read

Cybercrime damages in 2021 are expected to reach $6 trillion , with organizations of all sizes and industries exploring ways to protect themselves better. Potential security vulnerabilities come in many forms, from cross site scripting to improper privilege management. Over 17,000 new security vulnerabilities were discovered in 2020 alone. IT security teams are responsible for securing infrastructure that’s continually increasing in complexity, so it’s challenging to respond quickly to newly…
Read Post
fastboards6 min Read

Introduction Over the last many years, analytical dashboards have proliferated enterprises from the boardroom to the manufacturing line. As businesses have become increasingly more reliant on analytics, end users have started to demand snappier performance from their dashboards. Gone are the days that visualizations are used simply for historical data. Data professionals are now using them for predictive and prescriptive analytics on petabytes of information, expecting the most real-time…
Read Post
Announcement4 min Read

Today is an important milestone for our company. We have rebranded the company to reflect that we offer much more than an in-memory database. We also have an expanded vision to share. SingleStore, formerly MemSQL, provides one platform to actualize all of your enterprise’s data. “What’s in a name?” The MemSQL name has stood for unrivaled speed, scale, and simplicity for operational data since its founding in 2011. It is a well-recognized name among the data architect and performance engineer…
Read Post
Partners4 min Read

Infosys and SingleStore are now working together, identifying opportunities to implement SingleStore – a fast, scalable, relational database, renowned for fast analytics, streaming support, and solutions in areas such as financial services, digital media, telecom, and IoT – with the speed and effectiveness for which Infosys is rightly renowned, worldwide. Infosys is a global leader in next-generation digital services and consulting, with clients in 46 countries. With over three decades of…
Read Post
Partners3 min Read

Red Hat Marketplace provides a one-stop shop to purchase enterprise applications and deploy across any cloud or on-premise SAN FRANCISCO – SEPTEMBER 8, 2020 – SingleStore, The Database of NowTM for operational analytics and cloud-native applications, today announced that the SingleStore scalable SQL database is now available through Red Hat Marketplace. Red Hat Marketplace is an open cloud marketplace for enterprise customers to discover, try, purchase, deploy, and manage certified container…
Read Post
Resources2 min Read

The Database of Now delivers operational insights and advantages by providing the current state of the business. It is a modern, efficient approach to cloud data management which broadens, accelerates, and simplifies access to all the relevant in-the-moment and historical data while unifying data access styles and patterns. Digital transformation projects have accelerated to meet the increased demand for digital products and services providing answers and solutions with immediacy. With the…
Read Post
Engineering4 min Read

You run a database. You try to anticipate the future. You try to provide sufficient, even generous, resources to accommodate future growth in your service. But sometimes, growth far exceeds even your most optimistic expectations, and now you have to figure out how to accommodate that. One obvious way of increasing your database’s ability to handle and service more data is to simply add more machines to your cluster. That should increase the number of cores, and the amounts of memory and disk…
Read Post
Product9 min Read

You can run SingleStore software effectively on Windows, using the Windows Subsystem for Linux Version 2 (WSL 2). This is a development cluster running on a single host, and not suitable for production deployments – but fully capable for many development and demo tasks. You can also run SingleStore Managed Service for free or spin up a SingleStore cluster on Linux , on Docker Desktop , on Kubernetes , or on Vagrant , all in roughly 10 minutes. Read on to see how you can run SingleStore on…
Read Post
Announcement2 min Read

The following announcement is being released by SingleStore today on the news that SingleStore is a winner in the 2020 SaaS Awards, for Best SaaS Innovation in the Internet of Things. SingleStore Named 2020 SaaS Awards Winner Global Software Awards Program Announces Final Winners San Francisco, CA – 25 August 2020 – SingleStore, The Database of Now™ for operational analytics and cloud-native applications, is a winner in the 2020 SaaS Awards Program in the category of The Best SaaS…
Read Post