Here's an article about friendfeed and their approach using schema- less mysql. Might be some ideas in there for you.
http://bret.appspot.com/entry/how-friendfeed-uses-mysql On Jun 2, 2:45 pm, Korny Sietsma <[email protected]> wrote: > Also, I'm not sure how it'd play with rails, but I've done a lot of > useful sql database fiddling lately with the 'sequel' library > (http://sequel.rubyforge.org/) - it's very powerful for ad-hoc > querying and updating SQL databases, without needing any sort of model > class (unless you want one) > > For example, I have code like: > @db[:parent_table].filter(:name => "foo").inner_join(:child_table, > :parent_id => :id).each { ... } > > Also of note; if you are forced to handle actual spreadsheets, the > apache POI libraries (http://poi.apache.org/) are pretty easy to use > from JRuby - I'm using them with Sequel to do some pretty hairy data > migrations, with a lot of success. (Sadly, many business types are > far better at putting tabular data in a spreadsheet than anything as > complex as, say, a CSV or YAML file) > > - Korny > > > > > > On Tue, Jun 2, 2009 at 2:13 PM, Eaden McKee <[email protected]> wrote: > > > On Tue, Jun 2, 2009 at 3:26 PM, Sven Schott <[email protected]> wrote: > >> Unfortunately not an option. Any data has to stay in-house since it would > >> be > > > Sure, I understand :) > > > In that case I could suggest rbDB( > >http://github.com/redox/rbdb/tree/master) and Typus ( > >http://github.com/fesplugas/typus/tree/master) as possible starting > > points for Rails apps that edit multiple tables with single > > controllers to get ideas from or fork. > > > Eaden > > -- > Kornelis Sietsma korny at my surname dot com > "Every jumbled pile of person has a thinking part > that wonders what the part that isn't thinking > isn't thinking of" --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby or Rails Oceania" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rails-oceania?hl=en -~----------~----~----~----~------~----~------~--~---
