willbarrett commented on issue #8874: [SIP-33] Proposal for Removing SQLite Support for Metadata Databases URL: https://github.com/apache/incubator-superset/issues/8874#issuecomment-580353696 Thanks for the comments @xinbinhuang - I wasn't aware of that behavior on `batch_alter_table`. The main issue that we've had with migrations on SQLite is that constraints, once set on a table, cannot be altered. Even the `batch_alter_table` system doesn't provide a workaround. This leads to a lot of try/except blocks in our migration files, and thus schema drift between production systems. It's really painful to try to figure out what different organizations have as an underlying schema right now. I don't see it mentioned here in the history, so I should mention that this SIP has gone through the Apache voting process and has been approved. I'll be working on adding deprecation notices in the next week or so.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
