Installing dependencies for MyBinder

[psychemedia]

Interesting repo, but I'm not sure what the Binder benefits are? eg all the notebooks require a connection to a db that is not likely to be available to anyone using the Binderised notebooks?

Also, to run the notebooks in MyBinder, you need to install package dependencies.

eg create a file binder/requirements.txt containing at least:

numpy
pandas
matplotlib
scipy
seaborn

#pyodbc

FWIW, it is possible to run a db in a Binder container. For example, run postgres in MyBinder.

Another alternative would be to grab the data from your db or show how to download the data files from the NHS opendata site and put them into something simple like sqlite, then query from there. db-to-sqlite (export tables from connected db to sqlite) and csvs-to-sqlite are handy for that, ( @simonw also has other X-to-sqlite packages available.)

[meevans1]

Hi Tony, Thanks for your help. I'll start implementing these things. Meirin

…

________________________________ Oddi wrth: Tony Hirst [notifications@github.com] Anfonwyd: 11 Rhagfyr 2019 13:17:33 At: meevans1/PortsmouthHospitalTrust Copi: Subscribed Pwnc: [meevans1/PortsmouthHospitalTrust] Installing dependencies for MyBinder (#1) Interesting repo, but I'm not sure what the Binder benefits are? eg all the notebooks require a connection to a db that is not likely to be available to anyone using the Binderised notebooks? Also, to run the notebooks in MyBinder, you need to install package dependencies. eg create a file binder/requirements.txt containing at least: numpy pandas matplotlib scipy seaborn #pyodbc FWIW, it is possible to run a db in a Binder container. For example, run postgres in MyBinder<https://blog.ouseful.info/2019/02/04/running-a-postgresql-server-in-a-mybinder-container/>. Another alternative would be to grab the data from your db or show how to download the data files from the NHS opendata site and put them into something simple like sqlite, then query from there. db-to-sqlite<https://github.com/simonw/db-to-sqlite> (export tables from connected db to sqlite) and csvs-to-sqlite<https://github.com/simonw/csvs-to-sqlite> are handy for that, ( @simonw<https://github.com/simonw> also has other F-to-sqlite packages available<https://github.com/search?q=user%3Asimonw+%22to-sqlite%22>.) — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub<#1?email_source=notifications&email_token=AHXGEFGWWPFZULPRSD5PHFDQYDR63A5CNFSM4JZOZ4XKYY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4H7YIJ6Q>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AHXGEFFB6X2M7RBFQ6INBCTQYDR63ANCNFSM4JZOZ4XA>.

[meevans1]

Hi Tony, You say "grab the data from your db...and put them into something simple like sqlite". Would it not be even simpler to put them into a csv? Have a great day Thanks Meirin

…

________________________________ Oddi wrth: Tony Hirst [notifications@github.com] Anfonwyd: 11 Rhagfyr 2019 13:17:33 At: meevans1/PortsmouthHospitalTrust Copi: Subscribed Pwnc: [meevans1/PortsmouthHospitalTrust] Installing dependencies for MyBinder (#1) Interesting repo, but I'm not sure what the Binder benefits are? eg all the notebooks require a connection to a db that is not likely to be available to anyone using the Binderised notebooks? Also, to run the notebooks in MyBinder, you need to install package dependencies. eg create a file binder/requirements.txt containing at least: numpy pandas matplotlib scipy seaborn #pyodbc FWIW, it is possible to run a db in a Binder container. For example, run postgres in MyBinder<https://blog.ouseful.info/2019/02/04/running-a-postgresql-server-in-a-mybinder-container/>. Another alternative would be to grab the data from your db or show how to download the data files from the NHS opendata site and put them into something simple like sqlite, then query from there. db-to-sqlite<https://github.com/simonw/db-to-sqlite> (export tables from connected db to sqlite) and csvs-to-sqlite<https://github.com/simonw/csvs-to-sqlite> are handy for that, ( @simonw<https://github.com/simonw> also has other F-to-sqlite packages available<https://github.com/search?q=user%3Asimonw+%22to-sqlite%22>.) — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub<#1?email_source=notifications&email_token=AHXGEFGWWPFZULPRSD5PHFDQYDR63A5CNFSM4JZOZ4XKYY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4H7YIJ6Q>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AHXGEFFB6X2M7RBFQ6INBCTQYDR63ANCNFSM4JZOZ4XA>.