Rails 7 and MySQL 8 support JSON fields. Migrations support them. I have been using a combination of raw MySQL and other techniques to extract data. What's the proper ActiveRecord way of searching...

Joseph

Before using the Geocoding service in the Maps JavaScript API, first ensure that the Geocoding API is enabled in the Google Cloud Console, in the same project you set up for the Maps JavaScript API...

ammys09

I have a user model and around 1milion user records in my database and I'm using ILIKE to match the users by name or email. Sometimes it's very slow since I have a lot of records in my DB so I'm lo...

Denis Omerovic

I'm mostly interested for MySQL and PostgreSQL. Do you know of some good ones, maybe not too expensive and compatible with the new mac?

Gabriela Jack

What is the username and password for the Postgresql database?

Haig Douglas

I have built a drilldown type screen in an application I am working on and the way I set it up initially is super inefficient and causes really slow load times. The over all concept is we are displ...

RJ McCollam

I cannot for the life of me figure this out. I'm using the Algolia search API along with the Algolia gem, but I didn't set it up in the app I'm working on. The Algolia search is attached to my Proj...

Liam

I have a rails app. And of course, the development database is different from the prod database but the code is the same. So now I downloaded the prod database and I want to add it to the developme...

Houssein abil

Thanks Chris! Your comment just confirmed my thoughts :-) yes was rather complex to deal with the serialized params stored in Redis. I could though do what you said of just storing just product id ...

Eduard Garcia

I have a project in rails which worked with SQLITE3. I have to move out to POSTGRES, because Heroku needs to. **Following the docs: https://devcenter.heroku.com/articles/sqlite3#running-rails-on-p...

cratag

Hey Amanda! That is a fun challenge to solve. I wouldn't add that many columns to the table as that would get real tricky to manage. I like the idea of doing a new table, that could work well. T...

Chris Oliver

You can run `rails db:migrate` to run all the migrations in the `db/migrate` folder. That will make sure all your database tables are created. It won't restore any data, just the tables and columns...

Chris Oliver

This might be late but I had the same error. First place to look at was in the environment variables. nano /home/deploy/myapp/.rbenv-vars

Thuba Mamba

Try this on your database.yml: default: &default adapter: mysql2 username: root password: socket: /tmp/mysql.sock Mysql usually come with auth_socket as default authentication plugin,...

Elvis Serrão

I now have Postgres running on my local machine nicely. My issue now is i can't run a migration due to the following error: `ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR: relation "d...

Tom Dringer

Dear experts, I have a rails application that I was running on production environment. The data upon interacting with application on browser was therefore added to the production database. I would...

Shivam Barthwal