#1 most frequent
United States of America
61.8%268 installations of 434
What is SingleStore?
SingleStore aims to enable organizations to scale from one to one million customers, handling SQL, JSON, full text and vector workloads in one unified platform.
Categories & Use Cases
Videos
Who Buys & Uses SingleStore
#2 most frequent
India
5.8%25 installations of 434
#3 most frequent
United Kingdom of Great Britain and Northern Ireland
5.5%24 installations of 434
SingleStore is Fast and Furious
Use Cases and Deployment Scope
I use SingleStore for the data warehouse of a fintech, which processes payments through TCs worldwide. The integration was with Azure DataFactory, without complications, it helps us in an excellent way since we are very fast in obtaining the data for our dashboards and additionally the compression of the information.
Utilizo SingleStore para el datawarehouse de una fintech, la cual procesa pagos mediante TCs a nivel mundial, la integracion fue con Azure DataFactory, sin complicaciones, nos ayuda de manera excelente dado que tenemos mucha rapidez en obtener los datos para nuestros dashboards y adicional la compresion de la informacion
Utilizo SingleStore para el datawarehouse de una fintech, la cual procesa pagos mediante TCs a nivel mundial, la integracion fue con Azure DataFactory, sin complicaciones, nos ayuda de manera excelente dado que tenemos mucha rapidez en obtener los datos para nuestros dashboards y adicional la compresion de la informacion
Pros
- Fast Data Recovery
- Data compression by 80%
- Having the information in sheets, which helps to process the information quickly
- Simplicity in TSQL
- Recuperacion de Datos de manera rapida
- Compresion de datos en un 80%
- Tener la informacion en hojas, lo que ayuda a procesar la info rapidamente
- Simplicidad en TSQL
Cons
- Azure pipelines do not have many parameterization features compared to others, for example AWS.
- Error handling, for example when it fails due to memory, only indicates that but not exactly in which process it fell.
- a more detailed profiler
- Direct purchase through partners, but buying directly from the brand, I think, would be better without intermediaries.
- los pipelines para Azure no tienen muchas caracteristicas de parametrizacion en comparacion con otros, ejemplo AWS
- El manejo de errores, por ejemplo cuando falla por memoria solo indica eso pero no exactamente en que proceso cayo
- un profiler mas detallado
- la compra directa a travez de partners, sino comprar directo a la marca creo que seria de mejor manera sin intermediarios
Return on Investment
- Our internal clients are happy to have the data quickly.
- Making decisions based on data with a 2-hour delay to the transactional database is excellent since we go from 24 hours to 2 hours.
- I think the best comparison is decision-making with data that is close to reality.
- nuestros clientes internos estan felices al tener la data de manera rapida
- el tomar decisiones en base a datos con un lapso de delay de 2 horas hacia la base de datos transaccional es excelente ya que bajamos de 24 horas a 2 horas
- la mejor comparativa creo que es la toma de decisiones con datos apegados a la realidad.
Alternatives Considered
Exasol
Other Software Used
Azure Data Factory, Microsoft Power BI, Metabase
Why I like SingleStore ?
Use Cases and Deployment Scope
We use SingleStore for a super fast client experience, running real time analytics on billions of events arriving every day from various publishers channels.
Pros
- Performance - Milliseconds response of 80 tables Joined queries
- Scalability - Ability to grow with no downtimes
- Client success - Attentive to business needs, deep level support, patches and fixes
- Efficiency - Built-in Kafka / S3 / MySQL integrations well adjusted to leverage SingleStore architecture and hardware
- .
- .
- .
- .
- .
Cons
- Add Iceberg tables / files Pipeline
- CDC out in form of logfile / binlog / producer to Kafka
- Efficiency with multi shard-key use case: Joined three tables when one of them holds both shard keys of the other two.
- .
- .
- .
Return on Investment
- Graded as the top leaders in the field
- Client satisfaction
- Innovate with each new major release
Other Software Used
Confluent, Snowflake
SingleStore The Ultimate HTAP Database for Real-Time Performance.
Use Cases and Deployment Scope
IOT data processing and log analysis. The power of unified management is evident out of the box. Quick deployment, comprehensive troubleshooting, and customizable periodic reports increase productivity with fewer resources. Streamline, optimize, and elevate the network management experience through a single pane of glass with organization hierarchy, access controls, alerts from security threats, and usage thresholds - solutions that simplify network fabric and prioritize results to improve efficiency.
Pros
- Can scale horizontally on cloud instances.
- Can analyze large volumes of time-series data in real time.
- Can perform queries in milliseconds.
- Can process large amounts of data in parallel.
Cons
- Can be expensive for small startups.
- Migrating from traditional databases e.g., MySQL, PostgreSQL is complex.
- Switching to another database might require significant re-engineering.
Return on Investment
- We used it for Sensor data analytics for industrial IoT.
- Used it for Real-time dashboards for business intelligence.
- Predictive analytics.
Alternatives Considered
Snowflake, Google BigQuery and ClickHouse
Other Software Used
ClickHouse, Snowflake, Google BigQuery
"SingleStore: A Powerful All-in-One Database for Real-Time Analytics and Transactions"
Use Cases and Deployment Scope
Performing real-time risk calculations on complex financial instruments. Advanced analytics at scale helps with risk management and compliance with regulatory reporting requirements. Other usages include an anomaly detection system, order management platform, and tracking and optimization movement across multiple regions in real-time. The distributed architecture and sub second query responses helps manage huge systems with ease.
Pros
- Distributed architecture.
- Sub-second query responses.
- Handling time series data with high write and query performance.
Cons
- The UI can be made more user-friendly.
- Kubernetes integration.
- Compression and storage efficiency.
Return on Investment
- Optimized performance
- Cost saving
- Faster response time
Alternatives Considered
Snowflake and MongoDB Atlas
SingleStore - 10+ years of Experience
Use Cases and Deployment Scope
SingleStore is being used for concurrent high performance reporting powering Tableau BOBJ PowerBI and conventional .net and java pages. It is also being used for real time reporting with data loaded from OLTP systems using GoldenGate, Kafka and Spark. SingleStore is being used in Sales, Finance, Supply Chain, Inventory Management, Marketing, Servicing and Logistics reporting.
Pros
- Powering multiple dashboards on a single screen within short span of time
- Real time reporting for IOT devices
- Warehouse queries powering dashboards which suffers due to concurrency in Warehouse Database Systems
Cons
- Auto failover to DR Site
- Eventual Consistency
- Point in time recovery
- Robust Monitoring
Return on Investment
- Lower operational complexity - Installation and maintenance is pretty easy
- Object scale when used can compete with Traditional Warehouse Systems like Teradata, Netezza, Greenplum
- Adds lot of value to the business like couple of operations which never worked in traditional DBMS including HANA, Oracle In Memory, SQL Server In Memory just flew in SingleStore
Alternatives Considered
Tanzu Data Services (Greenplum, GemFire, RabbitMQ and Tanzu SQL)
Other Software Used
Tanzu Data Services (Greenplum, GemFire, RabbitMQ, Tanzu SQL), MongoDB, Apache Cassandra
