I am a geographer interested in all things spatial and open science! he/him/homard
Public Key
npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Profile Code
nprofile1qqsvd6utsd2sz3w4575q8d984c97n6749p49lm56p4tvys3kcqt5tzgpz4mhxue69uhhyetvv9ujuerfw36x7tnsw43qfrk95f
Show more details
Published at
2026-08-20T12:25:36Z Event JSON
{
"id": "818fd1cfbdc7b51ce64b54f7e928760c144ed22ab0314e49e5ae2fa5062a3f90" ,
"pubkey": "c6eb8b83550145d5a7a803b4a7ae0be9ebd5286a5fee9a0d56c24236c0174589" ,
"created_at": 1787228736 ,
"kind": 0 ,
"tags": [
[
"proxy",
"https://fosstodon.org/users/defuneste",
"activitypub"
],
[
"client",
"Mostr",
"31990:6be38f8c63df7dbf84db7ec4a6e6fbbd8d19dca3b980efad18585c46f04b26f9:mostr",
"wss://relay.ditto.pub"
]
],
"content": "{\"name\":\"Olivier Leroy\",\"about\":\"I am a geographer interested in all things spatial and open science!\\n\\nhe/him/homard\",\"picture\":\"https://cdn.fosstodon.org/accounts/avatars/109/235/210/338/204/021/original/2a496c976587d0e9.jpg\",\"nip05\":\"[email protected] \",\"fields\":[[\"Blog\",\"https://branchtwigleaf.com/about.html\"]]}" ,
"sig": "dd8c115bc43037e6ab9499e1692a90cfec6b1de702214a4078c41312b4d8b7deb9419433e412fd5cd7015b9d50ff6ed49e0bc17cea04bf59d0e5435b38761e2c"
}
Last Notes npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…2hpy smart idea, I would say that i have no idea on top of my head what is @nprofile…70wt support for data types npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…2hpy I would try more a CREATE table and specify data types and the n UPDATE. I do not remember on your error message what field generate that error. npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…2hpy just a type error no? I kind of like them, yeah they are frustrating but they make stuff more robust. npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy Happy Bday Pandoc! https://pandoc.org/twenty-years-of-pandoc.html Very interesting blog to read: > I decided to use Haskell, and then decided to write a document converter in it. > Thus, a project that started out as nothing more than the product of procrastination was nurtured by the joy of writing in Haskell and by its increasing usefulness for my own academic work. npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…k7ew cool glad you also knew someone! npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy #npr this morning I learned about "DEI bike lane". I am so glad this administration is protecting us against the big bike lane industry! npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…uptt oh I am jealous!! can you take some pictures of "dancing trees"? npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…ezwg yeah the "product close to consumer"seems nice, I am not gone far enough to get what is the "platform". definitely see how you need very good leadership ... npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy Reading about data mesh (very good to fight jet lag!), it seems like a DDD (domain driven dev) but for data: think API/contracts: you get a data product, I get one! it is too early for me to draw any kind of conclusions but it seems companies that can brag using it have both a crazy good data maturity (technically and governance) and a good grasp of their business (if they just have "one", well organized in "domains"). Their leadership must also be very good, sound like some unicorns 🦄 ! npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…5qfx @nprofile…tkg6 MNHN non? npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy interesting blog post on open source communities https://blog.stdlib.io/ai-and-the-invisible-newcomer-in-open-source/ Kind of happy to see that "friction" is more useful that it look like. @nprofile…afu4 (probably not here 🤷♂️ ) npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy started Reproducible Research Mooc 2 and I would like to say I 100% prefer computers science professors doing weird roleplay versus AI generated videos! https://www.fun-mooc.fr/fr/cours/reproducible-research-ii-practices-and-tools-for-managing-comput/ npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…ezwg not @nprofile…qx87 but the scale is more about team members / organization structure and tools you need to connect than volume of data. dbt with duckdb will be different than dbt with spark. I ran half TB data with targets and duckdb without (big) issue (but it did not need to run every few minutes). npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…ezwg good post (and I 100% agree)! I have not try duckdb but my memory using PG is that with dbt you can also set up a staging / per user /branch. You are not just promoting code but also data (kind of). In fact you need it for validation. You can also do that with targets using multiple "stores". I think gittarget help here but I usually use my crappy function that switch store if not on main branch. I find validation tests slightly easier with dbt but never tried data.validator. npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…ynd9 well that got me the opportunity to boost your LI post to my huge network (😉 ). i guess LI apply some Noblesse protocol:p npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…k7ew coffee is for you! (hope you can repair the framework!!) npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…dmr0 I am too much of guix noob but would you mind sharing what kind of help do they need? npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…ezwg def need to look more what kind if book they have! npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy Well I would like to unsubscribe to audible (but oh wait I do not have it)! What are good services for audiobooks? npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy Your Monthly reminder that if something need to read "wild" csv files (in their corporate natural environment) increase your time estimates to do the task! You are not just loading a file in a text format your are knocking at the door of years of "in house practices", memorials of past coworkers and layers of potential regulations! npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…ywth I should follow and read about the US agriculture but isn't a lot of farmers here just hyper specialized on cash crops on international markets with very intensive capital investment? strategy that works financially ehen you are part of a country that can impose trade agreements but are not so great on plenty of other parts of the... npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…ezwg probably true it is just I always end up in team that do not value it and I am the only one trying something ... npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…ynd9 winter coat! npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy another day where my logging is cat(sprintf"%s INFO: do stuff \n", Sys.time())) would 2026 be the year were I learn a logging framework #Rstats? npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…ynd9 southern hemisphere rule half a year! npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…6r70 wow isn't that 3 week a month early (from my NC perspective)? npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…6hrf not reading your blog was on point with reddit (kind of) but the comments show a total lack of curiosity which feel weird for DS... npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…6hrf saw your blog posted on the data science reddit, pretty hilarious or sad depending on your mood npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy "Mom when I grow up I want to manage Identity in Azure." npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…t0hh death to plastic skeleton!!! npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy waiting for threats or trickers with just a fire, some candles (to read my book), carved pumpkins and apparently I am more scary than the neighbors with full giant skeletons, inflatable spiders and lights! chocolates are going to be mine!! npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…t0hh probably but the main question is: "is that really butter" (I guess fine for cooking but not for baking) npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy "fine" butter is at $11 now. I should start moving for mediterranean cooking, oh wait oil price. To be clear, I am all for paying good products the fair price and allocating part of my budget for that. "fine" butter is just slightly above average agro industrial products. npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy Noob #Python question (yup I do not have choice) what is a good read on making python package (for internal purpose)? Can I get something similar than #RStats Packages book? npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…33hd Il y huma num (instance gitlab) pour les humanité numeriques (et ce fut pas evident de faire utiliser par certains collegues plutot que GH ping @nprofile…sdx9 pour le souvenir). Faire bouger les DSI c'est vraiment compliqué, en dehors de certains collegues. J'ai toujours eu l'impression que ces services repondaient principalement a la direction... npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…7s4z ouch ... npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…pp8p be strong buy second hand, like for video game :P npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…r4ut “there can only be one” npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy "510 years of professional experience in data science" how can I lie on that one :blobthinkingeyes: "I am Defuneste of the Clan #Rstats I was born in 1518 in the village of Glenfinnan since them I wrangled data. And I am immortal." npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…aa2m @nprofile…45ag will it be recorded I can t attend.., npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…aa2m I will come to this, curious why posit and why ESRI. npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…9g62 The "show comment" at the bottom, now that I clicked on it I see it is disqus, I have see a mastodon version and want that but did not spend time looking for it... (example: https://beej.us/blog/data/mastodon-comments/) npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…9g62 my use of them https://branchtwigleaf.com/posts/2024-09-15_function_factory/, I am with you on the point that I do not like much the do_x()() (inherited from ecdf()()? ). Using smarter name, like @nprofile…vp0l is def a good idea! Having more convention around it would also help, ie I would use factory_ other will use make_ etc ... PS: I will look at your blog to understand how the mastodon integration works! npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…9g62 I like function generator but mostly to simplify code in specific projects where some argument have limited value, for example « dev » / « prod » then you have write_to_dev() and write_to_prod() that came from write(x, env_or_prod). I am not smart enough for understanding all the trade off but I will read your futur blog post about it! 😉 npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…ca53 Oh cool I used Pomodoro once in my PhD and liked it! I should restart doing. 50k pushup is a very impressive number/goal! npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…25dv I have not get this one but I stile watch too much YouTube. I think it plays the role of "TV I am tired" and it is bad. npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…pp8p I understand the feeling! if that make you feel better: past student experience told me that they are bad option in protein/cash ratio (albeit in the US processed food is a bit less expensive). npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy Like a good parent I am “cooking” chicken nuggets dinosaurs with French fries npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…p7ts #Rstats 👆 npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…aa2m Very interesting read! "Data analysis has become a valuable skill in the job market. Argentina is experiencing a job crisis, making it crucial for people to access information. However, because much of this information is often in English, we aim to generate materials in Spanish and share them with our community, as linguistic barriers can be restrictive." npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy I am doing some #Linux foundations training and I would not recommend them if you do not have an already "good" grasp of the topics you want to learned. I am lacking but still have some basic covered, plus "in hand experience". It seems they never hired folks with pedagogy background. Books from @nprofile…qtsx , "blog post" from @nprofile…ntcd are, for example, miles ahead of what I am imposing myself right now.... npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…9g62 @nprofile…52yx Not forcing them to use any but I think it is easier to start somewhere :) So every way to produce a file should create an ID (and dictionary), unsure that ID is unique and update the dictionary if a file is moved (how will you know that?) you have an other table that is storing its history. I think on top of your API you will need some organizational rules to try simplify your scope. npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…9g62 @nprofile…52yx this is the Graal right now, corporate env. is the mess you are describing. At the end it seems folks are solving that with LLM (like everything 😉 ). You said you have metadata how consistent are they? When you update something in your mess how does the state of your database get affected? I agree with @nprofile…52yx it seems you are describing some kind of object storage, usually those can have header than can be requested. I will start by listings that. npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @nprofile…wkk2 @nprofile…qz4x I feel it is similar in France, the "national" far right party campaign a lot on consumers/consumption. eat advertisers also. npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @npub1g23…v7wv I clicked the subscribe button :P npub1cm4chq64q9zatfagqw620tsta84a22r2tlhf5r2kcfprdsqhgkyseu5h98 Olivier Leroy @npub1dc9…5t7a I do not know about cat pictures (as much as I love them) but I usually read your blog post!