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.
Loading...
Available keyboard shortcuts
- Alt + ⇧ Shift + l Login Dialog / Logout
- Alt + ⇧ Shift + a Add new task
- Alt + ⇧ Shift + m My searches
- Alt + ⇧ Shift + t focus taskid search
Tasklist
- o open selected task
- j move cursor down
- k move cursor up
Task Details
- n Next task
- p Previous task
- Alt + ⇧ Shift + e ↵ Enter Edit this task
- Alt + ⇧ Shift + w watch task
- Alt + ⇧ Shift + y Close Task
Task Editing
- Alt + ⇧ Shift + s save task
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.
Ok, thanks for comment. Currently not planned by us. But good to know for decision making.