Skip to content

paladini/aa-daily-reflections-database

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

9 Commits
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

πŸ“– AA Daily Reflections Database

Complete year of Alcoholics Anonymous Daily Reflections in English, Spanish, French, and Brazilian Portuguese

365 daily meditations and spiritual reflections from AA available in multiple formats (SQLite, JSON, CSV) for recovery apps, multilingual communities, and personal spiritual practice.

License: MIT Languages

πŸ“– Read this in other languages: πŸ‡ͺπŸ‡Έ EspaΓ±ol | πŸ‡«πŸ‡· FranΓ§ais | πŸ‡§πŸ‡· PortuguΓͺs

🌐 Live Portal

πŸ“– Access the Live Portal

Browse and read daily reflections in a beautiful, multilingual web interface with:

  • 🌍 4 languages: English, Spanish, French, Brazilian Portuguese
  • πŸ“… Easy navigation: Previous/Next day, date picker, "Today" button
  • πŸ“± Responsive design: Works perfectly on mobile and desktop
  • πŸ”— Shareable URLs: Every reflection has a unique, shareable link
  • πŸ” SEO optimized: Each reflection is searchable and indexable

πŸ‘¨β€πŸ’» Created by Fernando Paladini

This database and portal were compiled, developed, and maintained by Fernando Paladini.

  • πŸ“Š Data Compilation: Carefully collected and structured from official AA sources
  • 🌐 Multilingual Translation: Sourced authentic translations in 4 languages
  • πŸ’» Portal Development: Built a modern React-based web portal
  • πŸ”§ Technical Implementation: Database design, API structure, and deployment
  • πŸ“ˆ SEO Optimization: Multilingual SEO with hreflang, structured data, and sitemaps

If this project helps your recovery journey or development work, consider ⭐ starring the repository or β˜• supporting the project.

πŸš€ Quick Download

Choose your preferred format and language:

πŸ“Š All Languages Combined

πŸ“„ Individual Languages

Language JSON CSV
πŸ‡ΊπŸ‡Έ English JSON CSV
πŸ‡ͺπŸ‡Έ EspaΓ±ol JSON CSV
πŸ‡«πŸ‡· FranΓ§ais JSON CSV
πŸ‡§πŸ‡· PortuguΓͺs JSON CSV

πŸ“‹ What's Included

  • Complete year coverage: All 365 days of AA daily reflections
  • Multilingual: Available in English, Spanish, French, and Brazilian Portuguese
  • Complete data: Title, quote, reflection text, and source reference
  • Multiple formats: SQLite database, JSON files, and CSV spreadsheets
  • Ready to use: Perfect for apps, websites, or personal projects

πŸ“Š Data Structure

Each reflection contains:

{
  "date": "2025-01-01",
  "language": "english",
  "title": "I AM A MIRACLE",
  "quote": "The central fact of our lives today...",
  "text": "This truly is a fact in my life today...",
  "content": "ALCOHOLICS ANONYMOUS, p. 25"
}

πŸ“ For more details about data formats, see data/README.md

πŸ’» Code Examples

πŸ“ Ready-to-run examples in multiple languages: examples/README.md

Quick Start

Python

import sqlite3

conn = sqlite3.connect('data/reflections.db')
cursor = conn.cursor()

# Get today's reflection
cursor.execute("""
    SELECT title, quote, text FROM reflections 
    WHERE date = date('now') AND language = 'english'
""")
reflection = cursor.fetchone()
print(f"Today: {reflection[0]}")

JavaScript

const fs = require('fs');

// Load English reflections
const reflections = JSON.parse(
    fs.readFileSync('data/english/daily_reflections_english.json', 'utf8')
);

// Get today's date
const today = new Date().toISOString().split('T')[0];
const todayReflection = reflections.find(r => r.date === today);

console.log(`Today: ${todayReflection.title}`);

πŸš€ Getting Started

Option 1: SQLite Database

import sqlite3

conn = sqlite3.connect('data/reflections.db')
cursor = conn.cursor()

# Get today's reflection
cursor.execute("""
    SELECT title, quote, text FROM reflections 
    WHERE date = date('now') AND language = 'english'
""")
reflection = cursor.fetchone()
print(f"Today: {reflection[0]}")

Option 2: JSON Files

const fs = require('fs');
const reflections = JSON.parse(
    fs.readFileSync('data/english/daily_reflections_english.json', 'utf8')
);

const today = new Date().toISOString().split('T')[0];
const todayReflection = reflections.find(r => r.date === today);
console.log(`Today: ${todayReflection.title}`);

Option 3: CSV Files

import pandas as pd

# Load all languages
df = pd.read_csv('data/daily_reflections_2025_all_languages.csv')

# Filter by language and date
english_reflections = df[df['language'] == 'english']

🌍 Available Languages

Language Code Native Name Coverage
English en English Complete year (365 days)
French fr FranΓ§ais Complete year (365 days)
Spanish es EspaΓ±ol Complete year (365 days)
Brazilian Portuguese pt-BR PortuguΓͺs do Brasil Complete year (365 days)

🀝 Contributing

Found an error or want to help? See our contributing guidelines

πŸ“œ License

MIT License - Free to use for educational and recovery purposes.

Important: This is an unofficial compilation. Original content belongs to Alcoholics Anonymous World Services, Inc.

πŸ™ Acknowledgments

  • Alcoholics Anonymous World Services, Inc. for the original daily reflections content
  • AA communities worldwide who provided translations and cultural adaptations
  • Recovery community for inspiration and feedback

πŸ“¬ Contact & Support

Fernando Paladini - Project Creator & Maintainer

Support This Project

If this database helps your recovery journey or development work:


"One day at a time" 🌟
Dedicated to the recovery community worldwide

Created with ❀️ by Fernando Paladini

About

Alcoholics Anonymous (AA) Daily Reflections in English, Spanish, French and Brazilian Portuguese

Topics

Resources

License

Stars

Watchers

Forks

Contributors