13. Additional notes

• 13.1. Technical notes
  • 13.1.1. Resolved bugs elsewhere, previously affecting CRATE
  • 13.1.2. Cross-platform hosting
  • 13.1.3. Converting to SQLAlchemy
  • 13.1.4. Installing Python 3.4 on Ubuntu 16.04
  • 13.1.5. Transaction count always >0 for SQL Server, prohibiting CREATE FULLTEXT INDEX
  • 13.1.6. Celery: test_email_rdbm_task() missing 1 required positional argument: ‘self’
  • 13.1.7. SQL comments
  • 13.1.8. webnotes.txt
  • 13.1.9. notes_on_database_schemas.txt
  • 13.1.10. old notes.txt
  • 13.1.11. Old pipeline notes
• 13.2. Common relevant TCP/IP ports
• 13.3. External dependencies
• 13.4. Calling Python from SQL Server
  • 13.4.1. Prerequisites
  • 13.4.2. Basic communication with Python
  • 13.4.3. Install some external Python code
  • 13.4.4. See what packages are installed locally
  • 13.4.5. Structured data flow
  • 13.4.6. Example to find two antidepressants “episodes”
• 13.5. Using SemEHR
  • 13.5.1. Background on Docker
  • 13.5.2. SemEHR tutorial via Docker on Ubuntu
  • 13.5.3. Notes on Docker
  • 13.5.4. Notes on the SemEHR docker setup
  • 13.5.5. Troubleshooting SemEHR