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
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
| <?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 |
| -- 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 |