tags:

views:

47

answers:

1
Q: 

Are there any issues with Activerecord class in codeigniter?

I'm a little hesistant against to use it because I believe there can be some issues with it, but I don't really know it before I've tried it. Or is it good enough to use it or should I do plain sql statements? Does anyone know?

+2  A: 

It has it's advantages and disadvantages. One advantage is that all queries are automatically formatted, escaped, and optimized. This is a big plus on the security side because we all forget to do everything that can be done to protect ourselves sometimes. Active Record doesn't forget.

One disadvantage is that it sometimes is difficult to construct complex queries with it but that's easily taken care of by just running your own. All in all i would highly recommend using Active Record. We have been using it for our enterprise level application for the last 1.5+ years and it hasn't failed us yet.

Tom Schlick  2010-01-03 10:18:41
Thanks, I'll use it then.
marko  2010-01-03 10:24:16
No problem :)! If you have any problems check out some threads about active record on the codeigniter forums... http://codeigniter.com/forums/
Tom Schlick  2010-01-03 10:26:35

related questions

Problem accessing previousState in OnFlushDirty() event of Castle ActiveRecord
Should I be extending this class? (PHP)
How to best handle per-Model database connections with ActiveRecord?
How to eager load objects with a custom join in rails?
Grouping Activerecord query by a child attribute
Should you avoid object inheritence when persisting to an RDBMS solution
Stop Activerecord from loading Blob column
How does the ActiveRecord pattern differ from the Domain Object or Data Mapper pattern?
How does has_one :through work?
In Rails, after using find with :select, my objects don't save
Mixing ActiveRecord find Conditions
in Rails, how do I execute direct SQL code on a different database?
Overriding "find" in ActiveRecord the DRY way
rake db:migrate doesn't detect new migration ?
Best Practice for Model Design in Ruby on Rails
What is the easiest way to duplicate an activerecord record?
How to create multiple records at once with ActiveScaffold in ROR
activerecord as model, is this a good idea?
How can I upsert a bunch of ActiveRecord objects and relationships in Rails?
Database sharding and Rails
Do you know how to implement transactions in Castle ActiveRecord?
How can I count the number of records that have a unique value in a particular field in ROR?
How would you test observers with rSpec in a Ruby on Rails application?
Any tips on getting Rails to run with an Access back-end?
Why all the Active Record hate?