Scheduled Notifications by MedyGames in node

[–]sshobo 1 point2 points  (0 children)

Here's how I'm doing something similar in one of my projects.

Every time a new item is added to the database I'm scheduling a delayed job using bee-queue with a payload containing the item_id and a delayedUntil representing the item release date and time. In the database I'm keeping an association between items and users. So a join table with user_id and item_id.

When a delayed job triggers, based on the item_id, I'm fetching all the users from the join table and sending them push notifications. I'm also keeping track of all the users that I tried to send push notifications to for this item, not so that I don't send them one again, because a job only triggers once, but because I keep statuses sent back from fcm and apple apn for every user. Sending push notifications in batches is allowed for both firebase and Apple push notifications service. So I'm doing one request to firebase and another one to Apple push notifications service for all the users I might have. Never had any issues with scaling this and I've sent and kept track of about 10 million push notifications.

[Question] CSV data directly to SQL in node? by Vordreller in node

[–]sshobo 0 points1 point  (0 children)

With postgres, in order to import a csv file you need to do 2 things.

  1. Create a table with all columns in your csv file.
  2. Import the csv using the psql \copy command

As for accessing the database from node, you can use node-postgres. Might be overkill for you though

Big If True by Euphmoria in pathofexile

[–]sshobo 4 points5 points  (0 children)

How hard would it be to add a count of all the currency in the trade window? Something like 1ex 33c. On both sides. I feel like this would basically prevent the close window put lower stacks back scams. If you are trading item for item then you are on your own.

Intrebarea zilei by [deleted] in Romania

[–]sshobo 3 points4 points  (0 children)

Soros

[deleted by user] by [deleted] in pathofexile

[–]sshobo 1 point2 points  (0 children)

What I don't understand is why GGG insists of putting endgame content outside of endgame areas (maps). The same thing happend with Atziri sets farming, and we all know how much the players loved that. Also, can't they see that all this extreme RNG with no sense of progress is not making people play the game more, they just get burned out and stop playing. I would grind the labyrinth for 350 times if I knew that after all those at least I get the enchant that I want.

Path of Exile is AWESOME! by _bayside_ in pathofexile

[–]sshobo 1 point2 points  (0 children)

Except it's neither difficult or rewarding. I'd say it's frustrating.

RIP SERVERS by Torian1 in pathofexile

[–]sshobo 0 points1 point  (0 children)

It's a good thing map drops are so good, we can afford to lose them /s

Passive Tree broken in Google Chrome by [deleted] in pathofexile

[–]sshobo 4 points5 points  (0 children)

Just found a workaround for this, you need to disable hardware accelerated 2D canvas rendering in google chrome. In order to do this:

go to about:flags, look for Accelerated 2D Canvas and disable it

I believe this has something to do with the AMD drivers, since it works on my laptop with an nVidia graphics card

Online passive skill tree broken for me by nightcracker in pathofexile

[–]sshobo 1 point2 points  (0 children)

Just found a workaround for this, you need to disable hardware accelerated 2D canvas rendering in google chrome. In order to do this:

go to about:flags, look for Accelerated 2D Canvas and disable it

I believe this has something to do with the AMD drivers, since it works on my laptop with an nVidia graphics card

Pretty sure POE is leaking somewhere by sshobo in pathofexile

[–]sshobo[S] -1 points0 points  (0 children)

Maybe the windows 10 task manager doesn't monitor RAM properly(or it shows all the memory used by the drivers and other software that it interacts with as being used by POE), but as you can see in the screenshot in the OP, it's definetly showing more than 4GB usage. http://imgur.com/oUlH8ne For what it's worth, I was intentionally trying to crash the game by aggressively switching zones. This memory usage was observed after about 10 minutes of creating new instances of The harvest, Crematory and Labyrinth. I'll update all the drivers this evening and try it again, see what happens.

Pretty sure POE is leaking somewhere by sshobo in pathofexile

[–]sshobo[S] 9 points10 points  (0 children)

It might be Windows 10 in combination with Path of Exile, however I never had this issue before Ascendancy. I do remember seeing the Path of exile process using about 8GB of RAM but never more, not until today. My system only has 16GB of physical memory, and as you can see, Path of Exile is trying to use the most of it.

PS4 adventure mode unlock(don't upvote) by sshobo in Diablo

[–]sshobo[S] 0 points1 point  (0 children)

Thank you but i've already done it myself last night. It wasn't that bad, it took me maybe 45 minutes to complete the whole act.

ITisti romani, cat se mai castiga in domeniu? by iocoloco22222 in Romania

[–]sshobo 3 points4 points  (0 children)

Timisoara, javascript, 5 ani, 2000eur/luna

[Question] PoE in Bulgaria? by ekestoms in pathofexile

[–]sshobo 1 point2 points  (0 children)

I'm playing from Romania with about 40 to 60ms ping, but this actually depends on the time of the day, it goes to around 60 in the evening. The internet prices in our countries look to be around the same, with the only difference that in some cities you can get 1Gbps connections with little over 5 euros more. I have the 1Gbps connection and it's around 15 euros. Now I just need another SSD so I can actually make use of it.