pg version 0.13.0 has been released!
* <https://bitbucket.org/ged/ruby-pg>
Pg is the Ruby interface to the {PostgreSQL RDBMS}[http://www.postgresql.org/].
It works with {PostgreSQL 8.3 and later}[http://bit.ly/6AfPhm].
A small example usage:
#!/usr/bin/env ruby
require 'pg'
# Output a table of current connections to the DB
conn = PG.connect( dbname: 'sales' )
conn.exec( "SELECT * FROM pg_stat_activity" ) do |result|
puts " PID | User | Query"
result.each do |row|
puts " %7d | %-16s | %s " %
row.values_at('procpid', 'usename', 'current_query')
end
end
In the near future, I'll also be pushing out new versions of the 'ruby-pg' and 'postgres' gems which point people to 'pg', as the alternative names are confusing and contain code that hasn't been touched in 4+ years. People with dependencies on the existing code will, of course, continue to be able to install and use the old versions.
Changes:
## v0.13.0 [] Michael Granger <ged@FaerieMUD.org>
Reorganization of modules/classes to be better Ruby citizens (with backward-compatible aliases):
- Created toplevel namespace 'PG' to correspond with the gem name.
- Renamed PGconn to PG::Connection (with ::PGconn alias)
- Renamed PGresult to PG::Result (with ::PGresult alias)
- Renamed PGError to PG::Error (with ::PGError alias)
- Declare all constants inside PG::Constants, then include them in
PG::Connection and PG::Result for backward-compatibility, and
in PG for convenience.
- Split the extension source up by class/module.
- Removed old compatibility code for PostgreSQL versions < 8.3
Documentation:
- Clarified licensing, updated to Ruby 1.9's license.
- Merged authors list, added some missing people to the Contributor's
list.
- Cleaned up the sample/ directory
- Making contact info a bit clearer, link to the Google+ page and
the mailing list
Enhancements:
- Added a convenience method: PG.connect -> PG::Connection.new
Bugfixes:
- Fixed LATIN5-LATIN10 Postgres<->Ruby encoding conversions
···
--
Michael Granger <ged@FaerieMUD.org>
Rubymage, Architect, Believer
The FaerieMUD Consortium <http://FaerieMUD.org/>