Re: [sqlalchemy] Cannot insert strings with a length greater than 2000 into columns with a datatype of Text, VARCHAR, or NVARCHAR using MS SQL Server 2017 and 2019

2020-10-17 Thread Varun Madiath
I just want to comment that I have used pyodbc with Exasol before, so there is at least once other ODBC driver that is used in conjunction with pyodbc. However I later switched to using turbodbc since the performance was much better that with pyodbc, so maybe Mike is right about the real world use

Re: [sqlalchemy] Distinct within group by query

2019-09-04 Thread Varun Madiath
What database are you using? Some databases might support this natively, others would have to be emulated by the ORM. I’m not a big user of the ORM, so someone else would have to help you with that. If you’re using Postgres, then the array_agg function on the color column will give you exactly

Re: [sqlalchemy] Distinct within group by query

2019-09-04 Thread Varun Madiath
Just so I understand what you're asking? You want the minimum price per product (across all colors), as well as the list of colors? A result set looking something like this? | Attribute | Min Price | Colors | |---|---|--| | Attr_1| 10|

Re: [sqlalchemy] How to best integrate executing against a pandas dataframe in a custom dialect.

2019-08-29 Thread Varun Madiath
Hi Mike. Thank you for taking the time to respond. Responses inline On Thu, Aug 29, 2019 at 10:35 AM Mike Bayer wrote: > > hi there, responses inline > > On Wed, Aug 28, 2019, at 11:39 PM, Varun Madiath wrote: > > Hi. > > I'm working to extend the Turbodbc > <http

[sqlalchemy] How to best integrate executing against a pandas dataframe in a custom dialect.

2019-08-28 Thread Varun Madiath
e a lot more work to get that working seamlessly across the execution and core levels of SqlAlchemy, and I'm not even sure if it's possible. I appreciate any feedback you might have. Finally, I'd also like to thank everyone here for a wonderful product. I don't use the ORM much, but I really love