{"id":42235,"date":"2023-09-26T13:43:30","date_gmt":"2023-08-20T03:04:08","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8-rdbi-%e4%bd%9c%e4%b8%ba%e6%9b%bf%e4%bb%a3-ruby-dbi%e3%80%82\/"},"modified":"2024-05-04T01:39:47","modified_gmt":"2024-05-03T17:39:47","slug":"%e4%bd%bf%e7%94%a8-rdbi-%e4%bd%9c%e4%b8%ba%e6%9b%bf%e4%bb%a3-ruby-dbi%e3%80%82","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8-rdbi-%e4%bd%9c%e4%b8%ba%e6%9b%bf%e4%bb%a3-ruby-dbi%e3%80%82\/","title":{"rendered":"\u4f7f\u7528 RDBI \u4f5c\u4e3a\u66ff\u4ee3 Ruby\/DBI"},"content":{"rendered":"<h1>\u4f7f\u7528RDBI\u6765\u66ff\u4ee3Ruby\/DBI<\/h1>\n<h2>\u603b\u7ed3<\/h2>\n<p>\u4ee5\u524d\u4e3b\u8981\u4f7f\u7528Ruby 1.8\uff0c\u4f46\u73b0\u5728\u60f3\u5f00\u59cb\u4f7f\u7528Ruby 2.0\u4e86\u3002<br \/>\n\u8fde\u63a5\u6570\u636e\u5e93\u7684\u5e93\u6709\u5f88\u591a\uff0c\u4f46\u4e4b\u524d\u4e3b\u8981\u4f7f\u7528\u7684\u662fdbi\u3001dbd-pg\u548cpg\uff08\u76f4\u52301.8\u7248\u672c\uff09\u3002<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Ruby\/DBI https:\/\/rubygems.org\/gems\/dbi<\/ul>\n<\/li>\n<\/ul>\n<p>DBD::Pg https:\/\/rubygems.org\/gems\/dbd-pg<\/p>\n<p>pg https:\/\/rubygems.org\/gems\/pg<\/p>\n<p>\u4f46\u662f\u6839\u636e\u5f00\u53d1\u8005\uff08erikh\uff09\u8bf4\uff0c\u4f3c\u4e4edbi\u53ea\u652f\u6301\u5230Ruby 1.8\u3002<br \/>\nhttps:\/\/github.com\/erikh\/ruby-dbi\/issues\/5<br \/>\n\u5728\u4e0a\u8ff0\u95ee\u9898\u4e2d\uff0c\u5f00\u53d1\u8005\u63a8\u8350\u4f7f\u7528\u4ed6\u521b\u5efa\u7684\u540d\u4e3aRDBI\u7684Ruby\/DBI\u7684&#8221;Version2&#8243;\u3002<\/p>\n<p>\u6211\u5011\u8981\u8abf\u67e5\u7684\u662fRDBI\u4ee5\u53ca\u5176\u7528\u65bcPostgreSQL\u7684\u9a45\u52d5\u7a0b\u5f0frdbi-driver-postgresql\u3002<\/p>\n<h2>\u5b89\u88c5<\/h2>\n<p>\u53ea\u6709\u5b9d\u77f3<\/p>\n<pre class=\"post-pre\"><code>$ gem install pg\r\n$ gem install rdbi\r\n$ gem install rdbi-driver-postgresql\r\n<\/code><\/pre>\n<h2>\u6267\u884c<\/h2>\n<pre class=\"post-pre\"><code><span class=\"c1\">#-*- coding:utf-8 -*-<\/span>\r\n<span class=\"nb\">require<\/span> <span class=\"s1\">'rdbi'<\/span>\r\n<span class=\"nb\">require<\/span> <span class=\"s1\">'rdbi-driver-postgresql'<\/span>\r\n\r\n<span class=\"n\">dbh<\/span> <span class=\"o\">=<\/span> <span class=\"no\">RDBI<\/span><span class=\"p\">.<\/span><span class=\"nf\">connect<\/span><span class=\"p\">(<\/span><span class=\"ss\">:PostgreSQL<\/span><span class=\"p\">,<\/span> <span class=\"ss\">:dbname<\/span><span class=\"o\">=&gt;<\/span><span class=\"s2\">\"test\"<\/span><span class=\"p\">,<\/span> <span class=\"ss\">:port<\/span><span class=\"o\">=&gt;<\/span><span class=\"mi\">5432<\/span><span class=\"p\">,<\/span> <span class=\"ss\">:user<\/span><span class=\"o\">=&gt;<\/span><span class=\"s2\">\"user\"<\/span><span class=\"p\">,<\/span> <span class=\"ss\">:password<\/span><span class=\"o\">=&gt;<\/span><span class=\"s2\">\"pass\"<\/span><span class=\"p\">)<\/span>\r\n<span class=\"n\">dbh<\/span><span class=\"p\">.<\/span><span class=\"nf\">execute<\/span><span class=\"p\">(<\/span><span class=\"s2\">\"SELECT NOW()\"<\/span><span class=\"p\">).<\/span><span class=\"nf\">fetch<\/span><span class=\"p\">(<\/span><span class=\"ss\">:first<\/span><span class=\"p\">)<\/span> <span class=\"c1\">#=&gt; [\"2014-11-28 18:13:27.232+09\"]<\/span>\r\n<span class=\"n\">dbh<\/span><span class=\"p\">.<\/span><span class=\"nf\">disconnect<\/span>\r\n<\/code><\/pre>\n<h2>\u8981\u4f7f\u7528RDBI\u6765\u5b8c\u6210\u4e4b\u524d\u5728Ruby\/DBI\u4e2d\u6240\u505a\u7684\u4e8b\u60c5\u3002<\/h2>\n<p>\u770b\u8d77\u6765\uff0cRuby\/DBI\u7684\u4ee3\u7801\u548c\u5b83\u5b8c\u5168\u4e0d\u662f\u76f8\u540c\u7684\u7528\u6cd5\u3002<br \/>\n\u8ba9\u6211\u4eec\u7b80\u5355\u6bd4\u8f83\u4e00\u4e0b\u3002<\/p>\n<h3>\u9700\u8981 \uff08\uff09<\/h3>\n<pre class=\"post-pre\"><code><span class=\"nb\">require<\/span> <span class=\"s1\">'dbi'<\/span>\r\n<span class=\"c1\">#require 'dbd-pg' #\u4e0d\u8981<\/span>\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"nb\">require<\/span> <span class=\"s1\">'rdbi'<\/span>\r\n<span class=\"nb\">require<\/span> <span class=\"s1\">'rdbi-driver-postgresql'<\/span> <span class=\"c1\">#\u5fc5\u8981<\/span>\r\n<\/code><\/pre>\n<p>\u7531\u4e8eRDBI\u4e0d\u4f1a\u81ea\u52a8\u52a0\u8f7d\u9a71\u52a8\u7a0b\u5e8f\u3002<\/p>\n<h3>\u8fde\u63a5\u5230\u6570\u636e\u5e93.<\/h3>\n<pre class=\"post-pre\"><code><span class=\"n\">dbh<\/span> <span class=\"o\">=<\/span> <span class=\"no\">DBI<\/span><span class=\"p\">.<\/span><span class=\"nf\">connect<\/span><span class=\"p\">(<\/span><span class=\"s2\">\"dbi:Pg:dbname\"<\/span><span class=\"p\">,<\/span> <span class=\"s2\">\"user\"<\/span><span class=\"p\">,<\/span> <span class=\"s2\">\"pass\"<\/span><span class=\"p\">)<\/span>\r\n<span class=\"c1\"># or<\/span>\r\n<span class=\"c1\">#dbh = DBI.connect(\"dbi:Pg:database=dbname;port=5432;host=localhost\", \"user\", \"pass\")<\/span>\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"n\">dbh<\/span> <span class=\"o\">=<\/span> <span class=\"no\">RDBI<\/span><span class=\"p\">.<\/span><span class=\"nf\">connect<\/span><span class=\"p\">(<\/span><span class=\"ss\">:PostgreSQL<\/span><span class=\"p\">,<\/span> <span class=\"ss\">:dbname<\/span><span class=\"o\">=&gt;<\/span><span class=\"s2\">\"dbname\"<\/span><span class=\"p\">,<\/span> <span class=\"ss\">:user<\/span><span class=\"o\">=&gt;<\/span><span class=\"s2\">\"user\"<\/span><span class=\"p\">,<\/span> <span class=\"ss\">:password<\/span><span class=\"o\">=&gt;<\/span><span class=\"s2\">\"pass\"<\/span><span class=\"p\">)<\/span>\r\n<span class=\"c1\"># or<\/span>\r\n<span class=\"c1\">#dbh = RDBI.connect(RDBI::Driver::PostgreSQL, :dbname=&gt;\"dbname\", :user=&gt;\"user\", :password=&gt;\"pass\")<\/span>\r\n<\/code><\/pre>\n<p>\u5728connect\u51fd\u6570\u7684\u7b2c\u4e00\u4e2a\u53c2\u6570\u4e2d\u6307\u5b9aDriver\u7684\u7b26\u53f7\u6216\u7c7b\u3002<\/p>\n<h3>\u8fdb\u884c\u9009\u62e9<\/h3>\n<pre class=\"post-pre\"><code><span class=\"c1\">#1\u884c<\/span>\r\n<span class=\"n\">dbh<\/span><span class=\"p\">.<\/span><span class=\"nf\">select_one<\/span><span class=\"p\">(<\/span><span class=\"s2\">\"SELECT * FROM table_name\"<\/span><span class=\"p\">)<\/span> <span class=\"c1\">#=&gt; [1, \"aaa\"]<\/span>\r\n<span class=\"c1\">#\u5168\u884c<\/span>\r\n<span class=\"n\">dbh<\/span><span class=\"p\">.<\/span><span class=\"nf\">select_all<\/span><span class=\"p\">(<\/span><span class=\"s2\">\"SELECT * FROM table_name\"<\/span><span class=\"p\">)<\/span> <span class=\"c1\">#=&gt; [[1, \"aaa\"], [2, \"bbb\"], [3, \"ccc\"]]<\/span>\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"c1\">#1\u884c<\/span>\r\n<span class=\"n\">dbh<\/span><span class=\"p\">.<\/span><span class=\"nf\">execute<\/span><span class=\"p\">(<\/span><span class=\"s2\">\"SELECT * FROM table_name\"<\/span><span class=\"p\">).<\/span><span class=\"nf\">fetch<\/span><span class=\"p\">(<\/span><span class=\"ss\">:first<\/span><span class=\"p\">)<\/span> <span class=\"c1\">#=&gt; [1, \"aaa\"]<\/span>\r\n<span class=\"c1\">#\u5168\u884c<\/span>\r\n<span class=\"n\">dbh<\/span><span class=\"p\">.<\/span><span class=\"nf\">execute<\/span><span class=\"p\">(<\/span><span class=\"s2\">\"SELECT * FROM table_name\"<\/span><span class=\"p\">).<\/span><span class=\"nf\">fetch<\/span><span class=\"p\">(<\/span><span class=\"ss\">:all<\/span><span class=\"p\">)<\/span> <span class=\"c1\">#=&gt; [[1, \"aaa\"], [2, \"bbb\"], [3, \"ccc\"]]<\/span>\r\n<\/code><\/pre>\n<h3>\u4ea4\u6613<\/h3>\n<pre class=\"post-pre\"><code><span class=\"n\">dbh<\/span><span class=\"p\">[<\/span><span class=\"s2\">\"AutoCommit\"<\/span><span class=\"p\">]<\/span> <span class=\"o\">=<\/span> <span class=\"kp\">false<\/span>\r\n<span class=\"k\">begin<\/span>\r\n  <span class=\"c1\"># \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u4e2d\u306e\u51e6\u7406<\/span>\r\n  <span class=\"n\">dbh<\/span><span class=\"p\">.<\/span><span class=\"nf\">commit<\/span>\r\n<span class=\"k\">rescue<\/span>\r\n  <span class=\"c1\"># \u5931\u6557<\/span>\r\n  <span class=\"n\">dbh<\/span><span class=\"p\">.<\/span><span class=\"nf\">rollback<\/span>\r\n<span class=\"k\">end<\/span>\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"n\">dbh<\/span><span class=\"p\">.<\/span><span class=\"nf\">execute<\/span><span class=\"p\">(<\/span><span class=\"s2\">\"BEGIN\"<\/span><span class=\"p\">).<\/span><span class=\"nf\">fetch<\/span>\r\n<span class=\"k\">begin<\/span>\r\n  <span class=\"c1\"># \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u4e2d\u306e\u51e6\u7406<\/span>\r\n  <span class=\"n\">dbh<\/span><span class=\"p\">.<\/span><span class=\"nf\">execute<\/span><span class=\"p\">(<\/span><span class=\"s2\">\"COMMIT\"<\/span><span class=\"p\">)<\/span>\r\n<span class=\"k\">rescue<\/span>\r\n  <span class=\"c1\"># \u5931\u6557<\/span>\r\n  <span class=\"n\">dbh<\/span><span class=\"p\">.<\/span><span class=\"nf\">execute<\/span><span class=\"p\">(<\/span><span class=\"s2\">\"ROLLBACK\"<\/span><span class=\"p\">)<\/span>\r\n<span class=\"k\">end<\/span>\r\n<\/code><\/pre>\n<p>\u4f7f\u7528 transaction \u65b9\u6cd5\u65f6\u4e0d\u77e5\u9053\u4e3a\u4f55\u4f1a\u51fa\u73b0\u9519\u8bef\u3002<\/p>\n<h2>rdbi-driver-postgresql(0.9.2) \u7684\u9519\u8bef<\/h2>\n<p>\u5728\u8fdb\u884c\u8c03\u67e5\u65f6\uff0c\u6211\u4eec\u53d1\u73b0\u4e86\u4e00\u4e9b\u9519\u8bef\uff0c\u4e8e\u662f\u6211\u4eec\u5f00\u59cb\u5bfb\u627e\u539f\u56e0\u3002<br \/>\n\u603b\u7ed3\u4e00\u4e0b\uff0c\u6211\u4eec\u53d1\u73b0\u4e86\u5927\u7ea6\u4e24\u4e2a\u7531rdbi-driver-postgresql\u5f15\u8d77\u7684\u9519\u8bef\u3002<\/p>\n<h3>\u5982\u679c\u5217\u540d\u91cd\u590d\uff0cfetch(:first)\u7684\u7ed3\u679c\u4f1a\u51fa\u73b0\u95ee\u9898\u3002<\/h3>\n<p>\u5728PostgreSQL\u4e2d\uff0c\u5bf9\u4e8eSELECT\u8bed\u53e5\uff0c\u8868\u662f\u53ef\u9009\u7684\uff0c\u4e0d\u662f\u5fc5\u9700\u7684\u3002\u5982\u679c\u5728psql\u4e2d\u6267\u884c\u4ee5\u4e0bSQL\uff1a<\/p>\n<pre class=\"post-pre\"><code><span class=\"k\">SELECT<\/span> <span class=\"mi\">3<\/span><span class=\"p\">,<\/span><span class=\"mi\">2<\/span><span class=\"p\">,<\/span><span class=\"mi\">1<\/span><span class=\"p\">,<\/span><span class=\"n\">NOW<\/span><span class=\"p\">();<\/span>\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code> ?column? | ?column? | ?column? |            now\r\n----------+----------+----------+---------------------------\r\n        3 |        2 |        1 | 2014-12-19 14:43:24.77+09\r\n(1 row)\r\n<\/code><\/pre>\n<p>\u50cf\u8fd9\u6837\uff0c\u5217\u540d\u4e2d\u51fa\u73b0\u4e86\u591a\u6b21\u201c?column?\u201d\u3002<br \/>\n\u8fd9\u79cdSQL\u5728rdbi-driver-postgresql\u4e2d\u4e0d\u80fd\u6b63\u5e38\u5de5\u4f5c\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"n\">dbh<\/span><span class=\"p\">.<\/span><span class=\"nf\">execute<\/span><span class=\"p\">(<\/span><span class=\"s2\">\"SELECT 3,2,1,NOW()\"<\/span><span class=\"p\">).<\/span><span class=\"nf\">fetch<\/span><span class=\"p\">(<\/span><span class=\"ss\">:first<\/span><span class=\"p\">)<\/span>\r\n<span class=\"c1\">#=&gt; [1, \"2014-12-19 14:43:24.77+09\"]<\/span>\r\n<\/code><\/pre>\n<p>\u53ea\u8981\u6309\u7167\u4ee5\u4e0b\u65b9\u5f0f\u5199\uff0c\u5c31\u80fd\u591f\u56de\u907f\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"n\">dbh<\/span><span class=\"p\">.<\/span><span class=\"nf\">execute<\/span><span class=\"p\">(<\/span><span class=\"s2\">\"SELECT 3,2,1,NOW()\"<\/span><span class=\"p\">).<\/span><span class=\"nf\">fetch<\/span><span class=\"p\">(<\/span><span class=\"ss\">:all<\/span><span class=\"p\">)[<\/span><span class=\"mi\">0<\/span><span class=\"p\">]<\/span>\r\n<span class=\"c1\">#=&gt; [3, 2, 1, \"2014-12-19 14:43:24.77+09\"]<\/span>\r\n<\/code><\/pre>\n<h3>\u5f53\u8fde\u7eed\u6267\u884cSQL\u65f6\u4f1a\u51fa\u73b0\u9519\u8bef\u3002<\/h3>\n<p>\u5728PreparedStatement\u4e2d\uff0c\u53ef\u4ee5\u6307\u5b9a\u540d\u79f0\uff0c\u4f46\u4ed6\u4f7f\u7528\u4e86Time.now.to_f\u4f5c\u4e3a\u540d\u79f0\uff0c\u5982\u679c\u8fde\u7eed\u6267\u884c\u4f1a\u5bfc\u81f4\u540d\u79f0\u91cd\u590d\u5e76\u51fa\u73b0\u9519\u8bef\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"mi\">10<\/span><span class=\"p\">.<\/span><span class=\"nf\">times<\/span> <span class=\"k\">do<\/span>\r\n  <span class=\"n\">dbh<\/span><span class=\"p\">.<\/span><span class=\"nf\">execute<\/span><span class=\"p\">(<\/span><span class=\"s2\">\"SELECT 1\"<\/span><span class=\"p\">)<\/span>\r\n<span class=\"k\">end<\/span>\r\n<\/code><\/pre>\n<p>\u5982\u679c\u8981\u907f\u514d\u8fd9\u4e2a\u95ee\u9898\uff0c\u5728\u6bcf\u6b21\u6267\u884c\u4e4b\u524d\u90fd\u8fdb\u884csleep\u53ef\u80fd\u662f\u4e00\u4e2a\u9009\u62e9\uff0c\u4f46\u8fd9\u6837\u505a\u5f88\u611a\u8822\uff0c\u6700\u597d\u4fee\u590d\u6709\u95ee\u9898\u7684\u90e8\u5206\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gd\">--- lib\/ruby\/gems\/2.0.0\/gems\/rdbi-driver-postgresql-0.9.2\/lib\/rdbi\/driver\/postgresql.rb.original    Fri 11 28 10:32:52 2014\r\n<\/span><span class=\"gi\">+++ lib\/ruby\/gems\/2.0.0\/gems\/rdbi-driver-postgresql-0.9.2\/lib\/rdbi\/driver\/postgresql.rb Fri 12 12 10:11:51 2014\r\n<\/span><span class=\"p\">@@ -175,9 +175,9 @@<\/span> class RDBI::Driver::PostgreSQL &lt; RDBI::Driver\r\n     end\r\n\r\n     def next_row\r\n<span class=\"gd\">-      val = @handle[@index].values\r\n<\/span><span class=\"gi\">+      val = self[@index]\r\n<\/span>       @index += 1\r\n<span class=\"gd\">-      fix_dates(val)\r\n<\/span><span class=\"gi\">+      val\r\n<\/span>     end\r\n\r\n     def result_count\r\n<span class=\"p\">@@ -189,11 +189,11 @@<\/span> class RDBI::Driver::PostgreSQL &lt; RDBI::Driver\r\n     end\r\n\r\n     def first\r\n<span class=\"gd\">-      fix_dates(@handle[0].values)\r\n<\/span><span class=\"gi\">+      self[0]\r\n<\/span>     end\r\n\r\n     def last\r\n<span class=\"gd\">-      fix_dates(@handle[-1].values)\r\n<\/span><span class=\"gi\">+      self[result_count-1]\r\n<\/span>     end\r\n\r\n     def rest\r\n<span class=\"p\">@@ -206,7 +206,7 @@<\/span> class RDBI::Driver::PostgreSQL &lt; RDBI::Driver\r\n     end\r\n\r\n     def [](index)\r\n<span class=\"gd\">-      fix_dates(@handle[index].values)\r\n<\/span><span class=\"gi\">+      fix_dates(fetch_range(index, index)[0])\r\n<\/span>     end\r\n\r\n     def last_row?\r\n<span class=\"p\">@@ -281,7 +281,7 @@<\/span> class RDBI::Driver::PostgreSQL &lt; RDBI::Driver\r\n\r\n     def initialize( query, dbh )\r\n       super( query, dbh )\r\n<span class=\"gd\">-      @stmt_name = ('stmt_' + Time.now.to_f.to_s).tr('.', '_')\r\n<\/span><span class=\"gi\">+      @stmt_name = ('stmt_' + self.object_id.to_s + Time.now.to_f.to_s).tr('.', '_')\r\n<\/span>\r\n       ep = Epoxy.new( query )\r\n       @index_map = ep.indexed_binds\r\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u4f7f\u7528RDBI\u6765\u66ff\u4ee3Ruby\/DBI \u603b\u7ed3 \u4ee5\u524d\u4e3b\u8981\u4f7f\u7528Ruby 1.8\uff0c\u4f46\u73b0\u5728\u60f3\u5f00\u59cb\u4f7f\u7528Ruby 2.0\u4e86\u3002  [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-42235","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u4f7f\u7528 RDBI \u4f5c\u4e3a\u66ff\u4ee3 Ruby\/DBI - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528-rdbi-\u4f5c\u4e3a\u66ff\u4ee3-ruby-dbi\u3002\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u4f7f\u7528 RDBI \u4f5c\u4e3a\u66ff\u4ee3 Ruby\/DBI\" \/>\n<meta property=\"og:description\" content=\"\u4f7f\u7528RDBI\u6765\u66ff\u4ee3Ruby\/DBI \u603b\u7ed3 \u4ee5\u524d\u4e3b\u8981\u4f7f\u7528Ruby 1.8\uff0c\u4f46\u73b0\u5728\u60f3\u5f00\u59cb\u4f7f\u7528Ruby 2.0\u4e86\u3002 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528-rdbi-\u4f5c\u4e3a\u66ff\u4ee3-ruby-dbi\u3002\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-20T03:04:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-03T17:39:47+00:00\" \/>\n<meta name=\"author\" content=\"\u6587, \u7fd4\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u6587, \u7fd4\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8-rdbi-%e4%bd%9c%e4%b8%ba%e6%9b%bf%e4%bb%a3-ruby-dbi%e3%80%82\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8-rdbi-%e4%bd%9c%e4%b8%ba%e6%9b%bf%e4%bb%a3-ruby-dbi%e3%80%82\/\",\"name\":\"\u4f7f\u7528 RDBI \u4f5c\u4e3a\u66ff\u4ee3 Ruby\/DBI - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-08-20T03:04:08+00:00\",\"dateModified\":\"2024-05-03T17:39:47+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8-rdbi-%e4%bd%9c%e4%b8%ba%e6%9b%bf%e4%bb%a3-ruby-dbi%e3%80%82\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8-rdbi-%e4%bd%9c%e4%b8%ba%e6%9b%bf%e4%bb%a3-ruby-dbi%e3%80%82\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8-rdbi-%e4%bd%9c%e4%b8%ba%e6%9b%bf%e4%bb%a3-ruby-dbi%e3%80%82\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u4f7f\u7528 RDBI \u4f5c\u4e3a\u66ff\u4ee3 Ruby\/DBI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c\",\"name\":\"\u6587, \u7fd4\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g\",\"caption\":\"\u6587, \u7fd4\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/wenxiang\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8-rdbi-%e4%bd%9c%e4%b8%ba%e6%9b%bf%e4%bb%a3-ruby-dbi%e3%80%82\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u4f7f\u7528 RDBI \u4f5c\u4e3a\u66ff\u4ee3 Ruby\/DBI - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528-rdbi-\u4f5c\u4e3a\u66ff\u4ee3-ruby-dbi\u3002\/","og_locale":"zh_CN","og_type":"article","og_title":"\u4f7f\u7528 RDBI \u4f5c\u4e3a\u66ff\u4ee3 Ruby\/DBI","og_description":"\u4f7f\u7528RDBI\u6765\u66ff\u4ee3Ruby\/DBI \u603b\u7ed3 \u4ee5\u524d\u4e3b\u8981\u4f7f\u7528Ruby 1.8\uff0c\u4f46\u73b0\u5728\u60f3\u5f00\u59cb\u4f7f\u7528Ruby 2.0\u4e86\u3002 [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528-rdbi-\u4f5c\u4e3a\u66ff\u4ee3-ruby-dbi\u3002\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-08-20T03:04:08+00:00","article_modified_time":"2024-05-03T17:39:47+00:00","author":"\u6587, \u7fd4","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u6587, \u7fd4","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"2 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8-rdbi-%e4%bd%9c%e4%b8%ba%e6%9b%bf%e4%bb%a3-ruby-dbi%e3%80%82\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8-rdbi-%e4%bd%9c%e4%b8%ba%e6%9b%bf%e4%bb%a3-ruby-dbi%e3%80%82\/","name":"\u4f7f\u7528 RDBI \u4f5c\u4e3a\u66ff\u4ee3 Ruby\/DBI - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-08-20T03:04:08+00:00","dateModified":"2024-05-03T17:39:47+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8-rdbi-%e4%bd%9c%e4%b8%ba%e6%9b%bf%e4%bb%a3-ruby-dbi%e3%80%82\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8-rdbi-%e4%bd%9c%e4%b8%ba%e6%9b%bf%e4%bb%a3-ruby-dbi%e3%80%82\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8-rdbi-%e4%bd%9c%e4%b8%ba%e6%9b%bf%e4%bb%a3-ruby-dbi%e3%80%82\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u4f7f\u7528 RDBI \u4f5c\u4e3a\u66ff\u4ee3 Ruby\/DBI"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/64d5cc7727fffbff2f9a2a8da1de3e5c","name":"\u6587, \u7fd4","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/920c3d673e0bccacc98e5e6b7149bb3c22edd8d39cb753e5d7d7e471498118a1?s=96&d=mm&r=g","caption":"\u6587, \u7fd4"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/wenxiang\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8-rdbi-%e4%bd%9c%e4%b8%ba%e6%9b%bf%e4%bb%a3-ruby-dbi%e3%80%82\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/42235","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=42235"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/42235\/revisions"}],"predecessor-version":[{"id":95339,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/42235\/revisions\/95339"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=42235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=42235"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=42235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}