Is there ever reason to use string data type when using rails 6 with postgres database?

Question

I see here that :text data type seems to perform exactly the same as :string

This comment particularly:

PostgreSQL implementation prefers text. The only difference for pg string/text is constraint on length for string. No performance differences.

Is there any good reason to ever use :string when making a rails app using a postgresql database?

Siim Liiser · Accepted Answer · 2020-09-24 10:49:22Z

5

No difference in performance, difference in semantics.

Several libraries (for example simpleform) look at the data type of the field in the database and perform differently depending on it. Simple form will add a number input if it's a number, a checkbox if it's a boolean and so on. For this case, it will add a single line text field for string and a multiline text box for text.

Since there is no difference in performance, you can use either, but it's still useful to denote semantics.

answered Sep 24, 2020 at 10:49

Siim Liiser

4,58314 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

Is there ever reason to use string data type when using rails 6 with postgres database?

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