How did you use the SQL Anywhere Web Edition?

[Former Member]

As has been discussed in other questions, the SQL Anywhere Web Edition has been discontinued in SQL Anywhere 16.

If you use/used the SQL Anywhere Web Edition, I am interested in your answers to the following questions:

1. What kinds of application did/do you use with the Web Edition?
2. Are the applications used for in-house systems, or deployed to customers?
3. How many instances of the Web Edition did/do you run?
4. What would you have used (or will you use) instead of the SQL Anywhere Web Edition?

Thank you in advance.

[Former Member]

As I know, modern web apps demand horizontal scalability. SA WEB don't offer it, but posgresql as I know offer solution for scalability and also has relatively good sql engine.

[Former Member]

Thank you, Alexey.

SQL Anywhere does have support for horizontal read-only scale-out (http://dcx.sybase.com/index.html#sa160/en/dbadmin/da-copy-nodes.html). Although not included in the SQL Anywhere Web Edition, it was available as a paid option.

For write-heavy workloads, multiple SQL Anywhere Web Edition servers can be setup in a horizontal sharding configuration.