{"id":82224,"library":"postgres-pr","title":"Postgres PR","description":"A pure Ruby interface to PostgreSQL databases (version 7.4 and above) without native extensions.","status":"active","version":"0.7.0","language":"ruby","source_language":null,"source_url":null,"tags":["postgresql","database","sql","pure-ruby"],"install":[{"cmd":"gem install postgres-pr","lang":"bash","label":"gem install"},{"cmd":"# Gemfile\ngem 'postgres-pr', '~> 0.7.0'","lang":"ruby","label":"Gemfile"}],"dependencies":[],"imports":[{"symbol":"PostgresPR","correct":"require 'postgres-pr'"}],"quickstart":{"code":"require 'postgres-pr/connection'\n\nconn = PostgresPR::Connection.new('dbname=test', 'localhost', 5432)\nresult = conn.query(\"SELECT * FROM users\")\nresult.each do |row|\n  puts row.inspect\nend","lang":"ruby","description":"Connect to a PostgreSQL database and run a query"},"warnings":[{"fix":"Consider using the 'pg' gem for better performance in production.","message":"Pure Ruby implementation may be slower than native gems like pg.","severity":"gotcha","affected_versions":">= 0.7.0"}],"env_vars":null,"search_vec":"'7.4':11 'databas':9,18 'extens':16 'interfac':6 'nativ':15 'postgr':1 'postgresql':8,17 'pr':2 'pure':4,21 'pure-rubi':20 'rubi':5,22 'sql':19 'version':10 'without':14","created_at":"2026-06-19T05:14:53.050102+00:00","updated_at":"2026-06-19T05:14:53.050102+00:00","problems":[],"ecosystem":"rubygems","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":"http://postgres-pr.rubyforge.org","github":null,"docs":"http://www.rubydoc.info/gems/postgres-pr/","changelog":null,"pypi":null,"npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-19","next_check":"2026-12-16","install_tag":null}}