DHIS 2 Lite beta can now be downloaded here:
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.
···
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:
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:
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.
Knut2009/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.