Marcin Bilski bilus

layout	permalink
docs	/documentation/

Oya

Oya is a command line tool aiming to help you bootstrap and manage deployable projects.

1. No next step (how to install Dolt) before or after adding repository

2. Confusing “Dolt builds > Request access here” (is it an extra? do I HAVE to do it?)

3. Tried dolt checkout bilus/test initially, it just hangs there

4. Followed “Setting up a remote”

a. It’s `dolt push …` not `dolt remote`

b. Tried `dolt push` got `error: failed to get remote db` due to auth failure

c. Use dolt sql and did `create table countries (id integer primary key, name varchar(255));`

5. No obvious way to get data in. I want to see if it’s not a toy so I want a reasonably large dataset in.

a. Starting `dolt sql-server` it prints nothing but I tried 3306 nevertheless (have to google it up, am a Postgres guy)

b. Look for a GUI to make life easier, find Sequel Pro, try to use, got “An error occurred while retrieving information. MySQL said: unknown error: expecting “EOF” but got ‘`’ instead” when trying to view the contents of the (empty) countries table.

radiodns

Broadcast data

Link raw data to remote ids

SELECT n.message.data.remote_content_id, n.message.data.remote_broadcast_id, n.message.data.source, r.message as rawData, n.message as normalizedData
FROM `conrad-production-api.conradEvents.StaticDataRaw` r
LEFT JOIN `conrad-production-api.conradEvents.StaticDataNormalized` n
  ON (n.message.data.update_id = JSON_EXTRACT_SCALAR(r.message, "$.data.update_id"))

	package main

	import (
	"database/sql"
	"github.com/bilus/fencer/primitives"
	"github.com/iBiquity/conrad/delivery/go-broadcasts/store"
	_ "github.com/lib/pq"
	"log"
	"runtime"
	"time"

	package main

	import (
	"github.com/bilus/fencer/primitives"
	"github.com/iBiquity/conrad/delivery/go-broadcasts/store"
	"github.com/iBiquity/conrad/delivery/go-broadcasts/test/fixtures"
	"log"
	"runtime"
	)