Refer https://www.codementor.io/engineerapart/getting-started-with-postgresql-on-mac-osx-are8jcopb
http://suite.opengeo.org/docs/latest/dataadmin/pgGettingStarted/firstconnect.html
Psql console
psql
\c database_name (selects db)
\l - lists all the database
| # Setting PATH for Python 3.7 | |
| # The original version is saved in .bash_profile.pysave | |
| PATH="/Library/Frameworks/Python.framework/Versions/3.7/bin:${PATH}" | |
| export PATH | |
| if [ -f $(brew --prefix)/etc/bash_completion ]; then | |
| . $(brew --prefix)/etc/bash_completion | |
| fi |
| home brew - /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)" | |
| git brew instal git | |
| ffmpeg git clone https://git.ffmpeg.org/ffmpeg.git ffmpeg | |
| libv brew install libav | |
| youtubedl brew install youtube-dl |
| To get the number of value in the each column with the count | |
| # =========================================================================================================== # | |
| ModelName.objects.filter(id=model.id).all().values('fieldName').annotate(count=Count('fieldName')).order_by() | |
| class ModelNameSerializers(serializers.ModelSerializer): | |
| column_count = serializers.SerializerMethodField() | |
| class Meta: | |
| model = models.ModelName |
| server { | |
| listen 80; | |
| server_name {{ ip address }}; | |
| access_log /var/log/nginx/access.log; | |
| location = /favicon.ico { access_log off; log_not_found off; } | |
| location /static/ { | |
| root /home/ubuntu/projectName/; | |
| } |
| [Unit] | |
| Description=mitron gunicorn daemon | |
| After=network.target | |
| [Service] | |
| PIDFile=/run/gunicorn/pid | |
| User={{ user }} | |
| Group={{ user }} | |
| RuntimeDirectory=gunicorn | |
| WorkingDirectory={{ project_root }} |
| worker_processes | |
| A worker process is a single-threaded process. | |
| If Nginx is doing CPU-intensive work such as SSL or gzipping and you have 2 or more CPUs/cores, | |
| then you may set worker_processes to be equal to the number of CPUs or cores. | |
| If you are serving a lot of static files and the total size of the files is bigger than the available memory, | |
| then you may increase worker_processes to fully utilize disk bandwidth. |
| Informational - 1xx | |
| HTTP_100_CONTINUE | |
| HTTP_101_SWITCHING_PROTOCOLS | |
| Successful - 2xx | |
| HTTP_200_OK | |
| HTTP_201_CREATED | |
| HTTP_202_ACCEPTED |
| curl http://checkip.amazonaws.com | |
| import requests | |
| requests.get('http://checkip.amazonaws.com').text.rstrip() | |
| ########################## | |
| # Application specfic | |
| ########################## | |
| # config/config.js | |
| ########################## | |
| # General | |
| ########################## | |
| ##### |