A Flexibility-First Database
A Flexibility-First Database
Almost all web applications use relational/noSQL databases.
Existing systems are convenient, and familiar, but not perfect:
A schemaless database with automatic caching and streaming queries.
id | title |
---|---|
1 | Hello |
2 | World |
user | article |
---|---|
jon | 1 |
rtm | 2 |
SELECT
article.title,
COUNT(vote.user)
FROM article
LEFT JOIN vote
ON (article.id = vote.article)
GROUP BY article.id
WHERE article.id = ?
id | title |
---|---|
1 | Hello |
2 | World |
user | article |
---|---|
jon | 1 |
rtm | 2 |
SELECT
article.title,
COUNT(vote.user)
FROM article
LEFT JOIN vote
ON (article.id = vote.article)
GROUP BY article.id
WHERE article.id = ?
Six concurrent readers. One writer. Query/vote for
random article in a tight loop. PostgreSQL
(materialized) uses UPDATE
to avoid aggregation.
Thank you. Get in touch at jon@tsp.io.