본문 바로가기

분류 전체보기

(198)
[Django] Tutorial 따라하기 - 3 * Reference : https://docs.djangoproject.com/ko/2.1/intro/tutorial03/ 첫 번째 장고 앱 작성하기, part 3 | Django 문서 | Django Django The web framework for perfectionists with deadlines. Overview Download Documentation News Community Code Issues About ♥ Donate docs.djangoproject.com #. Add View -- add view to polls/views.py (djenv) ivan@django:~/djgo$ more polls/views.py #from django.shortcuts import render ..
[HANA] 2180165 - FAQ: SAP HANA Expensive Statements Trace * 2180165 - FAQ: SAP HANA Expensive Statements Trace https://launchpad.support.sap.com/#/notes/2180165 https://launchpad.support.sap.com/#/notes/2180165 launchpad.support.sap.com 3. Criteria can be used to record a database request Indicator Validity Parameter Unit Details Runtime general global.ini -> [expensive_statement] -> threshold_duration us SQL statements exceeding the configured runtime..
[Django] Tutorial 따라하기 - 2 * Reference : https://docs.djangoproject.com/ko/2.1/intro/tutorial02/ 첫 번째 장고 앱 작성하기, part 2 | Django 문서 | Django Django The web framework for perfectionists with deadlines. Overview Download Documentation News Community Code Issues About ♥ Donate docs.djangoproject.com #. Create DB - Define db and environment (djenv) ivan@django:~/djgo$ more mysite/settings.py ~~~ # Database # https://docs.djan..
[Django] Tutorial 따라하기 - 1 * Reference : https://docs.djangoproject.com/ko/2.1/intro/tutorial01/# #. Start Project - Command check : django-admin 더보기 (djenv) ivan@django:~/djgo$ django-admin Type 'django-admin help ' for help on a specific subcommand. Available subcommands: [django] check compilemessages createcachetable dbshell diffsettings dumpdata flush inspectdb loaddata makemessages makemigrations migrate runserver s..
[Postgresql] 외부에서 접속하기 1. 포트 확인 root@django:/home/ivan# netstat -ntlp | grep 5432 tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN 1481/postgres - DB에서 사용하는 포트 = 5432 - 127.0.0.1:5432 -> 내부에서만 사용 가능 2. Config 변경 - postgresql.conf 파일 변경 root@django:/etc/postgresql/10/main# ls -al postgresql.conf -rw-r--r-- 1 postgres postgres 23045 Nov 12 23:13 postgresql.conf root@django:/etc/postgresql/10/main# vi postgresql.conf #-----------..
[Django] Starting Django!! 1. Setup Environment 1-1. Install Postgresql DB root@django:/home/ivan# apt-get install postgresql-10 Reading package lists... Done Building dependency tree Reading state information... Done The following additional packages will be installed: libpq5 libsensors4 postgresql-client-10 postgresql-client-common postgresql-common ssl-cert sysstat Suggested packages: lm-sensors locales-all postgresql-..
[HANA] hdbsql options SAP HANA HDBSQL Options Set information for the database and for database objects by using SAP HANA HDBSQL commands. In addition to SAP HANA HDBSQL commands, you can also enter an SQL statement or a database procedure. The statement or procedure must be enclosed in quotation marks. Configuration Options Use the following options to modify the operation of SAP HANA HDBSQL commands. Database Sessi..
[HANA] Database trace설정 (savepoint) 설정 방법 HANA Studio -> Administator -> Trace Configuration -> Database Trace Component = savepoint 선택 Trace Level = 'INFO' -> 'DEBUG'로 변경하여 ON Savepoint Trace 예시 == Trace 미설정 상태 [620581]{-1}[-1/-1] 2019-07-12 08:49:07.030953 i Savepoint SavepointImpl.cpp(02995) : Savepoint current savepoint version: 11954, restart redo log position: 0xa90f2a482, next savepoint version: 11955, last snapshot SP vers..