Results 34 comments of Mark Fickett
trafficstars

We use the `WHERE x IN :list_from_params` style with MySQL SQLAlchemy as well, so it would require a lot of combing through SQL to change to `IN (:list_from_params)` in a...

Another case, even with the `IN (:list_from_params)` form, I'm getting this same error when using [pd.read_sql](https://pandas.pydata.org/docs/reference/api/pandas.read_sql.html). For example: ```py sql_query = "SELECT * FROM my_table WHERE my_col IN (:list_from_params)" params...

Using SqlAlchemy's [TextClause.bindparams](https://docs.sqlalchemy.org/en/20/core/sqlelement.html#sqlalchemy.sql.expression.TextClause.bindparams) and [sqlalchemy.bindparam](https://docs.sqlalchemy.org/en/20/core/sqlelement.html#sqlalchemy.sql.expression.bindparam) as described in [this SO post](https://stackoverflow.com/questions/13190392/how-can-i-bind-a-list-to-a-parameter-in-a-custom-query-in-sqlalchemy) works with both MySQL and Snowflake SqlAlchemy drivers, so it's a feasible workaround: ```py import pandas as pd from...

Thanks for taking a look! What do you think of the approach of customizing the yaml `Loader`? Here's an example from a [gist discussion thread](https://gist.github.com/pypt/94d747fe5180851196eb): ```py class UniqueKeyLoader(yaml.SafeLoader): def construct_mapping(self,...

I wasn't able to get anything working deriving from `mqtt.Mqtt` as in the snippet in [the MQTT API reference](https://appdaemon.readthedocs.io/en/latest/MQTT_API_REFERENCE.html). So I would have definitely found a working example in the...

Not full docs, but [here's a discussion](https://github.com/arendst/Tasmota/discussions/20202) where I got help using HT16K33 I2C seven segment displays. (I'm working on a [PR for docs](https://github.com/tasmota/docs/pull/1312) for another peripheral and if that...

A ManagedNodeGroup update is taking about 15 minutes for me. The new nodes show as ready and start taking on pods within about 3 minutes. The thing that seems most...

Another use case: I'm administering an Kubernetes cluster (EKS), which is set up as a systemd service. The provided `kubelet.service` `ExecStart` specifies various command-line flags, and then includes `$KUBELET_EXTRA_ARGS`. As...

Thanks @ocelotl ! I'm still getting a pip dependency conflict between `pulumi` and `opentelemetry-exporter-otlp-proto-grpc`. The latter directly has relaxed requirements, but it requires `opentelemetry-proto` which requires `protobuf~=3.13`, which conflicts with...