Skip to content

Instantly share code, notes, and snippets.

View nikpros's full-sized avatar

Nikolay nikpros

  • Samokat.Tech
  • Moscow
View GitHub Profile
@nikpros
nikpros / index.js
Last active February 13, 2024 11:54
test task by Leroy Merlin Node.js
// Нужно разгрузить EventLoop выполняя тяжелую функцию heavyComputationFunction на большом кол-ве данных.
// P.S. попробовать реализовать по-блочное выполнение функции
const array2 = [...new Array(100000)].map(() => ({
...largeDataset,
}));
array2.forEach(data => {
heavyComputationFunction(data)
});
@nikpros
nikpros / index.js
Last active February 13, 2024 11:53
test task by Yandex/VK tech
queueCb(
[
'https://jsonplaceholder.typicode.com/posts/1',
'https://jsonplaceholder.typicode.com/posts/2',
'https://jsonplaceholder.typicode.com/posts/4',
'https://jsonplaceholder.typicode.com/posts/4',
'https://jsonplaceholder.typicode.com/posts',
'https://jsonplaceholder.typicode.com/posts/3',
'https://jsonplaceholder.typicode.com/posts/1',
],
@nikpros
nikpros / crontab-perm-denied.md
Created March 16, 2022 14:20 — forked from plembo/crontab-perm-denied.md
crontab says fopen: permission denied

When crontab gives fopen: permission denied error

While trying to open my user's crontab on Ubuntu, the system barked back:

$ crontab -l
crontabs/myuser/: fopen: Permission denied

This is due to improper permissions on crontab executable.

@nikpros
nikpros / sql
Last active August 25, 2021 07:32
SQL commands
mysql -u<user_name> -p<user_password> <db_name> - подключение к БД
SELECT
TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME
FROM
INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE
REFERENCED_TABLE_SCHEMA = '<db_name>' [AND
REFERENCED_TABLE_NAME = '<table_name>' ...] - просмотр всех CONSTRAINT таблиц(ы)