I am getting the following error: ActiveRecord::StatementInvalid (PG::InsufficientPrivilege: ERROR: permission denied for relation users.. It is definitely a role issue but I am not sure what coul...

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...

Let's say you operate a library. You have so many patrons and so many books you need a Rails app and database to keep your sanity. The basic schema looks something like this: ```ruby create_tabl...

I’m not sure exactly how to word the functionality of what I’m trying to build but let to give it a shot here to see if someone has built or seen something similar I’m working on a web app that wi...

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...

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?

What is the username and password for the Postgresql database?

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...

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...

I wrote a custom validator for a model in my app, but when I try to access that model I get ``` LoadError: Unable to autoload constant Validators::LapseValidator, expected /home/lflores/Projects/c...

I have a calculator that takes yearly pension contributions into a hash. Therefore, everyone has a contribution lined up with a year. I don't want a database of dozens of years as one individuals c...

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...

Hi all! I'm currently working on a purchase order process that has several steps before the final checkout, pretty standard, adding products in the basket their quantity and finally asking for the ...

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...

Hi all, I need advice on what to do with an existing table on an existing app. Right now the table is used to store details about a property and its closing costs. Normally there are always a h...

hi there, quite a while ago I threw together a modest linguistic rails app demonstrating use of Russian 4-letter words in action based on ruby 2.3.3 which was deployed and worked online OK until th...

Hi I am working on deploying rails application to digital ocean everything is worked fine. just stuck on that final step: when I am runing `cap production deploy` I am getting > 01 PG::C...

Hello, I have problems with my connection to mysql and rails, when I access mysql through the terminal with the root user I have no problem, but when I do a db: create rails but I get the error tha...

Hi, So as i began a project earlier in the year, i decided to go full Docker for deployment. That was all good except debugging and stuff proved difficult so this weekend i decided to make the pro...

I'm trying to figure out the best way to setup relationships between models which allows users to publish saved content from multiple models. **ExampIe:** I have a **Post** model which allows use...