adancso / ruby-informix Goto Github PK
View Code? Open in Web Editor NEWThis project forked from santana/ruby-informix
Ruby library for IBM Informix
Home Page: http://ruby-informix.rubyforge.org
License: Other
This project forked from santana/ruby-informix
Ruby library for IBM Informix
Home Page: http://ruby-informix.rubyforge.org
License: Other
= Ruby/Informix -- Ruby library for connecting to IBM Informix. = This fork should compile on Mac OS 10.10 (clang) with Ruby 2.2. == Motivation The situation that started it all [link][http://santanatechnotes.blogspot.com/2006/03/informix-driver-for-ruby.html]. == Download The latest version of Ruby/Informix can be found at: http://rubyforge.org/projects/ruby-informix == Supported platforms Ruby/Informix has been tested succesfully with Informix 7 and above, and Informix CSDK 2.81 and above, on the following platforms: Operating System Architecture ----------------------------------------- Solaris SPARC64 Mac OS X x86-64 GNU/Linux x86, x86-64 Windows XP/2000 x86 HP-UX 11.11 PA-RISC 2.0 64-bit Send me an e-mail if you have [un]succesfully tested Ruby/Informix on another platform. == Installation === Requirements * Informix CSDK 2.81 or above If you want to build Ruby/Informix instead of installing a precompiled gem, you will also need: * Microsoft Visual Studio 6.0, for Windows or * an ANSI C compiler, for UNIX and Linux === Rubygem installation gem install ruby-informix == Documentation RDoc and ri documentation is automatically installed. It can also be found online at: http://ruby-informix.rubyforge.org/doc == Examples === Connecting to a database db = Informix.connect('stores') === Traversing a table db.foreach('select * from stock') do |r| # do something with the record end === Fetching all records from a table records = db.cursor('select * from stock') do |cur| cur.open cur.fetch_all end === Inserting records stmt = db.prepare('insert into state values(?, ?)') stmt.execute('CA', 'California') stmt.call('NM', 'New Mexico') stmt['TX', 'Texas'] === Iterating over a table using a hash (shortcut) db.foreach_hash('select * from customers') do |cust| puts "#{cust['firstname']} #{cust['lastname']}" end More examples can be found at: http://ruby-informix.rubyforge.org/examples.html == Data types supported Informix Ruby ----------------------------------------------------------------------------- SMALLINT, INT, INT8, FLOAT, Numeric SERIAL, SERIAL8 CHAR, NCHAR, VARCHAR, NVARCHAR String DATE Date DATETIME Time INTERVAL Informix::IntervalYTM, Informix::IntervalDTS DECIMAL, MONEY BigDecimal BOOL TrueClass, FalseClass BYTE, TEXT StringIO, String CLOB, BLOB Informix::Slob NULL values can be inserted and are retrieved as +nil+. Any IO-like object that provides a read method, e.g. StringIO or File objects, can be used to insert data in BYTE or TEXT fields. Data retrieved from BYTE and TEXT fields are stored in String objects. Strings can be used where Informix accepts them for non-character data types, like DATE, DATETIME, INTERVAL, BOOL, DECIMAL and MONEY == Recommendations * Use blocks to release Informix resources automatically as soon as possible. Alternatively, use #free. * You can optimize cursor execution by changing the size of fetch and insert buffers, setting the environment variable FET_BUF_SIZE to up to 32767. == Support Feel free to send me bug reports, feature requests, comments, patches or questions directly to my mailbox or the following forums: * Online forums at Rubyforge [link][http://rubyforge.org/forum/?group_id=1378] * Mailing list [link][http://rubyforge.org/mailman/listinfo/ruby-informix-misc] == Presentations and articles about Ruby/Informix * "Talking with Perl, PHP, Python, Ruby to IDS" [link][http://www.informix-zone.com/informix-script-dbapi], Eric Herber, The Informix Zone. * "Informix on Rails" [link][http://www.ibm.com/developerworks/blogs/page/gbowerman?entry=informix_on_rails], Guy Bowerman, IBM developerWorks Blogs: Informix Application Development. * "Ruby/Informix, and the Ruby Common client" [link][http://www.ibm.com/developerworks/blogs/page/gbowerman?entry=ruby_informix_and_the_ruby], Guy Bowerman, IBM developerWorks Blogs: Informix Application Development. * "Using IBM Informix Dynamic Server on Microsoft Windows, Part 6" [link][http://www.ibm.com/developerworks/offers/lp/demos/summary/usingids6.html], Akmal B. Chaudhri, IBM developerWorks: On demand demos. == License Ruby/Informix is available under the three-clause BSD license :include: COPYRIGHT
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.