s9y - SQLRelay - IBM DB2

[tessarek]

Hi,

Since serendipity 1.2.1 supports SQLRelay and SQLRelay supports IBM DB2, does this mean that serendipity now works with IBM DB2 as well?

Regards,
Helmut

[garvinhicking]

Hi!

No, since Serendipity still uses DB-relevant SQL (like for pgsql and mysql) that cannot be used in DB2 content. SQLRelay can route such queries to a mysql or pgsql backend, but AFAIK does not convert that to the DB2 language.

Regards,
Garvin

[tessarek]

Hi,

This is too bad. I really hoped that I can use DB2 with serendipity.
Thanks for the answer anyways.

Regards,
Helmut

[garvinhicking]

Hi!

Sadly, DB2 is very specific in many of its SQL statements, and not so easy to support.

Also, there's very little need for DB2 support...have you considered using the PHP5 internal SQLite support?

Regards,
Garvin

[tessarek]

I really don't want to contradict, but in this case, I have to:

DB2 follows all SQL standards, it is more like that the other databases introduced some SQL clauses, which are not SQL standard.

Yes, I'm currently using SQLite as the DB backend, but I really would love to use DB2...

[garvinhicking]

Hi!

I agree, I was not specific enough, I wanted to express "SQL de-facto standard that the popular RDBMS employ"

If there are volunteers for making our SQL queries compatible to IBM DB2, I'd love that.

Regards,
Garvin

[tessarek]

Hi Garvin,

I am not able to rewrite the statements alone. I'm too busy at work right now, but I can help and if there are any questions regarding DB2, I'm your man.

Btw., DB2 9.5 introduced some not SQL standard clauses for compatibility, but you have to set a parameter to make use of them.

If you put a workgroup together to make s9y working with DB2, count me in.

Regards,
Helmut

[garvinhicking]

Hi!

Sadly I myself can't help at all, I've never used DB2, nor do I have a testing environment.

Best regards,
Garvin