Skip to content

id serial PK
full_name text
role text
city text
country text
github text
linkedin text

id serial PK
developer_id integer FK → developer.id
company_id integer FK → companies.id
position text
started date
ended date?
summary text

id serial PK
developer_id integer FK → developer.id
institution_id integer FK → institutions.id
title text
started integer
ended integer

id serial PK
developer_id integer FK → developer.id
name text
issuer text
hours integer?

id serial PK
developer_id integer FK → developer.id
language text
level text
certified_by text?

id serial PK
developer_id integer FK → developer.id
channel text
handle text
preferred boolean

id serial PK
name text
sector text
description text
url text?

id serial PK
name text
city text

id serial PK
company_id integer FK → companies.id
name text
client text
summary text
year integer
status text
url text?

id serial PK
name text
category_id integer FK → skill_categories.id

project_id integer PK FK → projects.id
skill_id integer PK FK → skills.id

id serial PK
name text

id serial PK
developer_id integer FK → developer.id
kind text
title text
format text
url text

Click a table to query it Drag to move around the board

Schema

13 tables · 64 columns

certifications Courses and certificates
companies Organisations he has built software for
contact_channels How to reach him
developer The one row this whole site is about
documents Downloadable documents
education Formal training
experience Where he has engineered software
institutions Lookup table for schools
project_skills Junction table: which technologies each project used
projects Software in production
skill_categories Lookup table for skill kinds
skills What he works with
spoken_languages Languages he works in

Everything about me is in this database

Query it yourself, or take the shortcut.

I am not technical — show me everything No SQL required.

Are you a non-technical profile? Click me mini-wassit Are you a non-technical profile?

Pick a question

No problem. Here are the queries that tell you everything — copy one and paste it into the console.

Copy a query, then paste it at the prompt and press Enter. You run it, not me.

Who is he?
SELECT full_name, role, city, country FROM developer;
What has he built?
SELECT name, client, summary, url FROM projects;
Where does he work?
SELECT co.name AS company, e.position, e.started, e.summary FROM experience e INNER JOIN companies co ON co.id = e.company_id;
What does he know?
SELECT s.name, c.name AS category FROM skills s INNER JOIN skill_categories c ON c.id = s.category_id ORDER BY category;
What has he studied?
SELECT ed.title, i.name AS institution, ed.ended FROM education ed INNER JOIN institutions i ON i.id = ed.institution_id ORDER BY ed.ended DESC;
How do I reach him?
SELECT channel, handle, preferred FROM contact_channels;
Can I see his CV?
SELECT title, format, url FROM documents WHERE kind = 'cv';

Connected to elias_portfolio. Type ? for help, or click a table to query it.

I am not technical — show me everything No SQL required.