In the path to going full open source, it makes senses to move all components to open source technology.
The same way we are moving from .NET standard to .NET Core, we should move from SQL Server to an open source RDBMS.
And by the way should we keep using a RDBMS or switch to a nosql database ? My 5 cents here is to have both. Since Generative Objects can handle different datasource types, it makes sense to have a RDBM data source and a nosql datasource. So integrating a nosql datasource will be the subject of another post.
For an open source RDBMS, I can think of MariaDB or PostgreSQL. My preference intuitively goes to PostgreSQL. If anyone has input on this, please you are welcome to share.
@velulev , since you know pretty well PostgreSQL, this could be your first contribution to Generative Objects ! What do you think ?
Architecturally speaking, we are using NHibernate as the ORM. So integrating PostgreSQL at this level should be pretty straightforward. However there will custom work to do at the level of the database live update service.
The database live update service is the engine we have to generate database update scripts when the application data model has changed. This allows for automatic update of the database schema in all environments (dev, recette, production…) with no data loss. It is therefore essential. The work here will be to make sure the SQL code generated is compatible with PostgreSQL. I don’t remember for sure, but we must have already make it evolutive and ready to plug another SQL code generator. If not, this point of extension will have to be added. This way it will be straightforward to add full support for others RDBMS