October 2019


01/10/2019

Sanal sunucuda basli basina bir Django projesi olusturup MySQL kurarak birbirine baglama, ayrica Apache sunucusu kurma gibi asamalari anlattigim bir .ipynb dosyasi hazirladim.
https://colab.research.google.com/drive/1eMibI3fa7TSIKLX9hpJX0k5xjB5xYpao

02/10/2019

MySQL Data Types:
https://colab.research.google.com/drive/1eMibI3fa7TSIKLX9hpJX0k5xjB5xYpao
SQL Data Types(MySQL is included):
https://www.w3schools.com/sql/sql_datatypes.asp

MySQL Tutorial website can be followed:
http://www.mysqltutorial.org/

How to Backup databases from Command Line:
https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/mysqldump-sql-format.html
How to Reload backups:
https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/reloading-sql-format-dumps.html

How to connect a virtual server remotely from MySQL Workbench:
1- https://www.digitalocean.com/community/questions/can-t-connect-to-mysql-server-on-ipaddress-10061
2- https://support.plesk.com/hc/en-us/articles/360005493133-Unable-to-register-remote-MySQL-server-Host-is-not-allowed-to-connect-to-this-MySQL-server

W3Schools SQL Tutorial'i bitirdim.
https://www.w3schools.com/sql/default.asp

07/10/2019

A simple ER Diagram explanation:
https://creately.com/blog/diagrams/er-diagrams-tutorial/

A simple Is-A Relationship writing:
https://chortle.ccsu.edu/java5/Notes/chap50/ch50_5.html

How to implement an Is-A Relationship:
https://stackoverflow.com/questions/4361381/how-do-we-implement-an-is-a-relationship

How to map an Is-A Relationship into a database:
https://dba.stackexchange.com/questions/5501/how-do-i-map-an-is-a-relationship-into-a-database

How to use .gitignore:
https://fatihhayrioglu.com/git-ogreniyorum-4/

How to use same Python Virtual Environment on Linux and Windows?
https://stackoverflow.com/questions/42733542/how-to-use-the-same-python-virtualenv-on-both-windows-and-linux

08/10/2019

Django Template Does not Exist
https://stackoverflow.com/questions/1926049/django-templatedoesnotexist

09/10/2019

Error when changing to master branch: my local changes would be overwritten by checkout
https://stackoverflow.com/questions/22424142/error-when-changing-to-master-branch-my-local-changes-would-be-overwritten-by-c

How come "git pull origin master" doesn't actually change the files in my computer's directory?
https://stackoverflow.com/questions/15371262/how-come-git-pull-origin-master-doesnt-actually-change-the-files-in-my-comput

What is the difference between origin and upstream on GitHub?
https://stackoverflow.com/questions/9257533/what-is-the-difference-between-origin-and-upstream-on-github/9257901#9257901

GitHub fork a repo:
https://help.github.com/en/articles/fork-a-repo

.gitignore linkleri:
https://git-scm.com/docs/gitignore

https://help.github.com/en/articles/ignoring-files

https://gist.github.com/octocat/9257657

10/10/2019

Not: .gitignore ile ilgili bir not.
- Eger bir dosya bir repoda bulunuyorsa ona .gitignore islemiyor.
- O yuzden .gitignore repository'e eklendikten sonra dosyayi eklemek gerekiyor.

Note: A note about .gitignore
- If there is a file in a repository, .gitignore doesn't effect it.
- So, that file must be added after its path has been added to .gitignore .

11/10/2019

How to define a variable in apache conf file?
https://stackoverflow.com/questions/6569080/how-to-define-a-variable-in-apaches-httpd-conf-file

How to serve static files on Django Admin?
https://stackoverflow.com/questions/23728366/django-admin-not-serving-static-files

14/10/2019

Qt

Signal and Slots:
Slot is an action according to the given Signal.

QMessageBox:
QMessageBox gives notification to the current user.

Layouts in Qt ( Horizontal, Vertical, Grid and Form ):
Horizontal Layout, Vertical Layout, Grid Layout
Form Layout is used to give shape to the elements to compose a form in a whole.

Spacers, Splitter, Buddy and Tabs:
Spacers are used when we want to give space to somewhere in layout.
Splitter provides changes on layout while end-user is using the application.
Buddy:
Tabs:

How to show another window from main window in Qt:

17/10/2019

How to configure DNS on Vultr:
https://serverpilot.io/docs/how-to-configure-dns-on-vultr

MySQL INSERT INTO SELECT statement:
https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-select-into-table.html

Python os.path.dirname :
https://stackoverflow.com/questions/38412495/difference-between-os-path-dirnameos-path-abspath-file-and-os-path-dirnam

18/10/2019

How do I map an IS-A relationship into a database?
https://dba.stackexchange.com/questions/5501/how-do-i-map-an-is-a-relationship-into-a-database


21/10/2019

Python istihza
https://belgeler.yazbel.com/python-istihza/

22/10/2019

How to see where Django is looking for your static files:
https://stackoverflow.com/questions/50825957/static-css-files-with-django-application-error

MySQL Workbench Tutorial by edureka
https://youtu.be/uKwR9fWsZJ4



25/10/2019

Qt Getting Started Url:
https://doc.qt.io/qt-5/gettingstarted.html

os.path module:
https://docs.python.org/3/library/os.path.html#module-os.path

Bash command output to the variable:
https://linuxhint.com/bash_command_output_variable/

Step-by-step Guidance to Build a Drone from Scratch using Ardupilot APM Navio2 Flight Controller
https://www.instructables.com/id/Step-by-step-Guidance-to-Build-a-Drone-From-Scratc/


30/10/2019

How to install QtCreator on Ubuntu 18.04?
https://www.lucidar.me/en/dev-c-cpp/how-to-install-qt-creator-on-ubuntu-18-04/

Unknown modules in Qt: multimedia
https://stackoverflow.com/questions/26948466/project-error-unknown-modules-in-qt-multimedia





31/10/2019

Django studies...














Yorumlar