postgress

29 Nov How to run a Rails app in production mode locally with Puma

Posted at 18:49h in postgress, Rails by heridev 0 Comments

0 Likes

Sometimes, you need to debug an error with assets generation y/o in the context of production environment, for such cases, here, I'm sharing a few steps you can follow in order to run your Rails application in production mode. Prepare your https/ssl certificates: [shell] openssl req -x509 -sha256...

18 Mar How to save and query a JSONB column that contains an array of hashes

Posted at 19:03h in postgress by heridev 0 Comments

0 Likes

Have you used JSONB from Postgres recently? I'm not going to talk about it but I think it's pretty awesome and powerful, and I'm going to show some of my findings that I have made so far and actually was inspired by: https://www.reddit.com/r/PostgreSQL/comments/2u6ah3/how_to_use_json_to_recordset_on_json_stored_in_a/ Let's get...

19 Nov How to find the tables that have the maximum number of records in Heroku using postgress

Posted at 19:36h in heroku, hosting, postgress, spree by heridev 0 Comments

0 Likes

As you know there is a free plan in heroku.com and you can use only 10,000 rows in the database but sometimes your database exceeds those limits and you don't want to pay because the app installation in only for testing purposes. That is why you can use the following commands if you want to to search and find the tables that have the maximum number of records and be able to delete the ones that are not necessary for you

29 Nov How to run a Rails app in production mode locally with Puma

18 Mar How to save and query a JSONB column that contains an array of hashes

19 Nov How to find the tables that have the maximum number of records in Heroku using postgress

location

Drop me a message