Hello guys The documentation says to initialize a connection and create cursors and then use them to execute queries and fetch data. Can multiple cursors been created and do jobs parallel? Or is there another approach to parallelize executing queries? Thanks for your help! Regards Schabi

[image] SchabiDesigns: I also took a look into st.connection and there is also a youtube-video how to add a connection to any database, but not sure how it has to be done :face_with_peeking_eye: Actually it “simply works” when adding sqlalchemy-cratedb to your requirements.txt and specifying …

Hi @SchabiDesigns The crate-python library is thread-safe only at the module level, not at the connection or cursor level. Additionally, since the DB API lacks an asynchronous specification, it does not yet support executing queries asynchronously. To use crate-python in parallel, you must open mul…

Thanks for your help @proddata The documentation helped me to fetch some data from the database. How would you establish a pool feature from the asyncpg package? Some Background: I use streamlit in combination with crateDB. streamlit provide some drivers for different database solutions . I would…

Dear Schabi, [image] SchabiDesigns: The documentation helped me to fetch some data from the database. Excellent. Thanks. Please let us know any time where details can be improved. [image] SchabiDesigns: How would you establish a pool feature from the asyncpg package? Sorry for not di…

Thanks @amotl Documentation is good like it is :slight_smile: I also managed to use the pool feature from the asyncpg package, which wasn’t a big deal. Nice to hear that you would like to have crateDB working with streamlit. :star_struck: I tried the PostgreSQL database adapter you mentioned befo…

Hi again, [image] SchabiDesigns: I tried the PostgreSQL database adapter you mentioned before, but faced some errors, [effectively conveying back]: mismatched input 'ROLLBACK' Thank you for sharing your outcome. This error message usually indicates some other error happened where CrateDB do…

@proddata was so kind to whip up a quick example at GitHub - proddata/streamlit-cratedb . It looks like it validates that CrateDB is able to work successfully with Streamlit. You may want to exercise this application and maybe start from there when applicable? However, I also admit it does not exact…

Thanks for your help Georg and Andreas! Not sure if I should split this topic and if how it should be done… There are kind of 2 problems and 2 solutions :slight_smile:

Hi again. [image] SchabiDesigns: Thanks for your help Georg and Andreas! You are welcome. Please ask further questions any time. Based on your suggestions, and @proddata ’s investigations, we added those two resources to our documentation and code snippets. Using Programming Frameworks with…

[image] proddata: # .streamlit/secrets.toml [connections.cratedb] dialect = "crate" host = "localhost" port = "4200" username = "crate" password = "" Hi Georg, do you know how to add multiple hosts so that a kind of load balancer is in place? Or do I need to setup a load balancer manually …

I think connection() takes kwargs** and sqlalchemy-cratedb supports a servers argument, but I am not sure how they need to be provided. Maybe @amotl knows :grimacing: crate/sqlalchemy-cratedb/blob/6db47020b59b3a07257a487e9fe3a8a4e4b9e76a/src/sqlalchemy_cratedb/dialect.py#L212 …

Python crate using multiple cursors parallel

Integrations Client Libraries

surister September 12, 2024, 7:40am 18

Topic		Replies	Views
How to connect NpgsqlDatabaseInfo for crate database in C# CrateDB	22	4576	June 10, 2021
Fetching large result sets from CrateDB Tutorials sql , fundamentals	0	1838	October 31, 2022
About the Integrations category Integrations	0	882	November 26, 2018
Access crate via HTTP or via PostgreSQL CrateDB	1	1164	May 31, 2020
Load testing CrateDB using Locust Tutorials	5	1204	August 13, 2025

Python crate using multiple cursors parallel

Related topics