Description

This project contains several packages that allows Ruby to communicate with Sybase SQL Anywhere

What is SQL Anywhere?

SQL Anywhere is a fully-transactional RDBMS with enterprise-caliber performance and features. It is available on a wide range of platforms including Linux, Windows, Solaris, OS X, AIX, and HP-UX. SQL Anywhere includes advanced features such as immediate refresh materialized views, dynamic cache sizing, snapshot isolation, built-in full text indexing, row-level locking, online backups, event scheduling, and remote data access to other RMDBS. It also includes a comprehensive set of tools that allow administration, modeling, debugging, monitoring, and profiling of the database. SQL Anywhere is over 15 years old, and has over 20 million deployed seats

The SQL Anywhere Web Edition is a free, full-featured version for development and deployment of browser-based applications.

Project Packages

There are three separate packages available in the SQL Anywhere for Ruby project.

SQL Anywhere Native Ruby Driver -- sqlanywhere

This package is a low-lever driver that allows Ruby code to interface with SQL Anywhere databases. This package provides a Ruby wrapping over the interface exposed by the SQL Anywhere C API. This package is written in C, and is available as source, or as pre-compiled gems for Windows and Linux. If you have rubygems installed, this package can be obtained with:

gem install sqlanywhere

SQL Anywhere ActiveRecord Adapter -- activerecord-sqlanywhere-adapter

This package is an adapter that allows ActiveRecord to communicate with SQL Anywhere. ActiveRecord is an object-relational mapper, popularized by being part of the Ruby on Rails. This package is written in pure ruby, and available in source, or gem format. This adapter uses (and has a dependency on) the sqlanywhere gem. If you have rubygems installed, this package can be obtained with:

gem install activerecord-sqlanywhere-adapter

SQL Anywhere Ruby-DBI Driver -- dbd-sqlanywhere

This package is a driver that allows Ruby/DBI to communicate with SQL Anywhere. Ruby/DBI is generic database interface modeled after Perl's popular DBI module. This package is written in pure ruby, and available in source, or gem format. This driver uses (and has a dependency on) the sqlanywhere gem. If you have rubygems installed, this package can be obtained with:

gem install dbd-sqlanywhere

License

All of the packages and their files are distributed under the terms of the Apache License, Version 2.0.

Feedback and Questions

For feedback on any of these packages, or for general questions about using SQL Anywhere in a web environment, please use the SQL Anywhere Web Development forum. For general questions on SQL Anywhere and its usage, please use the sybase.public.sqlanywhere.general newsgroup.