Rails core - Aug 2008 - ActiveRecord patchset (introducing features such as postgres schema support)

Hi.

Our company is currently working on a large government contract to
develop an elearning system using Ruby on Rails. To support our needs,
we have added numerous useful features to ActiveRecord over the past
year or so; they include things such as proper support for PostgreSQL
schemas, saving binary data in PostgreSQL (currently broken as of
Rails 2.1), SQL reflection for stored procedures, calling stored
procedures using ActiveRecord, support for serializing (to_xml or
to_json) objects of multiple classes into the same array... Now, my
employer is seriously considering allocating person-hours for us to
work with the Rails core team to get our patches included in trunk.

We believe our changes to be quite useful, and consider it only fair
that we should give back to the community around this great project.
The question is, whether you would be interested in helping us with
this process, and including this functionality.

Thanks, I''ll look forward to your replies,
Adam

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Core" group.
To post to this group, send email to rubyonrails-core@googlegroups.com
To unsubscribe from this group, send email to
rubyonrails-core+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-core?hl=en
-~----------~----~----~----~------~----~------~--~---

On Thu, Aug 21, 2008 at 7:23 AM, Adam Šindelář <adam.sindelar@gmail.com>
wrote:
> Our company is currently working on a large government contract to
> develop an elearning system using Ruby on Rails. To support our needs,
> we have added numerous useful features to ActiveRecord over the past
> year or so; they include things such as proper support for PostgreSQL
> schemas, saving binary data in PostgreSQL (currently broken as of
> Rails 2.1), SQL reflection for stored procedures, calling stored
> procedures using ActiveRecord, support for serializing (to_xml or
> to_json) objects of multiple classes into the same array... Now, my
> employer is seriously considering allocating person-hours for us to
> work with the Rails core team to get our patches included in trunk.
>
> We believe our changes to be quite useful, and consider it only fair
> that we should give back to the community around this great project.
> The question is, whether you would be interested in helping us with
> this process, and including this functionality.
Hi Adam,

We'd love to work with you guys to merge your patches. Do you have a
github fork where we can peruse the changes?

Best,
jeremy

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Core" group.
To post to this group, send email to rubyonrails-core@googlegroups.com
To unsubscribe from this group, send email to
rubyonrails-core+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-core?hl=en
-~----------~----~----~----~------~----~------~--~---

Hi again,

We don't have a public fork right now, and it will take some time for things
to get moving in the company. I'm sorry about this process, I need to show
my superiors that there's interest on your side for them to green-light the
budget for this. I'll make sure to post back here as soon the person-hours
budget is approved and we can work out what would work best.

Thanks for your interest, I look forward to working with you guys.

Adam

2008/8/21 Jeremy Kemper <jeremy@bitsweat.net>
> On Thu, Aug 21, 2008 at 7:23 AM, Adam Šindelář
<adam.sindelar@gmail.com>
> wrote:
> > Our company is currently working on a large government contract to
> > develop an elearning system using Ruby on Rails. To support our needs,
> > we have added numerous useful features to ActiveRecord over the past
> > year or so; they include things such as proper support for PostgreSQL
> > schemas, saving binary data in PostgreSQL (currently broken as of
> > Rails 2.1), SQL reflection for stored procedures, calling stored
> > procedures using ActiveRecord, support for serializing (to_xml or
> > to_json) objects of multiple classes into the same array... Now, my
> > employer is seriously considering allocating person-hours for us to
> > work with the Rails core team to get our patches included in trunk.
> >
> > We believe our changes to be quite useful, and consider it only fair
> > that we should give back to the community around this great project.
> > The question is, whether you would be interested in helping us with
> > this process, and including this functionality.
>
> Hi Adam,
>
> We'd love to work with you guys to merge your patches. Do you have a
> github fork where we can peruse the changes?
>
> Best,
> jeremy
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Core" group.
To post to this group, send email to rubyonrails-core@googlegroups.com
To unsubscribe from this group, send email to
rubyonrails-core+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-core?hl=en
-~----------~----~----~----~------~----~------~--~---

Hello yet again,

I''m permitted by my superiors to go ahead, but I am going to have to
do work on this alone, so things may not go as fast as I''d intended.
Nevertheless, I have prepared the first patch that I would like to
show to you, and find out what you would have me fix, add, or change.
Due to the fact that I am only one person, and cannot possibly hope to
prepare the entirety of our repository (nor am I allowed to) for your
review in reasonable time, I''m going to have to submit individual
patches. Unless you want me to do otherwise, I''m going to stick with
the normal patch review process, and have, for now, submitted the
first version of this patch here:
http://rails.lighthouseapp.com/projects/8994-ruby-on-rails/tickets/888-add-sql-methods-to-models.

I would appreciate it, if you could review it and let me know what to
change.

Cheers,
Adam

On Aug 21, 9:08 pm, "Jeremy Kemper" <jer...@bitsweat.net>
wrote:
> On Thu, Aug 21, 2008 at 7:23 AM, Adam Šindelář
<adam.sinde...@gmail.com> wrote:
> > Our company is currently working on a large government contract to
> > develop an elearning system using Ruby on Rails. To support our needs,
> > we have added numerous useful features to ActiveRecord over the past
> > year or so; they include things such as proper support for PostgreSQL
> > schemas, saving binary data in PostgreSQL (currently broken as of
> > Rails 2.1), SQL reflection for stored procedures, calling stored
> > procedures using ActiveRecord, support for serializing (to_xml or
> > to_json) objects of multiple classes into the same array... Now, my
> > employer is seriously considering allocating person-hours for us to
> > work with the Rails core team to get our patches included in trunk.
>
> > We believe our changes to be quite useful, and consider it only fair
> > that we should give back to the community around this great project.
> > The question is, whether you would be interested in helping us with
> > this process, and including this functionality.
>
> Hi Adam,
>
> We''d love to work with you guys to merge your patches. Do you have
a
> github fork where we can peruse the changes?
>
> Best,
> jeremy
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Core" group.
To post to this group, send email to rubyonrails-core@googlegroups.com
To unsubscribe from this group, send email to
rubyonrails-core+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-core?hl=en
-~----------~----~----~----~------~----~------~--~---

We have also done some work extending the rails postgresql adapter for
a legacy database. Specifically, to support postgresql DDL commands in
ruby code. Currently it supports dumping and creating database
functions, database trigger functions, user defined database types,
and creating (not dumping by default) database views.

We created it as a monkey patch plugin for the rails schema_dumper and
postgresql_adapter and it has worked nicely for us from Rails 1.2.6 to
Rails 2.1. The rubyforge site is http://rubyforge.org/projects/railspgprocs/.

On Aug 21, 7:23 am, Adam Šindelář <adam.sinde...@gmail.com>
wrote:
> Hi.
>
> Our company is currently working on a large government contract to
> develop an elearning system using Ruby on Rails. To support our needs,
> we have added numerous useful features to ActiveRecord over the past
> year or so; they include things such as proper support for PostgreSQL
> schemas, saving binary data in PostgreSQL (currently broken as of
> Rails 2.1), SQL reflection for stored procedures, calling stored
> procedures using ActiveRecord, support for serializing (to_xml or
> to_json) objects of multiple classes into the same array... Now, my
> employer is seriously considering allocating person-hours for us to
> work with the Rails core team to get our patches included in trunk.
>
> We believe our changes to be quite useful, and consider it only fair
> that we should give back to the community around this great project.
> The question is, whether you would be interested in helping us with
> this process, and including this functionality.
>
> Thanks, I''ll look forward to your replies,
> Adam
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Core" group.
To post to this group, send email to rubyonrails-core@googlegroups.com
To unsubscribe from this group, send email to
rubyonrails-core+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-core?hl=en
-~----------~----~----~----~------~----~------~--~---

I should mention we''d be interested in getting these additions added
to the core postgresql adapter if there is a possibility of that.
Although I wouldn''t want to step on any toes either. We''d be
happy to
collaborate with Adam and Co. on this also, seeing as he brought it
up.

On Aug 25, 9:37 am, frogstarr78 <frogstar...@gmail.com>
wrote:
> We have also done some work extending the rails postgresql adapter for
> a legacy database. Specifically, to support postgresql DDL commands in
> ruby code. Currently it supports dumping and creating database
> functions, database trigger functions, user defined database types,
> and creating (not dumping by default) database views.
>
> We created it as a monkey patch plugin for the rails schema_dumper and
> postgresql_adapter and it has worked nicely for us from Rails 1.2.6 to
> Rails 2.1. The rubyforge site
ishttp://rubyforge.org/projects/railspgprocs/.
>
> On Aug 21, 7:23 am, Adam Šindelář <adam.sinde...@gmail.com> wrote:
>
> > Hi.
>
> > Our company is currently working on a large government contract to
> > develop an elearning system using Ruby on Rails. To support our needs,
> > we have added numerous useful features to ActiveRecord over the past
> > year or so; they include things such as proper support for PostgreSQL
> > schemas, saving binary data in PostgreSQL (currently broken as of
> > Rails 2.1), SQL reflection for stored procedures, calling stored
> > procedures using ActiveRecord, support for serializing (to_xml or
> > to_json) objects of multiple classes into the same array... Now, my
> > employer is seriously considering allocating person-hours for us to
> > work with the Rails core team to get our patches included in trunk.
>
> > We believe our changes to be quite useful, and consider it only fair
> > that we should give back to the community around this great project.
> > The question is, whether you would be interested in helping us with
> > this process, and including this functionality.
>
> > Thanks, I''ll look forward to your replies,
> > Adam
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Core" group.
To post to this group, send email to rubyonrails-core@googlegroups.com
To unsubscribe from this group, send email to
rubyonrails-core+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-core?hl=en
-~----------~----~----~----~------~----~------~--~---

2008/8/25 frogstarr78 <frogstarr78@gmail.com>:
> I should mention we''d be interested in getting these additions
added
> to the core postgresql adapter if there is a possibility of that.
> Although I wouldn''t want to step on any toes either. We''d
be happy to
> collaborate with Adam and Co. on this also, seeing as he brought it
> up.
Nice code :) What versions of pg does it work with?

jeremy

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Core" group.
To post to this group, send email to rubyonrails-core@googlegroups.com
To unsubscribe from this group, send email to
rubyonrails-core+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-core?hl=en
-~----------~----~----~----~------~----~------~--~---

On Aug 21, 4:23 pm, Adam Šindelář <adam.sinde...@gmail.com>
wrote:
> Hi.
>
> Our company is currently working on a large government contract to
> develop an elearning system using Ruby on Rails. To support our needs,
> we have added numerous useful features to ActiveRecord over the past
> year or so; they include things such as proper support for PostgreSQL
> schemas, saving binary data in PostgreSQL (currently broken as of
> Rails 2.1), SQL reflection for stored procedures, calling stored
> procedures using ActiveRecord, support for serializing (to_xml or
> to_json) objects of multiple classes into the same array... Now, my
> employer is seriously considering allocating person-hours for us to
> work with the Rails core team to get our patches included in trunk.
>
> We believe our changes to be quite useful, and consider it only fair
> that we should give back to the community around this great project.
> The question is, whether you would be interested in helping us with
> this process, and including this functionality.
>
> Thanks, I''ll look forward to your replies,
> Adam
I just want to say, good work. :) I''ve tried to use Rails with
PostgreSQL some time ago and I ran into all sorts of issues. Hopefully
these changes will get included in time.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Core" group.
To post to this group, send email to rubyonrails-core@googlegroups.com
To unsubscribe from this group, send email to
rubyonrails-core+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-core?hl=en
-~----------~----~----~----~------~----~------~--~---

On E, 2008-08-25 at 14:00 -0700, Hongli Lai wrote:
> I just want to say, good work. :) I''ve tried to use Rails with
> PostgreSQL some time ago and I ran into all sorts of issues. Hopefully
> these changes will get included in time.
Care to elaborate on the issues?

I''m not aware of any issues with using Postgresql with Rails like one
would use Mysql, but ofcourse the more advanced Postgresql features
aren''t supported by Rails. This sometimes means that for schema one
needs to use the :sql format and one also needs to write custom SQL to
access certain features, but I wouldn''t call those issues, just
lack of niceties.

Certain features, as you''re probably aware of, like foreign key
migrations/dumping, are provided by the Redhill on Rails plugins:
http://www.redhillonrails.org/index.html


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Core" group.
To post to this group, send email to rubyonrails-core@googlegroups.com
To unsubscribe from this group, send email to
rubyonrails-core+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-core?hl=en
-~----------~----~----~----~------~----~------~--~---

This works on PostgreSQL versions 8.0-8.2

On Aug 25, 12:50 pm, "Jeremy Kemper" <jer...@bitsweat.net>
wrote:
> 2008/8/25 frogstarr78 <frogstar...@gmail.com>:
>
> > I should mention we''d be interested in getting these
additions added
> > to the core postgresql adapter if there is a possibility of that.
> > Although I wouldn''t want to step on any toes either.
We''d be happy to
> > collaborate with Adam and Co. on this also, seeing as he brought it
> > up.
>
> Nice code :) What versions of pg does it work with?
>
> jeremy
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Core" group.
To post to this group, send email to rubyonrails-core@googlegroups.com
To unsubscribe from this group, send email to
rubyonrails-core+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-core?hl=en
-~----------~----~----~----~------~----~------~--~---