February 2022 Summaries

The database industry is experiencing a critical evolution, driven by increasing data intensity and the rise of demanding applications. Organizations are seeking ultra-fast modern databases that support any data model and are based on a relational foundation. SingleStore has emerged as a disruptor in the cloud database market, delivering a scalable, relational, multi-model database that supports both cloud and on-prem environments. The company has won several awards for its innovative solutions, including the Cloud Awards' Most Innovative Use of Data category. SingleStore's work with Fathom Analytics resulted in a 12,000x reduction in processing times and the provision of real-time data capabilities. The company is recognized as a cloud database leader by The Cloud Database Report, which praises its multi-model SQL database and emphasis on "data intensity" and converged workloads. With continued momentum as a leader in the cloud database arena, SingleStore aims to equip organizations with a scalable, real-time, multi-model high-performance database that streamlines data storage and processing.

Elephants can't jump, trot, or gallop, but together they can stampede, which is exactly what enterprises are doing to move away from Hadoop. Three industry leaders, Kellogg's, Comcast, and a Tier 1 wealth management firm, have successfully "augmented or retired the elephant" by embracing SingleStore as the successor to Hadoop, achieving game-changing benefits. Kellogg's reduced its ETL process from 24 hours to 43 minutes, an 80x improvement in analytics performance, while improving supply chain dashboards and customer logistics data analysis. Comcast eliminated data bottlenecks to reduce truck rolls, using SingleStore to power fast analytics on streaming data, helping customers in real-time at scale. A Tier 1 wealth management firm built a dashboard that delivers instant query responses in milliseconds, supporting 40,000 concurrent users with ease, while providing five years of historical data for deeper portfolio and market analysis.

This engineer showcase series highlights the incredible work of SingleStore's data and software engineers as they build a database that helps customers stay relevant in a rapidly changing world. Yamil Molinar, a software engineer at SingleStore, shares his background in robotics, favorite tools such as Go, and what makes working at SingleStore an excellent experience for him. He emphasizes the importance of understanding the tech behind every database, their tradeoffs, and market trends to navigate the crowded database market. Yamil also hopes to see SingleStore dominate the cloud RDBMS space for data-intensive use cases in five years.

This edition of SingleStore’s engineer showcase highlights the incredible work of software engineer Marta Vasconcelos, who joined the team after being introduced by her manager and is now based in Dublin, Ireland. Marta shares her favorite tools, including React, and offers advice to developers navigating a crowded database market, such as choosing their niche and finding growth potential within a product company. She also emphasizes the importance of writing code that future versions can understand and highlights SingleStore's goal to become one of the top databases in top tech companies in five years.

Many organizations have relied on MySQL for their customer-facing applications, but as these apps continue to grow in complexity and scale, they are finding that traditional databases like MySQL are struggling to keep up. In response, companies are turning to distributed SQL databases like SingleStore, which can handle high transaction volumes and complex queries without compromising performance. By migrating from MySQL to SingleStore, organizations can unlock significant performance advantages, including faster data ingest, query latency, and concurrency. Several case studies, including Stream Hatchet and Fathom Analytics, demonstrate the ease of migration and the benefits of using SingleStore, which offers a range of tools and features to make the process as smooth as possible. With its multi-model support, native JSON document support, and efficient relational SQL capabilities, SingleStore is an attractive option for companies looking to upgrade their databases and improve their overall performance.

SingleStore is a modern database technology that can ingest and process large amounts of data at ultrafast speeds, making it ideal for companies dealing with massive datasets. The company claims to be able to load tens of billions of rows into a database in just 10 minutes, resulting in 152.5 million rows per second being ingested into a single database. To achieve this feat, SingleStore uses Pipelines, which are built-in data processing tools that allow users to extract, transform, and load data in parallel at ultrafast speeds. The company provides an example of loading 100 billion rows into a table using a Pipeline, which is achieved by creating a Unix shell script that generates the data, splitting it into smaller files, compressing them, and then uploading them to an AWS S3 bucket for processing. Once the data is loaded, SingleStore can deliver this impressive display of speed consistently at regular intervals, making it an attractive solution for businesses dealing with large datasets.

The Big Game is one of the most widely streamed media events, attracting a massive volume of data and requiring seamless streaming experiences to manage. Streaming companies must handle complex, real-time data analytics to deliver quality content in real time, without outages or poor user experiences. The success of cable TV has led to an explosion of internet streaming services, with new providers entering the market, driven by consumer expectations for personalized media and high-performance infrastructure. To address these challenges, effective data management tools are crucial, enabling organizations to solve data-intensive workloads, reduce costs, and create lucrative revenue streams from advertiser-supported streaming. Successful companies like Comcast and Hulu have adopted modern databases, such as SingleStore, to simplify operations, deliver high performance at scale, and provide real-time insights to drive proactive care and recommendations. By adopting the right data management tools, businesses can benefit from decreased data footprint, improved user experiences, and increased revenue opportunities.

SingleStore is a fast, distributed, highly scalable SQL data platform designed to power modern data-intensive applications and analytics. It delivers maximum performance for both transactional (OLTP) and analytical (OLAP) workloads in a single unified engine, driven by its patented Universal Storage that unifies traditional database row stores and column stores into one table type. SingleStore can drive 100-1000x faster analytics, with features such as streaming ingestion and analytics, fastest event-to-insight response, and handling any type of data. It also offers up to 50% lower costs compared to Hadoop, eliminating the need for high-end support personnel and resources. Additionally, SingleStore has zero complexity, replacing a daisy chain of multiple open-source projects with a robust modern distributed architecture. Finally, it runs anywhere - on-premises, in the cloud, or in a hybrid mode, providing flexibility to enterprises.

The Bytecode Alliance is a vendor-neutral nonprofit organization that aims to create a powerful, secure and simplified software development platform based on WebAssembly (Wasm) and WebAssembly System Interface (WASI) standards. SingleStore has joined the alliance, dedicating significant resources toward building out Wasm technology, with the goal of extending database capabilities by safely running code written in many languages close to the data. This technology is expected to simplify analytics, make them faster and more interactive, and lower Total Cost of Ownership (TCO). The Bytecode Alliance will provide a platform for applications and service providers to confidently run untrusted code on any infrastructure, with security, efficiency, modularity and portability as guiding principles.