Category: Draft

The draft section is a unique space where you can access raw ideas and fresh topics even before they are polished to perfection. Here, you’ll find quick thoughts, rough insights, and raw discussions about various tech-centric topics. The presentation might be a work in progress, but the value and knowledge they carry are worth exploring.

The draft section also allows us to gauge your interest, helping to fashion the blog in tune with your preferences. This area is about transparency, providing you a peek into work-in-progress contents. Explore, read on, and be part of the content evolution right from the drafting stage. With your input, we’re able to create more engaging and relevant content.

Google Spreadsheets Quick tips

Google Spreadsheets Tips & Tricks 1. Extract URL from an Hyperlink The formula use in D2 is =REGEXEXTRACT(FORMULATEXT(A2); C2)The Regex is (http.*)”;” 2. Import JSON data into your spreadsheets There is an article here that explique how to do https://medium.com/@paulgambill/how-to-import-json-data-into-google-spreadsheets-in-less-than-5-minutes-a3fede1a014a 3. Link data between 2 sheets Todo so you can use the formula =VLOOKUP(D2,List!A:B,2,0)

How to force response json format for GPT4

In the payload, we need to ask in the content to get a response in jsonand in the body of the api request we need to add “response_format”: { “type”: “json_object” } To be able to use the json format, the content send must include the notion of json. var request = require(‘request’); var options […]

I created a video avatar of me with heygen

Using the tool heygen, I was able to create this avatar. This is quite funny !I recorded a 30secondes videos in french to train an avatar. This is the result in english. The fun fact is that my voice is not so deep and I don’t speak english as good as on the video.

Split the audio track from a music with machine learning

docker run -v $(pwd)/output:/output -v $(pwd)/model:/model researchdeezer/spleeter separate -i input.mp3 -o /output -p spleeter:5stems

Upscale an image with an open source software

1. Method 1: Max image resolution enhancer Repository: https://github.com/IBM/MAX-Image-Resolution-Enhancer#1-build-the-model 1.1 Launch the server command: docker run -it -p 5000:5000 codait/max-image-resolution-enhancerThis create a local webserver on on url http://localhost:5000 Limitation: (Required) An image file (RGB/HWC).The ideal image size is 500×500 or smaller, and the best results are observed using a PNG image. Images with dimensions over 2000×2000 are not […]