Re: [sqlalchemy] MySQL default driver for python3

2019-03-14 Thread 'Van Klaveren, Brian N.' via sqlalchemy
Hi Tomek, You actually want mysqlclient, which is the maintained fork of mysqldb: https://pypi.org/project/mysqlclient/ Brian On Mar 14, 2019, at 7:41 AM, Tomek Rożen mailto:tomek.ro...@gmail.com>> wrote: Hi, 'mysqldb' is the default driver, however it does not support python3. Any chance

Re: [sqlalchemy] Re: Security Implications of Directly Executing Queries Compiled to Strings

2019-03-08 Thread 'Van Klaveren, Brian N.' via sqlalchemy
As has been said, if you are generating the SQL, you will be fine so long as you use parameters and no blind string interpolation. This isn't really any different that any other API in that regard - obviously you don't want to allow a non-substituted first name field of the form `'; DROP TABLE

[sqlalchemy] Proper way to handle new 128 character identifier limit in Oracle >= 12.2

2018-11-08 Thread 'Van Klaveren, Brian N.' via sqlalchemy
Hi, Oracle 12.2 now allows 128 character length identifiers: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/newft/new-features.html#GUID-64283AD6-0939-47B0-856E-5E9255D7246B It'd be great if sqlalchemy knew about this, but what's the proper way of handling this? Just use the

[sqlalchemy] Custom type compilers interplace with with_variant

2018-11-06 Thread 'Van Klaveren, Brian N.' via sqlalchemy
Hi, I want to create a custom type for TINYINT and DOUBLE. I've defined them as custom types. I want to use with_variant for them, so that in sqlite they print out as TINYINT and DOUBLE. But I also want them to use the variants defined for other databases, like Oracle and Postgres. The