activerecord-cockroachdb-adapter
activerecord-cockroachdb-adapter copied to clipboard
cockroachdb
CockroachDB adapter for ActiveRecord.
```shell ❯ bundle show activerecord-cockroachdb-adapter /Users/some_user/.asdf/installs/ruby/3.1.1/lib/ruby/gems/3.1.0/gems/activerecord-cockroachdb-adapter-7.0.0 ❯ bundle show rails /Users/some_user/.asdf/installs/ruby/3.1.1/lib/ruby/gems/3.1.0/gems/rails-7.0.3.1 ❯ ruby -v ruby 3.1.1p18 (2022-02-18 revision 53f5fc4236) [arm64-darwin21] ❯ be rake db:create Created database 'some_app_development' PG::UndefinedObject: ERROR: unrecognized...
In our Rails app we use both Postgres and Cockroach at the same time with Rails 6 multi-database support. This adapter monkey patches `ActiveRecord::ConnectionAdapters::PostgreSQL::Column#serial?` in a way that causes the...
It isn't necessary to pin this gem anymore. The related commit 29175527605d58fd7f84b6cc2beb5096be0256ba from before already switches to the new constant layout.
This is default in github now, and many projects including rails have already done this.
Refs: cockroachdb/cockroach#68363 (`ConcurrentTransactionTest#test_transaction_isolation__read_committed`, first hit Aug 12) Setup a table: ``` CREATE TABLE "developers" ("id" bigserial primary key, "name" character varying, "first_name" character varying, "salary" int DEFAULT '70000', "firm_id" bigint,...
``` Error: ActiveRecord::PostgresqlConnectionTest#test_reset_with_transaction: ActiveRecord::StatementInvalid: PG::FeatureNotSupported: ERROR: unimplemented: the configuration setting "geqo" is not supported HINT: You have attempted to use a feature that is not yet implemented. Please check the...
``` Failure: PostgreSQLReferentialIntegrityTest#test_only_catch_active_record_errors_others_bubble_up [/Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/referential_integrity_test.rb:103]: ArgumentError expected but nothing was raised. bin/rails test Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/referential_integrity_test.rb:100 Failure: PostgreSQLReferentialIntegrityTest#test_should_reraise_invalid_foreign_key_exception_and_show_warning [/Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/referential_integrity_test.rb:58]: Expected /WARNING: Rails was not able to disable referential integrity/ to match "". bin/rails...
All tests fail because the setup is trying to create a table with an `hstore` column, and `hstore` is not a supported type in CockroachDB. See the [Contributing Guide](https://github.com/cockroachdb/activerecord-cockroachdb-adapter/blob/master/CONTRIBUTING.md#setup-and-running-tests) for...
``` Failure: PostgresqlRenameTableTest#test_renaming_a_table_also_renames_the_primary_key_index [/Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/rename_table_test.rb:18]: Expected: 1 Actual: 0 bin/rails test Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/rename_table_test.rb:16 ``` See the [Contributing Guide](https://github.com/cockroachdb/activerecord-cockroachdb-adapter/blob/master/CONTRIBUTING.md#setup-and-running-tests) for instructions on running tests. If the test isn't valid against CockroachDB 1. Add...