July 2022 Summaries

To create a MySQL database, developers can follow a step-by-step guide using either the command line interface (CLI) or MySQL Workbench. The first step is to download the MySQL server and log in as a user with database creation privileges. Next, choose between CLI and MySQL Workbench for simplicity and ease of use. Before creating a new database, it's essential to check existing databases using the `SHOW DATABASES` command. To create a new database, use the `CREATE DATABASE` command followed by the desired database name. Once created, users can employ the `USE` statement to switch to their newly created database and work with it. Additionally, SingleStoreDB is a real-time, distributed SQL database that unifies transactions and analytics in a single engine, offering high-speed access to large datasets and simplifying the development of fast, modern enterprise applications.

SingleStoreDB is a fast distributed SQL database designed to power modern applications that require real-time access to data and low latency query responses. It currently powers some of the largest mission-critical applications at enterprises such as Uber, Comcast, Disney, and Sirius XM. The company has introduced its newest feature called Workspaces, which enables customers to run multiple workloads on isolated compute deployments while providing ultra-low-latency access to shared data. This allows organizations to manage and meet rapidly changing needs without introducing cost or complexity. SingleStoreDB's unique architecture leveraging native internal data replication ensures applications are always operating on fresh data. With the introduction of Workspaces, customers can create and terminate workspaces directly using the cloud portal or through the scalable Management API, allowing simultaneous operation of multiple workloads on shared data. This feature provides a simple way to manage isolation between ingest and application workloads, enabling isolated workspaces for ingesting from streaming data sources like Confluent Kafka or Redpanda, and dynamically scaling them up or down based on scheduling and performance needs. Additionally, Workspaces allows organizations to run reporting or custom telemetry applications on the fly without incurring charges when a workspace is terminated.

The modern world demands real-time insights and action, which requires a choice of database that can handle complex data plumbing efficiently. SingleStoreDB is a ground-up solution designed for real-time use cases, offering innovations such as unified multi-model capabilities, fast storage architecture, and advanced analytics features like flexible parallelism and dbt adapters. This enables customers to achieve faster response times, lower costs, and improved scalability, making it an attractive option for businesses looking to thrive in today's data-intensive environment. By adopting SingleStoreDB, companies can address data intensity without complexity, improve their digital maturity, and deliver great customer experiences with timely insights.

The SinglestoreDB Code Engine — Powered by Wasm brings the power of existing code to SQL, allowing developers to apply logic close to data and benefit from the full power of SQL. With this feature, developers can move computation to the database, reducing the need to export data to applications and speeding up development. The new feature supports languages such as C, C++, Rust, and others through a Wasm runtime environment, enabling faster performance, reduced labor intensity, and simplified development. By leveraging existing code in libraries or applications, developers can create complex calculations in SQL without writing custom application logic, making it easier to extract value from data. The feature has been validated by customers, who are excited about the possibilities of running application functions in SQL, including sentiment analysis. With SinglestoreDB Code Engine — Powered by Wasm, developers can now perform sentiment analysis with a single UDF or use a TVF for more detailed results, providing flexibility and scalability to meet their needs.

The author aims to build a universe simulation where millions of spaceships make real-time decisions in a massive universe, supported by a unique database called the Wasm Space Program. This project requires a database that can handle large volumes of transactions and analytics, as well as high concurrency for thousands of clients. The author finds SingleStoreDB 7.9 meets these requirements with its Hybrid transactional/analytical processing (HTAP) capabilities, extensibility, and support for WebAssembly (Wasm). The program uses the Code Engine - Powered by Wasm feature to run Rust code directly within SQL queries, Workspaces to isolate portions of the workload, and the Data API to connect directly from a browser to SingleStoreDB. The project results in a real-time simulation where spaceships interact with each other and their environment, providing an engaging experience for players.

Three hours of content, two role-specific tracks, and one product that customers love were covered at the Summer 2022 product launch event. For everybody who cares about data systems, a real conversation about real-time was had in a thought-provoking keynote, where SingleStore CEO Raj Verma explained his vision for real-time and how SingleStore plays a role in creating real-time experiences across multiple industries. A first look at new SingleStoreDB features was also given, including Workspaces, Code Engine Powered by Wasm, and Flexible Parallelism. These features allow customers to scale dynamically, safely port over external code libraries, and use all cores on their machines to process queries. For developers and data engineers, key technical capabilities for real-time databases were discussed, as well as new features like Flexible Indexing, Universal Storage, and Vector Functions. The event also covered topics such as Workspaces, Code Engine Powered by Wasm, Data API, and the SingleStoreDB dbt Adapter. For IT and business leaders, data-intensive applications, IoT and cybersecurity at scale, and the convergence of relational/non-relational databases were discussed. Finally, the fintech revolution and the importance of real-time data and analytics in various industries were highlighted, with companies such as Siemens and impact.com showcasing their use cases for SingleStoreDB. The event concluded with a call to action to try SingleStoreDB free today.

The world's fastest cloud database, SingleStoreDB, has added key features to accelerate enterprise adoption for data applications. Workspaces allow organizations to deploy and scale isolated workloads across shared data, while Code Engine enables developers to push computation directly into the database for performance and agility. The new capabilities enhance the performance, scalability, and manageability of SingleStoreDB, making it easier than ever to build modern data applications. Isolated compute instances called Workspaces enable rich customer-facing applications, real-time analytics workloads, and operationalizing machine learning models at scale. Additionally, SingleStoreDB now provides a Management API for deploying, managing, and operating the database at large scales, as well as Security Enhancements with modern access controls, end-to-end encryption, compliance certification, and advanced access controls. The Data API enables stateless dynamic connections to serverless applications, while Vector Functions enable developers to build and deploy image recognition models, sophisticated financial calculations, and other advanced learning algorithms using Single Instruction / Multiple Data (SIMD). Flexible Parallelism allows workloads to scale evenly across compute resources delivering increased performance and better resource utilization. The Power BI Connector enables business intelligence running directly on the data in SingleStoreDB, while the dbt Adapter provides true data ops with CI/CD data pipelines and SQL for enrichment and transformation. A completely free trial of the cloud database-as-a-service is also available to get started.

In a challenging year due to global events, SingleStore has achieved outstanding results, securing $116M in funding led by Goldman Sachs Asset Management, bringing its total raised capital to $278M and valuing the company at over $1.3B. The new funding round is a testament to investor confidence in the company's growth potential. With this influx of capital, SingleStore continues to strengthen its executive team with key hires including Shireesh Thota, Yatharth Gupta, Brad Kinnish, and Meaghan Nelson. The company has also partnered with industry leaders IBM and SAS to accelerate insights for real-time applications, and conducted a TCO study that reveals its unparalleled performance in the industry, delivering 50% lower TCO compared to other combinations. SingleStore's upward trajectory is driven by its focus on providing both transactional and analytical capabilities in one database, which has enabled customers to achieve fast results in real-time analytics. With this funding, the company plans to invest in innovation and collaboration with Intel to optimize performance and handle new levels of data intensity. An upcoming launch event, [re]volution 2022, will provide a platform for customers to learn more about SingleStore's products and capabilities.

The ability to supercharge real-time customer experiences is crucial for developers, engineers, IT leaders and business leaders alike. SingleStore's Summer 2022 launch event, [r]evolution, will highlight innovations in its database, SingleStoreDB, which unifies transactions and analytics. The event features product demos, industry deep dives and keynotes from SingleStore CEO Raj Verma. Attendees can choose between two breakout tracks: one for developers and engineers and another for IT and business leaders, offering insights into building real-time applications and measuring digital maturity. The event also includes a raffle with prizes and on-demand content will be shared with registrants who miss the live event.

Operational analytics is a form of business analytics focused on improving operations by processing real-time data in real-time, enabling quick decision-making and strategic planning. It has gained prominence due to the increasing adoption of digital technologies, allowing organizations to leverage real-time information from their IT infrastructure to make informed decisions that drive profits and create competitive advantages. Operational analytics differs from traditional analytics, focusing on integration between all systems and ensuring a single source of truth for data, reducing time needed for decision-making by reacting to customer behavior in real-time. It benefits organizations with near-real-time decision-making, trustworthy data from one central hub, improved customer loyalty, consistent business intelligence across tools, and efficient data teams. Operational analytics is used in various industries, including financial institutions, oil and gas industries, and medicine, and requires a database that supports complex queries, low data latency, high query volume, live sync with external sources, and mixed types of data.

This guide provides a step-by-step process to get started with Laravel and SingleStoreDB in minutes. To begin, create a fresh Laravel project and require the SingleStoreDB database driver for Laravel. Update the `database.php` configuration file to use the new SingleStoreDB driver and set up connection details in the `.env` file. Modify default Laravel migrations to be compatible with SingleStoreDB's sharding strategy, including changing unique constraints to plain indexes. After making these changes, run `php artisan migrate` and you should see all tables created in SingleStoreDB. The guide also provides further reading resources for more information on using SingleStoreDB with Laravel.