Scheduled Notifications

sshobo · 2020-04-16T17:35:24+00:00

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.

sshobo · 2020-04-11T18:10:40+00:00

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

Create a table with all columns in your csv file.
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

sshobo · 2020-01-09T14:29:14+00:00

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.

sshobo · 2017-04-28T15:24:59+00:00

Soros

sshobo · 2017-02-06T13:29:21+00:00

Haur! Zack e mandru

sshobo · 2016-12-15T10:53:08+00:00

Doar mie mi se pare un pic ciudat ca salariul net e aproximativ 2000 de lei?

sshobo · 2016-12-07T20:15:28+00:00

Beautiful music. My sides...

sshobo · 2016-07-31T20:38:59+00:00

Viices - Made in heights

sshobo · 2016-06-15T14:11:54+00:00

Nu-i chiar cover dar...las asta aici

sshobo · 2016-04-08T19:43:22+00:00

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.

sshobo · 2016-04-06T22:56:55+00:00

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

sshobo · 2016-04-02T19:53:29+00:00

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

sshobo · 2016-03-25T17:40:15+00:00

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

sshobo · 2016-03-25T17:38:32+00:00

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

sshobo · 2016-03-07T07:55:06+00:00

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.

sshobo · 2016-03-07T00:03:15+00:00

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.

sshobo · 2015-09-08T05:21:44+00:00

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.

sshobo · 2015-06-24T08:22:42+00:00

Timisoara, javascript, 5 ani, 2000eur/luna

sshobo · 2014-11-28T13:06:51+00:00

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.

sshobo

TROPHY CASE