Rudá Almeida rdlmda

Technology Enthusiast. Former organizer of the Rio de Janeiro WordPress Meetup.

rdlmda / count.sql

Last active March 18, 2021 13:46

WordPress: count posts by year and month

	SELECT YEAR(post_date) YEAR, MONTH(post_date) MONTH, COUNT(*) COUNT
	FROM wp_posts
	WHERE post_type = 'post' AND post_status = 'publish'
	GROUP BY YEAR(post_date), MONTH(post_date);

rdlmda / smtp.py

Created January 17, 2025 15:05

barebones SMTP email delivery with Python

	import smtplib
	from email.mime.text import MIMEText

	smtp_server = 'mail.domain.com'
	smtp_port = 587 # Typically 587 for TLS

	username = '[email protected]'
	from_email = username
	password = 'password'