SQL Server compatibility (mysql, sqlite, etc.)

[toothrot]

Hello,

The documentation mentions only PostgreSQL. Does MoSQL support any other SQL database servers, or does it rely on Postgres specific features?

[nelhage]

We currently rely on postgres-specific features (notably Postgres' COPY for initial bulk import). It probably wouldn't be too hard to refactor to support other backends, but it's not currently on my agenda.

[toothrot]

I'd be happy to help add MySQL support. Do you have any list of postgres specific things that I could work through?

[nelhage]

The ones I know offhand:

• copy_data in lib/mosql/schema.rb, used for initial bulk import. It should be easy to add a generic importer that uses INSERT and is portable (but slow), and then support backend-specific optimized versions.
• duplicate_key_error? in lib/mosql/sql.rb depends on the pg-specific API to extract error codes from a database error. On MySQL, it might make sense to make upsert just do a REPLACE or something to implement upsert.

There may be more.

[toothrot]

Thanks. I'll give this a shot with our staging setup in the next few weeks and will update this if there is any positive progress.

[smchugh]

Was there any progress on this @toothrot? I'm about to try implementing this myself unless you found a viable solution. Thanks

[toothrot]

@smchugh Haven't ended up doing anything on it. Oddly enough, ended up using Postgres.

[smchugh]

Thanks, @toothrot. Postgres wasn't an option for us, so I wrote up the following patch #37.