Download images - database.sqlite more than 400MB n8n Desktop

Questions
, , ,
1

Hey,
I’d like to extract from html file some url to download.
But I cannot extract them and save them into a folder.
I am using n8n Desktop and the database is increasing after each run.
And also , I’d like to save the file with a the index of the item in the array .
here the html file content

<div class="listePageIn svelte-1typfm2"><div class="thumbnail svelte-1typfm2 active"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/99e28a052dc48fc7222e5d82f8c3d546?g=100x200" alt="page 1" title="page 1" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/632b69426d92600be97e2013966739c0?g=100x200" alt="page 2" title="page 2" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/0f9c92eacda1ddd1c74bb4d709a77c7d?g=100x200" alt="page 3" title="page 3" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/f4991a06ce3a6550a83e10461d190df7?g=100x200" alt="page 4" title="page 4" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/a2e6a160851850cb855e82547c4200ce?g=100x200" alt="page 5" title="page 5" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/a245fcd41eb25e487f2997f2e63bc48f?g=100x200" alt="page 6" title="page 6" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/6e923a895f46408fe995eb9f407133c1?g=100x200" alt="page 7" title="page 7" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/5b99c2081153d4df21ba3d8f259af65d?g=100x200" alt="page 8" title="page 8" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/c8324e03dee4fd9a3c67a2ce17794fd1?g=100x200" alt="page 9" title="page 9" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/568f377904b9c8eddcbcf335945ed5d9?g=100x200" alt="page 10" title="page 10" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/389c214c3c5046891eaa9384aced81f6?g=100x200" alt="page 11" title="page 11" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/0e9e0b26e342a0b5cd3c8d16f2a39471?g=100x200" alt="page 12" title="page 12" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/a525e12aaf60bf5f5cba9e1d35bfb464?g=100x200" alt="page 13" title="page 13" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/a71896f06edfeedc83ed9afb2de1a4e1?g=100x200" alt="page 14" title="page 14" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/7406f08cd0072f4e1084f1e6b7202a54?g=100x200" alt="page 15" title="page 15" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/c7027b6d770b7d355ca62b6203d93f59?g=100x200" alt="page 16" title="page 16" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/6f97bb15707e52b62d16d3d2dd618e73?g=100x200" alt="page 17" title="page 17" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/3496729be0a6e6b15f51dc7c2374b022?g=100x200" alt="page 18" title="page 18" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/f0ea3bcb5af918685da4b9e9203bcbd2?g=100x200" alt="page 19" title="page 19" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/376d0ca45653a11c82e6cc28c36ee27e?g=100x200" alt="page 20" title="page 20" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/75419598a17c69e9ef61fbb469548464?g=100x200" alt="page 21" title="page 21" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/7b610f9ffd2f048e47680f03eacbc919?g=100x200" alt="page 22" title="page 22" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/533437720d98d531a70f0f1d9e8de9fd?g=100x200" alt="page 23" title="page 23" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/73cdc21bdb89b694db1fa0a8a801e9f8?g=100x200" alt="page 24" title="page 24" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/5762a2e438f1abf0bbf47287a4833a80?g=100x200" alt="page 25" title="page 25" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/2e5f8ce51ec184d07b65dbff7dfaa021?g=100x200" alt="page 26" title="page 26" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/81c7f82bdbe563b86c6ab3ccb9b0b546?g=100x200" alt="page 27" title="page 27" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/5d56ae5fd274d6cbf3f31a4bd5423dce?g=100x200" alt="page 28" title="page 28" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/9a05a31a5d5de46b9f7a87539199c0dd?g=100x200" alt="page 29" title="page 29" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/bb134f69d3421a42b9c6a09c98205d26?g=100x200" alt="page 30" title="page 30" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/d87400603ae44f9b233295e118834b34?g=100x200" alt="page 31" title="page 31" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/0d892913c77c379bdc1aa6ea5ee97c83?g=100x200" alt="page 32" title="page 32" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/02956adfaf8414e58ae99713dd51f896?g=100x200" alt="page 33" title="page 33" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/9ef1ae3329fea69626c8080a3e014443?g=100x200" alt="page 34" title="page 34" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/06857cee1c74e575ae37aebbaca98ebb?g=100x200" alt="page 35" title="page 35" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/398c16f6fd71051827dc7b5cafbd4f98?g=100x200" alt="page 36" title="page 36" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/faf104bd34218f3787af9ab3fcae8f09?g=100x200" alt="page 37" title="page 37" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/d0a0cab68132318fb107c6a8e5f59ea9?g=100x200" alt="page 38" title="page 38" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/bc3e69678a94a44f41b83266692b9615?g=100x200" alt="page 39" title="page 39" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/64eb387b6c03f9aa8e76063fa43aff2f?g=100x200" alt="page 40" title="page 40" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/e72dbd1e059ed8c65e508409b0c0686d?g=100x200" alt="page 41" title="page 41" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/2e6e317b4b8a302826d5b0ffe114c434?g=100x200" alt="page 42" title="page 42" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/22e58a76d65283af90df8c645d078f52?g=100x200" alt="page 43" title="page 43" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/f67079c34005e76ea4966bbabc1d5123?g=100x200" alt="page 44" title="page 44" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/b519140b26b041e92e9b884b724536ee?g=100x200" alt="page 45" title="page 45" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/306c465fc6961f0dcdd51682e27a5213?g=100x200" alt="page 46" title="page 46" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/212ee216d22715bccfa4bb8a3cc06652?g=100x200" alt="page 47" title="page 47" class="svelte-1typfm2"></div> </div><div class="thumbnail svelte-1typfm2"><div><img src="https://nos-catalogues-promos-v2.e.leclerc/media/bbcc9eb97766c07142cff2ff415f33a2?g=100x200" alt="page 48" title="page 48" class="svelte-1typfm2"></div> </div></div>
2

Hey @tiger360, I am sorry to hear you’re having trouble.

The database growth will most likely be because you are saving the execution data for your workflow. You could avoid saving execution data by adjusting the respective workflow settings:

image
image1163×714 43.4 KB

If you want to keep your workflow data you might want to enable the pruning option described in our documentation (seeing you a re using the default SQLite database make sure to also set DB_SQLITE_VACUUM_ON_STARTUP=true as mentioned in the Keep in mind box):

On n8n.desktop, the environment variables are configured through the n8n-desktop.env file in the .n8n folder of your user directory.

But I cannot extract them and save them into a folder.

I took your workflow and adjusted it so it matches paths on my local filesystem:

This was working fine and after running the workflow I have 48 files in the target folder:

image
image1718×926 150 KB

The one additional change I needed to implement was the path in the Write Binary file node, the last slash would need to be a forward one to work as expected:

Was this by any chance the problem you were facing? If not, could you confirm which error exactly you are seeing?

1 Like
3

Thank you very much,
yeah the problem was this freaking “/” at the end :sweat_smile:
For the saving of execution data, you mean that even when I download images from a node, it’s stored in the database, in my case: sqlite ?

4

Glad to hear this helps! And yes, your execution data is persisted in the database by default.

1 Like