User Tools

Site Tools


development

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
development [2018-03-29 13:46] – mrksdevelopment [2022-07-28 08:24] (current) – mrks
Line 1: Line 1:
 ===== Development ===== ===== 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 ==== ==== 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: Set the default editor:
Line 39: Line 87:
  
  
-==== LDAP ==== +==== Database Schema Management ====
- +
-=== General information === +
- +
-  * DN: distinguished name +
-  * CN: common name +
-  * OU: organizational unit +
-  * 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://alembic.sqlalchemy.org/en/latest/|Alembic]] 
 +  * [[https://flywaydb.org/|Flyway]] 
 +  * [[https://www.liquibase.org/|Liquibase]]
  
-  - [[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.]] 
  
  
Line 74: Line 108:
  
 ^ Database ^ URL ^ ^ Database ^ URL ^
-| IBM DB2 | jdbc:db2://[HOST]:[PORT]/[DB] | +| IBM DB2 | <nowiki>jdbc:db2://[HOST]:[PORT]/[DB]</nowiki> | 
-| Microsoft SQL Server | jdbc:microsoft:sqlserver://[HOST]:[PORT](;DatabaseName=[DB]) | +| Microsoft SQL Server | <nowiki>jdbc:microsoft:sqlserver://[HOST]:[PORT](;DatabaseName=[DB])</nowiki> | 
-| MySQL | jdbc:mysql://[HOST]:[PORT]/[DB] |+| MySQL | <nowiki>jdbc:mysql://[HOST]:[PORT]/[DB]</nowiki> |
 | Oracle Thin | <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> | 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 | jdbc:postgresql://[HOST]:[PORT]/[DB] | +| PostgreSQL | <nowiki>jdbc:postgresql://[HOST]:[PORT]/[DB]</nowiki> | 
-| SQLite | jdbc:sqlite:sample.db |+| SQLite | <nowiki>jdbc:sqlite:sample.db</nowiki> |
  
development.1522323991.txt.gz · Last modified: (external edit)