1. MySQL db remote connection establish with python example

2. Postgres Upgrade 9.x to 10.x or latest

3. Postgresql Tutorial

4. Postgresql Replication Tutorial

   • External Links:
     • https://severalnines.com/blog/top-pg-clustering-ha-solutions-postgresql
     • https://cloud.google.com/community/tutorials/setting-up-postgres-hot-standby
     • https://cloud.google.com/community/tutorials/setting-up-postgres

5. How To Set Up SSH Keys on Ubuntu

6. To view cron logs in ubuntu:

grep CRON /var/log/syslog

7. Kill all greb result in linux:

   • To kill all odoo services : sudo ps -ax |grep odoo| awk '{print $1}'|xargs kill -9 $1
   • To Kill paricular Port : sudo fuser -k 7073/tcp

8. Dropbox upload script:

   • Dropbox upload script Document

   wget https://raw.githubusercontent.com/andreafabrizi/Dropbox-Uploader/master/dropbox_uploader.sh && chmod +x dropbox_uploader.sh

9. External Application links not working(Blank chrome page opening)

10. Install Redash reporting tool(Open source)

11. Pivot Views JS - Library

    • Pivot JS - awesome - CSV or JSON
    • CSV File Map test

12. Testing System performance Linux (Calculating 10000 Pi value)

    time echo "scale = 10000; 4 * a (1)" | bc -l

13. Set a Static IP on Ubuntu Server

14. Delete all pyc files in current directory in terminal

find . -name '*.pyc' -delete

15. Github or any VCS, for private repository pull and push every time asking username and password
16. Postgresql Config File in MAC OS
17. Restart postgreSQL in mac(without install brew):

• sudo su postgres && pg_ctl -D /Library/PostgreSQL/11/data/ status
• if Brew:
  • Restarting postgresql in mac

18. Create Virtual environment in python
19. ProcessManager for individual scripts(node, py, sh or etc ...)
20. GIT Cheatsheet pages
21. GIT cherry pick commits
22. MacOS Shell change to bash

• cat /etc/shells
• chsh -s /bin/bash

23. SQL based system query from facebook - Osquery
24. How to create a node-js module ?
25. How to display data from the degitalocean api with django
26. How to build a morden web application to manage with django and react on ubuntu -production deploy
27. Github config commands:

• Change Email : git config --global user.email "[email protected]"
• Change Name : git config user.name "Hariprasath"
• Dontconsider fiele permision changes : git config core.fileMode false

28. Http toolkit for testing requests : https://httptoolkit.tech/