Good afternoon, Connect Engine the coolest thing! It allowed the local file to be turned into a table! And also many other things allow. Thank you very much for this addition!
I use Windows 10.
And can I just use your DLL file, ie how do I understand just copy it to a specific folder MariaDB, or should I do some more preparatory work?
I would just test on the example of Apache Solr
Looking ahead, Apache Solr has the ability of BASIC AUTHENTICATION, specifically its anyway have to use, at least to protect from an outside of the index, is it possible your method is also to use it. I all these details REST authorization not know, in your example,or rather from Open Weather there is issued a TOKEN, and Apache Solr, I do not remember such possibility, there's just a pair of USERNAME/PASSWORD
Strelkov Andrey
added a comment - I use Windows 10.
And can I just use your DLL file, ie how do I understand just copy it to a specific folder MariaDB, or should I do some more preparatory work?
I would just test on the example of Apache Solr
Looking ahead, Apache Solr has the ability of BASIC AUTHENTICATION, specifically its anyway have to use, at least to protect from an outside of the index, is it possible your method is also to use it. I all these details REST authorization not know, in your example,or rather from Open Weather there is issued a TOKEN, and Apache Solr, I do not remember such possibility, there's just a pair of USERNAME/PASSWORD
When I tried it I realized that I did not have vcpkg and I had to install it from https://github.com/Microsoft/vcpkg
These sites explain how to get and install the packages. When installing cpprestsdk (Casablanca) one step install a lot of boost utilities and this can last almost half an hour.
In addition, I had to add the path of where the Casablanca DLLs have been loaded in the PATH environment variable and restart my system.
Then you must compile the EOM module. I cannot just send you mine because it was compiled and linked against my own version of CONNECT. By the way I was obliged to fix a few bug in CONNECT to have discovery working. But with another version, it should work but without discovery, meaning you would have to define manually the table columns. This can be done with Visual Studio if you know how to use it. The issue is that the compilation and link is done against the ha_connect.lib library that is now distributed with MariaDB and should be found in the Plugin directory.
Perhaps I can do this for you if you upload and attach here your ha_connect.lib file of your present distribution (by the way tell me what version of MariaDB you are using) If so, I will be able to send you the pre-compiled EOM module (DLL)
Olivier Bertrand
added a comment - - edited I also use Windows 10 however, it's not so simple:
You must install the Microsoft Casablanca support that my OEM module uses. This is described in https://github.com/Microsoft/cpprestsdk and for Windows do:
vcpkg install cpprestsdk cpprestsdk:x64-windows
(assuming you have a 64 bits machine)
When I tried it I realized that I did not have vcpkg and I had to install it from https://github.com/Microsoft/vcpkg
These sites explain how to get and install the packages. When installing cpprestsdk (Casablanca) one step install a lot of boost utilities and this can last almost half an hour.
In addition, I had to add the path of where the Casablanca DLLs have been loaded in the PATH environment variable and restart my system.
Then you must compile the EOM module. I cannot just send you mine because it was compiled and linked against my own version of CONNECT. By the way I was obliged to fix a few bug in CONNECT to have discovery working. But with another version, it should work but without discovery, meaning you would have to define manually the table columns. This can be done with Visual Studio if you know how to use it. The issue is that the compilation and link is done against the ha_connect.lib library that is now distributed with MariaDB and should be found in the Plugin directory.
Perhaps I can do this for you if you upload and attach here your ha_connect.lib file of your present distribution (by the way tell me what version of MariaDB you are using) If so, I will be able to send you the pre-compiled EOM module (DLL)
Good day, Olivier!
I tried at myself to make all this (to establish, compile, etc.) but unfortunately nothing turned out. Can I ask you to compile=) I have version 10.3.9
Strelkov Andrey
added a comment - - edited Good day, Olivier!
I tried at myself to make all this (to establish, compile, etc.) but unfortunately nothing turned out. Can I ask you to compile=) I have version 10.3.9
Of course you cannot compile, you do not have the source code of the OEM module!
So I have installed MariaDB 10.3.9 and compiled the module. I have uploaded it here and a Readme.txt file explaining how to use it.
Let me know about failure or success!
Olivier Bertrand
added a comment - Of course you cannot compile, you do not have the source code of the OEM module!
So I have installed MariaDB 10.3.9 and compiled the module. I have uploaded it here and a Readme.txt file explaining how to use it.
Let me know about failure or success!
The REST requests are now implemented in CONNECT and allow you to create tables based on web APIs, without even describing the columns.
Julien Fritsch
added a comment - bertrandop told me that:
The REST requests are now implemented in CONNECT and allow you to create tables based on web APIs, without even describing the columns.
People
Olivier Bertrand
Strelkov Andrey
Votes:
2Vote for this issue
Watchers:
5Start watching this issue
Dates
Created:
Updated:
Git Integration
Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.
[{"id":-1,"name":"My open issues","jql":"assignee = currentUser() AND resolution = Unresolved order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":true},{"id":-2,"name":"Reported by me","jql":"reporter = currentUser() order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":true},{"id":-4,"name":"All issues","jql":"order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-5,"name":"Open issues","jql":"resolution = Unresolved order by priority DESC,updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-9,"name":"Done issues","jql":"statusCategory = Done order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-3,"name":"Viewed recently","jql":"issuekey in issueHistory() order by lastViewed DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-6,"name":"Created recently","jql":"created >= -1w order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-7,"name":"Resolved recently","jql":"resolutiondate >= -1w order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-8,"name":"Updated recently","jql":"updated >= -1w order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false}]
0.3
0
{"report":{"fcp":880.0999999046326,"ttfb":226.59999990463257,"pageVisibility":"visible","key":"jira.issue.nav-detail","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"51e5aa18-bc70-4ab5-8a46-619c479ce457","navigationType":0,"readyForUser":1695.5999999046326,"redirectCount":0,"resourceLoadedEnd":657.5,"resourceLoadedStart":234.30000019073486,"resourceTiming":[{"duration":44.59999990463257,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":234.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":234.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":278.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":44.69999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/1478ee9518804fac4b35845dc4ce556a-CDN/lu2cib/820016/12ta74/97a9a6b13407d4702f4a258757d43f81/_/download/contextbatch/css/jira.view.issue,viewissue.standalone,jira.navigator.kickass,jira.general,jira.global,jira.navigator,atl.general,jira.navigator.simple,jira.navigator.advanced,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":234.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":234.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":279.19999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":45,"initiatorType":"link","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/3.0.4/_/download/batch/com.atlassian.jira.jira-tzdetect-plugin:tzdetect-banner-component/com.atlassian.jira.jira-tzdetect-plugin:tzdetect-banner-component.css","startTime":234.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":234.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":279.69999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":44.89999961853027,"initiatorType":"link","name":"https://jira.mariadb.org/s/a7c82c2f9b4c8fd63530eb9f2a1d712a-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.filter.deletion.warning:styles/jira.filter.deletion.warning:styles.css","startTime":234.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":234.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":279.69999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":172.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":235,"connectEnd":235,"connectStart":235,"domainLookupEnd":235,"domainLookupStart":235,"fetchStart":235,"redirectEnd":0,"redirectStart":0,"requestStart":282.40000009536743,"responseEnd":407.69999980926514,"responseStart":295.80000019073486,"secureConnectionStart":235},{"duration":211,"initiatorType":"script","name":"https://jira.mariadb.org/s/3e25a0b0c47560558d0a6707b047e06f-CDN/lu2cib/820016/12ta74/97a9a6b13407d4702f4a258757d43f81/_/download/contextbatch/js/jira.view.issue,viewissue.standalone,jira.navigator.kickass,jira.general,jira.global,jira.navigator,atl.general,jira.navigator.simple,jira.navigator.advanced,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":235.19999980926514,"connectEnd":235.19999980926514,"connectStart":235.19999980926514,"domainLookupEnd":235.19999980926514,"domainLookupStart":235.19999980926514,"fetchStart":235.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":286,"responseEnd":446.19999980926514,"responseStart":302.59999990463257,"secureConnectionStart":235.19999980926514},{"duration":73.39999961853027,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":235.30000019073486,"connectEnd":235.30000019073486,"connectStart":235.30000019073486,"domainLookupEnd":235.30000019073486,"domainLookupStart":235.30000019073486,"fetchStart":235.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":286.09999990463257,"responseEnd":308.69999980926514,"responseStart":306.59999990463257,"secureConnectionStart":235.30000019073486},{"duration":76.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/aa6a6199803063cf5eed6122dfa3f13b-CDN/lu2cib/820016/12ta74/3.0.4/_/download/batch/com.atlassian.jira.jira-tzdetect-plugin:tzdetect-banner-component/com.atlassian.jira.jira-tzdetect-plugin:tzdetect-banner-component.js?locale=en","startTime":235.59999990463257,"connectEnd":235.59999990463257,"connectStart":235.59999990463257,"domainLookupEnd":235.59999990463257,"domainLookupStart":235.59999990463257,"fetchStart":235.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":286.5,"responseEnd":311.69999980926514,"responseStart":307.19999980926514,"secureConnectionStart":235.59999990463257},{"duration":76,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/3.0.4/_/download/batch/com.atlassian.jira.jira-tzdetect-plugin:tzdetect-lib/com.atlassian.jira.jira-tzdetect-plugin:tzdetect-lib.js","startTime":235.80000019073486,"connectEnd":235.80000019073486,"connectStart":235.80000019073486,"domainLookupEnd":235.80000019073486,"domainLookupStart":235.80000019073486,"fetchStart":235.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":287.09999990463257,"responseEnd":311.80000019073486,"responseStart":308.90000009536743,"secureConnectionStart":235.80000019073486},{"duration":76.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":236,"connectEnd":236,"connectStart":236,"domainLookupEnd":236,"domainLookupStart":236,"fetchStart":236,"redirectEnd":0,"redirectStart":0,"requestStart":287.90000009536743,"responseEnd":312.09999990463257,"responseStart":309.40000009536743,"secureConnectionStart":236},{"duration":76.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":236.09999990463257,"connectEnd":236.09999990463257,"connectStart":236.09999990463257,"domainLookupEnd":236.09999990463257,"domainLookupStart":236.09999990463257,"fetchStart":236.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":288.30000019073486,"responseEnd":312.90000009536743,"responseStart":310.40000009536743,"secureConnectionStart":236.09999990463257},{"duration":51.299999713897705,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":236.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":236.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":287.59999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":78.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":236.40000009536743,"connectEnd":236.40000009536743,"connectStart":236.40000009536743,"domainLookupEnd":236.40000009536743,"domainLookupStart":236.40000009536743,"fetchStart":236.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":289.69999980926514,"responseEnd":314.5,"responseStart":310.80000019073486,"secureConnectionStart":236.40000009536743},{"duration":196.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":241.30000019073486,"connectEnd":241.30000019073486,"connectStart":241.30000019073486,"domainLookupEnd":241.30000019073486,"domainLookupStart":241.30000019073486,"fetchStart":241.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":292.80000019073486,"responseEnd":437.80000019073486,"responseStart":436.69999980926514,"secureConnectionStart":241.30000019073486},{"duration":416,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":241.5,"connectEnd":241.5,"connectStart":241.5,"domainLookupEnd":241.5,"domainLookupStart":241.5,"fetchStart":241.5,"redirectEnd":0,"redirectStart":0,"requestStart":558.8000001907349,"responseEnd":657.5,"responseStart":654.6999998092651,"secureConnectionStart":241.5},{"duration":424.80000019073486,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":634.5,"connectEnd":634.5,"connectStart":634.5,"domainLookupEnd":634.5,"domainLookupStart":634.5,"fetchStart":634.5,"redirectEnd":0,"redirectStart":0,"requestStart":1026.9000000953674,"responseEnd":1059.3000001907349,"responseStart":1058.6999998092651,"secureConnectionStart":634.5},{"duration":330.5,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":866.3000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":866.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1196.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":456.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/api/2/filter/favourite?expand=subscriptions[-5:]&_=1743512229729","startTime":985.1999998092651,"connectEnd":985.1999998092651,"connectStart":985.1999998092651,"domainLookupEnd":985.1999998092651,"domainLookupStart":985.1999998092651,"fetchStart":985.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":1416.5999999046326,"responseEnd":1441.6999998092651,"responseStart":1441,"secureConnectionStart":985.1999998092651},{"duration":588.6999998092651,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/issueNav/latest/preferredSearchLayout","startTime":1048.5,"connectEnd":1048.5,"connectStart":1048.5,"domainLookupEnd":1048.5,"domainLookupStart":1048.5,"fetchStart":1048.5,"redirectEnd":0,"redirectStart":0,"requestStart":1610.9000000953674,"responseEnd":1637.1999998092651,"responseStart":1636.8000001907349,"secureConnectionStart":1048.5},{"duration":552.6999998092651,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/issueNav/1/issueTable/stable","startTime":1095,"connectEnd":1095,"connectStart":1095,"domainLookupEnd":1095,"domainLookupStart":1095,"fetchStart":1095,"redirectEnd":0,"redirectStart":0,"requestStart":1611.5,"responseEnd":1647.6999998092651,"responseStart":1646.9000000953674,"secureConnectionStart":1095},{"duration":534.4000000953674,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/menu/latest/appswitcher?_=1743512229730","startTime":1102.1999998092651,"connectEnd":1102.1999998092651,"connectStart":1102.1999998092651,"domainLookupEnd":1102.1999998092651,"domainLookupStart":1102.1999998092651,"fetchStart":1102.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":1611.6999998092651,"responseEnd":1636.5999999046326,"responseStart":1635.5,"secureConnectionStart":1102.1999998092651}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":55,"responseStart":227,"responseEnd":238,"domLoading":230,"domInteractive":946,"domContentLoadedEventStart":946,"domContentLoadedEventEnd":1125,"domComplete":2060,"loadEventStart":2060,"loadEventEnd":2061,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"6b344b9310af4e","effectiveType":"4g","downlink":9.8,"rtt":0,"serverDuration":104,"dbConnsTimeInMs":7,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
I use Windows 10.
And can I just use your DLL file, ie how do I understand just copy it to a specific folder MariaDB, or should I do some more preparatory work?
I would just test on the example of Apache Solr
Looking ahead, Apache Solr has the ability of BASIC AUTHENTICATION, specifically its anyway have to use, at least to protect from an outside of the index, is it possible your method is also to use it. I all these details REST authorization not know, in your example,or rather from Open Weather there is issued a TOKEN, and Apache Solr, I do not remember such possibility, there's just a pair of USERNAME/PASSWORD