# ActiveRecord, using sql functions for some attributes

**URL:** <https://www.ruby-forum.com/t/activerecord-using-sql-functions-for-some-attributes/63582>\
**Category:** Rails\
**Created:** [June 16, 2006, 12:11pm UTC](https://www.ruby-forum.com/t/activerecord-using-sql-functions-for-some-attributes/63582 "2006-06-16T12:11:36Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![zven](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/z/77aa72/32.png) [@zven](https://www.ruby-forum.com/u/zven)\
**Post date:** [June 16, 2006, 12:11pm UTC](https://www.ruby-forum.com/t/activerecord-using-sql-functions-for-some-attributes/63582/1 "2006-06-16T12:11:36Z")

</div>

Hi.  
I need to use functions INET\_ATON, INET\_NTOA for IP address retrieving.  
Is it possible to make this transparently (without custom SQL for  
saving, updating and retrieving)?

---

<div class="post-metadata">

**Author:** ![zven](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/z/77aa72/32.png) [@zven](https://www.ruby-forum.com/u/zven)\
**Post date:** [June 16, 2006, 1:32pm UTC](https://www.ruby-forum.com/t/activerecord-using-sql-functions-for-some-attributes/63582/2 "2006-06-16T13:32:14Z")

</div>

I made a rails plugin for using SQL Functions in rails. If you would  
like  
it, let me know.

mark

---

<div class="post-metadata">

**Author:** ![zven](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/z/77aa72/32.png) [@zven](https://www.ruby-forum.com/u/zven)\
**Post date:** [June 16, 2006, 1:50pm UTC](https://www.ruby-forum.com/t/activerecord-using-sql-functions-for-some-attributes/63582/3 "2006-06-16T13:50:51Z")

</div>

On Fri, 2006-06-16 at 07:30 -0400, Mark Van H. wrote:

> I made a rails plugin for using SQL Functions in rails. If you would  
> like it, let me know.

Yes! I would like it 🙂 I think others will like it too…

---

<div class="post-metadata">

**Author:** ![zven](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/z/77aa72/32.png) [@zven](https://www.ruby-forum.com/u/zven)\
**Post date:** [June 16, 2006, 8:32pm UTC](https://www.ruby-forum.com/t/activerecord-using-sql-functions-for-some-attributes/63582/4 "2006-06-16T20:32:21Z")

</div>

I have released a new plugin offering the ability to use built-in  
database  
functions within ActiveRecord. Please visit  
[http://www.agilewebdevelopment.com/plugins/activerecord\_database\_functions](http://www.agilewebdevelopment.com/plugins/activerecord_database_functions)  
. If anyone has any questions, suggestions, or improvements, please let  
me  
know!

Thanks,  
Mark Van H. (removed\_email\_address@domain.invalid)  
Zach D. ( removed\_email\_address@domain.invalid)