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-06-14 13:48] – 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 ====
Line 45: 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 80: 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.1528976928.txt.gz · Last modified: (external edit)