Database |> 

Language

Our database provides SQL without ontology to query content on the web; taking advantage of how the grammar of a SELECT statement tells you the desired output structure without requiring a CREATE TABLE beforehand. For example, you can run the following query to get the posts and links from Hacker News as-is with no context or prior definitions.

SELECT
  a AS post
, a@href AS link
FROM
  https://news.ycombinator.com
GROUP BY
  span.titleline;

Or, using our pipe operator syntax:

FROM https://news.ycombinator.com
|> SELECT a AS post, a@href AS link
|> GROUP BY span.titleline

Aside from not needing to create tables before performing queries, there are a few key differences between postgres and LSD:

• CSS selectors are column identifiers
• URLs are table identifiers
• Time-based filtering is applied at the query level rather than column level