All
Accepted answers
Dmitry Maslennikov · Apr 3, 2023 go to post

The issue is in quotes, try some other combination. Your whole call in single quotes, then you don't need to escape double quotes inside

Dmitry Maslennikov · Apr 3, 2023 go to post

Python WON

One of the winner's articles uses my project SQLAlchemy-IRIS. And one more could use it too, and there is an example with it in the comments.

Dmitry Maslennikov · Apr 3, 2023 go to post

You can do this query

SELECT TABLE_SCHEMA, TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES                   
WHERE TABLE_TYPE='BASE TABLE'

Filter by TABLE_TYPE is to get rid of system tables

Dmitry Maslennikov · Apr 3, 2023 go to post

Example of using SQLAlchemy+Pandas, works with this Cloud SQL as well

from sqlalchemy import create_engine
import pandas as pd

server = '<your-server-hostname>'
port = 1972
namespace = 'USER'
username = 'SQLAdmin'
password = '<YOUR_PASSWORD>'

url = f"iris://{username}:{password}@{server}:{port}/{namespace}"
print(url)
engine = create_engine(url)

df = pd.DataFrame({
    'int': [1, 2, 3, 4, 5],
    'float': [1.1, 2.2, 3.3, 4.4, 5.5],
    'string': ['a', 'b', 'c', 'd', 'e'],
    'datetime': pd.date_range('20130101', periods=5),
    'bool': [True, False, True, False, True]
})

# create a table in IRIS
df.to_sql('iris_table', engine, if_exists='replace', schema='sqlalchemy')

# read the table back from IRIS 
df2 =  pd.read_sql_table('iris_table', engine, schema='sqlalchemy')
# print the dataframe
print(df2)
Dmitry Maslennikov · Mar 29, 2023 go to post

Squirrel actually already has a driver definition for Caché and IRIS out of the box
And DBeaver has this ability too

Dmitry Maslennikov · Mar 28, 2023 go to post

Yeah, the VSCode plugin has not been updated for a while. The ObjectScriptQuality plugin itself already has new ARM64 support. We'll check and update the extension soon.

Dmitry Maslennikov · Mar 20, 2023 go to post

Is it really the reading file taking so much time or using $piece on the line and setting it to global too?

There are various things here that may slow you, even $increment (best to be replaced by i+1)

You can also split the reading file and set it to global by two parts, and use $sortbegin 

Try to run your code with %SYS.MONLBL started, it will help you understand where it spends more time.

Dmitry Maslennikov · Mar 20, 2023 go to post

Sorry, but it is the most horrible way to do it.

too old-school, the code has been outdated for many years. Dots syntax in 2023, seriously?

Projections are definitely not a way to solve it and did not get why they were even considered here

The best way to go is using %Studio.SourceControl, there are a lot of examples, and even some are out of the box already.

And most modern way now is to switch from Studio to VSCode, and to local-side development. So, all your classes will always be as files and can be synced to the git repository.

Dmitry Maslennikov · Mar 20, 2023 go to post

You may slow a bit your process, to leave some process time to other processes.

to do so, you would need to use hang command, somewhere in the loop, with some small value such as 0.1 seconds, and depends how fast is your process may do it once per 100 iterations or more

Dmitry Maslennikov · Mar 17, 2023 go to post

I’m not a fun of using LOAD DATA, it’s not complete, there are some things required to be kept in mind.

now I would recommend to look at dbt tool, which has support for IRIS, and may probably support older versions too, and it works with CSV quite easy, and can create table for you as well. Have a look, and let me know if you have any issues with it. I can fix bugs in IRIS support, if you find any. For IRIS you would need use dbt-iris package 

Dmitry Maslennikov · Mar 16, 2023 go to post

Not sure why you think, that the IP is wrong. And probably it's the Windows thing and WSL

But, I use this way a lot of time, when I need to access from some docker container, some another service running locally, or another docker container not connected to the same network, and it works fine. This address is supposed to be used only from the container, it should not show the real IP address of the host. If you wish to show some URL, which will be available outside of the container, obviously it will not help.

Dmitry Maslennikov · Mar 15, 2023 go to post

Your issue with screen formatting is very interesting, it deserves a separate topic. I have not seen any issues yet with it. While I’d like to find a way to improve a standard IRIS terminal, like irissqlcli, I’d like to see the most challenging parts like this.

webTerminal obviously not a right tool for it. As a replacement for it, you can try to use ttyd, I use it for irissqlcli-web

Dmitry Maslennikov · Mar 14, 2023 go to post

It may happen when upgrade from quite old version of zpm. Could you confirm that, if you have old version already installed. In that case, try to manually delete %ZPM package and install again 

Dmitry Maslennikov · Mar 1, 2023 go to post

well, then I would check the %session.SessionId, is it the same or not?

I did not work much with sessions last time. And most of my experience with using %session.Data was in a project where we used %session.Preserve=1. But I can't recommend using this way, it may cause many other issues from my experience.

Dmitry Maslennikov · Mar 1, 2023 go to post

First of all you have to check if it's a different Web Applications, then the Cookie path has to be the same for both.

If not, it will mean two separate applications with a separate session.

Dmitry Maslennikov · Feb 23, 2023 go to post

Go to Security, Web Applications, select /csp/user, which is default app for the USER namespace, or if you need it for another namespace, find default web application for that namespace. And check Analytics there, and save

Dmitry Maslennikov · Feb 22, 2023 go to post

You can use whatever you want, just remember about some caveats, like issue with bitslice/bitmap indexes, which requires numerical ID

I would recommend using just a Unique Index for the UUID field and use it, it should cover most of the needs.