sqlite

[leroygumede]

Any chance we can get a .db3 of this? Json dump douse not help that much

[adieyal]

You're looking for a sqlite database? If so you can find it in the codebase. https://github.com/Code4SA/medicine-price-registry/blob/master/mpr.db Is that useful?

…

On 10 Sep 2017 20:26, "LeRoy Gumede" ***@***.***> wrote: Any chance we can get a .db3 of this? Json dump douse not help that much — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#32>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAZrslymQuB1kuJwJD5EUOC5bpuDqdPVks5sg9VvgaJpZM4PSTYQ> .

[leroygumede]

@adieyal Thanks, But I was looking for something little bit more structured like the dump.

mpr.code4sa.org/api/v2/dump

[adieyal]

Sorry, not sure I understand. A csv dump is difficult as there are multiple ingredients per medicine. You would need two separate csv files. What exactly do you need and why does json not work for you?

…

On Mon, Sep 11, 2017 at 2:11 PM, LeRoy Gumede ***@***.***> wrote: @adieyal <https://github.com/adieyal> Thanks, But I was looking for something little bit more structured like the dump. mpr.code4sa.org/api/v2/dump — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#32 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAZrsrEDtKhMuF7K9G-EbBdZ0SBLKVnGks5shM8mgaJpZM4PSTYQ> .

-- Adi Eyal Director OpenUp Promoting informed decision-making phone: +27 78 014 2469 skype: adieyalcas linkedin: http://za.linkedin.com/pub/dir/Adi/Eyal web: http://www.openup.org.za twitter: @soapsudtycoon Follow us on twitter at @OpenUpSA Sign up for Naked Data, our weekly round-up of what's happening locally and internationally in data journalism and data visualisation. Register here: https://openup.org.za/nakeddata.html

[leroygumede]

I'm doing a mobile version of the app, and offline is one of the requirements.
I tried using the JSON dump but downloading everything takes a while on mobile.

The alternative is to have a .db3 pre-installed on the app.
so I need to convert the Json dumb to .db3 (SQLite) format.

[adieyal]

Happy to implement something if it makes sense, tell me exactly what structure you need.

…

On Mon, Sep 11, 2017 at 2:32 PM, LeRoy Gumede ***@***.***> wrote: I'm doing a mobile version of the app, and offline is one of the requirements. I tried using the JSON dump but downloading everything takes a while on mobile. The alternative is to have a .db3 pre-installed on the app. so I need to convert the Json dumb to .db3 (SQLite) format. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#32 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAZrsol-wXjM-Ni2dJxrXc0WI0XEqqJ6ks5shNPlgaJpZM4PSTYQ> .

-- Adi Eyal Director OpenUp Promoting informed decision-making phone: +27 78 014 2469 skype: adieyalcas linkedin: http://za.linkedin.com/pub/dir/Adi/Eyal web: http://www.openup.org.za twitter: @soapsudtycoon Follow us on twitter at @OpenUpSA Sign up for Naked Data, our weekly round-up of what's happening locally and internationally in data journalism and data visualisation. Register here: https://openup.org.za/nakeddata.html

[leroygumede]

That would be great. just need a SQLite version of the json dump, I can send you a sample by end of day?

[adieyal]

Have you looked at mpr.db?

…

On Mon, Sep 11, 2017 at 2:45 PM, LeRoy Gumede ***@***.***> wrote: That would be great. just need a SQLite version of the json dump, I can send you a sample by end of day? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#32 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAZrsla2ISpN1Ki-0_T3stqqiMFrO_pLks5shNcbgaJpZM4PSTYQ> .

-- Adi Eyal Director OpenUp Promoting informed decision-making phone: +27 78 014 2469 skype: adieyalcas linkedin: http://za.linkedin.com/pub/dir/Adi/Eyal web: http://www.openup.org.za twitter: @soapsudtycoon Follow us on twitter at @OpenUpSA Sign up for Naked Data, our weekly round-up of what's happening locally and internationally in data journalism and data visualisation. Register here: https://openup.org.za/nakeddata.html

[leroygumede]

Yes, I did, With that version, I still need to do the joins. But before you do anything, I'll do some performance testing. I'll let you know the results.

[leroygumede]

@adieyal It's not working out well it's in SQL, I need it in SQLite .db3 format

[leroygumede]

A sample of what I mean Medicine price checker app

[adieyal]

I'll take a look and get back to you

…

On 13 Sep 2017 13:35, "LeRoy Gumede" ***@***.***> wrote: A sample of what I mean Link to app <https://github.com/leroygumede/medicine-price-registry-xamarin/tree/master/medicinepricechecker/iOS/Resources> — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#32 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAZrsgoiLqU2l6_pbqjHvbqhxwchsX45ks5sh2mRgaJpZM4PSTYQ> .