(Be) In Picture - technical concept

Databases (servers)

There can be uncontrollable amount of independent databases around the world.

API

Documented public API of database.

versioning - sem-ver
REST
JSON response

Data and links

group / person
impact
citation
event
pointer

Sctucture

Data tables

nodes (data table)
connections (data table)
nodes__corrections
connections__corrections
votes
vote_polls
sources
source media
places

M:N

source:ALL_DATA_TABLES

Nodes

UUID [PK]	bytemark (8bytes)	date_start Date()	date_end Date(NULL)	updated Date()	author_UUID [FK]?	name char(60)	text char(160)	picture char(2048)	type set()	pointed_fingers SUM(pointers where FK=this.PK)	place_UUID
inPicture-type-2378ghj543	0000000

Connections

UUID	bytemark (8bytes)	date_start	date_end Date(NULL)	date (last update)	author	type set()	left_item_UUID	right_item_UUID	name Char(60)
inPicture-con-type-2378ghj543	0000000

Votes

vote = TRUE -> means Yes

ID	author_UUID [FK]	item_UUID	vote Boolean(NULL)	locked Boolean(FALSE)

Votes_public

ID	author_UUID [FK]	picture_UUID	vote Boolean(NULL)

Vote polls

Polls which are created by logic in app automatically - have NULL author. E.q. annual board vote.

UUID	name	date_start	date_end	author (can be NULL)	item_UUID (can be NULL)	locked Boolean(FALSE)

Sources

ID	url	sources-media_UUID (can be NULL)

Source media

Smart layer to help with qualification of sources for redactors decisions. Based on REGEXP’s from URL.

UUID [PK]	bytemark (8bytes)	regexp Char(256)	updated Date()	author_UUID [FK]?	name char(60)	type set(journal, gov, …)
inPicture-media-2378ghj543	0000000

Users (author/redactor)

UUID [PK]	username	auth_token (? - PGP key ? ¹)

Pictures

UUID [PK]	author_UUID	name	votes_up	votes_down	updated

Pointers

One of few tables, that have impact from normal users.

Relevancy of pointers (“Point your finger”) is based on amount of users who used same one for same item.

@todo decide how many fingers pointing to something is needed to make them publicly visible.

UUID [PK]	user_UUID	tag_UUID	item_UUID

Places

UUID [PK]	author_UUID	name

Bytemark of main data tables

Bytemark INT value is used as information weight and is updated based on voting of redactors.

affected tables -> optimized for order by bytemark (for performance)

value/byte	1.	2.	3.	4.	5.	6.	7.	8.
0 FALSE	archived		not approved	—	potentionaly misleading or incomplete			denied	unlocked
1 TRUE	active	verified = approved by 2/3 of redactors and more then one	approved by one redactor and >= 1/2 of redactors	fact = considered as objective fact by 2/3 redactors and > 1	objective = considered as objective by 1/2 redactors and >= 1	serious considered significant 2/3 of redactors and more then one	impactful = considered significant 1/2 of redactors >= 1	not denied	locked

Databases.list

Publicly accessible list of existing databases.

[
	{
		"lang": "en_US",
		"url": "inPicture:API_ROOT_URL",
		"name": "(Be) In Picture",
		"icon": "data:=38706hjbvk4hg35g32343..."
	},
	{
		"lang": "cs_CZ",
		"url": "inPicture:vObraze.cz.gov",
		"name": {
			"cs_CZ": "Buď v Obraze!",
			"en_US": "Czech In Picture!"
		},
		"icon": "data:=/ik,;aeulmrszhdwejlk213kj4b;k66p;45hv..."
	},
	{
		"lang": "en_US",
		"url": "inPicture:inPicture.thepiratebay.org/globalWorldNews",
		"name": "Stay in picture of todays IT world @by Pirates of Caribbean"
	},
	{
		"lang": "en_US",
		"url": "inPicture:illuminate.com/bigConspiracy:42",
		"name": "Juicy conspiracy of everything - everything is connected! Open your eyes!"
	}
	
	/* ... */
	
]

Other data load through API. (Like description, rules, information about owner.)

Authentication

To be picked. Possibilities are:

OpenID
register simple account with PGP authentication token
other? …

Future possibilities

Machine-learning

Independent neuron networks to create pictures and pointers and suggest connections.

Authentication method ↩

inPicture

(Be) In Picture