Stack Overflow
Stack Overflow

Questions tagged [in-memory-database]

An in-memory database (IMDB; also main memory database system or MMDB) is a database management system that primarily relies on main memory for computer data storage. It is contrasted with database management systems which employ a disk storage mechanism.

From Wikipedia:

An in-memory database (IMDB; also main memory database system or MMDB) is a database management system that primarily relies on main memory for computer data storage. It is contrasted with database management systems which employ a disk storage mechanism.

784 questions
92
votes
11 answers

View content of H2 or HSQLDB in-memory database

Is there a way to browse the content of an H2 or an HSQLDB in-memory database for viewing? For example, during a debugging session with Hibernate in order to check when the flush is executed; or to make sure the script that instantiates the DB gives…
jplandrain
  • 2,088
  • 4
  • 23
  • 21
46
votes
5 answers

In django, how do I call the subcommand 'syncdb' from the initialization script?

I'm new to python and django, and when following the Django Book I learned about the command 'python manage.py syncdb' which generated database tables for me. In development environment I use sqlite in memory database, so it is automatically erased…
Thiago de Arruda
  • 4,360
  • 5
  • 37
  • 66
44
votes
3 answers

Multiple collections in Angular-in-memory-web-api

How do we create multiple collections using Angular-in-memory-web-api? Not an issue with single collection. But I'm not able to implement it for multiple collections. For example, I want to create say two collections in the memory db - Country and…
Sparrow
  • 441
  • 1
  • 4
  • 4
42
votes
2 answers

Why Spark SQL considers the support of indexes unimportant?

Quoting the Spark DataFrames, Datasets and SQL manual: A handful of Hive optimizations are not yet included in Spark. Some of these (such as indexes) are less important due to Spark SQL’s in-memory computational model. Others are slotted for…
hillel
  • 2,083
  • 2
  • 17
  • 25
40
votes
5 answers

Safe modelling of relational data in Haskell

I find it very common to want to model relational data in my functional programs. For example, when developing a web-site I may want to have the following data structure to store info about my users: data User = User { name :: String ,…
Rotsor
  • 13,009
  • 5
  • 40
  • 57
38
votes
2 answers

How to suppress InMemoryEventId.TransactionIgnoredWarning when unit testing with in-memory database with transactions?

I'm using an EF Core in-memory database and I'm trying to run a unit test on a method that uses transactions: using (var transaction = await _context.Database.BeginTransactionAsync()) { _context.Update(item); result = await…
tomRedox
  • 18,963
  • 13
  • 90
  • 126
38
votes
10 answers

redis-server in ubuntu14.04: Bind address already in use

I started redis server on ubuntu by typing this on terminal: $redis-server This results in following > http://paste.ubuntu.com/12688632/ aruns ~ $ redis-server 27851:C 05 Oct 15:16:17.955 # Warning: no config file specified, using the default…
aruns
  • 611
  • 1
  • 5
  • 19
37
votes
2 answers

How to isolate EF InMemory database per XUnit test

I am trying use InMemory EF7 database for my xunit repository test. But my problem is that when i try to Dispose the created context the in memory db persist. It means that one test involve other. I have read this article Unit Testing Entity…
Ivan Mjartan
  • 941
  • 1
  • 9
  • 20
32
votes
4 answers

Create an in-memory database structure from an Oracle instance

I have an application where many "unit" tests use a real connection to an Oracle database during their execution. As you can imagine, these tests take too much time to be executed, as they need to initialize some Spring contexts, and communicate to…
Romain Linsolas
  • 73,921
  • 45
  • 197
  • 265
28
votes
6 answers

in-memory database in Python

I'm doing some queries in Python on a large database to get some stats out of the database. I want these stats to be in-memory so other programs can use them without going to a database. I was thinking of how to structure them, and after trying to…
Claudiu
  • 206,738
  • 150
  • 445
  • 651
28
votes
2 answers

Create SQLite database in memory

Trying to learn a bit about PDO and is going through this tutorial. It has the following snippet of code:
Svish
  • 138,188
  • 158
  • 423
  • 589
28
votes
1 answer

Does Mongo DB have an In-Memory mode?

Possible Duplicate: Embedded MongoDB when running integration tests I want to use In-Memory mode for unit test, is there an in In-Memory mode like RavenDB?
Alon Ashkenazi
  • 1,223
  • 4
  • 20
  • 29
27
votes
9 answers

When should I consider using a in memory database and what are the issue to look out for?

I was just think that now it is common to have enough RAM on your database server to cache your complete database why are the specialist in memory database (e.g TimesTen, see also Wikipedia page) that were all the rage a few years ago not being…
Ian Ringrose
  • 49,271
  • 50
  • 203
  • 302
26
votes
2 answers

In C#, is there any way to have an in-memory file linked as an in-memory SQLite database with System.Data.SQLite?

What I want to do is something along the lines of the following: using System.Data.SQLite; using System.IO; //My SQLite connection SQLiteConnection myCon; public void ReadAndOpenDB(string filename) { FileStream fstrm = new FileStream(filename,…
Mike Webb
  • 8,305
  • 18
  • 74
  • 108
26
votes
1 answer

Why Apache Kafka Streams uses RocksDB and if how is it possible to change it?

During investigation within new features in Apache Kafka 0.9 and 0.10, we had used KStreams and KTables. There is an interesting fact that Kafka uses RocksDB internally. See Introducing Kafka Streams: Stream Processing Made Simple. RocksDB is not…
Seweryn Habdank-Wojewódzki
  • 1,615
  • 2
  • 25
  • 47
1
2 3
…
52 53