Kiran Jonnalagadda

Commit to PostgreSQL

1

Coaster currently provides much _optional_ functionality that depends on PostgreSQL, providing workarounds for other databases. The `JsonDict` type in `coaster.sqlalchemy`, for instance, does client-side JSON parsing if the server isn't...

Supply naming_convention to SQLAlchemy metadata

1

Since 0.9.2, SQLAlchemy has supported [an explicit naming convention for foreign keys, indexes and constraints](http://docs.sqlalchemy.org/en/latest/core/metadata.html#sqlalchemy.schema.MetaData.params.naming_convention). Alembic also [supports reading and honouring this naming convention](http://alembic.zzzcomputing.com/en/latest/naming.html). Coaster should supply a naming convention...

failsafe_add should use UPSERT where available

4

Nested transactions are nice, but UPSERT is more reliable. `failsafe_add` should use it when it detects the underlying engine supports it. SQLAlchemy supports custom compilation for standard statements like INSERT...

Be consistent with use of decimal in JsonDict column

1

In `coaster.sqlalchemy.JsonDict` [line 595](https://github.com/hasgeek/coaster/blob/399a59ddaeba2f36f53cd22f4b8fc3f59d8df557/coaster/sqlalchemy.py#L595), we use simplejson with `use_decimal=True` to parse non-integer numbers as `Decimal` instead of `float`. While this is a good idea because of the general unreliability of...

Null MX validation

2

[RFC 7505](https://tools.ietf.org/html/rfc7505) specifies "null MX" for when a domain explicitly does not support email. This is testable with the `example.*` domains: ``` example.org mail is handled by 0 . ```...

Debugging a segmentation fault

5

**Bug Report** Some code I was working on last week is causing mypy to segfault. I tried retracing my steps to find the change that broke mypy, without luck. Config:...

The `request_has_auth` helper function accompanying `current_auth` is meant to be used in an after_request processor to set a `Vary: Cookie` header if the request accessed `current_auth` in any way, implying...

There's a popup on every open of nvim saying: ``` coc.nvim switched to custom popup menu from 0.0.82 you have to change key-mapping of to make it work. ``` What...

Chrome now has a well defined process for showing an app install banner within the browser. We should support this. https://developers.google.com/web/updates/2015/03/increasing-engagement-with-app-install-banners-in-chrome-for-android

Can roles be defined as enums instead of strings?

3

Roles are currently defined as string-only. No other object type is accepted, and a role match is defined as a plain string match. However, roles are also scoped to a...