DEV Community: adriens

💸 How $0 marketing budget boosted my creativity & automation opportunities

adriens — Wed, 11 Mar 2026 20:11:05 +0000

💡 Inception back in days

Years ago I watched the following Netflix series :

A look beyond blueprints and computers into the art and science of design, showcasing great designers from every discipline whose work shapes our world.

Then wrote a dedicated article :

How did Netflix put my heart & brain on fire with "Abstract: The Art of Design" S02

That brought me a lot of inspiration about :

The power of simple/pure designs
Importance of typography
How to manage color gradients
How a minimalist design opens opportunities
How playing with things makes us creative and productive (Cas Holman, founder of toy company)

⏳ About `geol` : the need for a logo

Then since last year we started to work on geol, and I started to feel the need to get a logo for example to :

Display in the terminal
Show up in youtube thumbnails
Give an identity to our website (we built one w. Docusaurus)

So I filled an issue... to fix later.

🎨 How low marketing skills and budget boosted my creativity

// Detect dark theme var iframe = document.getElementById('tweet-1992068608395276623-371'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1992068608395276623&theme=dark" }

🍿 Show me what it looks like

📝 Inception and paper/pen drafts

To build a logo, you need to focus on what your product does at its very core.
In my case, I came to the conclusion that there were two core things:

⏳ Pay a tribute to the data source : endoflife.date API
🚦 Colors which is the color identities, know when:
- 🟢 We're ok with a product,
- 🟠 When we should start to take care: time to plan
- 🔴 When it's too late: you're at risk

So finally, two dimensions :

📐 Shape
🎨 Colors

It started to trigger my curiosity about geometric considerations, which could hence be described thanks to mathematical objects, finally opening coding and automation opportunities.

I started to draw and draw a lot of shapes, think about how to put colors, the benefits of a simple geometrical/mathematical vectorial approach while enjoying a coffee cup outdoor seating at a café, drafting ideas and charts w. the paper/pen strategy :

// Detect dark theme var iframe = document.getElementById('tweet-2025338147153084787-874'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=2025338147153084787&theme=dark" }

☝️ Put more constraints to be more productive

I really love the pattern that consists of putting more rules to be more creative and just:

see what happens if...

Finally I got my own rules.

The logo should:

Be perfectly described with a few mathematical geometrical rules as possible (easier to code or to draw, even by a kid)
Give sense to colors and product lifecycle
Pay a tribute to its core meaning : the hourglass
Fun with graph datascience: it has to be both eulerian and hamiltoninan
Be as light as possible

🚀 Pure code and automation

Once I found the solution came the coding part:

Design the svg (and put placeholders inside them)
Create a Taskfile to automate a bunch of things (generate various formats from a single task command)
Inject colors with code and automation
Create automation tasks that build jpeg, png, animated & static gifs, webp, optimize jpeg... all built and delivered as output artefacts

So finally I came from a workflow on a paper to a fully automated makefile:

// Detect dark theme var iframe = document.getElementById('tweet-2030389652960710939-627'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=2030389652960710939&theme=dark" }

🖼️ Benefits : the `100%` LaTeX cheatsheet

As a benefit I could produce a 100% LateX version of the logo (see full demo)

// Detect dark theme var iframe = document.getElementById('tweet-1995616096351891548-543'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1995616096351891548&theme=dark" }

🔭 Further opportunities

What's exciting with a "simple logo" is that it makes it possible to use the mathematical vectorial description and inject it in many artistic artefacts

3d printing
Pixelart
T-Shirts
Code driven animations
Shaders
Desktop Wallpapers

Who knows where creativy will take us 🤗

🦈 Analyzing Open Data shark attacks with gemini-cli and Quarto 📊

adriens — Sat, 28 Feb 2026 06:55:37 +0000

This is a submission for the Built with Google Gemini: Writing Challenge

😂 Spoiler alert : what it was not

It was not a straight and peaceful journey

// Detect dark theme var iframe = document.getElementById('tweet-2027947601442836653-914'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=2027947601442836653&theme=dark" }

❔ What I Built with Google Gemini

I created a Quarto Notebook based on Open data (I maintain since many years now) that reports Shark attacks in New-Caledonia to better understand what happens since many years now.

I used Gemini-cli to :

Help implement the Notebook that I wanted to look a bit like a newspaper report
Give me some inspirations during chats
Ask him to challenge me with questions
Imagine an interview which gave me the opportunity to better express & share my ideas
Challenge me with new questions
Finally produce a journalistic like paper anyone can read and print
Finally put this pdf as input with other related articles data sources into NotebookLM to produce a video

Pretty fast, I could get first stuning dataviz :

// Detect dark theme var iframe = document.getElementById('tweet-2027632648970223954-188'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=2027632648970223954&theme=dark" }

🔥 Work planning (brain on fire)

Saturday 2026-02-28 : 07:00 AM to 18:30 PM
- First MVP
- Video demo
- NotebookLM video production
- First article version and publication
- First social posts to share the insights I discovered
Sunday 2026-03-01 07h00 AM - 10:30 & 13:00 - 15:00 :
- pdf finetuning, review and little enhancements
- Section title review
- Charts title review
- Take feedbacks and implement them
- Chase on keyfindings hallucinations with specific data-driven PROMPTs

🍿 Demos

The main output of the project is a pdf.

Yet, here is the full storytelling I'll use for educational purpose:

Long edition with pdf commenting

Short edition (for educational purposes)

📑 Resources

Source code : github.com/adriens/odata-ncl/data/shark-attacks
Final pdf report
NotebookLM project
Python SDK for water quality : adriens/edb-noumea
Ready to use csv data for water quality : edb-noumea-data, automated with Gh Actions
Go TUI to browser water quality from any terminal : edb-noumea-tui
Kaggle dataset : 🦈 Shark Attacks - New Caledonia
Kaggle Notebook : 🦈 Shark Attacks New-Caledonia for dummies
Kaggle Notebook : Shark Attacks in New Caledonia - Analysis
Kaggle Notebook : 🦈 Shark Attacks New-Caledonia KPIs

🧑‍🎓 What I Learned

Need to very seriouly & carefully review AI generated comment on charts as quite often for example the "Key findings" were wrong :
- Nor respect for the color code accross the whole document (fatal vs. non fatal attacks)
- Evaluating 59% as the 2/3 of the attacks
Put the terminal to a given level of transparency so I coul read the resulting pdf while chating with gemini-cli (I have a small laptop with single screen)
I could very efficently take other people feedbacks in account which had a huge impact on dataviz and KPIs to avoid bias

💡 Google Gemini Feedback

I only used Gemin-cli :

I really enjoyed being interviewed by Gemini, it really made me creative, it was the first time I did this, but for sure I will reuse this pattern

📸 Screenshots

Below a collection of the resulting pdf :

🦆Built a duckdb community extension for brew

adriens — Sat, 14 Feb 2026 03:55:40 +0000

This is a submission for the GitHub Copilot CLI Challenge

🤓 What I Built

Sometimes ago I got asked to report what I installed on my Ubuntu... and like many people it turned out I installed various softwares in very various ways :

apt
snap
brew
pip or uv (but mostly in virtual environments)

Basically, at first I started with that kind of data-analysis and dataviz (and made it open source, see adriens/ubuntu-rmarkdown-report):

So I started to look around how I could efficiently automate that with standard data tools to make this work look like a piece of cake (avoid boilerplate R code in my case).

I then found the great osquery initiative, which makes it possible to query any operating system metric or information from a simple SQL :

osquery exposes an operating system as a high-performance relational database. This allows you to write SQL queries to explore operating system data. With osquery, SQL tables represent abstract concepts such as running processes, loaded kernel modules, open network connections, browser plugins, hardware events or file hashes.

But when I wanted to query installed brew packages, it turned out that I had to write an extension (which is very well documented).

So I finally opted to write a dedicated Rmarkdown notebook, started to play with custom dataframes (easy to share)... but pretty soon I felt like it would be much more convenient to be able to query this data within duckdb itself so it could make the data much much easier to get in various usecases (R, Python, Go, ... ).

💡 The idea : the `duckdb` extensions community

Therefore, I decided to build - and heopefully to get it accepted - a duckdb brew community extension so I can build reports on the installed homebrew packages from simple SQL and benefit from the amazing duckdb ecosystem and a very large amount of language bindings and data tools:

// Detect dark theme var iframe = document.getElementById('tweet-2016990414583321074-547'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=2016990414583321074&theme=dark" }

🍿 Demo

Official duckdb's brew DuckDB CE extension's page.

Below the whole story, from the function table concept in various databases, to the pitch, including the developer experience with Copilot CLI:

📷 Screenshots

📈 Historical brew install

When doing reports, I felt the need to know how many brew packages I installed, and when:

🌌 Graph Dependencies

For security analysis, it makes sense to be aware of the centrality of the installed software.

It is now made easy to produce and chart, see below:

🐧 `SQL` reports from terminal

Then it's really very easy to do reports from the terminal itself:

🤓 My Experience with GitHub Copilot CLI

Below my complete development workflow setup, which consists in three panels :

The top left one : to run make commands by myself, which made things easier to handle
The bottom left one : the GH Copilot CLI to which I asked to add features, write nice commit messages, check CI for failures, write Release Notes, create tags and releases
The right one : dedicated to try the output binary by myself, purely manual written SQL statements etc...

This how it looks::

Video announce :

// Detect dark theme var iframe = document.getElementById('tweet-2019167438546563160-961'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=2019167438546563160&theme=dark" }

👨‍🎓 Lesson learned : `CI`, tests and lint first

The CLI experience is very responsive, but what I would keep in mind and would like to put the maximum emphasis is how crucial are about build automation and CI :

Tests
Linting process
Code formating rules

The more they are part of the build tools and CI pipeline, the more the vibe coding experience is efficent and the more we build trust with the generated code.

In my case, duckdb community provided a repo template (see duckdb/extension-template) with all the required stuff so I could very efficiently start to work, which means : get continuous feedback from CI and give it immediately to Copilot for continuous improvement without having to ask help to community.

📑 Resources

Extension source code : adriens/duckdb-brew
duckdb brew extension homepage : https://duckdb.org/community_extensions/extensions/brew
adriens/ubuntu-rmarkdown-report

⏳ Managing EOLs w. geol: the impossible 1' Mux demo

adriens — Fri, 02 Jan 2026 21:53:35 +0000

This is a submission for the DEV's Worldwide Show and Tell Challenge Presented by Mux

❔ What I Built

We have built and maintain geol a cli to help manage, report and survey software EOLs (end-of-life), both for:

Interactive cli UX
Automates DEVOPS CI/CD pipelines

See below for previous Hacktoberfest hackathon :

Hacktoberfest: Maintainer Spotlight

adriens

Oct 29 '25

⏳geol, the cli to efficiently manage EOLs like a boss

#devchallenge #hacktoberfest #opensource #devops

Comments 29

3 min read

⏱️ My `1'` Pitch Video

📑 Demo

🤓 Project repository : opt-nc/geol
🍿 Youtube playlist : geol playlist
🗓️ Product Kanban

💭 The Story Behind It

Since a long time now (December 2022), I started to work on following software technical debt, security, ... at scale with:

DEVOPS in mind
Datascience & dataengineering
Datavisualizations
DEVSECOPS

Then I discovered endoflife.date website, its API.
Since that day, I contributed almost 200 PRs to add/enhance products.

Also, on a daily basis, I used hugovk/norwegianblue (aka. eol) to efficiently browse products end of lifes, for example with markdown to efficiently produce Github issues of html reports:

adriens

Dec 14 '22

⌛ Manage EoLs like a boss with endoflife.date 🛑

#showdev #security #api #opensource

Comments 14

3 min read

Then, years later I wondered what if I could try to push it harder and build a brand new Go based version of eol,... which I did during a 48h hours hackathon :

adriens

Jan 11 '25

⏳GitHub Copilot 1-Day Build Challenge : eol, a tiny Go client to manage eols

#devchallenge #githubchallenge #ai #go

Comments 9

2 min read

The result was pretty nice, I like the feeling... especially :

The "Eat your own dog food approach" (aka. Dogfeeding)
Freedom to design a brand new client, with a dedicated UX
Remove the need for Python runtime
Try some exciting new ideas
Improve productivity and talk about technical debt around me

Finally we officially created geol :

Hacktoberfest: Maintainer Spotlight

adriens

Oct 29 '25

⏳geol, the cli to efficiently manage EOLs like a boss

#devchallenge #hacktoberfest #opensource #devops

Comments 29

3 min read

⚙️ Technical Highlights

We wanted to learn as much and take as much profit as possible from Go ecosystem, to adopt the same stack of some tools we love - and admire - to use on a daily basis :

Language : Golang
Delivery : brew to deliver/install efficiently as fast - and yet secure - as we want
Release Management : goreleaser/goreleaser
spf13/cobra for CLI
charmbracelet/fang on top of Cobra to give glamour to our cli
charmbracelet/lipgloss for styish terminal outputs : colors, arrays, links, markdown display and redirection t files
duckdb as primary export format
osv.dev to continuously check for vulnerabilities in our base code
Code QL as part of our CI to ensure our tool does not bring security issues
Docusaurus for nice professional website (work in progress)
crush and gemini-cli to evaluate the design of our cli
pandoc for document post-processing (eg. transform output markdown into html or pdf...)
LaTeX to build the cheetsheat
The way we an put together geol and trivy (with crush or gemini-cli) at work together to build efficient and nice looking technical debt and security reports
distrobox to test install and binaries on various OS and architectures
Now, I'm starting to focus on what can be done around geol outputs to automate reporting, with a professional data-stack, like Rmarkdown or quarto to make professional looking technical debt reports
Also, I'm thinking about the most efficient way to share EOL's datas into other systems to make technical debt easier to monitor

🐦 Some Tweets showcasing what's achieved and how

`distrobox`

// Detect dark theme var iframe = document.getElementById('tweet-1987002052460106151-227'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1987002052460106151&theme=dark" }

Putting `geol`, `trivy`, `gemini` & `latex` to work

// Detect dark theme var iframe = document.getElementById('tweet-1989079778058727889-94'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1989079778058727889&theme=dark" }

Building cheetsheat with pure code w. `LaTeX`

// Detect dark theme var iframe = document.getElementById('tweet-1995616096351891548-967'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1995616096351891548&theme=dark" }

Build a website with `docusaurus`

// Detect dark theme var iframe = document.getElementById('tweet-2005772435057242580-559'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=2005772435057242580&theme=dark" }

⏳geol, the cli to efficiently manage EOLs like a boss

adriens — Wed, 29 Oct 2025 20:39:59 +0000

This is a submission for the 2025 Hacktoberfest Writing Challenge: Maintainer Spotlight

⏱️ `geol` in `5'` for impatients

🤗 Building ideas & patterns before software

First of all, I would like to point what makes my core motivation & energy last, what keeps me in movement : my curiosity.
I only understood recently that this is curiosity and the satisfaction we get once got answers that (from my POV) makes things possible.

Of course we are building software or products, but first, I want to focus on creating and experimenting news ways of viewing problems that affect us and prototype new ways of fixing issues (regardless of programming languages or technologies) or rewiring known problems, then share these techniques and POVs with others to confront perspectives.

Nothing excites me more that seeing the solution come to life, talk with my teammates about how to tweak an output, what to remove until we get something really useful and pleasant.

Some call this being nerd... I don't care but what I enjoy the most is talking about software engineering, DEVOPS and architecture while enjoying a coffee, drawing something on a paper, challenging perspectives and make it happen on a schedule, at a regular pace... and gain experience.

💭 About the core idea

Back in time time in January, I submitted a first try to porting eol to a golang stack :

adriens

Jan 11 '25

⏳GitHub Copilot 1-Day Build Challenge : eol, a tiny Go client to manage eols

#devchallenge #githubchallenge #ai #go

Comments 9

2 min read

Also I previously talked - a lot - about these data and why it matters:

// Detect dark theme var iframe = document.getElementById('tweet-1968410713480733162-629'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1968410713480733162&theme=dark" }

I wanted to push ~~a bit~~ much further around around stack lifecycle management and bring DEVOPS,DEVSECOPS and SECOPS to the front and imagine complementary practices to automate things around that.

After a paper and pen ideation session :

// Detect dark theme var iframe = document.getElementById('tweet-1974974775836754362-138'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1974974775836754362&theme=dark" }

I finally opted for a full unboxing video that would focus on the MVP, from start to end.

🍿 Unboxing demo

🧑‍🤝‍🧑 Team mates

Innovation is much more interesting when it's achieved with other people, below the core team:

👨 Adrien : adriens
👨 Vinh : supervinh
👱🏻‍♀️ Michèle : mbarre

🎯 Our `MVP`

I designed a MVP milestone to be sure to be ready to deliver for D-day and at last deliver the demo:

📢 Tell the world `geol` exists #4

adriens posted on Aug 10, 2025

🎯 DoD

[ ] Write a dedicated article
[ ] Create an unboxing video
[ ] Tweet
[ ] linkedIn
[ ] Add as a contribution to https://github.com/endoflife-date/endoflife.date

View on GitHub

🤩 What we learned and techniques we developed on the journey

🧰 Stack

Charmbracelet
charmbracelet/fang "The CLI starter kit"
charmbracelet/lipgloss "Style definitions for nice terminal layouts 👄"
Cobra
gemini-cli
charmbracelet/crush "The glamourous AI coding agent for your favourite terminal 💘"
GoReleaser
go-task/task
pandoc
asciidoctor
fish-shell/fish-shell "The user-friendly command line shell."
aquasecurity/trivy "Find vulnerabilities, misconfigurations, secrets, SBOM in containers, Kubernetes, code repositories, clouds and more"

➿ `cli` design tuning with AI

I used gemini-cli and crush to continuously evaluate & improve the design of our cli : which command to add, examples to provide, better options, option names, sub-commands layouts,...

👉 Our goal was to achieve zero-prompts answers, eg. :

// Detect dark theme var iframe = document.getElementById('tweet-1970676017556865268-411'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1970676017556865268&theme=dark" }

Ask the agent "learn to use geol thanks to man pages" (it appeared than, after benchmarking, man was the best option)
Challenge the assistant to produce new kind of documents, for example with the help of third parties cli like trivy or grype

📰 Original report productions

I challenged geol and trivy as data producers, gemini-cli as thinker to efficiently produce LaTeX some original reports pretty easily and share them:

// Detect dark theme var iframe = document.getElementById('tweet-1971740458331394521-740'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1971740458331394521&theme=dark" }

🔭 Further ideas

Below some features to be implemented that excites us a lot:

Stack survey : 🔔 Lock, warn & report watch stack 👀
Data exports : 📤 Add export and duckdb sub-command : geol export duckdb
Documentation export : design still in progress 😅 but preparing some cool work

🙌 Last words

This project makes us learn a lot about software packaging, distribution, make choice to be sure to deliver the most ~~important~~ useful features, also carefully not implement the things that should not be... and learn learn and learn about free software.

🛡️ Data quality, SQL, duckdb and http_client on CI🦆

adriens — Mon, 08 Sep 2025 04:02:44 +0000

💭 CI, `duckdb` et and data protection

To efficiently yet effortlessly manage data quality, we created a GitHub Action to install duckdb :

adriens for opt-nc

Jul 25 '23

🦆 Effortless Data Quality w/duckdb on GitHub ♾️

#duckdb #githubactions #data #automation

Comments 10

1 min read

... but recently I had to face an another challenge : as part of our CI, I had the need to validate data... that were relying on web resources.

I needed to be sure that a GitHub Account was really existing (for example to avoid typos) as part of our CI.

In this very short article, I'll show how to use DuckDB with the http_client extension to verify GitHub handles stored in a table, for example to lint data as part of a CI pipeline thanks to GitHub Duckdb Action... and do the job with a very simple SQL script and CHECK constraints.

🍿 For impatients

🔖 Resources

🕹️ Do the job with `SQL`

First install extension:

INSTALL http_client FROM community;
LOAD http_client;

Then create a table with some example data:

create or replace table person_gh_member
(
  sam_accountname varchar primary key,
  gh_member varchar not null
);

-- insert rows
INSERT INTO person_gh_member (sam_accountname, gh_member)
values
('adriens', 'adriens'), 
('jdoe', 'johndoe'), 
('asmith', 'annasmithRRRRR');

Finally, run a query to check the status of each GitHub handle:

create or replace view v_person_gh_status as
    select 
    sam_accountname,
    gh_member,
    'https://github.com/' || gh_member as gh_url,
    cast(http_get(gh_url).status as integer) as http_gh_status
    from person_gh_member;
    --where gh_status <> 200;

from v_person_gh_status;

Now, to lint, we can add a check to see if any status is not 200:

from v_person_gh_status
    where http_gh_status <> 200;

create or replace table lint_gh_handle(
    gh_handle varchar primary key,
    gh_url varchar not null unique check (gh_url like 'https://github.com/%'),
    gh_status integer check (gh_status = 200)
);

insert into lint_gh_handle(
            gh_handle,
            gh_url,
            gh_status)
select
    gh_member,
    'https://github.com/' || gh_member as gh_url,
    cast(http_get(gh_url).status as integer) as gh_status
from person_gh_member;

🎬 2025 UNC MIAGE démo finale

adriens — Sun, 18 May 2025 20:57:50 +0000

❔ Une video... pourquoi pas un rapport 🤔

// Detect dark theme var iframe = document.getElementById('tweet-1926774800480870459-727'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1926774800480870459&theme=dark" }

// Detect dark theme var iframe = document.getElementById('tweet-1915874203083149769-543'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1915874203083149769&theme=dark" }

📜 Règles de base

Teaser < 1' : que j'utiliserai pour faire les shorts YT pour pitcher votre travail (elevator pitch)
Rappeler le cadre qui a permis ces travaux (UNC/IAE, promotion,...)
Durée totale ≤ 20'
Format : horizontal (16:9), format MP4
Texte et liens vers les ressources démontrées (datasets, notebooks, repos,...)
Résumé (5 lignes max)
Pitch résumé format twitter
Nom du fichier : 2025_unc_miage_{kaggle_handle}.mp4
Un thumbnail format YT (visuel, logo UNC/IAE, stack, avatar Kaggle,...)

🎯 Objectif

Présenter votre projet de fin d’année sous forme d’une vidéo synthétique et structurée, destinée à restituer de manière claire, convaincante et captivante plus de 3 mois de progrés et de travaux.

La vidéo devra à minima inclure :

La problématique
La collaboration mise en oeuvre
Le pipeline technique
Les résultats obtenus
Les limites et perspectives
Ce que vous auriez aimé creuser mais que vous n'avez pas pu faute de temps

💡 Idées

Se faire plaisir
Etre créatif
Profiter des possibilités ouvertes par le montage video (montage ,coupage, animations,...)
Créer un support de présentation en ligne (Canva, ppt, ...) afin de structurer le contenu, avec des visuels et des revues de code,...
Mettre en avant le caractère innovant pour la Nouvelle-Calédonie
Ce que vous avez découvert
Mettre en avant ce que vous avez aimé (côté humain, technologique,..)
Pointer là où vous vous êtes fait plaisir
Ce qui a suscité le plus de curiosité ou l'envie de continuer vers plus de recherche, d'approfondir une technologie ou un thème
Si vous pouviez passer le flambeau à d'autres étudiants l'année prochaine ce vous aimeriez voir réalisé
La mise en perspective des travaux des autres camarades de promotion
Donner du feedback sur la pédagogie ou le pipeline didactique qui a émergé
En quoi vous pensez que votre travail est innovant voire disruptif
En quoi votre travail bénéficie à la société
Contexte métier ou sociétal
Sources de données et pipeline (collecte, nettoyage, transformation)
Modèles/stack utilisés et justification
Résultats (graphiques, métriques, comparaisons)
Analyse critique, limites, éthique
Impacts concrets ou potentiel du projet
Chiffres clés ou visuel fort
Appel à l’action (“Découvrez la vidéo complète !”)
Limites & perspectives
Si vous avez dépassé les objectifs que vous vous étiez fixés
**Si/comment cette expérience va impacter **votre carrière
...

🧮 Axes d’évaluation

Capacité à captiver le spectateur
Clarté et structuration du propos
Mise en avant des problématiques d'interopérabilité d'un point de vue technique
Problématiques organisationnelles
Qualité technique de la démarche
Analyse critique des résultats et des limites
Valorisation des résultats (visualisation, impact)
Qualité visuelle et sonore de la vidéo
Capacité à vulgariser / synthétiser
Curiosité suscitée chez le spectateur pour le travail réalisé ou de nouvelles questions

🧭 Dimension	Description	Note / Pondération
1. Clarté et structuration du message	Présentation logique, fluide, introduction + développement + conclusion. Le discours est compréhensible, bien rythmé.	/4
2. Qualité de vulgarisation et de synthèse	Capacité à expliquer clairement les concepts, à vulgariser les aspects techniques, à aller à l’essentiel sans perdre de rigueur.	/4
3. Richesse et pertinence technique	Pipeline de données, stack, interopérabilité, justifications techniques, rigueur méthodologique.	/4
4. Créativité, montage et impact visuel	Originalité du montage, qualité sonore et visuelle, utilisation pertinente de visuels, démos, animations.	/4
5. Portée, analyse critique et engagement	Mise en perspective, limites, éthique, bénéfices pour la société, passion, envie de transmettre, implication personnelle.	/4

🥳 We built the cli of our dreams to send sms ❣️

adriens — Mon, 14 Apr 2025 21:48:18 +0000

🤔 About the benefits of `cli`

Since a few years now, we started to design various cli for internal batch usage, on our Java Stack on top of picocli and quarkus, delivered as images, and run on podman.

Our goal was to :

Avoid as much as possible to write unnecessary documentations : each tool should describe himself according to a common pattern
Rely on the best possible practices
And overall : deliver a consistent first-class UX to OPS

Therefore I started to read and follow the following site to follow the best possible guidelines :

cli-guidelines / cli-guidelines

A guide to help you write better command-line programs, taking traditional UNIX principles and updating them for the modern day.

Command Line Interface Guidelines

An open-source guide to help you write better command-line programs, taking traditional UNIX principles and updating them for the modern day.

This is the source code for the guide. To read it, go to clig.dev.

Join us on Discord if you want to discuss the guide, or just chat about CLI design.

Contributing

The content of the guide lives in a single Markdown file, content/_index.md. The website is built using Hugo.

To run Hugo locally to see your changes, run:

$ brew install hugo
$ cd <path>/<to>/cli-guidelines/
$ hugo server

To view the site on an external mobile device, run:

hugo server --bind 0.0.0.0 --baseURL http://$(hostname -f):1313

License

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

View on GitHub

🎯 Our `Go`(al)

On my very own side I gave a try during a hackathon to Go and goreleaser :

adriens

Jan 11 '25

⏳GitHub Copilot 1-Day Build Challenge : eol, a tiny Go client to manage eols

#devchallenge #githubchallenge #ai #go

Comments 9

2 min read

Then, I wanted to bring my team to the Go experience at the office as sometimes we need to deliver apps to systems on which we don't want or can't install new softwares : so delivering a static binary thanks to Go and goreleaser seemed a good option for effortless cross-compilation... and of course build the best possible UX thanks to Cobra.

So I used this opportunity to sharpen our skill with my team :

// Detect dark theme var iframe = document.getElementById('tweet-1909597554590855170-986'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1909597554590855170&theme=dark" }

And...

Build the best possible cli of our dreams to send sms from a terminal and see what we can deliver and learn from that.

🍿 `v1.0.0` `brew` unboxing

📜 The story behind the product development

As I always say to my team & student, always "Start with why" :

// Detect dark theme var iframe = document.getElementById('tweet-1910458188945867005-564'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1910458188945867005&theme=dark" }

After having drafted my ideas :

// Detect dark theme var iframe = document.getElementById('tweet-1908757267941666914-566'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1908757267941666914&theme=dark" }

Here are the motivations that kept us on track :

Do things extremely :

🧩 Interoperable
🫴 Easy to integrate for anyone (even on legacy systems)
⚡ Efficient
🦥 Useful : make people save time, ie. make more with less effort
📦 Easy to deliver and install
🤩 Beautiful
📉 Fast to build : for an improved Time to market
🟢 Fast to (learn to) use
💡 Inspiring for us and others, eg. create new business opportunities ideas
😍 Desirable : people should feel the desire to use the product and feel joy while using it
🧑‍🤝‍🧑 Create new relationships with people and discover new practices

🔭 What's next

Next, we'll focus on showing and sharing the benefits :

♾️ Continuous delivery tools and automation
📼 New ways of documentation with next-gen tools
🛡️ Security (beacause it always matters)
🦸 One liners (because they're both a cool and efficient way to get things done)
🐧 Classical linux tools
📚 General IT Culture
🧑‍🎨 Creative product design and development

Hopefully you'll like it as much as we do...and will engage yourself on the same kind of way : the #learnbydoing journey 🤗

🔬Public docker images Trivy scans as duckdb datas on Kaggle

adriens — Mon, 31 Mar 2025 21:03:40 +0000

❔ About

As Trivy is becoming quite popular :

// Detect dark theme var iframe = document.getElementById('tweet-1901655379542475129-438'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1901655379542475129&theme=dark" }

I decided to give it a first try... and see what could be achieved within a very (very) few lines of code :

With datascience
Scheduled on Kaggle
With existing datasets
Deliver nice ready-to-use data as duckdb, parquet and csv

... and last but not least produce some first dataviz and see how it goes:

But... enough talk, let's see how it looks like !

🍿 Demo

🔖 Resources

🎓 2025 Teacher journey at University of New-Caledonia

adriens — Sun, 23 Mar 2025 21:13:59 +0000

// Detect dark theme var iframe = document.getElementById('tweet-1900928845521244177-122'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1900928845521244177&theme=dark" }

❔ About

As teased during 2025 New Year Writing challenge, I wanted to put more efforts in :

"🧑‍🤝‍🧑 Mentoring students"

🔭 Compiling 2025 : growing technical skills for more creativity

adriens ・ Jan 31

#devchallenge #newyearchallenge #career #learning

I wanted to put more effort in evangelizing skills, knowledge and ideas with the young generation.

Luckily I had the - indeed unexpected - opportunity to teach at the master, at IAE from UNC :

Master MIAGE - IAE NC

iae.unc.nc

ℹ️ More about IAE New-Caledonia

Below the credo :

"Venez nous rejoindre et faire vivre notre devise : « créateur d’avenirs »." - ref

IAE : "Master's Degree in Computer Methods Applied to Business Management (MIAGE)"
UNC : University of New-Caledonia

🎯 (Student )Learning Objectives

As detailed in the provided syllabus, here are the key objectives :

Master the fundamental concepts of interoperability: levels, challenges, and issues.
Understand key technologies and standards ensuring interoperability: protocols, data formats, ontologies
Implement interoperability solutions in real-world projects.
Analyze the organizational and technical challenges related to interoperability

💰 Personal rewards

🔍 Discover new problems
🤝 Meet new talents
🎭 Learn new ways of storytelling & teaching techniques
💬 Talk about my passion
🌍 Spread IT culture
🛠️ Train in getting students’ ideas into working solutions
🧩 Put technical solutions in perspective for students to create patterns
🔓 Share Open Source & Open Data concerns
🌱 Participate in the #techforgood movement
🎉 Have fun while working

🚀 About the journey

The main goal of this article is to put all live cloud driven resources available as I cannot share all contents.

So in this post, you'll find all the public things I can share to my students so they can get all the resources in a very easy way... and share them to a wider audience.

Sooooo.... let's go 👇

// Detect dark theme var iframe = document.getElementById('tweet-1900450139397120166-721'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1900450139397120166&theme=dark" }

🤔 How to keep up-to-date with news ?

Just like, comment this post to get some cool stuff.

🔭 Compiling 2025 : growing technical skills for more creativity

adriens — Fri, 31 Jan 2025 03:33:23 +0000

This is a submission for the 2025 New Year Writing challenge: Compiling 2025.

🤔 Forewords : about the "why"

First I'd like to mention that the more times goes by, the more I'd like to focus on an artistic path... which requires technical skills and knowledge to get freedom of creation:

// Detect dark theme var iframe = document.getElementById('tweet-1884783672475505034-971'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1884783672475505034&theme=dark" }

At the core of all the work I produce there is curiosity, generally, it always starts with the following questions:

Why does this...
What if I was....
I wonder if...

So my learning pattern is the following one :

🎯 Pick a specific question
🧑‍🎨 Learn the pieces of tech that helps me answer the question
📝 Write down what I learned to put things in order in my mind and achieve the work
🌌 Discover new questions

🧑‍🎓 Assesments and certifications

Follow the machine Intro to Machine Learning learning path on Kaggle
Pass the Hugging Face AI Agents Course 🤗
Give a try to dlt and hopefully achieve some courses

// Detect dark theme var iframe = document.getElementById('tweet-1879549104654885089-677'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1879549104654885089&theme=dark" }

🧑‍🎨 Creative

Do some stuff around embeddings and make something creative w. Nomic AI for example around poetry, movies, politics
Classify datasets and play with vectorial projection
Try to write even a minimalistic novel

🇫🇷 Have a lot of fun by creating some "détournements" - getting some famous movie trailers and adding french subtitles to make jokes about IT culture - :

// Detect dark theme var iframe = document.getElementById('tweet-1883293788082475247-7'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1883293788082475247&theme=dark" }

📰 Data-journalism

Now that I've grabbed a lot of skills and datasets on Kaggle, I'm very interested in putting data in perspective with traditional medias:

// Detect dark theme var iframe = document.getElementById('tweet-1884008202389578230-494'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1884008202389578230&theme=dark" }

// Detect dark theme var iframe = document.getElementById('tweet-1884776103665140005-229'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1884776103665140005&theme=dark" }

I find very interesting to see how I can fact-check or illustratre things thanks to Open Data and Open Source software. In a way, I find it like a crucial part of democracy.

Also on this journey, I learn a lot about very various topics and technologies, or sometimes produce new datasets.

🧑‍🤝‍🧑 Mentoring students

As each year, mentor interns at OPT-NC and produce some original tech creations. Here my work consist in identifying appealing subjects so CS students can come and give a try to produce something, regardless of their current skills.

So I have to create various pitches with various skills requirements so it's very opened to all for a maximum impact.

🎙️ Speaker at Events

Maybe produce some creative Open Data content around Neo4J to show off at #NODES25
Participate to Pacific dataviz challenge and try some new dataviz tools

🧪 Prototyping & discovering

Play w. ollama structured output and fix some real life questions
Write a python package with uv
Grab some GOlang skills by building a cli
Find a way to apply more mathemtic in concrete enterprise problems
Perform a LLM fine tuning on top of Open Data
Evangelize around Microcks
Build something with my Sensecap Watcher:

// Detect dark theme var iframe = document.getElementById('tweet-1867792707625922651-500'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1867792707625922651&theme=dark" }

📚 Books

I have a bookshelf with my to-read list, still here are the ones I absoluetly want to achieve in 2025:

Currently reading

// Detect dark theme var iframe = document.getElementById('tweet-1879998721590718896-779'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1879998721590718896&theme=dark" }

... but here's what's in the pipeline:

🌊 Outdoor sports

Make real progress in Wingfoiling ;-p

🤖 Job seeker agent.ai for Public Services in New-Caledonia

adriens — Sat, 25 Jan 2025 22:35:01 +0000

This is a submission for the Agent.ai Challenge: Productivity-Pro Agent (See Details)

❔ What I Built

Currently, the way to find a job in Public Services in New-Caledonia is a classical form:

But when I come to look for a job this way:

"I'm a full stack developer but also passionate about data-engineering, AI & DEVOPS"

... things get complicated - time consuming 😵 - to find the best possible matches.

🎯 Why I built this agent

I built New-Caledonia Public Services (DRHFPNC) Job Seeker Agent to provide a ready to-use as a service agent that points anyone the best job opportunities according to its skills or aspirations so they find them & apply to them efficiently without having to crawl pdfs and run many "legacy searches".

🔭 Envision and perspectives

🗞️ Build a Job trends Blog Poster that makes weekly notes on specific skills and related job opportunities
📑 Custom job recommendation team : a Team that takes in input curriculum/skills from a specific set of sources (curriculum, online linkedIn activity,...) to make dedicated recommendations
🌐 Plug it into a team next to LinkedIn Profile Analyzer
📜 Create an agent that make is possible to put together all the assesments of a given user

Then it became public :

// Detect dark theme var iframe = document.getElementById('tweet-1881560530122572227-998'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1881560530122572227&theme=dark" }

🍿 End User UX on mobile

Below a demo of the UX from a mobile device:

🔬 How it's built demo

💬 `Agent.ai` Experience

At first, I watched the video tutorial which took me a very few minutes, then I was ready to go to build the firs version of the agent.

🔬 How does it work ?

I have developped and scheduled a Kaggle Notebook : ⚙ Loader Avis de vacances de poste AVPs DRHFPNC that takes in input an OpenData dataset, performs transformations and as well pushed data into a Github Repo adriens/odata-avps-drhfpnc:

// Detect dark theme var iframe = document.getElementById('tweet-1880130238849630557-159'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1880130238849630557&theme=dark" }

It pushed csv files and the markdown version from initial pdf ones.

For this agent I used the scraping feature of the raw csv file :

Then i's just about prompting...

🤩 Best agent RUNs

Below some agent analysis that retained my attention:

💡 Making the product better : API automation, datasources,...

// Detect dark theme var iframe = document.getElementById('tweet-1880836261986107488-170'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1880836261986107488&theme=dark" }

// Detect dark theme var iframe = document.getElementById('tweet-1881759951095525454-448'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1881759951095525454&theme=dark" }

📢 Social interactions

// Detect dark theme var iframe = document.getElementById('tweet-1883259568282915046-301'); if (document.body.className.includes('dark-theme')) { iframe.src = "https://platform.twitter.com/embed/Tweet.html?id=1883259568282915046&theme=dark" }

DEV Community: adriens

💸 How $0 marketing budget boosted my creativity & automation opportunities

💡 Inception back in days

⏳ About geol : the need for a logo

🎨 How low marketing skills and budget boosted my creativity

🍿 Show me what it looks like

📝 Inception and paper/pen drafts

☝️ Put more constraints to be more productive

🚀 Pure code and automation

🖼️ Benefits : the 100% LaTeX cheatsheet

🔭 Further opportunities

🦈 Analyzing Open Data shark attacks with gemini-cli and Quarto 📊

😂 Spoiler alert : what it was not

❔ What I Built with Google Gemini

🔥 Work planning (brain on fire)

🍿 Demos

Long edition with pdf commenting

Short edition (for educational purposes)

📑 Resources

🧑‍🎓 What I Learned

💡 Google Gemini Feedback

📸 Screenshots

🦆Built a duckdb community extension for brew

🤓 What I Built

💡 The idea : the duckdb extensions community

🍿 Demo

📷 Screenshots

📈 Historical brew install

🌌 Graph Dependencies

🐧 SQL reports from terminal

🤓 My Experience with GitHub Copilot CLI

👨‍🎓 Lesson learned : CI, tests and lint first

📑 Resources

⏳ Managing EOLs w. geol: the impossible 1' Mux demo

❔ What I Built

⏱️ My 1' Pitch Video

📑 Demo

💭 The Story Behind It

⚙️ Technical Highlights

🐦 Some Tweets showcasing what's achieved and how

distrobox

Putting geol, trivy, gemini & latex to work

Building cheetsheat with pure code w. LaTeX

Build a website with docusaurus

⏳geol, the cli to efficiently manage EOLs like a boss

⏱️ geol in 5' for impatients

🤗 Building ideas & patterns before software

💭 About the core idea

🍿 Unboxing demo

🧑‍🤝‍🧑 Team mates

🎯 Our MVP

🎯 DoD

🤩 What we learned and techniques we developed on the journey

🧰 Stack

➿ cli design tuning with AI

📰 Original report productions

🔭 Further ideas

🙌 Last words

🛡️ Data quality, SQL, duckdb and http_client on CI🦆

💭 CI, duckdb et and data protection

🍿 For impatients

🔖 Resources

🕹️ Do the job with SQL

🎬 2025 UNC MIAGE démo finale

❔ Une video... pourquoi pas un rapport 🤔

📜 Règles de base

🎯 Objectif

💡 Idées

🧮 Axes d’évaluation

🥳 We built the cli of our dreams to send sms ❣️

🤔 About the benefits of cli

cli-guidelines / cli-guidelines

A guide to help you write better command-line programs, taking traditional UNIX principles and updating them for the modern day.

Command Line Interface Guidelines

Contributing

License

🎯 Our Go(al)

🍿 v1.0.0 brew unboxing

📜 The story behind the product development

🔭 What's next

⏳ About `geol` : the need for a logo

🖼️ Benefits : the `100%` LaTeX cheatsheet

💡 The idea : the `duckdb` extensions community

🐧 `SQL` reports from terminal

👨‍🎓 Lesson learned : `CI`, tests and lint first

⏱️ My `1'` Pitch Video

`distrobox`

Putting `geol`, `trivy`, `gemini` & `latex` to work

Building cheetsheat with pure code w. `LaTeX`

Build a website with `docusaurus`

⏱️ `geol` in `5'` for impatients

🎯 Our `MVP`

➿ `cli` design tuning with AI

💭 CI, `duckdb` et and data protection

🕹️ Do the job with `SQL`

🤔 About the benefits of `cli`

🎯 Our `Go`(al)

🍿 `v1.0.0` `brew` unboxing

💬 `Agent.ai` Experience