Nicolay Gerold

It’s underdigitized. According to the McKinsey Industry Digitalization Index, only the agriculture sector is less digitized than construction. The typical IT spend for construction companies is 1-2% of the revenue, compared with the 3-5% average across industries. Moreover, there are many barriers to digital technology adoption including skill... See more

Optimizing Further

Creating so many indices and aggregating so many tables is sub-optimal. To optimize this, we employ materialized views, which create a separate disk-based entity and hence support indexing. The only downside is that we have to keep it updated.

CREATE MATERIALIZED VIEW search_view AS

ᅠᅠSELECT c.name FROM company c UNION

ᅠᅠSELECT... See more

SQLGlot is a no-dependency SQL parser, transpiler, optimizer, and engine. It can be used to format SQL or translate between 20 different dialects like DuckDB, Presto / Trino, Spark / Databricks, Snowflake, and BigQuery. It aims to read a wide variety of SQL inputs and output syntactically and semantically correct SQL in the targeted dialects.

It is... See more

We identified 30 types of tasks that UX professionals used generative AI tools for in their work. We grouped these tasks under four roles: content editor, research assistant, ideation partner, or design assistant.

• Content editor : Generating and editing text, from microcopy to social media posts, based on specifications or copy given by UX

... See more

• Multiple indices. Splitting the document corpus up into multiple indices and then routing queries based on some criteria. This means that the search is over a much smaller set of documents rather than the entire dataset. Again, it is not always useful, but it can be helpful for certain datasets. The same approach works with the LLMs themselves.

... See more

A service has constant administration costs which are paid by the service provider.

A library instead moves these costs to the users of the library.

For any developer with limited resources,

this means a library (where viable) can provide the same functionality to the user,

at a lower cost to the developer than a service.

By library, I mean any software... See more

Token Embeddings: These are vector representations of tokens, which can be characters, subwords, or other text units. Token embeddings are particularly useful in languages with complex morphology or when handling out-of-vocabulary words. Models like BERT use token embeddings to represent subword units.

Word Embeddings: These are dense vector... See more

Shipping to production

Before shipping to production, we think about all the different artifacts that might be affected by a new feature.

Here's a non-exhaustive list of things we ask ourselves:

• Does the API need to be updated?


• Is the OpenAPI spec up to date now?


• Have we released all the official SDKs?


• Do we need to write a Changelog post to announce

... See more