pev2 VS SVGcode

This runs in about 250ms. Let's have a look at the explain plan to understand it better. To visualise it, I am using the excellent visualisation tool from Dalibo.

The PEV2 is open source and give you a good visualization. I never used this pgmustard to compare.

https://explain.dalibo.com/

Visualize Your Plan: Visit explain.dalibo.com and paste the generated plan text and query. Then, hit Submit. The tool will generate a visualization of your query plan. Here's an example of the visualization for the fifth attempt version of the query from this post. It shows the different types of scans that were used and how the data gets combined. The duration of each operation is also shown:

You can download the whole analyzer as a simple html file and use it this way. No need to obfuscate or sanitize anything at all.

https://github.com/dalibo/pev2

You might be interested in sites like https://explain.dalibo.com/ which make the output a bit nicer to read. I use these quite often to quickly identify bottlenecks.

PostgreSQL Query Plan Analyzer and Visualizer

I didn’t know about pev2, interesting, checking it now. Did you integrate the component yourself or are you using this hosted page by them: https://explain.dalibo.com/?

IMO it‘s important to get started with indexing. Grab your most frequently used queries and run an EXPLAIN ANALYZE to identify the problems. This tool might help you to understand your execution plans. Once you identified your problems, you can build indexes and check again. Then you should regularly check if your indexes are used.

Raster Image to SVG Converter

here are some options -- potrace is free, or https://svgco.de/... there's also this extension that puts them in an a1111 extension. Illustrator also has a function for it, if you have access

Thanks to SVGCode (https://github.com/tomayac/SVGcode) which did already my idea to compile POTRACE into WebASM/JS so to get rid of exectuables and faster inbrowser-vectorizing (the guy in the input example image is Richard Feynman)

Oh op use this for png to svg conversion if you do not have better Ai or pro design tools. https://svgco.de

This issue was about experimenting with SVGCode to see if it could be used to convert raster images to SVGs. I blogged about this process in my last post. I created a pull request which demoed the results of my research by including several SVGs that I created using SVGCode, Adobe Illustrator and Inkscape. Overall, I think that Inkscape produced the most consistent results for coloured and black and white images compared to other tools I tried, which I mentioned in my PR.

In a previous post, I mentioned working on an issue for converting raster images to SVGs. This week, I did some research on the tool recommended in the issue, SVGCode, as well as other popular tools and in this post I will be discussing some of what I learned after trying them out. For the tools that I tried, I wanted to find something that is free and easy to use, while still creating high quality SVGs, as there are a lot of images to convert. (Disclaimer: I'm pretty new to working with images and image editing software so I'm probably not using all the right terminology here, but I'm trying to learn!)

Thanks for the kind words! The documentation is still missing (tracked in part as https://github.com/tomayac/SVGcode/issues/19), but Potrace, the library SVGcode is based upon, has detailed information in a PDF on all parameters: http://potrace.sourceforge.net/potracelib.pdf.