incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Metin Akat <akat.me...@gmail.com>
Subject Re: Importing from CSV or MySQL DUMP
Date Fri, 16 Oct 2009 19:28:36 GMT
Sure :)
If you don't know how to write couchdb-python models, here is a good example:
http://bitbucket.org/bbangert/kai/src/c5a69c10aa0c/kai/model/human.py

You can learn a lot by studying that application's source.

Regards


On Fri, Oct 16, 2009 at 6:26 PM, AnotherNetFellow
<anothernetfellow@gmail.com> wrote:
> Thankyou Metin.
> Just a question: are you using http://code.google.com/p/couchdb-python/ ?
>
> (i'm referring to the "import couchdb" line)
>
> Thankyou!
>
> 2009/10/16 Metin Akat <akat.metin@gmail.com>
>
>> Hi,
>> Writing such an import script is really simple. I doubt it that there
>> can be "something ready", because it would have to be very flexible in
>> order to do some real work.
>>
>> See the example I am attaching to this mail.
>> I use such scripts constantly.
>> Pay a special attention at the "bulk insert" part, otherwise you will
>> have serious performance issues.
>> The csv module I am importing here is not a part of the standard
>> library so you will have to install python-csv (or whatever is it
>> called in your distro).
>> Also read that module's documentation in order to choose the right csv
>> dialect for your needs.
>>
>> By no means this is the "perfect" way of importing csv documents, but
>> it does the job for me, I hope you'll find it useful too.
>>
>>
>> On Fri, Oct 16, 2009 at 4:36 PM, AnotherNetFellow
>> <anothernetfellow@gmail.com> wrote:
>> > Hi,
>> > i'm testing CouchDB as an alternative to MySQL (using python rewriting my
>> > application data model doesn't seem so difficult).
>> >
>> > To have some bench i want to put in it something like 3 million entries
>> and
>> > see the get/put/delete latency. I have this data available in CSV format,
>> or
>> > in alternative to this i can import them in MySQL and then export
>> everything
>> > in SQL language.
>> >
>> > Do you know if there is a simple way to import everything on couch db?
>> >
>> > I think i can write a python script to read a csv file and put all
>> entries
>> > in couch, but hope something similar has already been written.
>> >
>> > Thankyou very much
>> >
>> > Giorgio
>> >
>> > --
>> > --
>> > AnotherNetFellow
>> > Email: anothernetfellow@gmail.com
>> >
>>
>
>
>
> --
> --
> AnotherNetFellow
> Email: anothernetfellow@gmail.com
>

Mime
View raw message