DHIS 2 Lite Beta

DHIS 2 Lite beta can now be downloaded here:

http://folk.uio.no/larshelg/files/dhis2-lite-sample-db.7z

About 74 MB. Contains sample data from Limpopo for 2006, 2007 + sample charts, reports, etc. Runs on embedded Jetty container and H2 database.

···

2009/4/16 Lars Helge Øverland larshelge@gmail.com

DHIS 2 Lite beta can now be downloaded here:

http://folk.uio.no/larshelg/files/dhis2-lite-sample-db.7z

Some testing would be nice, especially from the India team as this will be crucial for their field implementation.

···

2009/4/16 Lars Helge Øverland larshelge@gmail.com

2009/4/16 Lars Helge Øverland larshelge@gmail.com

DHIS 2 Lite beta can now be downloaded here:

http://folk.uio.no/larshelg/files/dhis2-lite-sample-db.7z

About 74 MB. Contains sample data from Limpopo for 2006, 2007 + sample charts, reports, etc. Runs on embedded Jetty container and H2 database.

We were just discussing this yesterday that it would be good to give these to the states… but then since Indian modules are directly using MySQL, it will be sometime until we can use this.

···

Regards,

Saptarshi PURKAYASTHA
Director R & D, HISP India
Health Information Systems Programme

My Tech Blog: http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE

2009/4/16 Lars Helge Øverland larshelge@gmail.com

2009/4/16 Lars Helge Øverland larshelge@gmail.com

2009/4/16 Lars Helge Øverland larshelge@gmail.com

DHIS 2 Lite beta can now be downloaded here:

http://folk.uio.no/larshelg/files/dhis2-lite-sample-db.7z

About 74 MB. Contains sample data from Limpopo for 2006, 2007 + sample charts, reports, etc. Runs on embedded Jetty container and H2 database.

Some testing would be nice, especially from the India team as this will be crucial for their field implementation.


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

OK I see.

Is the Indian modules very much depending on MySQL specific functions, or could we rewrite this code to use standard SQL only? If so, the org.hisp.dhis.jdbc.StatementBuilder interface (which gives you SQL statements) could be extended and used here. We have a StatementBuilderFactory in the service-jdbc project which will give you an implementation based on which database you are running. I am happy to help out here if you like.

···

2009/4/16 Saptarshi Purkayastha sunbiz@gmail.com

We were just discussing this yesterday that it would be good to give these to the states… but then since Indian modules are directly using MySQL, it will be sometime until we can use this.

Sunny and Bharath,

Can you describe exactly what the dependencies on Mysql in India are? I remember this was discussed during the workshop, but cannot recall the details.

Knut

···

2009/4/16 Lars Helge Øverland larshelge@gmail.com

2009/4/16 Saptarshi Purkayastha sunbiz@gmail.com

We were just discussing this yesterday that it would be good to give these to the states… but then since Indian modules are directly using MySQL, it will be sometime until we can use this.

OK I see.

Is the Indian modules very much depending on MySQL specific functions, or could we rewrite this code to use standard SQL only? If so, the org.hisp.dhis.jdbc.StatementBuilder interface (which gives you SQL statements) could be extended and used here. We have a StatementBuilderFactory in the service-jdbc project which will give you an implementation based on which database you are running. I am happy to help out here if you like.


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Cheers,
Knut Staring

It doesn't look too daunting.

I've attached output of:
grep -r mysql local/in/ >~/mysql.txt

I guess most of the work will be in the various DBConnection.java
files. And of course the mysqldump.

I'm off till Wednesday though ...

Cheers
Bob

mysql.txt (8.24 KB)

···

2009/4/17 Knut Staring <knutst@gmail.com>:

Sunny and Bharath,
Can you describe exactly what the dependencies on Mysql in India are? I
remember this was discussed during the workshop, but cannot recall the
details.
Knut

2009/4/16 Lars Helge Øverland <larshelge@gmail.com>

2009/4/16 Saptarshi Purkayastha <sunbiz@gmail.com>

We were just discussing this yesterday that it would be good to give
these to the states... but then since Indian modules are directly using
MySQL, it will be sometime until we can use this.

OK I see.

Is the Indian modules very much depending on MySQL specific functions, or
could we rewrite this code to use standard SQL only? If so, the
org.hisp.dhis.jdbc.StatementBuilder interface (which gives you SQL
statements) could be extended and used here. We have a
StatementBuilderFactory in the service-jdbc project which will give you an
implementation based on which database you are running. I am happy to help
out here if you like.

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

--
Cheers,
Knut Staring

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

All India Modules is using both hibernate and mysql. But we are going to start to refactor all modules.

···

2009/4/17 Knut Staring knutst@gmail.com

Sunny and Bharath,

Can you describe exactly what the dependencies on Mysql in India are? I remember this was discussed during the workshop, but cannot recall the details.

Knut

2009/4/16 Lars Helge Øverland larshelge@gmail.com

2009/4/16 Saptarshi Purkayastha sunbiz@gmail.com

We were just discussing this yesterday that it would be good to give these to the states… but then since Indian modules are directly using MySQL, it will be sometime until we can use this.

OK I see.

Is the Indian modules very much depending on MySQL specific functions, or could we rewrite this code to use standard SQL only? If so, the org.hisp.dhis.jdbc.StatementBuilder interface (which gives you SQL statements) could be extended and used here. We have a StatementBuilderFactory in the service-jdbc project which will give you an implementation based on which database you are running. I am happy to help out here if you like.


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Cheers,
Knut Staring


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Regards,
Bharath Kumar. Ch

OK happy to hear this.

I mean, we basically made the lite version for the Indian context to handle low-end hardware and large-scale implementations. It would be sad to let some sql statements prohibit it. Again I’m happy to help or guide in the use of StatementBuilder.

cheers

···

2009/4/18 bharath kumar chbharathk@gmail.com

All India Modules is using both hibernate and mysql. But we are going to start to refactor all modules.