Re: [sqlalchemy] chinook with sqlalchemy core

Or any sample database would e.g. northwind https://docs.devexpress.com/XtraReports/403995/product-information/sample-northwind-database Le mer. 12 avr. 2023 à 20:40, sumau a écrit : > Hello > > Is there a sqlalchemy core version of the chinook database >

Re: [sqlalchemy] IDLE vs checked in connection

Hello Mike Thanks for quick response as always :-) So I understand setting AUTOCOMMIT has no impact on the number of 'IDLE' connections and will look for different culprit. About the single row in pg_stat_activity, I was actually running the query below, but sent you the shortened version

Re: [sqlalchemy] compiler tutorial questions

t with all these suggestions (including the example you posted) :-) Regards Soumaya Le mer. 21 avr. 2021 à 16:19, Mike Bayer a écrit : > > > On Tue, Apr 20, 2021, at 10:08 AM, Soumaya Mauthoor wrote: > > Hello Mike > > Thanks for the quick response. Would you mind helpin

Re: [sqlalchemy] compiler tutorial questions

Hello Mike Thanks for the quick response. Would you mind helping me write a complete example? It would help me understand compilation better :-) I would also be happy to turn this into a merge request if you think other people will benefit from it? I have also converted this into a sqlite example

Re: [sqlalchemy] autocommit Transaction Isolation Level

TE TABLE", "INSERT", etc. This is called "library level autocommit", > it's deprecated and the whole thing is documented at > https://docs.sqlalchemy.org/en/14/core/connections.html#library-level-e-g-emulated-autocommit > > > > On Sun, Apr 4, 2021, at 1:47 PM, Soumay

Re: [sqlalchemy] autocommit Transaction Isolation Level

>> del c >>> c = create_engine('postgresql://***:***@localhost:5432/postgres').connect() >>> c.execute(text('select * from test')).fetchall() [] Thanks Soumaya Le jeu. 1 avr. 2021 à 18:33, Soumaya Mauthoor a écrit : > Ooooh I see thanks for clarifying :-) >

Re: [sqlalchemy] autocommit Transaction Isolation Level

Ooooh I see thanks for clarifying :-) Soumaya On Thu, 1 Apr 2021, 17:34 Mike Bayer, wrote: > > > On Thu, Apr 1, 2021, at 11:20 AM, Soumaya Mauthoor wrote: > > Hello Mike > > Thanks for quick response! I don't have postgres installed right now so I > tried with sqlite,

Re: [sqlalchemy] autocommit Transaction Isolation Level

Hello Mike Thanks for quick response! I don't have postgres installed right now so I tried with sqlite, which is also autocommit by default. Example: >>> from sqlalchemy import text, create_engine >>> e = create_engine('sqlite:///foo.db') >>> with e.connect() as conn: conn.execute(text('create

[sqlalchemy] Custom Compilation

Hello I have two uses cases: (1) drop cascade as option I know I can use custom compilation to add cascade for postgres databases using this example: https://stackoverflow.com/questions/38678336/sqlalchemy-how-to-implement-drop-table-cascade Is it possible to use custom compilation to add

Re: [sqlalchemy] Large RAM usage in bulk_insert_mappings

What did you use to profile memory usage? I've recently been investigating memory usage when loading data using memory_profiler and would be interested to find out about the best approach On Thu, 14 Nov 2019, 17:16 James Fennell, wrote: > Hi all, > > Just sharing some perf insights into the

Re: [sqlalchemy] TableProxy equivalent to RowProxies

With a dataframe you can do df.columns to get the column labels and df[["col1","col2"]] to extract column1 and column2 rowProxy has similar functionality as explained before However if I use s= fetchmany() I return a string and it's not possible to do the equivalent s.keys() and s["col1"]. On