go to post Dmitry Maslennikov · Apr 3, 2023 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
go to post Dmitry Maslennikov · Apr 3, 2023 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.
go to post Dmitry Maslennikov · Apr 3, 2023 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
go to post Dmitry Maslennikov · Apr 3, 2023 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)
go to post Dmitry Maslennikov · Mar 29, 2023 Squirrel actually already has a driver definition for Caché and IRIS out of the boxAnd DBeaver has this ability too
go to post Dmitry Maslennikov · Mar 29, 2023 Could you update the article and extract the tutorial out of pdf?
go to post Dmitry Maslennikov · Mar 28, 2023 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.
go to post Dmitry Maslennikov · Mar 24, 2023 Have a look at some of my projects which can help with this contest irissqlcli - REPL for IRIS SQL sqlalchemy-iris dialect for SQLAlchemy, can be used with Pandas, Flask or FastAPI django-iris driver for Django dbt-iris adapter for dbt Give it a try and let me know if you have any issues with them, I can help to solve
go to post Dmitry Maslennikov · Mar 22, 2023 Well, it’s not so old, it is definitely supports SourceControl class
go to post Dmitry Maslennikov · Mar 20, 2023 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.
go to post Dmitry Maslennikov · Mar 20, 2023 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.
go to post Dmitry Maslennikov · Mar 20, 2023 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
go to post Dmitry Maslennikov · Mar 17, 2023 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
go to post Dmitry Maslennikov · Mar 17, 2023 It’s actually in process now, to be implemented, should be available soon
go to post Dmitry Maslennikov · Mar 17, 2023 I have tool for it, but it requires full authorization https://github.com/caretdev/iscctl
