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
-~----------~----~----~----~------~----~------~--~---
