Active

jlsksr, to gardening
@jlsksr@mastodon.online avatar

At work we've just begun migrating a few thousand workloads to a new datacenter facility and besides that I'm barely using computers right now. These time-outs just come and go. Meanwhile I leased a 500m² garden and cheerfully dig into this shit. And of course the roof of the summer house there is leaky.. 😉 So.. don't mind me not reacting to your comments and new followings, I'm just outside wearing my straw hat! 🙃

levampyre,
@levampyre@chaos.social avatar

@jlsksr Good for you. That's just the best. Also, fix the roof or your hut will get mouldy and crumble. It's not healthy and you will miss it the springs to come.

Sebprovencher, to random
@Sebprovencher@cosocial.ca avatar

"Pour la première fois, une étude réalisée par une équipe de chercheurs de l’Université d’Aix-Marseille et de l’Université Sorbonne Paris Nord, composée de spécialistes du champ de la communication, de la nutrition, de l’épidémiologie et de santé publique, met en évidence qu’afficher le Nutri-Score des produits alimentaires dans les publicités conduirait les consommateurs à choisir des aliments plus favorables à leur santé."
https://www.laprovence.com/article/societe/31078350323752/nutri-score-ces-chercheurs-provencaux-veulent-lafficher-des-les-publicites-pour-lutter-contre-lobesite

ComicContext, to random
@ComicContext@mstdn.social avatar
dtgeek,
@dtgeek@mastodon.social avatar

@timrichards @ComicContext "it's a mullet! The hip, with-it haircut of the 90s! I need to show that I'm cool! Now excuse me while I record 'The Simpsons' on my VCR, have a Crystal Pepsi and then listen to my new Smashing Pumpkins CD."

timrichards,
@timrichards@aus.social avatar

@dtgeek @ComicContext Was Clark Kent wandering around with that hair too? Bit of a giveaway. Perhaps he had a classy ponytail.

wielding, to Birds
@wielding@fosstodon.org avatar

A Scarlet Tanager came closer than normal for a good photo.

realTuckFrumper, to random
@realTuckFrumper@mastodon.social avatar

Palestinians mark 76 years of dispossession as the catastrophe of war unfolds in Gaza https://www.youtube.com/watch?v=bCZdKVfBoCk&utm_source=dlvr.it&utm_medium=mastodon

madbarrister, to HashtagGames
@madbarrister@mastodon.social avatar
gnomon, to random
@gnomon@mastodon.social avatar

Is there an idiomatic SQL (sqlite3) way of mapping a subset of selected records from a large table ("users") to unique values in a smaller table ("coupons")? It's easy enough to select all the user records not yet mapped, and to select all as-yet unmapped coupons, but then what's a nice clean way of mapping one to the other? Order doesn't matter, only that the mapping once established can be queried again in the future.

My brain is stuck thinking sequentially about this, frustratingly.

glyph,
@glyph@mastodon.social avatar

@gnomon @jalefkowit Understandable. Is this what you were looking for? https://gist.github.com/glyph/09f1d71c6329016b786cb75e62f20235

glyph,
@glyph@mastodon.social avatar

@gnomon @jalefkowit I couldn't quite golf it down to a single statement, since you cannot treat an 'insert returning' (or any DML) as a generalized source of rows or a subquery in SQLite, but as long as you have some arbitrary ordering you can zip arbitrary sets of rows together using window functions

ai6yr, to random

CHP: ENDANGERED MISSING ADVISORY - Santa Clara County
Last seen: California Street and Escuela Avenue, Mountain View

IF SEEN, CALL 9-1-1

dnc, to random
@dnc@vive.im avatar
spocko, to TeslaMotors
@spocko@mastodon.online avatar

A with its passenger rear panel missing. They cost $100K. As my friend Water Tiger said, "It's the Fyre Festival of pickups."

's Cybertruck is quickly becoming the Edsel or the Chevrolet Corvair of modern vehicles.

Who will fire for this?

Tengrain,
@Tengrain@mastodon.social avatar

@spocko

Just sayin’

dannotdaniel,
@dannotdaniel@mastodon.social avatar

@spocko pickup? more like a put down truck

valou, to random French
@valou@masto.bike avatar

Bonjour, aujourd'hui 8h de caisse, motivation

Flobzh,
@Flobzh@masto.bike avatar

@valou bonjour Valou

  • All
  • Subscribed
  • Moderated
  • Favorites
  • normalnudes
  • tsrsr
  • DreamBathrooms
  • thenastyranch
  • magazineikmin
  • hgfsjryuu7
  • Youngstown
  • InstantRegret
  • slotface
  • everett
  • rosin
  • ngwrru68w68
  • kavyap
  • PowerRangers
  • Leos
  • ethstaker
  • GTA5RPClips
  • Durango
  • cisconetworking
  • osvaldo12
  • vwfavf
  • khanakhh
  • mdbf
  • cubers
  • modclub
  • tacticalgear
  • tester
  • anitta
  • All magazines