• Status Maybe
  • Percent Complete
  • Task Type Feature Request
  • Category Database Queries
  • Assigned To No-one
  • Operating System Windows 7
  • Severity Very Low
  • Priority Very Low
  • Reported Version 1.0 alpha1
  • Due in Version Undecided
  • Due Date Undecided
  • Votes 1
  • Private
Attached to Project: Flyspray
Opened by peterdd - 20.07.2015

FS#2014 - Add MS SQL Server as database backend

My company maybe changes to a MS SQL Server backed ERP.

In this case it could be nice to have Flyspray customized as CRM working on the same database for integration with ERP.

Well, currently just an idea.

jahto commented on 30.07.2015 16:06

There are in my knowledge only three functions total in Flyspray where the SQL is not MS SQL Server compatible. Project::getDayActivityByProject, User::getDayActivityByUser and Backend::get_task_list. For the first two one, I have had an idea, it's even documented somewhere either here or Github, just can't find it just now (it was something about changing the grouping by date(from_unixtime()) on mysql, date(to_timestamp()) on PostgreSQL and tolerating one hour error when standard time/daylight savings time change happen, because the results were only used for drawing those two lines in Overview page, not very critical...).

But then the last one. It uses GREATEST. That does not exist in MS SQL Server. That one should be rethought. After doing that, it might even be as easy as to just add SQL server as a supported database to installer and start testing.

Project Manager

Ok, thanks for comment. Currently not planned by us. But good to know for decision making.


Available keyboard shortcuts


Task Details

Task Editing