[gentoo-user] in-memory database

[gentoo-user] in-memory database

[Hung Dang]

[-- Attachment #1: Type: text/plain, Size: 214 bytes --]

Hi all,

I am looking for an open source in-memory database for data mining purpose.
I have tried to look into /usr/portage/dev-db/ and have not found any
in-memory package. Any suggestion?

Thanks in advance
Hung

[-- Attachment #2: Type: text/html, Size: 244 bytes --]

Re: [gentoo-user] in-memory database

[Alexander]

On Thursday 11 February 2010 20:27:15 Hung Dang wrote:
> Hi all,
> 
> I am looking for an open source in-memory database for data mining purpose.
> I have tried to look into /usr/portage/dev-db/ and have not found any
> in-memory package. Any suggestion?
> 
> Thanks in advance
> Hung
> 

What kind of database are you looking for? There is several ways of in-memory 
db: Berkley DB, native languages hash tables  and etc

Re: [gentoo-user] in-memory database

[Hung Dang]

[-- Attachment #1: Type: text/plain, Size: 749 bytes --]

Hi Alexander,

Thanks a lot for your quick reply. I just start my project then I might have
to try some in-memory dbs and see which one is suitable for my application.

Thanks
Hung


On Thu, Feb 11, 2010 at 10:50 AM, Alexander <b3nder@yandex.ru> wrote:

> On Thursday 11 February 2010 20:27:15 Hung Dang wrote:
> > Hi all,
> >
> > I am looking for an open source in-memory database for data mining
> purpose.
> > I have tried to look into /usr/portage/dev-db/ and have not found any
> > in-memory package. Any suggestion?
> >
> > Thanks in advance
> > Hung
> >
>
> What kind of database are you looking for? There is several ways of
> in-memory
> db: Berkley DB, native languages hash tables  and etc
>
>


-- 
Hung Dang
New Mexico State University

[-- Attachment #2: Type: text/html, Size: 1158 bytes --]

Re: [gentoo-user] in-memory database

[Helmut Jarausch]

On 11 Feb, Hung Dang wrote:
> Hi all,
> 
> I am looking for an open source in-memory database for data mining purpose.
> I have tried to look into /usr/portage/dev-db/ and have not found any
> in-memory package. Any suggestion?
> 

You might use dev-db/sqlite and put its files on a tmpfs directory.
Helmut.

-- 
Helmut Jarausch

Lehrstuhl fuer Numerische Mathematik
RWTH - Aachen University
D 52056 Aachen, Germany

Re: [gentoo-user] in-memory database

[Joshua Murphy]

On Thu, Feb 11, 2010 at 1:45 PM, Helmut Jarausch
<jarausch@igpm.rwth-aachen.de> wrote:
> On 11 Feb, Hung Dang wrote:
>> Hi all,
>>
>> I am looking for an open source in-memory database for data mining purpose.
>> I have tried to look into /usr/portage/dev-db/ and have not found any
>> in-memory package. Any suggestion?
>>
>
> You might use dev-db/sqlite and put its files on a tmpfs directory.
> Helmut.
>
> --
> Helmut Jarausch
>
> Lehrstuhl fuer Numerische Mathematik
> RWTH - Aachen University
> D 52056 Aachen, Germany

Or, even, just use SQLite's support for in-memory databases... a
little about that's here:
http://www.sqlite.org/cvstrac/wiki?p=InMemoryDatabase

-- 
Poison [BLX]
Joshua M. Murphy

Re: [gentoo-user] in-memory database

[Ognjen Bezanov]

Helmut Jarausch wrote:
> On 11 Feb, Hung Dang wrote:
>> Hi all,
>>
>> I am looking for an open source in-memory database for data mining purpose.
>> I have tried to look into /usr/portage/dev-db/ and have not found any
>> in-memory package. Any suggestion?
>>
> 
> You might use dev-db/sqlite and put its files on a tmpfs directory.
> Helmut.
> 

SQLITE supports holding a database in memory. I never did it in python, 
but in PHP if you put "memory" in the connect string rather than a 
filename, the database will reside solely in RAM.

As this is a sqlite feature rather than a PHP feature, it should work 
under python as well (but I've never done it, so I don't know the syntax).

Ognjen.

[gentoo-user] Re: in-memory database

[Doug O'Neal]

On 02/11/2010 12:27 PM, Hung Dang wrote:
> Hi all,
> 
> I am looking for an open source in-memory database for data mining 
> purpose. I have tried to look into /usr/portage/dev-db/ and have not 
> found any in-memory package. Any suggestion?
>  
> Thanks in advance
> Hung

mysql has a `memory' table engine.

Doug

Re: [gentoo-user] Re: in-memory database -> SOLVED

[Hung Dang]

Hi all,

Thank a lot for your advices. I will try both mysql and sqlite to see
which one is better for our purpose.

Have a nice weekend,
Hung

On 02/12/10 10:56, Doug O'Neal wrote:
> On 02/11/2010 12:27 PM, Hung Dang wrote:
>> Hi all,
>>
>> I am looking for an open source in-memory database for data mining
>> purpose. I have tried to look into /usr/portage/dev-db/ and have not
>> found any in-memory package. Any suggestion?
>>  
>> Thanks in advance
>> Hung
>
> mysql has a `memory' table engine.
>
> Doug
>
>