Re: OpenDiscSF Re: We need this for the April 12 Summit

[Asha John]

Peter, 

Thanks for following up on this. 

Andrew - we'd really like to set this up tonight. We have data that we are preparing for the day of the event. There is big chunk of data from the State we would like to stick into a db and do some cleanup work on it before the Summit.

thanks, 

Asha  

On Wed, Apr 1, 2015 at 9:58 AM, Peter Thompson <ptho...@atlanticfusion.com> wrote:

Hey Guys - anyone had a chance to ponder anything I"m asking here? Committed to help the team tonight, but as of right now, still not clear the quickest path to do this. 

Andrew - are you at Hack Night tonight? Maybe we can sit down together and walk through this? 

ᐧ

Peter Thompson | B-Comm | Eng. Tech

AtlanticFusion Inc. 

SFO: 415.463.9110 | YYC: 403.613.6497

ptho...@atlanticfusion.com

On Sat, Mar 28, 2015 at 3:11 PM, Peter Thompson <ptho...@atlanticfusion.com> wrote:

Hey Guys - just ran into the Open Disclosure Team hacking away their Saturday and have committed to mapping out the best way of getting them stood up in the Brigade leveraging the tools we have available to us. Which to the best of my knowledge, is not something that's easy to navigate right now. 

Jean & Judy - I think this is something the Core Team has been working on putting together for sometime, so I'd like to understand your view as to where this at and the vision. It's fine if it's still somewhat scattered process, just want to make sure I don't re-hack or derail any current efforts. Eitherway, I figure we can use this to create a baseline for other project teams.

Andrew & Matthew - The very first thing I need to do is get the team set up with a Database. I got them going on this last year, but we ran into a few problems and ultimately they ended up hosting their own DB on Heroku I believe.  The main issue previously, is that we had no operational framework in how to use services such as Amazon's in a way that let each team control who had access to what and track what had been done. Basically everyone logged into one Account and could do anything, and there work was deleted by someone. That said, do we have a more structured way to manage Amazons Web Services? May other options available to us are better? What is the current list of tools commonly used in the Brigade? Off the top of my head we have: 

1. Office 365 - Cloud Version only - can be used for team colaboration, community facing pages and portals, etc. Not sure there is any DB hosting capabilities that can be leveraged on SharePoint? 

2.Google Apps - offers similary abilities to Office 365 and much more. Can host Apps, DB's, etc - although I have not dug into this piece deeply before. 

3.Amazon Web Services- This seems to be a cluster f*ck of products bundle together. Think there are lots of capabilities here, but its not immediately clear what. 

4.Github - Code Collaboration, documentation, Team messaging? Site hosting? anything else its good or acceptable to use for? 

5. Heroku - I don't know much, but know DB's can be hosted on it, anything else it's good for? 

6. Other options? 

Jason - I think you know a lot about the above and what teams use - anything you can add. please do. 

Jesse - Sounds like the team has purchased domains etc. under their own dime.I think the Brigade was talking about or is now able to reimburse for these costs? If so, sure the team would appreciate the financial support. 

Thanks!

P.S. Goal is to have Open Discourse Team stood up with a DB that they can confidently manage without fear something will happen to it. Of course, what to build on a foundation that will be scaleable and support long term growth, hopefully without discovering a need to migrate to a new platform later. 

Peter Thompson | B-Comm | Eng. Tech

AtlanticFusion Inc. 

SFO: 415.463.9110 | YYC: 403.613.6497

ptho...@atlanticfusion.com

ᐧ

--
You received this message because you are subscribed to the Google Groups "Open Disclosure SF" group.
To unsubscribe from this group and stop receiving emails from it, send an email to open-disclosure...@googlegroups.com.
Visit this group at http://groups.google.com/group/open-disclosure-sf.
To view this discussion on the web, visit https://groups.google.com/d/msgid/open-disclosure-sf/CANrVt0m8z%3DpL%3D582K%3DSYR_LJGjdd6Cqw01GGBKjg_QX9TAJnWg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[Jean Kao]

Here's are some options for hosting the db / server.

1. Completely client side using just javascript. Data in a geojson file or a spreadsheet. This is easiest and fastest.
   
2. Free tier Heroku with data in postgres.
3. Use the Code for San Francisco free credits from AWS or Digital Ocean.

Let me know if you'd like to use the AWS credits.

[Peter Thompson]

Jean - I think the plan is to use AWS, however the challenge is ensuring we can create an account that is team specific. This wasn't clear last year when we initially tried, have we got that ironed out now?

Thanks.