go to post Evgeny Shvarov · Feb 23, 2022 Hi Peter! Thanks for sharing! BTW, do you want to publish your company on the Partner Directory?
go to post Evgeny Shvarov · Feb 23, 2022 Thanks for your hard work, @Robert Cemper ! but where’s your review on csvgen?)
go to post Evgeny Shvarov · Feb 23, 2022 @Sergey Mikhailenko - this is great! Could you please send a PR?
go to post Evgeny Shvarov · Feb 23, 2022 Updated the article with notes regarding the lowercase for classes: Package names are written in all lower case to avoid conflict with the names of classes or interfaces. So the full qualified name of the class is company.project.subpackage.TheClass.cls. The approach borrowed from the naming convention for java classes.
go to post Evgeny Shvarov · Feb 23, 2022 Thanks @Ben Spead ! How is this different from: USER>!<cmd line>
go to post Evgeny Shvarov · Feb 22, 2022 Thanks for the explanation, @Dan Pasco! Could you please explain why the size of indexes is reduced and why the queries are faster? Is it because of a shorter global name and path to the indexes? For a lot of developers who got used to the meaningful global names this random hash can be an issue when you want to examine the global values for the related class/table or to make direct changes to it programmatically.
go to post Evgeny Shvarov · Feb 22, 2022 Moreover, you can receive points and badges in Global Masters by completing the reviews.
go to post Evgeny Shvarov · Feb 22, 2022 It's not! Everyone is very welcome to review the apps. E.g. here you can provide a review for the ZPM Package manager.
go to post Evgeny Shvarov · Feb 22, 2022 Released a new version with @Alexey Maslov suggestion and two new one-liners, courtesy of @Sylvain Guilbaud
go to post Evgeny Shvarov · Feb 22, 2022 This is really cool, @Alexey Maslov ! Updated two one-liners with your suggestion!
go to post Evgeny Shvarov · Feb 21, 2022 Turned out, that this behavior can be adjusted by removing the Final clause from DDL generation via the following flag: set sc=$SYSTEM.SQL.Util.SetOption("DDLFinal",0,.oldval)
go to post Evgeny Shvarov · Feb 19, 2022 Just tried - it makes the global name not random but ClassD like. So for Sample.Person it is ^Sample.PersonD. Great life-hack, thanks @Sylvain Guilbaud !
go to post Evgeny Shvarov · Feb 16, 2022 It's not only for Eastern and Central Europe, @Ben Spead ! Any startup from any region is very welcome! The majority of activities will be online! Besides the Czech Republic, we already have applications from USA, UK, Netherlands, UAE, Ukraine and invite startups to apply!
go to post Evgeny Shvarov · Feb 14, 2022 If you need to export the result of SQL to CSV you can use csvgen lib. install csvgen: USER>zpm "install csvgen" Perform export: USER>set query="select * from your.classname" USER>w ##class(community.csvgen).SQLToCSV(";",1,"/folder/file.csv",query) 1