Shane Cooke githubber

## open_source_church_software.md

      
              1 file
            
          
              5 forks
            
          
              2 comments
            
          
              27 stars
            
          
                seven1m
                / open_source_church_software.md
            
            
              Last active Feb 23, 2020
            
              
                List of Open Source Church Software
              
          
      View open_source_church_software.md
  
    
Name
Type
License
Tech


apostello
SMS communication
MIT
Python


Bible API
bible reference
MIT
Ruby


Bible Helper
bible reference
MIT
Javascript


BVCMS
ChMS
GPLv2
C♯ (.NET)


Cedar
media projection
MIT
JavaScript (Meteor)


ChurchCRM
ChMS
MIT
PHP


ChurchInfo
ChMS
GPLv2
PHP


Jethro Pastoral Ministry Manager
ChMS
GPLv3
PHP


## backup.sh
#!/bin/bash
BACKUP_SRC="/root /etc /home"
BACKUP_DST="/tmp"
MYSQL_SERVER="127.0.0.1"
MYSQL_USER="mysql username"
MYSQL_PASS="mysql password"
#VPS_ID="vpsidentifier"

# Stop editing here.
NOW=$(date +"%Y.%m.%d")

## convert_utf8_to_utf8mb4
# For each database:
ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
# For each table:
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
# For each column:
ALTER TABLE table_name CHANGE column_name column_name VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
# (Don’t blindly copy-paste this! The exact statement depends on the column type, maximum length, and other properties. The above line is just an example for a `VARCHAR` column.)

## node-and-npm-in-30-seconds.sh
echo 'export PATH=$HOME/local/bin:$PATH' >> ~/.bashrc
. ~/.bashrc
mkdir ~/local
mkdir ~/node-latest-install
cd ~/node-latest-install
curl http://nodejs.org/dist/node-latest.tar.gz | tar xz --strip-components=1
./configure --prefix=~/local
make install # ok, fine, this step probably takes more than 30 seconds...
curl https://www.npmjs.org/install.sh | sh
Name	Type	License	Tech
apostello	SMS communication	MIT	Python
Bible API	bible reference	MIT	Ruby
Bible Helper	bible reference	MIT	Javascript
BVCMS	ChMS	GPLv2	C♯ (.NET)
Cedar	media projection	MIT	JavaScript (Meteor)
ChurchCRM	ChMS	MIT	PHP
ChurchInfo	ChMS	GPLv2	PHP
Jethro Pastoral Ministry Manager	ChMS	GPLv3	PHP
	#!/bin/bash
	BACKUP_SRC="/root /etc /home"
	BACKUP_DST="/tmp"
	MYSQL_SERVER="127.0.0.1"
	MYSQL_USER="mysql username"
	MYSQL_PASS="mysql password"
	#VPS_ID="vpsidentifier"

	# Stop editing here.
	NOW=$(date +"%Y.%m.%d")
	# For each database:
	ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
	# For each table:
	ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
	# For each column:
	ALTER TABLE table_name CHANGE column_name column_name VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
	# (Don’t blindly copy-paste this! The exact statement depends on the column type, maximum length, and other properties. The above line is just an example for a `VARCHAR` column.)
	echo 'export PATH=$HOME/local/bin:$PATH' >> ~/.bashrc
	. ~/.bashrc
	mkdir ~/local
	mkdir ~/node-latest-install
	cd ~/node-latest-install
	curl http://nodejs.org/dist/node-latest.tar.gz \| tar xz --strip-components=1
	./configure --prefix=~/local
	make install # ok, fine, this step probably takes more than 30 seconds...
	curl https://www.npmjs.org/install.sh \| sh