effariwhy (@effariwhy@theforkiverse.com)
In this week's adventure of "Will I be replaced by AI":
Copilot generated a really nice module using sqlalchemy to automate the db migration we use in my ETL shop. It took a few days going back and forth with copilot to get it to produce the DDL we the way we like it. I stopped myself from editing this module and I'm letting copilot manage it.
I still did the integration of it's use into our code base.
I'm still saying NO, AI cannot replace me YET.
#python #sql #copilot #llm #ai
Show Original Post
noirello (@noirello@mastodon.social)
More like a long overdue bugfix, than a new release, but here we go: https://pypi.org/project/bonsai/1.5.5/ #python #bonsai #ldap
Show Original Post
jobsfordevelopers (@jobsfordevelopers@mastodon.world)
Celonis is hiring Manager, Cloud Security
🔧 #python #aws #azure #cicd #gcp #kubernetes #terraform #securityengineer
🌎 Raleigh, North Carolina
⏰ Full-time
🏢 Celonis
Job details https://jobsfordevelopers.com/jobs/manager-cloud-security-at-celonis-com-dec-9-2025-e549a4?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring
Show Original Post
2026 (@2026@jakespurlock.com)
I Built My Own iMessage Wrapped (And So Can You)
My daughter was joking that someone should build a Spotify Wrapped, but for iMessage — your year in emoji and reactions. My wife said my brother-in-law should build it since he works at Apple. (Every Apple problem is his fault in our house.)
From the other room, my daughter yelled: “I bet Dad could write this!”
Challenge accepted.
The Result
Thirty minutes later, I had a working script. Here’s my 2025:
🎁 iMessage Wrapped 2025
📱 Messages
Total: 35,768
Sent: 12,191
Received: 23,577
💬 Reactions
Given: 1,974
Received: 5,014
🏆 Your Reaction Style
👍 982
❤️ 398
😂 275
‼️ 126
❓ 19
👎 16
📈 Messages by Month
Jan ███████████████ 3,052
Feb █████████████ 2,621
Mar █████████████████ 3,422
Apr ██████████████████ 3,696
May ██████████████████ 3,640
Jun ████████████████████ 3,904
Jul █████████████ 2,561
Aug ████████████ 2,448
Sep ██████████████ 2,790
Oct █████████████████ 3,466
Nov ███████████ 2,206
Dec ██████████ 1,962Some things I learned about myself:
- I’m a listener. I receive almost 2x as many messages as I send.
- People love reacting to me. 5,014 reactions received vs 1,974 given.
- I’m a thumbs-up guy. 👍 accounts for half my reactions. Apparently I’m very agreeable.
- June was my chattiest month. December was quietest (holiday break mode).
How It Works
Your iMessage history lives in a SQLite database at ~/Library/Messages/chat.db. It’s just sitting there, queryable.
The tricky bits:
- Dates are weird. Apple stores timestamps as nanoseconds since January 1, 2001 (because of course they do).
- Reactions are messages. When you tapback a ❤️, it’s stored as a separate message with
associated_message_typeset to a magic number (2000 = loved, 2001 = liked, etc.). - Custom emoji reactions landed in iOS 17 and are stored in
associated_message_emoji.
Once you know the schema, it’s just SQL.
The Script
Here’s the full thing — about 100 lines of Python, no dependencies beyond the standard library:
#!/usr/bin/env python3
"""
iMessage Wrapped — Your year in emoji and reactions
Usage: python3 imessage-wrapped.py [year]
Requires: Full Disk Access for Terminal
"""
import sqlite3
import os
import sys
from datetime import datetime
from pathlib import Path
YEAR = int(sys.argv[1]) if len(sys.argv) > 1 else 2025
DB_PATH = Path.home() / "Library/Messages/chat.db"
APPLE_EPOCH_OFFSET = 978307200
TAPBACKS = {
2000: "❤️", # Loved
2001: "👍", # Liked
2002: "👎", # Disliked
2003: "😂", # Laughed
2004: "‼️", # Emphasized
2005: "❓", # Questioned
}
def get_db():
if not DB_PATH.exists():
print(f"❌ Database not found at {DB_PATH}")
sys.exit(1)
return sqlite3.connect(f"file:{DB_PATH}?mode=ro", uri=True)
def date_filter(year):
return f"""
datetime(date/1000000000 + {APPLE_EPOCH_OFFSET}, 'unixepoch') >= '{year}-01-01'
AND datetime(date/1000000000 + {APPLE_EPOCH_OFFSET}, 'unixepoch') < '{year + 1}-01-01'
"""
def main():
print(f"\n🎁 iMessage Wrapped {YEAR}\n")
db = get_db()
cur = db.cursor()
# Message counts
cur.execute(f"""
SELECT COUNT(*),
SUM(CASE WHEN is_from_me = 1 THEN 1 ELSE 0 END),
SUM(CASE WHEN is_from_me = 0 THEN 1 ELSE 0 END)
FROM message WHERE {date_filter(YEAR)} AND associated_message_type = 0
""")
total, sent, received = cur.fetchone()
print(f"📱 Messages: {total:,} ({sent:,} sent, {received:,} received)")
# Reaction counts
cur.execute(f"""
SELECT SUM(CASE WHEN is_from_me = 1 THEN 1 ELSE 0 END),
SUM(CASE WHEN is_from_me = 0 THEN 1 ELSE 0 END)
FROM message WHERE {date_filter(YEAR)} AND associated_message_type >= 2000
""")
given, got = cur.fetchone()
print(f"💬 Reactions: {given + got:,} ({given:,} given, {got:,} received)")
# Your tapback style
print(f"\n🏆 Your Reaction Style")
cur.execute(f"""
SELECT associated_message_type, COUNT(*) FROM message
WHERE {date_filter(YEAR)} AND associated_message_type BETWEEN 2000 AND 2005 AND is_from_me = 1
GROUP BY associated_message_type ORDER BY COUNT(*) DESC
""")
for type_id, cnt in cur.fetchall():
print(f" {TAPBACKS.get(type_id, '?')} {cnt:,}")
# Custom emoji
cur.execute(f"""
SELECT associated_message_emoji, COUNT(*) FROM message
WHERE {date_filter(YEAR)} AND associated_message_emoji IS NOT NULL AND is_from_me = 1
GROUP BY associated_message_emoji ORDER BY COUNT(*) DESC LIMIT 5
""")
customs = cur.fetchall()
if customs:
print(f"\n🎯 Custom Reactions: {', '.join(f'{e} ({c})' for e, c in customs)}")
# Monthly volume
print(f"\n📈 By Month")
cur.execute(f"""
SELECT strftime('%m', datetime(date/1000000000 + {APPLE_EPOCH_OFFSET}, 'unixepoch')), COUNT(*)
FROM message WHERE {date_filter(YEAR)} AND associated_message_type = 0
GROUP BY 1 ORDER BY 1
""")
months = ["Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
data = {row[0]: row[1] for row in cur.fetchall()}
max_cnt = max(data.values()) if data else 1
for i, name in enumerate(months, 1):
cnt = data.get(f"{i:02d}", 0)
bar = "█" * int(20 * cnt / max_cnt)
print(f" {name} {bar} {cnt:,}")
db.close()
if __name__ == "__main__":
main()Running It
- Save the script as
imessage-wrapped.py - Grant Full Disk Access to your terminal (System Settings → Privacy & Security → Full Disk Access)
- Run it:
python3 imessage-wrapped.py # defaults to 2025
python3 imessage-wrapped.py 2024 # or any yearThat’s it. Your data never leaves your machine.
What I’d Add Next
If I turn this into a proper app:
- Shareable cards — export your stats as an image
- Conversation breakdown — who do you text the most?
- Time of day patterns — are you a morning texter or a midnight scroller?
- Streak tracking — longest daily conversation streak
But honestly? The script is fun enough. Sometimes a quick hack that makes your daughter laugh is the whole point.
The script and a slightly more polished version are on GitHub if you want to grab it.
#Apple #iMessage #Messages #NerdyStuff #PythonShow Original Post
esther_alter (@esther_alter@mastodon.social)
Laid off :/
I know:
- Unity C#
- Rust
- Python
I can learn:
- Anything
I've 8 years of experience as an MIT software engineer specializing in research simulation platform projects. I would prefer: not creating the next big AI thing, not making weapons, never having to think about blockchain anything.
Anyone got anything?
#rust #softwaredevelopment #unity3d #python
Show Original Post
pyohio (@pyohio@fosstodon.org)
Good News Everyone!
The #PyOhio 2026 Call for Proposals will be opening soon! We appreciate submissions on a wide variety of topics and perspectives having to do with #Python or Python-related subjects. Keep an eye on our social media channels or subscribe to our newsletter at https://newsletter.pyohio.org/ to stay up to date!
Show Original Post
treyhunner (@treyhunner@mastodon.social)
Python Tip #49 (of 365):
Tuple unpacking supports a list-like syntax.
Tuple unpacking optionally supports parens:
>>> point = (1, 2)
>>> x, y = point
>>> (x, y) = point
But did you know that it also works with a list-like syntax?
>>> [x, y] = point
Neat... but why???
Well, I usually prefer the list-like tuple unpacking syntax:
1. when unpacking a single-item iterable
2. to convey the fact that I'm unpacking list-like data
🧵 (1/3)
Show Original Post
FLOZz (@FLOZz@mastodon.social)
J'étais complètement passé à côté, mais ils ont rajouté de la couleur dans l'aide générée par argparse dans #Python 3.14 !
Cébô ! 
Show Original Post
RodStephens (@RodStephens@hachyderm.io)
Fit an image to a target rectangle and center it in Python
(This is the first in a series of posts leading to a flash card application that you can use to learn about Japanese hiragana characters.)
https://rodstephensbooks.com/fit_image.html
Show Original Post
realpython (@realpython@fosstodon.org)
🐍💻 Python Developer Wanted: Software Engineer (Python / Django) at Mirvie (South San Francisco, CA, USA) #pythonjob #sponsored #python
Show Original Post
pytexas (@pytexas@fosstodon.org)
Have you been looking for a place to share your knowledge with other interested #python developers? 🐍
Every 1st Tuesday of the month, #PyTexas has a meetup on Discord & we would love to hear what you would like to share! 💛
Learn more here: https://www.pytexas.org/meetup
Show Original Post
Possiblydrew (@Possiblydrew@pnw.zone)
Begging people to not return nested dicts more than two levels deep.
Named tuples or data classes or structs (maybe not) are so easy to write and comprehend!
Tabulated / numeric data? Send me an array or a series or a data frame or an xarray or …
More complicated? Reevaluate please.
/rant
#python
Show Original Post