Talk:Collaboration/Team/Processes

Scripts and hacks
Things we do unrelated to the code in git/gerrit.

working with UUIDs
Base 36 has code to convert to/from Flow's alphadecimal representation of UUIDs in URLs e.g.  . Note JavaScript integers have insufficient precision, e.g.

There are online base36 converters, e.g. this one with ads.

mysql
We store 88-bit UUIDs in  columns, so they appear as garbled strings such as: �#�����o~p

In mysql, use  and , e.g.:

There is no (?) mysql function to convert to/from Flow's alphadecimal representation.

Determinining database, gaining access
The configuration of Flow's cross-wiki external database can be opaque.

ssh into MediaWiki server (e.g. deployment-bastion for the Beta cluster), then $ mwscript eval.php --wiki=enwiki var_dump( Flow\Container::get( 'db.factory' )->getDB( DB_MASTER ) ); this will give you mServer, mDBname, mUser, mPassword for $ mysql -u mUser -p --host=mServer mDBname

You can run this comment from a labs instance to access the beta cluster.