First, read or watch tutorial attentively

Secondly, try to understand, relate and think where we can apply.

Third, apply what we have learnt. It may be far from perfect. But the key is we have done something with our newly learnt knowledge

Lastly, share it. Share it to the friends, write a post on your blog, write on social media. Share!

If you don’t use it. You lose it

1. group preview
2. 1-on-1 briefing
3. ceramah/talk by speaker
4. influencer on social media
5. social media ads
6. autoresponder to educate

Give more.

Share more free tips, sharing, ideas etc. Sponsor an event to educate the market. Give something valueable to get the name out. Can do FB live, series of tips in mailing list (not automated). Don’t hard sell all the time.

Use migration to update database structure in more systematic way. For CI version 3.x

Setting up

1. Create migration directory – application/migrations
2. Update setting application/config/migration.php
   1. set $config[‘migration_type’] = ‘sequential’
3. Create table “migrations” in database. With 1 field named “version” of type INT(11)
4. Add controller “Migration” in application/controllers directory

To use

1. after add the migration file in application/migrations directory,
2. update version number to latest version in config/migration.php
3. run migration script https://your_domain/migrate

Other notes and references

1. Migration file name should be 001_add_users.php (sequence_number+operation+tablename)
2. use dbforge class to construct the migration file

$config[‘sess_save_path’] = sys_get_temp_dir();

Grav – flat file CMS

Pico – flat file CMS. use mark down to format content

October – based on laravel

Textpattern

can run on every minute

can set many cron jobs for free

Some video tutorials/courses can be prepared

Google Workspace

1. Basic google drive and app functions
   1. sharing
   2. export
2. Google sheet
   1. vlookup
   2. sum
   3. other math formula
   4. if else logic
   5. conditional formatting
   6. pivot
   7. graph
3. Google docs
   1. page setup
   2. basic text format
   3. header/footer
   4. heading
   5. table of contents

For SaaS solution, we need to cater many customers database with a single code base application

There are several type of multi-tenant architecture for database.

1. different database
2. shared database server but different schemas (or “database”)
3. shared database and shared schemas

Some further readings

1. https://web.archive.org/web/20110311185417/http://msdn.microsoft.com/en-us/library/aa479086.aspx
2. https://www.mysql.com/products/cluster/ -partition/shards

Ways to call.

1. JS
   1. XMLHttpRequest
   2. Fetch
2. jQuery
3. Axios

further reading