Author | Lightnews

How to optimize an existing MS Access database | Christophe Avonture

1 1 3

cavo789 🐳 @avonture.be · 2d

In the professional world, there are still #MSAccess databases everywhere, created by business users with little or no technical skills. The last time I was called in to help because the database was slow and under-optimized, I created a tutorial to enable users to optimize their other databases.

Speed up your slow Microsoft Access database with this step-by-step optimization guide. Learn to improve table structure, use indexes, optimize queries, and compact your database for better performanc...

MS Excel - Get the list of references used in your modules | Christophe Avonture

cavo789 🐳 @avonture.be · 7d

If you are or have been a #VBA programmer for Excel, here is a script that allows you to extract the code from modules as text files. The idea is to take a backup and send them to #GitHub, for example, for code versioning.

MS Excel - Get the list of references used in your modules

GitHub - NDXDeveloper/formation-docker: 🐳 Formation Docker - De débutant à intermédiaire | Guide progressif en français couvrant Docker Engine, Docker Compose, volumes, réseaux et bonnes pratiques | C...

cavo789 🐳 @avonture.be · 11d

J'ai survolé et ton travail est extrêmement impressionnant ainsi que fortement pédagogique. Bravo.

2

cavo789 🐳 @avonture.be · 11d

Je l'utilise depuis des années... pour tout ou presque. Super pour le repo, j'en ai fait la promo sur les réseaux sociaux

Reposted by cavo789 🐳

NDXDev @ndxdev.bsky.social · 12d

🐳 En train de créer une formation Docker complète – du niveau débutant à intermédiaire !

➡️ 12 chapitres progressifs
➡️ Compatible Windows & Ubuntu
➡️ 100% en français 🇫🇷

🔗 github.com/NDXDeveloper...

#Docker #DevOps #Container #OpenSource

🐳 Formation Docker - De débutant à intermédiaire | Guide progressif en français couvrant Docker Engine, Docker Compose, volumes, réseaux et bonnes pratiques | Compatible Windows & Ubuntu - NDXD...

github.com

1 1 5

cavo789 🐳 @avonture.be · 12d

J'adore Docker aussi je ne peux qu'applaudir une telle formation en français pour permettre à plus de monde de comprendre la révolution qu'il représente. Bravo et bonne continuation 👏

CaesiumCLT – Effortlessly compress your images right on your device | Christophe Avonture

cavo789 🐳 @avonture.be · 12d

Did you know the `tree` command in Linux ? Would be so great to be able to copy/paste into the md file and hop it's working

cavo789 🐳 @avonture.be · 14d

#CaesiumCLT is a Linux batch image optimization program. For my part, I foolishly used the png format to take screenshots, which were then included in my articles. Compressing and saving them in #webp format without any loss of quality resulted in a 90% gain in file size—huge!

Fast and efficient lossy/lossless image compression tool

One Docker Image for Production and Devcontainers - The Clean Way | Christophe Avonture

1 3

cavo789 🐳 @avonture.be · 21d

How should you structure your program to have a #Docker image for production and, when working locally, extend it with development tools (#devcontainer)?

In this article, let's see how to proceed. One image for the deployment and, locally, using VSCode and the devcontainer feature.

Learn how to design a Docker setup that delivers a secure, minimal production image while enabling effortless local development through VS Code Devcontainers with clean overrides and environment isola...

Linux - Take advantage of the number of CPUs you have; start concurrent jobs | Christophe Avonture

cavo789 🐳 @avonture.be · 24d

Can tasks be executed in parallel using a #linux #bash script? Yes! You can launch multiple processes, wait for them to finish, and start new ones. When you need to manage thousands of input files to, f.i., check data quality, process them, download them somewhere, this tip will boost your script.

Optimize your Bash scripts! Learn how to run concurrent jobs and leverage all your CPU cores using process IDs (pids), wait, and nproc to dramatically reduce execution time.

Linux - Using a progression bar in your script | Christophe Avonture

cavo789 🐳 @avonture.be · 24d

How to write a #progressbar in a #bash shell? In my use case, I need to download and process one or more zip, they'll contains one or till thousands of csv files. How to show the progression to the user? With a progress bar for sure; even in a #linux script.

Add a visual progression bar to your Bash scripts on Linux. This guide shows you how to easily implement a progress bar to track concurrent jobs, visualize progress, and improve your terminal user int...

Docker - How to group containers together | Christophe Avonture

cavo789 🐳 @avonture.be · 24d

When you launch several different tools with #Docker, you get several independent containers, meaning that with the Docker Desktop tool, you see them as if they were "files" (easy comparison). In my case, I like to group them by “folder”: my ‘tools’ in a “tools” folder. Can this be done with Docker?

Learn how to organize Docker containers into logical groups using compose.yaml for a cleaner workflow.

cavo789 🐳 @avonture.be · 28d

Deployed on my site since three weeks en avant-première. Works perfectly and nice animation.

A Docusaurus component that alerts readers the article is over a year old | Christophe Avonture

cavo789 🐳 @avonture.be · Oct 3

When a #Docusaurus technical blog post was written a year or more ago, perhaps some things are no longer entirely relevant; versions may have changed, a particular tool may generate a deprecation notice, or something else may have happened.

Let's display a banner to inform the reader.

Displays a warning banner when the page content is over a year old

cavo789 🐳 @avonture.be · Oct 2

Often, the only way to understand an extension is to test it live. With this new article, the wow factor is definitely there; you can play around and imagine what it would look like on your own site; nice!

Yoo-hoo, but who is this rock star? ;)

cavo789 🐳 @avonture.be · Sep 29

And to demand that you repair his site without delay. Immédiatement 😇

cavo789 🐳 @avonture.be · Sep 29

Blog upgraded, zero problem. I've plenty of custom React components / Remark plugins and no conflicts at all. Great work ! Thanks for the excellent work.

How I used Google Gemini Nano Banana on my blog | Christophe Avonture

cavo789 🐳 @avonture.be · Sep 29

Over the last few days, I've redone all the images on my blog using Google Nano Banana, where you can upload one or more images, ask it to isolate one or more characters, include one or more logos, etc. and generate a new image that uses the same style as the others. In short, it's incredibly easy.

How I used Google Gemini Nano Banana on my blog

Running a HTML site in seconds using Docker | Christophe Avonture

1 2

cavo789 🐳 @avonture.be · Sep 29

Learn how to start a HTML site with #Docker in just one CLI. Even using MS-DOS.

Running a HTML site in seconds using Docker

A component for showing code snippets in a Docusaurus blog | Christophe Avonture

cavo789 🐳 @avonture.be · Sep 24

#Docusaurus Build a dynamic #Snippet component that auto-updates code from your source files, ensuring your articles are always current and impactful.

Thanks to @docuxlab.com for his LogoIcon component.

Learn how to build a custom React component to embed dynamic code snippets in your Docusaurus blog for a more interactive reader experience.