SQL Server Compatibility

  • Resolved smneal

    (@smneal)


    9 years, 9 months ago

    Hi,

    Trying to use Pods on SQL Server in Azure, and it’s not playing nicely.

    Have had issues iterating through some taxonomies, where the double quote is used around column values, and MSSQL thinks this is a column.

    Also having issues with the SQL_CALC_FOUND_ROWS function (and subsequent FOUND_ROWS()).

    Has anyone come across these before, and had success in updating the plugin to be MSSQL compatible? Is there anything in the pipeline for the future?

    https://www.ads-software.com/plugins/pods/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor Josh Pollock

    (@shelob9)

    Interesting. We do not have any current plans to work on compatibility with other SQL engines. But if you had a quick fix, that didn’t break anything we’d consider it. Feel free to open and issue, and submit a PR here: https://github.com/pods-framework/pods/issues

    Plugin Contributor Scott Kingsley Clark

    (@sc0ttkclark)

    If you find the issues for us to fix, we’ll make an effort to fix them. But there’s not really a way for us to work on this heavily since none of us use MS SQL as the primary DB engine and our unit tests all run on MySQL.

    Happy to have help and direction on this though, if it’s worth your time.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘SQL Server Compatibility’ is closed to new replies.