ActiveSQL
=========
Get the super fast mysql query results from Ruby and Rails applications.
Love to write queries.
Build queries on your own.
Get super fast results.
Keep everything in mysql.
USAGE:
======
require 'active_sql'
ActiveSQL::Base.establish_connection(:host=> 'localhost', :username=>'root', :password=> 'peep', :socket=> '') => true
ActiveSQL::Base.connected? => true
ActiveSQL::Base.insert_sql("insert into users values(1, 'user1@example.com', 12, 12.3)") => true
ActiveSQL::Base.execute_sql("delete from roles") => true
ActiveSQL::Base.select_sql("select * from users") => [[1, 'user1@example.com', 12, 12.3]]
ActiveSQL::Base.select_sql("select * from users").columns => ["id@users", "email@users", "rate@users", "points@users"]
user = ActiveSQL::Base.select_sql("select id, rate as rank from users limit 1").first
# Methods will be added by default.
# Disabling methods possible.
user.id => 1
user.rank => 12
ActiveSQL::Base.my_char_set => "latin1"
ActiveSQL::Base.my_char_set("utf8") => "utf8"
ActiveSQL::Base.my_database("another_database") => true
# Append get methods to every row.
ActiveSQL::Base.add_methods(true) => true
# Do not append methods:
ActiveSQL::Base.add_methods(false) => true
# Status of adding methods to the rows.
ActiveSQL::Base.add_methods? => true
Note:
Tentative build compiled by ruby 1.8 - linux.
Project
active_sql
Easy to work with mysql from ruby and rails
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
Dependencies
Project Readme