When will rails support true prepared statements?

I’m in an Oracle shop, and it’s the 1 thing that gets on my bosses
nerves. I wish they would support this.

Anyone any idea if or when it will be supported?

Thanks
Chris

Chris wrote:

I’m in an Oracle shop, and it’s the 1 thing that gets on my bosses
nerves. I wish they would support this.

What is a “prepared statment”?

On 8 Aug 2006, at 12:21, Chris wrote:

OK, ill rephrase it. When will Rails support bind variables with
Oracle?

“find(“name = ?”,var)” is not using bind variables.

Without bind variables oracle has to to more processing on every piece
of SQL

This has been discussed on the rails-core list. Have a look through
the archives there. I’m pretty sure somethings cooking, no idea what
state it’s at though.

Chris

Chris wrote:

OK, ill rephrase it. When will Rails support bind variables with
Oracle?

“find(“name = ?”,var)” is not using bind variables.

Without bind variables oracle has to to more processing on every piece
of SQL

I highly encourage you to start an OracleActiveRecords gem that extends
the API of ActiveRecords towards the feature set of Oracle.
Rails/ActiveRecords will always support the lowest-common denominator of
features provided by the supported databases. e.g. no foreign key
support, only implicit keys via column names. No transactions for
migrations.

Once you have your own extension, you are friend to improve the CRUD API
with bind calls, transactions for migrations, etc.

Might be good branding for your boss too if your company/department
sponsors the development.

Cheers
Nic

OK, ill rephrase it. When will Rails support bind variables with
Oracle?

“find(“name = ?”,var)” is not using bind variables.

Without bind variables oracle has to to more processing on every piece
of SQL

This guy is doing Oracle AR work, perhaps chat with him:
http://www.ruby-forum.com/topic/76352#new

Chris wrote:

I’m in an Oracle shop, and it’s the 1 thing that gets on my bosses
nerves. I wish they would support this.

Anyone any idea if or when it will be supported?

Prepared statements don’t really matter so much, what’s big is the use
of native bind variables. Which I’m working on (insert/update are
complete), hope to have a patch ready within a week or so.

On 8/8/06, Michael A. Schoen [email protected] wrote:

Chris wrote:

I’m in an Oracle shop, and it’s the 1 thing that gets on my bosses
nerves. I wish they would support this.

Anyone any idea if or when it will be supported?

Prepared statements don’t really matter so much, what’s big is the use
of native bind variables. Which I’m working on (insert/update are
complete), hope to have a patch ready within a week or so.

Sweet. You’re rewriting AR to pass around [“query string ? ? ?”,
bunch, of, params], as discussed on rails-core?

But aren’t prepared statements and bind variables two aspects of the
same thing?

Isak

On 8/8/06, Chris [email protected] wrote:


Rails mailing list
[email protected]
http://lists.rubyonrails.org/mailman/listinfo/rails

As I understand it, the answer to questions like these is,
“When you write a plugin for it.”

Chris wrote:

Prepared statements don’t really matter so much, what’s big is the use
of native bind variables. Which I’m working on (insert/update are
complete), hope to have a patch ready within a week or so.

Will this be a rails core patch?? Where will I be able to access it?

My goal is to get this into rails core, though that’ll require some
review from the core team. Not sure when it’ll happen – in particular,
don’t know if it’ll make it into the upcoming 1.2, the exact timing of
which I’m unsure.

Prepared statements don’t really matter so much, what’s big is the use
of native bind variables. Which I’m working on (insert/update are
complete), hope to have a patch ready within a week or so.

Will this be a rails core patch?? Where will I be able to access it?

Thanks
Chris

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs