Community Hub

Join the Growing SingleStore Community

Get expert advice, develop skills, and connect with others.

Join the Forums
SingleStore Community
Play IconVideosFlask IconProjectsComments IconForumsUser IconTrainingStar IconWish List

See SingleStore in Action

Watch product demos, customer use cases, and catch up on developer live streams.

TDD a TypeScript API with Jest; AMA; New developers welcome
Video
TDD a TypeScript API with Jest; AMA; New developers welcome
In this episode, we take a step back and code-review the failing tests. It's only 1 line! Let's write a suite of tests to flex this line and prevent the fails. Then we take the user edit screens for a spin and build out the new-user features. It's all in TypeScript, Express, Jest, and Vue. Grab the code at https://github.com/robrich/product-catalog, and join us every week at 11 am pacific at https://twitch.tv/memsql. New developers welcome. #MemSQL is now #SingleStore
Watch Now
How to Migrate MySQL to SingleStore
Video
How to Migrate MySQL to SingleStore
Watch Sarung Tripathi, Dir. of Solutions Engineering at SingleStore, show how to migrate from MySQL to a SingleStore database. How to Migrate from MySQL to SingleStore: https://www.singlestore.com/blog/how-to-migrate-from-mysql-to-singlestore/ Free trial: https://www.singlestore.com/free/?utm_medium=osm&utm_source=youtube Ask questions in the Forum: https://www.singlestore.com/forum/?utm_medium=osm&utm_source=youtube Talk to an expert: https://www.singlestore.com/contact/?utm_medium=osm&utm_source=youtube #MySQL #SingleStore #Migration #HTAP #CloudDatabase #DistributedSQL
Watch Now
SingleStoreDB Demo: Real-Time Marketing Offers & Analytics
Video
SingleStoreDB Demo: Real-Time Marketing Offers & Analytics
#realtime #realtimedata #marketing #telco #martech #adtech #singlestore #distributedSQL #demo This SingleStoreDB demo dives deeper into how to serve ads to users based on behaviors and real-time location. SingleStore's Director of Solutions Engineering Sarung Tripathi guides you through a demo based on location, purchase and request history from millions of simulated subscribers for a hypothetical service company. It's a fictional telco with millions of subscribers and serve them targeted ads in offers to customers in real time. Targeted advertisements as served based on demographics, geo location, purchase history, and much more. SingleStoreDB is evaluating 80 million ad-serving opportunities in real time and simulating 30,000 to 50,000 ads and offers in real time to cell phones. This real-time digital marketing app sends out notifications of offers that are based on matching algorithms and complex customer segmentation on real-time and batch data. 00:00:00 Introduction 00:01:46 Demo Overview 00:02:18 Real-time Application in Action 00:03:12 Batch & Streaming Data Sources w/Multi-model Data Types 00:04:01 Logical Data Flow from AWS S3, SingleStore Pipelines, Matching Algos 00:05:05 Starting Up SingleStoreDB 00:07:36 Creating your Database, Setup the Schema and Connect 00:08:38 Customer Segments Table Defined as an In-Memory Rowstore Table 00:09:17 Purchases Table Defined as a Universal Storage Table (unified table type with 3-tier storage: memory, local SSD and cloud object storage) 00:10:29 Locations Table defined with Multi-model Data 00:11:00 Ingesting Data in Parallel with SingleStore Pipelines 00:12:22 Benchmarking Streaming Data Ingestion Speed 00:12:41 Real-Time Offers: Max Bid Price, Activation Zone, Segmentation & Notifications 00:14:18 Deliver 78.6k Ads by Evaluating 40.2M Opportunities Over 3.0M Segments in only 764 milliseconds 00:15:08 Geospatial Dashboard of Notifications with Real-Time Analytics. 100,000 Subscribers with 400 Offers Across 561 Segments with Segmentation Executing in 185 milliseconds. Matching Algos Execute in less than 100 milliseconds. 00:15:51 Advertising Analytics Dashboard Super-fast, responsive interactive analytic dashboard giving users delightful data experiences. Slice and dice the real-time streaming data and sort by highest conversion rates. See the power of transactions and analytics with SingleStoreDB. 00:16:43 Ad Hoc Analytics with SQL Vendor analysis by joining purchases with locations on subscribe ID and examine a specific vendor with geospatial and time-series data. Ranking analysis to determine the conversion rates by geographic zone in #NYC by customers and vendors in under 200 milliseconds. 00:18:30 Why Choose SingleStoreDB 20x-100x Better Performance. Simplicity & Lower Cost. Real-Time Operational Analytics 00:19:41 Powering Data-Intensive Applications with SingleStoreDB Unifying OLTP, OLAP, Streaming, Batch, Diverse Data Models with Multi-Model, and Tiered Storage 🟣 Resources Source code on GitHub: https://github.com/singlestore-labs/demo-realtime-digital-marketing Universal Storage (unified table type): https://www.singlestore.com/blog/singlestore-universal-storage-episode-4/ Try SingleStoreDB free: https://www.singlestore.com/cloud-trial/ 🤙 Hang out and ask questions in the SingleStore Forum: https://www.singlestore.com/forum 🥰 Loving SingleStoreDB? Share the love with a TrustRadius review: https://www.trustradius.com/products/... 👩‍🚀 Follow Sarung: https://twitter.com/sarung #OperationalAnalytcs #HTAP #Translytical #SQL #Mulrimodel #Relational #Database #Geospatial #GIS #Geofencing #TimeSeries #TimeSeriesAnalysis #DataIntensive #StreamingData
Watch Now

More Videos

View All
Chevron Left Icon
Chevron Right Icon

Watch more on SingleStore’s YouTube Channel and our live stream on Twitch TV

Break Through with SingleStore

Learn how others in the community successfully use SingleStore in their projects.

Community Conversations - Vinicius Ruoso
Video
Community Conversations - Vinicius Ruoso
Vinicius Ruoso, CTO at Leads2B, joins Domenic Ravita of SingleStore for this Community Conversation. Leads2B is a sales growth machine, an integrated sales & marketing system for the Brazilian market. Leads2B is a one-stop system for integrating with social media, web sites, and email and communication systems. Vinicius works diligently with executives and the product team to optimize the system and deliver value to customers. In this discussion, Vinicius discusses the real-time needs of their system, the data stores they tried previously, and why SingleStore was the perfect fit for their company. #community #MemSQL is now #SingleStore 0:00 - Introduction 1:17 - Introducing Leads2B 4:40 - Data challenges: #realtime, #bigdata 6:19 - What sources and rates do you ingest? 7:50 - How big is the data you're storing and ingesting? 10:09 - What does Leads2B need in a data platform?: #interactive, #geolocation, #lowlatency 12:58 - How did BigQuery work out? 13:34 - What attracted you to MemSQL? 15:28 - What skills did the team need to learn to use MemSQL? 16:02 - What MemSQL capabilities are you using?: #analytics, #geolocation, #popularity 19:41 - How are you using Machine Learning in the popularity score collector? 20:40 - What are your concurrency needs?: #nolocks, analytics during ingest 23:17 - What SLAs do you need for user-facing systems? 25:04 - How much data is under management? 26:10 - Are you using in-memory row store and on-disk column store? 26:57 - What schema design decisions did you make with row store and column store? 29:45 - How did you design with #datasharding? 31:49 - What other products did you try to scale / shard MySQL before you moved? 33:31 - What advice do you have for the users looking at MemSQL?: #realtime #analytics 36:15 - What's next for Leads2B?: #MachineLearning 38:00 - What do you love about MemSQL? 39:40 - How long have you used MemSQL? 40:12 - How many people develop the Leads2B platform? 41:16 - Signing off
Watch Now
SingleStore | Community Call | July 2022
Video
SingleStore | Community Call | July 2022
00:00 Intro 00:41 Community Updates from Maria 06:46 Summer Release of SingleStoreDB 14:43 Meetups, Conferences and How-to with Akmal 20:04 Running SingleStoreDB on Apple M1 with Charlie Appearances: Host: Domenic Ravita - SingleStore Head of Community (https://www.singlestore.com/forum/u/dravita) (Twitter: @DomenicRavita) Co-Host: Maria Silverhardt - SingleStore Community Manager (https://www.singlestore.com/forum/u/mariasilverhardt) (Twitter: @MsDataDetective) Guest - Charlie Joseph - Laravel developer (https://www.singlestore.com/forum/u/heychazza) Twitter: @heychazza Guest - Akmal Chaudhri - SingleStore Developer Evangelist (https://www.singlestore.com/forum/u/achaudhri) (Twitter: @akmalchaudhri) Links: SingleStore Developer Hub: https://www.singlestore.com/developers SingleStore Labs on GitHub: https://github.com/singlestore-labs SingleStore Forum: https://www.singlestore.com/forum New Feature Summary in SingleStoreDB’s Summer Release: https://www.singlestore.com/blog/whats-new-in-singlestoredb/ SingleStore Wasm Space Program: https://wasm-space-program.labs.singlestore.com/ GitHub repo for SingleStore Wasm Space Program: https://github.com/singlestore-labs/wasm-space-program Community Events, Meetups and Conferences: https://singlestore.com/events#community Charlie Joseph’s Minecraft Analytics: https://analyse.net/ Charlie’s article: Running SingleStore on Apple Silicon: https://laravel-news.com/running-singlestore-on-apple-silicon #Laravel #AppleM1 #AppleM1Chip #database #SQL #SingleStore #Wasm #WebAssembly #API #devcommunity #distributedSQL
Watch Now
Big Data Journey: Unifying and Modernizing Databases With Imperva and SingleStore
Video
Big Data Journey: Unifying and Modernizing Databases With Imperva and SingleStore
Enterprises around the globe choose Imperva for world-class security. Imperva is a nine-time Leader in the Gartner® Magic Quadrant™ for Web Application and API Protection (WAAP). Learn how Imperva has built a cybersecurity one-stop shop with SingleStore and Twingo. Imperva covers all the bases in cybersecurity. It also has expert knowledge in a myriad of specialized areas such as combating bots and fraud in eCommerce. Learn more here: https://www.singlestore.com/customers/seed-cms/ About SingleStore SingleStore delivers the cloud-native database with the speed and scale to power the world’s data-intensive applications. With a distributed SQL database that introduces simplicity to your data architecture by unifying transactions and analytics, SingleStore empowers digital leaders to deliver exceptional, real-time data experiences to their customers. About Twingo Twingo is a leading technology provider of expert services, products and projects for Big Data & BI Analytics, serving data-driven companies and start-ups in the Israeli market.
Watch Now
SingleStore | Community Call | September
Video
SingleStore | Community Call | September
Watch Now

Try SingleStore for free today.

Download Now

The SingleStore Forumsforums

Ask, learn, and engage with the community by asking questions and posting projects. Sign up Today!

Posted in Welcome (Start Here)

SingleStore AMA Event: Monitoring SingleStore March 17

Comment Icon3
Eye Icon1368
Julie's avatar image
Posted in Introductions

Introduce yourself here!

Comment Icon4
Eye Icon1371
Julie's avatar image
JoeKarlsson's avatar image
MariaSilverhardt's avatar image
Posted in Help

Invalid JSON value for column for pipeline and stored procedure

Comment Icon17
Eye Icon283
ahkjeldsen's avatar image
Tigran's avatar image
Posted in SingleStore Tools

Returning >300 rows in SingleStore Studio

Comment Icon10
Eye Icon2290
dhenry's avatar image
david's avatar image
ganesh.usi.gk's avatar image
marta's avatar image
Posted in Off-Topic

Using SingleStore in AWS Glue (as source and target)

Comment Icon23
Eye Icon2018
oemer.percin's avatar image
carl's avatar image
iblinov-ua's avatar image
saurshan's avatar image
Posted in 3rd-Party Integrations

Power BI Connector

Comment Icon31
Eye Icon2547
moralez.rodrigo's avatar image
sdew's avatar image
KillerDAN's avatar image
e.soden's avatar image

SingleStore Champions

Franck Leveneur's avatarTrophy Icon
Franck Leveneur
@franklw
Gerry Morgan's avatarTrophy Icon
Gerry Morgan
@gerry
Martin Skovvang's avatarTrophy Icon
Martin Skovvang
@mpskovvang
Vinicius Ruoso's avatarTrophy Icon
Vinicius Ruoso
@vkruoso
Dendi Suhubdy's avatarTrophy Icon
Dendi Suhubdy
@dendisuhubdy
Prerak Sanghvi's avatarTrophy Icon
Prerak Sanghvi
@prerak
Pierre Bazoge's avatarTrophy Icon
Pierre Bazoge
@pierre
Vishwajeet Dabholkar's avatarTrophy Icon
Vishwajeet Dabholkar
@vishwajeetdabholkar
Joshua Blackburn's avatarTrophy Icon
Joshua Blackburn
Yogeshwar Phull's avatarTrophy Icon
Yogeshwar Phull
@yogeshwar.phull

How can I become SingleStore Champion? Find Out

SingleStore Training

Learn how to use SingleStore by taking our guided training. These self-paced courses cover topics like Schema Design, Data Ingestion, Optimizing Queries, and more.

Chevron Left Icon
Chevron Right Icon

Get started in minutes. Enroll Now

Community Wish List

Got a feature you’d like us to add to SingleStore? Share your idea, and we’ll research its plausibility and get back to you.

Star IconMake a Wish
Join the Community Forum

Join the Community Forum

Ask, learn, and engage with the community by asking questions and posting projects.
Sign Up
Subscribe to Our Newsletter

Subscribe to Our Newsletter

Get the latest news & developer announcements straight to your inbox.
Subscribe