announcement

Arrays a Hidden Gem in MemSQL

Arrays - A Hidden Gem in MemSQL

Released this March, MemSQL 6 Beta 1 introduced MemSQL Procedural SQL (MPSQL). MPSQL supports the creation of: User-Defined Functions (UDFs) Stored Procedures (SPs) Table-Valued Functions (TVFs) User-Defined Aggregate Functions (UDAFs) A Hidden Gem: Array Types There’s a hidden gem in MemSQL 6 Beta 1 that we didn’t document at first — array types!  These make programming much more convenient. Since we compile your extensions to machine code, the performance is fantastic. And you...


MemSQL 2.5 Ships Today with JSON Datatype, Online Alter Table, and More

We are excited to announce that MemSQL 2.5 is now available for download.  Of the many new features and performance improvements, one of the most exciting is support for JSON analytics. With native support for the JSON datatype, MemSQL delivers a consolidated view across structured and semi-structured data in real-time. Using MemSQL 2.5, developers can use SQL to easily analyze JSON objects while quickly ingesting JSON data feeds. In addition, MemSQL 2.5 ships with support for ONLINE ALTER...


Oracle Announces an In-Memory Technology, At an Ungodly Speed…And Cost

Oracle OpenWorld started yesterday, and Larry Ellison announced new in-memory options in Oracle 12c. According to PCWeek “The Big Memory Machine costs $3 million, a sum Ellison termed as ‘a fraction’ of what competitors charge.” The core of the newly announced Oracle technology is a columnar store. It is in fact a fascinating technology that leverages compression, vectorized execution using SIMD, and parallel query processing. However, this technology has been on the market for a long...


MemSQL Releases 2.1 - Increasing the Value of All Data in the Enterprise

Today, MemSQL released version 2.1 of its real-time analytics platform, which is available for immediate download. This release includes new features and enhancements to give customers the ability to access, explore and increase the value of data, regardless of the size, age, or format. The release also includes additional SQL surface area and a custom AWS CloudFormation template for fast and easy deployment in the cloud. Here are the new features customers will see in the release: ...


MemSQL ships 2.0. Scales in-memory database across hundreds of nodes, thousands of cores.

When we started MemSQL a little over two years ago, our goal was to deliver the fastest OLTP database ever. Inspired by the scale and architectures we saw at Facebook, we hoped to help every enterprise leverage in-memory technologies similar to those that leading web companies use. As we worked with our early customers, we saw that an in-memory solution could provide the greatest value by enabling users to analyze real-time and recent historical data together. Customers like Zynga and Morgan...