Differences

This shows you the differences between two versions of the page.

--- development [2015-11-18 13:59] – mrks
+++ development [2022-07-28 08:24] (current) – mrks
@@ Line 1: / Line 1: @@
 ===== Development =====
+==== Tools ====
+  * Code editors
+    * Visual Studio Code
+    * Sublime Text
+    * Notepad++
+  * Visualization
+    * [[https://github.com/jgraph/drawio-desktop|draw.io Diagrams]]
+    * GraphViz
+    * Inkscape
+    * paint.net
+    * PlantUML
+  * Productivity
+    * AutoHotKey
+    * KeePass
+    * SysInternals
+    * VirtuaWin
+    * WinDirStat
+  * Misc
+    * ADExplorer
+    * Archi
+    * aws-cli
+    * dbeaver
+    * docutils (rst2html)
+    * [[https://git-scm.com|Git version control]]
+    * FoxitReader
+    * FreeFileSync
+    * kubectl
+    * PuTTY
+    * s3cmd
+    * WinSCP
+==== Visual Studio Code ====
+Extensions:
+  * Python (Microsoft)
+  * reStructuredText (LeXtudio Inc.)
+  * Rewrap (stkb)
 ==== Git ====
-Documentation online as well as downloadable as HTML, ePub, etc.: [[https://git-scm.com/doc|Pro Git]]
+Documentation and Best Practices:
+  * [[https://git-scm.com/book/en/v2|Git Book]] including downloads as HTML, ePub etc.
+  * [[https://www.atlassian.com/git/tutorials/comparing-workflows/gitflow-workflow|Gitflow Workflow by Atlassian]]
+  * [[https://chris.beams.io/posts/git-commit/|How to Write a Git Commit Message]]
+  * [[https://git-scm.com/docs/|Git Reference]]
 Set the default editor:
@@ Line 16: / Line 64: @@
 git log --decorate --graph --full-history --all --color --pretty=format:"%x1b[31m%h%x09%x1b[32m%d%x1b[0m%x20%s"
 </code>
+[[http://blog.kfish.org/2010/04/git-lola.html|Clean log information using git lola alias.]]
+Git global config:
+  * Linux: ~/.gitconfig
+  * Windows: %HOMEDRIVE%%HOMEPATH%\.gitconfig
 Show all diffs which were made between two commits in reverse order (ascending commit time) which is useful for code reviews:
@@ Line 29: / Line 84: @@
 </code>
+[[http://durdn.com/blog/2012/11/22/must-have-git-aliases-advanced-examples/|Useful Git aliases.]]
-===== LDAP =====
-==== General information ====
+==== Database Schema Management ====
+  * [[https://alembic.sqlalchemy.org/en/latest/|Alembic]]
+  * [[https://flywaydb.org/|Flyway]]
+  * [[https://www.liquibase.org/|Liquibase]]
+==== Windows ====
+Create .lnk files in batch:
+<code>
+powershell '$s=(New-Object -COM WScript.Shell).CreateShortcut("my_shortcut.lnk");$s.TargetPath="C:\my_path\to\some_file.txt";$s.Save()'
+</code>
-  * DN: distinguished name
-  * CN: common name
-  * OU: organizational unit
-  * DC: domain component
-==== Searches ====
+==== JDBC ====
-  * Search within base DN: <code>ldapsearch -h example.com -b "dc=wob,dc=vw,dc=vwg" "cn=MY_IDENTIFIER"</code>
-  * Search the whole database: <code>ldapsearch -h example.com "cn=MY_IDENTIFIER"</code>
-  * Search a host inside all Oracle TNS strings: <code>ldapsearch -h example.com "orclNetDescString=*HOST=database.tld*"</code>
-==== References ====
+^ Database ^ URL ^
+| IBM DB2 | <nowiki>jdbc:db2://[HOST]:[PORT]/[DB]</nowiki> |
+| Microsoft SQL Server | <nowiki>jdbc:microsoft:sqlserver://[HOST]:[PORT](;DatabaseName=[DB])</nowiki> |
+| MySQL | <nowiki>jdbc:mysql://[HOST]:[PORT]/[DB]</nowiki> |
+| Oracle Thin | <nowiki>
+jdbc:oracle:thin:@[HOST]:[PORT]:[SID]</nowiki> \\ <nowiki>jdbc:oracle:thin:@[HOST]:[PORT]/[SERVICE_NAME]</nowiki> \\ <nowiki>jdbc:oracle:thin:@ldap://[LDAP_URL]:[LDAP_PORT]:[SID],[CONTEXT_PATH]</nowiki> \\ <nowiki>jdbc:oracle:thin:@ldap://[LDAP_URL]:[LDAP_PORT]/[SERVICE_NAME],[CONTEXT_PATH] </nowiki> |
+| PostgreSQL | <nowiki>jdbc:postgresql://[HOST]:[PORT]/[DB]</nowiki> |
+| SQLite | <nowiki>jdbc:sqlite:sample.db</nowiki> |
-  - [[https://tools.ietf.org/search/rfc1558|RFC 1558: A String Representation of LDAP Search Filters]]
-  - [[https://en.wikipedia.org/w/index.php?title=LDAP_Data_Interchange_Format&oldid=661799172|Wikipedia contributors. "LDAP Data Interchange Format." Wikipedia, The Free Encyclopedia, 11 May. 2015. Web. 21 Oct. 2015.]]