![\"Number](\"https:\/\/i2.wp.com\/www.theill.com\/stuff\/screenshots\/gomore-number-of-seats-per-ride-20110424-090916.png?w=660\")
<\/p>\nWhile working on migrating “gomore.dk”, a Danish ridesharing service, to Rails 3, I figured it would make sense to look into the existing database to figure out if I could add some sensible defaults when creating e.g. new rides. The site already contains a decent database so I figured it would be rather easy to measure which defaults to use.<\/p>\n
As an initial example, I would like to know how many seats were shared on each trip and therefore I did a simple query as shown below:<\/p>\n
<\/p>\n
From this, it is pretty obvious that I should use “3” as a default number of seats available. In this case, some common sense would probably give you the same result (four seats in a standard car minus one for the driver).<\/p>\n
Same type of query can be used to figure out the most popular seat price:<\/p>\n
![\"Default](\"https:\/\/i2.wp.com\/www.theill.com\/stuff\/screenshots\/gomore-default-price-per-seat-20110424-091149.png?w=660\")
<\/p>\n
It is even possible to remove<\/em> options if you look into providing sensible defaults for your users. As in this case where the existing gomore.dk contains a checkbox for specifying if car is “smoking” or “non smoking” area. A query showed me<\/p>\n i.e. we really don’t need to have users decide on this .. more than 95% of all rides are non-smoking rides so the rest should either write it in a comment field or edit the ride afterwards to mark is specifically as “smoking”. So in this case we just removed an option from our wizard to avoid clutter. Lovely.<\/p>\n![\"Smoking](\"https:\/\/i0.wp.com\/www.theill.com\/stuff\/screenshots\/gomore-smoking-20110424-091853.png?w=660\")
<\/p>\n