search

NAVADMC / ADSM

A simulation of disease spread in livestock populations. Includes detection and containment simulation.
Other
10 stars 5 forks source link

Select a database browser to package #452

Closed josiahseaman closed 9 years ago

missyschoenbaum commented 9 years ago

OK, I have looked at SQLite Administrator, SpatialLite and SQLiteSpy. Although our USDA folks recommended SpataiLite, I found SQLite Administrator to be much easier to work with. It allowed for code complete when an alias has been assigned. It also allowed for saved queries. This may mean we could push a batch of queries with the initial installation.

missyschoenbaum commented 9 years ago

@josiahseaman I will start working on simple documentation and you can figure out the hard parts. Also, I tested connecting to a SQLite database with MS Access, and it was a breeze once I had the correct driver. We cannot ship MS Access, but users may already have it.

josiahseaman commented 9 years ago

Sounds like you've made a decision. Is this what you would like me to package?

http://www.winportal.com/sqlite-administrator

I'll add it to the Windows branch. You can also make a file of DB queries you find useful and I'll make sure the directories link up. Just email me the queries file when you're done.

missyschoenbaum commented 9 years ago

Yes, that's the one. I will get going on queries.

josiahseaman commented 9 years ago

Before I package anything we'll need to verify the licensing:

The SQLite Administrator Software which is provided to be downloaded on www.orbmu2k.de is completely freeware (free of costs). In any case the copyright is restricted and remains by the author. It can be fully used and copied for private purposes only. If for any commercial use, the explicit approval of the author is mandatory. The commercial exploitation is strictly not allowed. The author is not to be held responsible for the liability of any potential damage caused by the usage of the software.

http://sqliteadmin.orbmu2k.de/

So we should contact him and ask for permission. It looks like he's a native German speaker, so it'd be polite if we could contact him in German. Do you know anyone who knows German fluently?

missyschoenbaum commented 9 years ago

Ann can and agrees. I was going to attempt to explain our project. Give me a sec

missyschoenbaum commented 9 years ago

how's this? Our team, the North American Virtual Animal Disease Modeling Center is developing a disease simulation model that uses SQLite as the database platform. The project has used open source software on all development components. This model will be made available to the public free of charge. To have a friendly database administration tool would provide value to the users. Although we are not going to have a commercial distribution, we felt it was important to have your explicit approval as a widespread, worldwide distribution is possible within the veterinary epidemiology community. The model is in beta and can be downloaded from https://github.com/NAVADMC/ADSM/releases.

josiahseaman commented 9 years ago

It's a good start, though you didn't actually ask a question.

missyschoenbaum commented 9 years ago

OK, but it describes our project adequately?

missyschoenbaum commented 9 years ago

Checked with Ann today, no answer yet.

missyschoenbaum commented 9 years ago

Still no answer

missyschoenbaum commented 9 years ago

Still no answer - I guess we can offer user suggestions to download their own package. I will close this unless an answer pops in.

missyschoenbaum commented 6 years ago

No answer to date. SQLite Manager through Firefox has become obsolete. I found a new package SQLite Studio that does not require an installation, and will allow users to save queries. Export of data requires a few more steps, but is can be done and gives option to include field names. Import of tables is more complex. SpatialLite is still the winner for importing.