in-memory-database

php java in memory database

i need to load data as array to memory in PHP.but in PHP if i write $array= array("1","2"); in test.php then this $array variable is initialized every time user requests.if we request test.php 100 times by clicking 100 times browser refresh button then this $array variable will be executed 100 times. but i need to execute the $array v...

has anyone produced an in-memory GIT repository?

I would like to be able to take advantage of the benefits of GIT (and its workflows), but without the cost of disk access - I just would like to leverage the distributed revision control capabilities of GIT to produce something like a hybrid of memcached and GIT. (preferably in .NET) Is there such a beast out there? ...

Techniques for querying a set of object in-memory in a Java application

Hi All, We have a system which performs a 'coarse search' by invoking an interface on another system which returns a set of Java objects. Once we have received the search results I need to be able to further filter the resulting Java objects based on certain criteria describing the state of the attributes (e.g. from the initial objects ...

Why would someone need an in-memory database?

I read that a few databases can be used in-memory but can't think of reason why someone would want to use this feature. I always use a database to persist data and memory caches for fast access. ...

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 set up some complicated nested dictionaries, I realized that a good representation would ...

Best practice for inserting and querying data from memory

We have an application that takes real time data and inserts it into database. it is online for 4.5 hours a day. We insert data second by second in 17 tables. The user at any time may query any table for the latest second data and some record in the history... Handling the feed and insertion is done using a C# console application... Ha...

HSQLDB: Easy way to have all created files deleted after closing connection?

I have an app/tool which reads from a CSV file and writes to another, processing it using HSQLDB. I want to have the CSV file as the only output, and the database files should disappear after the process finishes. I tried to use mem storage, but that prevents HSQLDB to write to the CSV file. I also tried to DROP SCHEMA before closing ...

How do in-memory databases provide durability?

The title says all, but more specifically, are there any databases that don't require secondary storage (e.g. HDD) to provide durability? Thank you in advance! Note:This is a follow up of my earlier question. ...

In-memory/Embedded DB solution

I'm currently using the in-memory option for SQLite and while it works (a bit slow right now but I'm still exploring ways to optimize my usage of it like batching and such), I'm just curious whether there are other alternatives to SQLite that support in-memory DBs and are embedded solutions. I don't necessarily need a schema-based DB (N...

Simple and reliable in memory database for fast java integration tests with support for JPA

My integration tests would run much faster if I used in-memory-database instead of PostgreSQL. I use JPA (Hibernate) and I need an in-memory-database that would be easy to switch to using JPA, easy to setup, and reliable. It needs to support JPA and Hibernate (or vice verse if you will) rather extensively since I have no desire to adopt ...

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 everytime I restart the server. So how do I script this 'syncdb' command?(Should that be d...

Using PDO Sqlite in-memory Db for PHPUnit tests

Hello I recently got PHPUnit working with xDebug for testing my Zend Framework applications. The fact I use ZF shouldn't make any difference to this question- just mentioned it for completeness. Anyway, it all works fine, but now I want to set up an in-memory database using PDO SQLite. I have done this successfully and have created tab...

Create an in-memory database structure from an Oracle instance

Hello, 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 the Oracle instance. In addition to that, we have to manage complex mechanisms, s...

Does anybody have any experience with FastDB (C++ in-memory database)?

FastDB is an open-source, in-memory database that's tightly integrated with C++ (it supports a SQL-like query language where tables are classes and rows are objects). Like most IMDBs, it's meant for applications dominated by read access patterns. The algorithms and data structures are optimized for systems that read and write data entire...

How efficient will be to use a in memory database to store millions of temporary values?

Hello, My application currently stores millions of Double elements for a calculation. These values are only temporary values before they are used for a specific algorithm that is run at the end of the calculation. Once this calculation is done, the millions of values can be discarded. The full story is here, if you need more details. ...

Is there in-memory SQL database supporting replication/clustering?

Free and stable is the winner. My plan is quite trivial - just put all the data in memory and use the cluster without changing the application code. Then, for persistence, I could just dump the data from nodes in a regular disk-access database. The only thing is, that since I demand in-memory storage, there is no possibility of full da...

What would you reccomend to read to a person who is going to write his own DB?

Since there are no answers to my previous question. I'm really thinking to implement a custom DB which will satisfy my requirements. Yes I know, sounds crazy. But what books, articles and etc. would you recommend to read? If it does matter the requirements for my DB are following Graph oriented - optimized for storing graphs and ...