Skip to content

Instantly share code, notes, and snippets.

@srdi
srdi / queue.js
Created December 24, 2021 19:12
Queue instance example
const {Queue} = require('bullmq');
const sendQueue = new Queue('Send', { connection: '127.0.0.1'});
///...
// Add job to queue
sendQueue.add('send', { job: 'data' });
@srdi
srdi / worker.js
Created December 24, 2021 19:14
BullMQ worker example
const {Worker} = require('bullmq');
const worker = new Worker('Send', async job => {
const sendData = job.data;
//Send stuff
return something; // return is not required here, as we use async function.
}, {concurrency: 1, {connection: { host: '127.0.0.1' } }});
@srdi
srdi / queue-scheduler.js
Created December 24, 2021 19:16
BullMQ QueueScheduler example
const {QueueScheduler} = require('bullmq');
const sendScheduler = new QueueScheduler('Send', {connection: {host: '127.0.0.1' } });
@srdi
srdi / select-users.sql
Created December 24, 2021 19:20
Select users by id example
SELECT endpoint, auth, p256dh, ... FROM users WHERE id IN (...);
@srdi
srdi / select-users-ids.sql
Last active December 24, 2021 19:21
Select users id
SELECT id FROM users WHERE id > 0 AND country IN ('IN', 'ID'... ) AND subscription_timestamp < 1640210030 ORDER BY id LIMIT 100000;
@srdi
srdi / select-users-map.sql
Created December 24, 2021 19:22
Select from users map
SELECT id FROM users_map_IN WHERE id > 0 AND ts < 1640210030 LIMIT 100000;