search

dougestey / toronto-city-hall-api

Powering municipal apps in Toronto.
5 stars 2 forks source link

Document how to populate database #1

Closed patcon closed 9 years ago

patcon commented 9 years ago

Not sure how the postgres db is being populated. Would generally be great to have some project spin-up instructions.

patcon commented 9 years ago

More generally, I have tons of experience working with open source projects and what's involved in opensource stewardship, and I've love to help you get these two repos to a point where any developer Alice or Bob could drop in and set this up and start messing with it

And yes, I know I know, "you feel it's not ready yet", right? That's honestly the gut feeling of every person with their first open/collaborative project, and all I can say is that you really need to suppress that feeling, because it's usually unhelpful :)

:heart:

EDIT: On second thought, let's leave the general FOSS convo for elsewhere, as I'm conflating issues :)

dougestey commented 9 years ago

I'll have these up tonight!

patcon commented 9 years ago

Yay!

dougestey commented 9 years ago

I've been doing some thinking about the best way to populate the database in a fresh environment. Sails doesn't really have a convention for this, and councillor data is not constant and therefore shouldn't be implemented as fixtures.

The most seemingly relevant method, as mentioned by one of the Sails developers here, is to use Waterline syntax to inject it in the bootstrap phase. This really is a similar problem to the above, however, and would require writing/maintaining code for the 40+ councillors in Toronto city hall.

So I think I'm going to provide a Postgres DB in the repo to get people up and running. It's what seems to make the most sense.

dougestey commented 9 years ago

@patcon I updated the project setup readme. This will get you up and running with a properly structured DB, albeit empty.

patcon commented 9 years ago

thanks dude!

dougestey commented 9 years ago

Marking this as closed, as I think the method of obtaining data to insert into the db is a different/non-issue altogether.