a community of Powershell lovers, who are invested in making Atlassian product part of their Powershell life
Kategorie: Dev
Copy InterSystems IRIS JDBC Driver from Docker Container to local filesystem
docker cp my-iris:/usr/irissys/dev/java/lib/1.8/ e:\temp
https://docs.docker.com/engine/reference/commandline/cp/
https://docs.intersystems.com/
InterSystems IRIS and IRIS for Health 2021.2 preview: https://community.intersystems.com/post/intersystems-iris-and-iris-health-20212-preview-published
2021.2 LOAD DATA
LOAD DATA FROM FILE filepath
[ COLUMNS (fieldname datatype,
fieldname2 datatype2, ...) ]
INTO table [ (fieldname, fieldname2, ...)
[ VALUES (headeritem,headeritem2, ...) ] ]
[ USING {json_object} ]
LOAD DATA FROM JDBC connection TABLE jtable
INTO table [ (fieldname, fieldname2, ...)
[ VALUES (jfieldname,jfieldname2, ...) ] ]https://irisdocs.intersystems.com/iris20212/csp/docbook/DocBook.UI.Page.cls?KEY=RSQL_loaddata
Two example repositories using LOAD DATA:
- https://github.com/bdeboe/isc-tpch-script
- https://github.com/bdeboe/isc-adventureworks (using the DWH flavour of this well-known dataset only)
Fail fast\fail early
Fail-Fast (sinngemäß „schneller Abbruch“) bezeichnet die Eigenschaft eines Systems, Fehler frühzeitig zu erkennen. Ein Fail-Fast-System ist so konzipiert, dass es an seinen Schnittstellen Fehler oder Zustände, die zu Fehlern führen, erkennt und aufzeigt. Üblicherweise beenden sich Fail-Fast-Systeme im Fehlerfall selbst und versuchen nicht, mit dem Fehler weiterzuarbeiten
https://de.wikipedia.org/wiki/Fail-Fast
Why do computers stop and what can be done about it?
by Jim Gray
Manage Dataset Using Apache Drill – Set up Your Data Analytic Environment
The beauty of Apache Drill is that you do not need any overhead of traditional SQL database server. Just save your dataset using parquet data format then query your dataset by just pointing to it using SQL, just like any SQL database table or SAS datasets.
https://towardsdatascience.com/organize-dataset-using-apache-drill-ecdb58a19139
IntelliJ Platform UIkit
Big Data, SQL engines
https://github.com/apache/zeppelin
Trino is a highly parallel and distributed query engine, that is built from the ground up for efficient, low latency analytics.
Apache Commons CSV
Commons CSV reads and writes files in variations of the Comma Separated Value (CSV) format.
The most common CSV formats are predefined in the CSVFormat class:
- Microsoft Excel
- Informix UNLOAD
- Informix UNLOAD CSV
- MySQL
- Oracle
- PostgreSQL CSV
- PostgreSQL Text
- RFC 4180
- TDF
Custom formats can be created using a fluent style API.
SQL Server- how to add a user as sysadmin without using SSMS
sqlcmd -S .\sql-instance -q "exec sp_addsrvrolemember
'machin-name\windows-user', 'sysadmin'"Details: https://thecodehttps://thecodeblogger.com/2019/01/09/sql-server-how-to-add-a-user-as-sysadmin-without-using-ssms/
Download java from oracle without login \ oracle account
Java SE 8u291 is the latest release for the Java SE 8 Platform
Java SE Development Kit 8u291
Windows x64
https://download.oracle.com/otn-pub/java/jdk/8u291-b10/d7fc238d0cbf4b0dac67be84580cfb4b/jdk-8u291-windows-x64.exe
Java SE Development Kit 11.0.11
Windows x64 Installer
https://download.oracle.com/otn-pub/java/jdk/11.0.11%2B9/ab2da78f32ed489abb3ff52fd0a02b1c/jdk-11.0.11_windows-x64_bin.exe
Windows x64 Compressed Archive
https://download.oracle.com/otn-pub/java/jdk/11.0.11%2B9/ab2da78f32ed489abb3ff52fd0a02b1c/jdk-11.0.11_windows-x64_bin.zip
Java SE Development Kit 16.0.1
Windows x64 Installer
https://download.oracle.com/otn-pub/java/jdk/16.0.1+9/7147401fd7354114ac51ef3e1328291f/jdk-16.0.1_windows-x64_bin.exe
Windows x64 Compressed Archive
https://download.oracle.com/otn-pub/java/jdk/16.0.1+9/7147401fd7354114ac51ef3e1328291f/jdk-16.0.1_windows-x64_bin.zip
To download any JRE or JDK from the Oracle download page without signing in, go to the downloads page for the version you want (such as https://www.oracle.com/java/technologies/javase-downloads.html) and click on the Download link of your choice.
https://gist.github.com/wavezhang/ba8425f24a968ec9b2a8619d7c2d86a6
When a window pops up saying you need to accept the license agreement, check the box that says you agree. But instead of clicking on the green Download link (which will send you to the login page), right-click the download link and select Copy Link Location.
NOTE: If clicking Download doesn’t show a box and takes you straight to the login page instead, you will need to clear your cookies on the Java website (or open in incognito mode). Paste the copied link into a text editor like Notepad. You’ll see the link points to something like oracle.com/webapps/redirect/signon, but it has a query attached that starts with „nexturl=“. The URL that follows nexturl= is the actual link that will download the file to your computer.
If you want to download any JRE or JDK without signing into Oracle, go to the downloads page for the version you want (such as https://www.oracle.com/java/technologies/jdk12-downloads.html) and right-click on the Download link of your choice. Select „Copy Link Location“ and then paste it into a text editor like Notepad.
NOTE: you may need to change the otn in the path to otn-pub as described below.