How to handle booleans in a Rails app with both SQLite and PostgreSQL?

Question

I have a ruby on rails application where I am using SQLite for development and testing, and I am using PostgreSQL in production. How can I write queries that handle booleans in my models that can handle both cases? SQLite handles booleans by using 0 and 1 , and PostgreSQL uses t and f, which is causing my problems.

consider using the same database for both development and production, there is no reason not to really — house9
– house9, Commented Oct 15, 2013 at 15:46
Has ActiveRecord fixed its boolean brain damage with SQLite? SQLite certainly thinks that booleans are C-style numbers but ActiveRecord hasn't always done so with SQLite. Anyway, stop smashing your own head with a brick and start developing on top of PostgreSQL if that's what you're deploying on, building a non-trivial database-portable application is very difficult and no ORM will protect you from the subtle differences. — mu is too short
– mu is too short, Commented Oct 15, 2013 at 16:06

Benjamin Tan Wei Hao · Accepted Answer · 2013-10-15 15:28:46Z

2

Just use true/false. ActiveRecord will handle the rest.

So for example: Post.where(published: true)

answered Oct 15, 2013 at 15:28

Benjamin Tan Wei Hao

9,6723 gold badges34 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to handle booleans in a Rails app with both SQLite and PostgreSQL?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related