Website Database Landing Page

[jrmerz]

Schema to render can be viewed here:

pg-farm/services/administration/schema/004-database.sql

Lines 145 to 166 in 06a2047

	CREATE OR REPLACE VIEW pgfarm.instance_database AS
	SELECT
	o.name as organization_name,
	o.title as organization_title,
	o.organization_id as organization_id,
	i.hostname as instance_hostname,
	i.name as instance_name,
	i.state as instance_state,
	i.instance_id as instance_id,
	i.port as instance_port,
	db.name as database_name,
	db.title as database_title,
	db.short_description as database_short_description,
	db.description as database_description,
	db.url as database_url,
	db.tags as database_tags,
	db.pgrest_hostname as pgrest_hostname,
	db.database_id as database_id,
	db.tsv_content as tsv_content
	FROM pgfarm.database db
	LEFT JOIN pgfarm.instance i ON i.instance_id = db.instance_id
	LEFT JOIN pgfarm.organization o ON o.organization_id = i.organization_id;

This will include the admin view for db admins. See #15

[wrenaria]

@jrmerz I don't what to do with this. it doesn't mean anything to me. Can you provide me a real world example of what data should be displayed to a user on a database landing page?

[jrmerz]

Sure. Database properties to render on the landing page:

• Organization name or title, with link to organization page (filters search or landing page, tbd)
• Database name or title
• Database short description (single sentance)
• Database long description (longer, markdown supported, description of the database)
• Database url (either to a landing page for the project or lab that created database)
• Database Tags (search filter tags/keywords for database)