MSSQL Storage

[kedoska]

Hi there,

Very interesting tools. Thank you in advance.
I see that MSSQL is not in the roadmap.

How could it be implemented? Adding a dedicated datastore would be enough?
I could eventually help in the process

[cube2222]

Hey, it would basically be copy pasting the postgres data source and changing the sql generation parts to fit the dialect. MySQL support was added in like half an hour as a copy paste of the postgres package.

[cube2222]

I've written a small datasource contribution guide if that helps: https://github.com/cube2222/octosql/tree/master/storage

[Xirui]

@cube2222 this tool has been very useful to me.

Just want to contribute to this feature, though the link to the contribution guide is broken.

[cube2222]

Hey @Xirui, glad to hear that!

OctoSQL doesn't accept contributions right now, as is detailed in the README: https://github.com/cube2222/octosql#contributing

However, since this issue was created, OctoSQL adopted a plugin model for datasources, so you can actually create this yourself, in your own repository.

There's no guide right now, but you should be able to base yourself on the MySQL or PostgreSQL plugins:

• https://github.com/cube2222/octosql-plugin-mysql (that one should be easier to adapt, as it's based on the standard library database/sql package)
• https://github.com/cube2222/octosql-plugin-postgres

Happy to help and answer any questions during the process!

[Xirui]

Thanks @cube2222, I will have a go with that, looks quite straight-forward.