Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

storing more than 255 characters in a PostgreSQL DB on heroku

Tags:

sql

postgresql

ruby-on-rails

heroku

I am using heroku, and in doing so, am experiencing my first foray into postgresql. Maybe I just never came across it in development, but I am unable to save entries into my database that are longer than 255 characters. Is there a way around this? Currently the I am just using strings to store message data.

Secondly, if there is indeed a way to store more than 255 characters, is there a good way to convert my message strings into this form, using migrations? My app is currently live and in use.

Thanks!

like image 686
goddamnyouryan Avatar asked Nov 05 '10 02:11

goddamnyouryan

People also ask

What is the maximum size for a database in PostgreSQL?

PostgreSQL normally stores its table data in chunks of 8KB. The number of these blocks is limited to a 32-bit signed integer (just over two billion), giving a maximum table size of 16TB.

What is maximum length of character varying Postgres?

What is PostgreSQL Varchar datatype? In PostgreSQL, the Varchar data type is used to keep the character of infinite length. And it can hold a string with a maximum length of 65,535 bytes.

Is Heroku Postgres good?

Heroku Postgres is an easy, low-cost way to get started with a relational database on the Heroku platform. This open-source database is also the most effective service for developers looking to build engaging apps.

Does PostgreSQL support Heroku?

Heroku Postgres is a managed SQL database service provided directly by Heroku. You can access a Heroku Postgres database from any language with a PostgreSQL driver, including all languages officially supported by Heroku.

1 Answers

use text instead of string on your migration type.

To change a migration

  1. script/generate migration change_string_to_text
  2. change_column :model, :attribute, :text
  3. rake db:migrate
like image 54
thenengah Avatar answered Oct 18 '22 03:10

thenengah
Sign in to Comment

Related questions

How to fetch result from MySQL row with multiple same-name columns with PHP? [duplicate]
Is it possible to insert an entire VB.NET DataTable into a SQL Server at once
SQL most executed query?
Calling SQL Functions directly from C#
negative selection SQL Query
Filter Magento collection but not products, using distinct
SQL Function without input parameters
How to calculate the number of "Tuesdays" between two dates in TSQL?
How to join two tables in an UPDATE statement?
Doctrine2 using setParameters
How to sort by created_at column of association in rails?
A script to test existence of primary keys
Problems creating a full text index on a view
JSON_PRETTY_PRINT not working as expected when Content-Type is HTML
SQL - Query to find if a string contains part of the value in Column
why spring jdbcTemplate batchUpdate insert row by row
Select all columns with GROUP BY one column [duplicate]
SQL query to exclude records if it matches an entry in another table (such as holiday dates)
SQL Server for C# Programmers [closed]
SQL to have one specific record at the top, all others below

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!