Official Docs links:
https://docs.nestjs.com/techniques/caching
https://docs.nestjs.com/techniques/caching#different-stores
Also add types
npm install --save-dev @types/cache-manager
-- Cleans up IPB 3 database before importing it into another forum engine | |
-- tbl_* are project specific, could be removed | |
-- Remove banned members and members with no posts | |
delete m | |
from ipb_members m | |
left join tbl_user u on u.id = m.member_id | |
where | |
( | |
member_banned = 1 |
<?php | |
/* | |
Directory traversal in PHP | |
see https://www.shellscript.sh/eg/directories/#traverse.sh (bash) | |
below one is in PHP 7.3 - Ubuntu | |
usage demo | |
1. cd <to ptrav.php> | |
2. $ php ptrav.php |
Official Docs links:
https://docs.nestjs.com/techniques/caching
https://docs.nestjs.com/techniques/caching#different-stores
Also add types
npm install --save-dev @types/cache-manager
Instructions:
Created view query is strangely different in the query.sql file that is generaed by pg_dump command. Original and simple one is shown in the blog
Download the query.sql file locally.
Find & replace pgsql username pgsql_user_name
with your actual one
Then import by command - $ psql -h localhost -d db -U pgsql_user_name -f query.sql