Stack Overflow
Stack Overflow

Questions tagged [singlestore]

For programming questions relating to the use of Singlestore (formerly known as MemSQL), which is a distributed SQL database.

Singlestore (formerly MemSQL) is a high-performance distributed relational (SQL) database management system (RDBMS) designed to scale across hundreds of nodes.

It uses a combination of in-memory row-based tables (with full persistence) and disk-based column-store tables to support OLTP, OLAP, and hybrid query workloads with support for joins across all data and native JSON handling. It's compatible with the MySQL protocol and commands.

More info at:

389 questions
121
votes
8 answers

How to increase docker-machine memory Mac

I am new to Docker, and trying to go through this tutorial setting up MemSQL from a Docker image - http://docs.memsql.com/4.0/setup/docker/ . I am on a Mac, and the tutorial uses boot2docker which seems to have been deprecated. The VM needs 4GB…
DJElbow
  • 3,345
  • 11
  • 41
  • 52
26
votes
5 answers

How to make volumes permanent with Docker Compose v2

I realize other people have had similar questions but this uses v2 compose file format and I didn't find anything for that. I want to make a very simple test app to play around with MemSQL but I can't get volumes to not get deleted after…
jimmy
  • 1,413
  • 2
  • 13
  • 23
20
votes
3 answers

MemSQL - Starting up / worth the move "Worlds Fastest Database"

MemSQL is claiming to be the "Worlds Fastest Database" Faster than DB2, Oracle, mySQL and SQL server. Can anyone vouch for this? I have searched the web and tried to gather as much information as possible about this. MemSQL is claiming to be the…
TheBlackBenzKid
  • 26,324
  • 41
  • 139
  • 209
12
votes
3 answers

Spark DataFrame InsertIntoJDBC - TableAlreadyExists Exception

Using Spark 1.4.0, I am trying to insert data from a Spark DataFrame into a MemSQL database (which should be exactly like interacting with a MySQL database) using insertIntoJdbc(). However I keep getting a Runtime TableAlreadyExists…
DJElbow
  • 3,345
  • 11
  • 41
  • 52
8
votes
1 answer

Pandas to_sql() performance - why is it so slow?

I am running into performance issues with Pandas and writing DataFrames to an SQL DB. In order to be as fast as possible I use memSQL (it's like MySQL in code, so I don't have to do anything). I benchmarked my instance just now: docker run --rm -it…
wishi
  • 7,188
  • 17
  • 64
  • 103
6
votes
1 answer

Aurora vs MemSQL for low throughput but low latency purpose

We are changing our current user side MySQL database. We have a website + mobile app for which users around the US query our database. the relevant data is is contained in three tables, and a join query against the three tables is needed to send the…
LAlearner
  • 115
  • 1
  • 1
  • 8
6
votes
1 answer

MEMSQL vs. MySQL

I need to start off by pointing out that by no means am I a database expert in any way. I do know how to get around to programming applications in several languages that require database backends, and am relatively familiar with MySQL, Microsoft SQL…
JDA
  • 73
  • 2
  • 4
5
votes
1 answer

Is it possible to use EntityFramework with MemSQL?

I am trying to create an entity model for 2 super simple tables that I created in MemSQL: CREATE TABLE foo(id int primary key auto_increment, name varchar(20)); CREATE TABLE t(id int primary key auto_increment); I am using Entity Framework 6.1.x. …
AngryHacker
  • 59,598
  • 102
  • 325
  • 594
4
votes
1 answer

What are the supported Connection String properties for MemSQL?

This page describes the supported connection string properties for MySql Connector / .Net. Which of these options are officially supported when connecting to MemSQL? I suspect that options like SharedMemoryName and BlobAsUTF8IncludePattern are not.…
Andrey Belykh
  • 2,578
  • 4
  • 32
  • 46
4
votes
3 answers

Select json column using JPA native query with MemSql

I have a table in a MemSql database which contains a column of type JSON. I am trying to execute the following query. select tweet from tweets_json; The tweet column is the JSON column. Here is the code I am using to execute this query. public…
Fanooos
  • 2,718
  • 5
  • 31
  • 55
4
votes
1 answer

Scala/Java joda.time not converting date in 24 hours format

I am trying to convert a long utc value into "yyyy-MM-dd HH:mm:ss" formatted pattern. I am expecting my data to be converted on 24 hours range scale and in GMT. My code passes all the test cases, I push the data into database using the jar that is…
a13e
  • 838
  • 2
  • 11
  • 27
4
votes
1 answer

Does memsql support Full Outer Join?

I wanted to have a full outer join in memsql. Something like SELECT * FROM A FULL OUTER JOIN B ON A.id = B.id Is it possible ?
Vivek Aditya
  • 1,145
  • 17
  • 46
4
votes
4 answers

How to change the root password after memsql install?

I've installed MemSQL community edition (single host cluster) and all is working well. I need to allow remote access to the database, but MemSQL installs the user root without a password. If I open up the 3306 port on the firewall, memSQL happily…
Gabriel Magana
  • 4,338
  • 24
  • 23
4
votes
3 answers

Connecting to MemSQL from PHP codeigniter application

MemSQL is new. Stackoverflow did not return any search result with the keyword 'MemSQL'. MemSQL claims absolute similarity to MySQL, except that MemSQL is 30 times faster. I was just studying MemSQL and stumbled on this thought. Unable to try it out…
Rakib
  • 12,376
  • 16
  • 77
  • 113
3
votes
1 answer

SingleStore 1.0.1 JDBC ResultsetMetadata returns type name VARSTRING while getColumns returns VARCHAR

JDBC version 1.0.1 Server version 7.6 A table defined as follows create table TVCHAR ( RNUM integer not null , CVCHAR varchar(32 ) null , SHARD KEY ( RNUM ) ) ; DatabaseMetadata.getColumns returns a type name of VARCHAR(32). When a query select *…
Matt Brown
  • 31
  • 3
1
2 3
…
25 26