Differences

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

--- development [2018-01-03 14:33] – 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 36: / 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 ====
-  * DN: distinguished name
+  * [[https://alembic.sqlalchemy.org/en/latest/|Alembic]]
-  * CN: common name
+  * [[https://flywaydb.org/|Flyway]]
-  * OU: organizational unit
+  * [[https://www.liquibase.org/|Liquibase]]
-  * DC: domain component
-=== Searches ===
-  * Search within base DN: <code>ldapsearch -h example.com -b ",dc=example,dc=com" "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 ===
-  - [[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.]]
 ==== Windows ====
@@ Line 64: / Line 102: @@
 powershell '$s=(New-Object -COM WScript.Shell).CreateShortcut("my_shortcut.lnk");$s.TargetPath="C:\my_path\to\some_file.txt";$s.Save()'
 </code>
+==== JDBC ====
+^ 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> |