ddikman

SELECT
    case user.value.string_value 
    when '0' then 'Baseline'
    when '1' then 'Other version'
    else 'Error'
    end as experiment_value,
    count(distinct(user_pseudo_id)) as users,
    count(*) as events,
    (count(*) / count(distinct(user_pseudo_id))) as ratio
FROM `<project_name>.analytics_<id>.events_*`,

ddikman

import 'package:flutter/material.dart';

void main() => runApp(ExampleApp());

class ExampleApp extends StatelessWidget {
  @override
  Widget build(BuildContext context) {
    return MaterialApp(
      title: 'Floating overlay example',
      debugShowCheckedModeBanner: false,

ddikman

select
    platform,
    avg(p.value.double_value) as avg_value, 
    count(distinct(user_pseudo_id)) as views,    
    DATE_TRUNC(DATETIME(TIMESTAMP_MICROS(event_timestamp)), MONTH) as month
FROM `<project>.analytics_<id>.events_*`,
unnest(event_params) p
where event_name = 'view_item' and p.key = 'value'
group by month, platform
order by month, platform

ddikman

SELECT 
  all_users.platform,
  all_users.event_date,
  views.item_views / all_users.unique_users as searches_per_user 
FROM (
    SELECT 
      platform,
      count(distinct(user_pseudo_id)) as unique_users,
      event_date 
    FROM `<project-id>.analytics_<id>.events_*`

ddikman

select
    platform,
    DATE_TRUNC(DATETIME(TIMESTAMP_MICROS(event_timestamp)), WEEK(SATURDAY)) as week_start,
    count(distinct(user_pseudo_id)) as unique_users
FROM `<project-name>.analytics_<id>.events_*`
group by week_start, platform
order by week_start asc

ddikman

cache:
  paths:
    - $CI_PROJECT_DIR/.pub-cache/

build:
  image: greycastle/flutter:2.2.3
  script:
    - export PUB_CACHE=$CI_PROJECT_DIR/.pub-cache
    - export PATH="$PATH":"$PUB_CACHE/bin"
    - flutter pub get

ddikman

#!/bin/bash

# usage:
# chmod +x download.sh
# pbpaste | download.sh
# cat inputfile.txt | download.sh

# thanks to https://stackoverflow.com/a/7045517

while read -r full_url

ddikman

_initRemoteConfig(ExperimentalMode experimentalMode) async {
  final RemoteConfig remoteConfig = RemoteConfig.instance;

  var cacheDuration = Duration(hours: 1);
  // allows us to force update the cache even when we exit the experimental mode
  if (experimentalMode.isExperimentalMode || experimentalMode.isConfigStale()) {
    cacheDuration = Duration(seconds: 0);
  }
  experimentalMode.setConfigStale(false);
  await remoteConfig.setConfigSettings(RemoteConfigSettings(

ddikman

import 'package:flutter/material.dart';
import 'package:japanese_reading/settings_page/services/experimental_mode.dart';

class ExperimentalModeSwitcher extends StatefulWidget {
  final Widget child;
  final ExperimentalMode experimentalMode;

  const ExperimentalModeSwitcher({Key key, @required this.child, @required this.experimentalMode}) : super(key: key);

  @override

ddikman

import 'package:firebase_analytics/firebase_analytics.dart';
import 'package:japanese_reading/services/preferences.dart';

class ExperimentalMode {
  static final cacheStaleKey = 'cache_stale';
  static final experimentalModeKey = 'experimental_mode';

  final FirebaseAnalytics analytics;
  final Preferences preferences;