夜鸣猪 发表于 2013-1-25 21:09:02

在Ruby把MySQL做NoSQL用 Friendly简介

Friendly是一个github上的一个插件,起源是因为FriendFeed把MySQL做NoSQL的用,具体参见这篇:
http://bret.appspot.com/entry/how-friendfeed-uses-mysql


Friendly就是这样的作用,把MySQL变成一个文件数据库来用。NoSQL日趋狂热,schemaless是其中一个原因。客户端的改变可以将MySQL达到同样目的。下面是简单的介绍:



安装friendly


sudo gem install friendly

在Rails里



#environment.rb:    config.gem "friendly"

#and create a config/friendly.yml:development::adapter:"mysql":host:   "localhost":user:   "root":password: "swordfish":database: "friendly_development"

没有使用Rails:
Friendly.configure :adapter=> "mysql",                   :host   => "localhost",                   :user   => "root",                   :password => "swordfish",                   :database => "playing_with_friendly"

创建Model


class BlogPostinclude Friendly::Document   attribute :author, Stringattribute :title,Stringattribute :body,   Stringend

创建Table

#script/console:Friendly.create_tables!

索引

class BlogPostinclude Friendly::Document   attribute :author, Stringattribute :title,Stringattribute :body,   String   indexes :authorindexes :created_atend   

#Run create_tables again and the index tables will be created for you.Friendly.create_tables!

创建Objects

#With familiar ActiveRecord syntax:BlogPost.create :author => "James Golick",                :title=> "Friendly has familiar syntax.",                :body   => "So, there's very little learning curve."

查询

BlogPost.all(:author => "James Golick")

#Most recent posts:BlogPost.all(:order! => :created_at.desc)

缓存
#Install the memcached gem:sudo gem install memcached#配置 Friendly:Friendly.cache = Friendly::Memcached.new(Memcached.new)#Configure your model to cache:class BlogPostinclude Friendly::Document   attribute :author, Stringattribute :title,Stringattribute :body,   String   indexes :authorindexes :created_at   caches_by :idend
页: [1]
查看完整版本: 在Ruby把MySQL做NoSQL用 Friendly简介