go to post Dmitry Maslennikov · Nov 9, 2020 I've never faced with accents, so, not sure about this case. But I see many useful use cases for using slugify in SQL. But this feature looks more complex in realization. There are many realizations in many languages, but no standard at all. For the info, slug, slugify, translates string in any language to ASCII, URL compatible string. For instance, it would help to get a cost-effective, language-independent index, but with a quite correct order.
go to post Dmitry Maslennikov · Nov 9, 2020 Sorry, it's just for discussion, to see how people would do some simple task.
go to post Dmitry Maslennikov · Nov 9, 2020 For sure, you have good points, but some points just out of scope at all. Yes, it's limited anyway. My main point is to not have a limited number of parameters like below ClassMethod setValue(key1, key2, key3, key4, value) As %Status And I was just curious if the community knows how to deal with MultiDimensional property, in such a case.
go to post Dmitry Maslennikov · Nov 9, 2020 Yes, this is better, I would even use this s name=$name(%session.Data)
go to post Dmitry Maslennikov · Nov 9, 2020 Nope, still not what I mean, I have a better solution, just would like to see if the community will find it.
go to post Dmitry Maslennikov · Nov 9, 2020 Quite simple, but could be even better, with no useless quotations
go to post Dmitry Maslennikov · Nov 6, 2020 IRIS is a kind of replacement for Caché, which now no active development. So, while you are evaluating it, you should not look for Caché, and switch to IRIS.
go to post Dmitry Maslennikov · Nov 6, 2020 You can download these versions. Community Edition just has a few limitations, but still can be used. And look at the installation guides
go to post Dmitry Maslennikov · Nov 4, 2020 Are you sure that, your insert queries send null and not an empty string? Null and empty strings are different, what are you trying to achieve it's a null, and $c(0) is an empty string. Documentation
go to post Dmitry Maslennikov · Nov 3, 2020 Unfortunately, it does not fully support work with CSP files. If you use local instance, you can just open the folder with CSP files in VSCode, and edit them as any local file. If your server is remote, so, the only way right now is using virtual filesystem isfs.
go to post Dmitry Maslennikov · Nov 2, 2020 In VSCode you just had to open any local folder. And it's a manual choice. When you opened any folder, which is supposed to be as a project root. Configured the server connection, you then should be able to open ObjectScript Server Explorer (by InterSystems logo icon). There you can observe your code on the server, and do export from context menu. Export will be logged to ObjectScript output, with full path's of exported items. Go to File explorer in VSCode (default view), and from context menu on any folder or class, you will have action Import and compile.
go to post Dmitry Maslennikov · Oct 31, 2020 Extracting such amount of data with using JDBC/ODBC, will be much slower than any sort of native access in Cache. InterSystems Cache offers a way to export the whole table, with selected columns Open System Management Portal, System Explorer, SQL. Switch to the desired namespace. Click on Wizards and select Data Export The next steps should be pretty much simple, just select what you need to export and starts in the background. So, you will be able to control how it is going. Look at the documentation for more details
go to post Dmitry Maslennikov · Oct 30, 2020 Extract data could be quite tricky depending on how old is application there. If you sure that the desired data is available through SQL, so you can use any SQL tools, DataGrip, DBeaver, Squirrel-SQL. DBeaver already supports Cache out of the box, and very soon will support IRIS as well.
go to post Dmitry Maslennikov · Oct 30, 2020 What kind of editor do you need? What do you need to do with this editor?
go to post Dmitry Maslennikov · Oct 19, 2020 @Bob Kuszewski, what do you mean by better processes? What does it mean for jdbc driver or any other jar files, which have only one place where they supposed to be published is, maven central. Currently, InterSystems - JDBC and InterSystems XEP just contain empty files, which have to be deleted. JAR files here, just only 155 bytes in size or even less. https://repo1.maven.org/maven2/com/intersystems/intersystems-jdbc/3.0.0/ https://repo1.maven.org/maven2/com/intersystems/intersystems-jdbc/2018.1... https://repo1.maven.org/maven2/com/intersystems/intersystems-xep/2018.1....
go to post Dmitry Maslennikov · Oct 19, 2020 The most interesting, is why current files on maven central us completely useless? Just empty jar files.
go to post Dmitry Maslennikov · Oct 16, 2020 In chrome you can open developer console, switch to console tab, and copy an actual link in the latest error message.
go to post Dmitry Maslennikov · Oct 16, 2020 I can confirm that it happens due to changes in Google Chrome, it prevents downloading files from http:// when the site is opened as https://.
