Tango with only file database on windows - limitations?

tbraun · December 14, 2017, 8:37am

Hi,

I’m thinking about developing a tango based desktop application. The idea would be that although we use tango, the user does need to know that. I have to generate a simple installer for this application as well.

For that we would like to not use a MYSQL database, but only the file database. From reading [1, 2] it looks like that the limitations of using a file database only are not so severe. Are these lists complete? I’m using a lot of events, like CHANGE_EVENT, DATA_READY_EVENT etc., that is the reason I’m asking.

How mature would you consider the windows port of tango? Mature like compiles? Or mature like XYZ is using that in production since a few years?

Thanks,
Thomas

PS: I’m using latest tango9.

rbourtembourg · December 15, 2017, 11:46am

Hi Thomas,

If I were you, I would send an e-mail to info@tango-controls.org mailing list to try to reach more people.
For the moment, there are not so many people who are subscribed automatically to the new topics of the forum.
Actually, since the new version of the website, there is now a new button to subscribe automatically to all forums in one click (on http://www.tango-controls.org/community/forum/ page, the user can click on “Subscribe to all forums”).
It looks like very few people have done that so I would try the mailing list if I were you.

I’m sorry I cannot really help you since my experience with Tango on Windows or Tango with a file Database is very limited.
I guess the best is to try it out, do your own tests for your use case and to create issues or pull requests for the problems you encounter.

Kind regards,
Reynald

gdi_franco · February 2, 2018, 4:18pm

Hi everyone,

Tango on Windows is mature enough to be deployed on real systems and its installation is quite easy. At Thales, we are using Tango 8 in laser systems like ELI-NP and so far it’s running quite good on Windows servers 2008, 2012, 2016 and also on Windows 7. We are currently testing Tango 8 on Windows 10 and it has not failed us yet. Databases are running smoothly without any interruption 24 hours a day, 7 days a week.

We also have switched from MySQL to MariaDB, so we are not using the file based system. We have development database that are constantly dropped and restored for our device tests and that’s fine.

Best regards,

Guillaume

vmichel · February 5, 2018, 8:37am

Pytango is using the file database for its unit-tests, and that includes testing the event system:

github.com/tango-controls/pytango

tango/test_context.py

develop

"""Provide a context to run a device without a database."""

from __future__ import absolute_import

# Imports
import os
import sys
import six
import time
import struct
import socket
import tempfile
import traceback
import collections
from functools import partial

# Concurrency imports
import threading
import multiprocessing
from six.moves import queue

This file has been truncated. show original

However, some API calls are not implemented. That might or might not be a problem for you.

tbraun · February 7, 2018, 6:13pm

Thanks Vincent and Guillaume. This sounds promising!