Log inSign up
Image
user avatar
Hamilton Ulmer
@hamiltonulmer
👁️📈👁️ building data analysis and AI features @motherduck
Bay Area
hamiltonulmer.com
Joined January 2009
455
Following
3,963
Followers
  • Pinned
    user avatar
    Hamilton Ulmer
    @hamiltonulmer
    Apr 24, 2025
    So thrilled to announce we've released Instant SQL! It's a new interaction pattern for writing SQL queries that provides realtime result previews and deep query inspection & debugging. Bye bye run button 👋 Truly, literally only possible with DuckDB
    Image
    00:00
    23K
  • user avatar
    Hamilton Ulmer
    @hamiltonulmer
    Jun 21, 2023
    Mosaic looks really great! Great to see a viz library thread down to the db level. DuckDB is such a natural choice for something like this. uwdata.github.io/mosaic/
    Image
    00:00
    58K
  • user avatar
    Hamilton Ulmer
    @hamiltonulmer
    Sep 4, 2024
    instant-feedback SQL editing aka "query-as-you-type" uses DuckDB's AST, duckdb-wasm for local-first caching, and MotherDuck as the backend Still early, but should enable arbitrary scale and still retain a near real-time feel while writing ad hoc queries! Bye bye run button 👋
    Image
    00:00
    58K
  • user avatar
    Hamilton Ulmer
    @hamiltonulmer
    Apr 20, 2022
    excited to share an alpha version of @RillData Developer, a reactive EDA-centric SQL tool for exploring and transforming datasets. Something I've always wanted as a data person :) Powered by @duckdb and @sveltejs ✨ try it & let me know what you think! github.com/rilldata/rill-…
    Image
    00:00
  • user avatar
    Hamilton Ulmer
    @hamiltonulmer
    Jan 12, 2022
    have been prototyping something I've wanted forever: all the basic data quality / basic EDA I want for every field of a dataset. Never again will I calculate null %s, cardinality, top-n, & histograms of numeric columns by hand again! Made with @duckdb & @sveltejs 😎
    Image
    00:00
  • user avatar
    Hamilton Ulmer
    @hamiltonulmer
    Mar 30, 2023
    now that I've found out about svg's paint-order=stroke, I can finally make tons of these outlined text elements and suffer no rendering consequences
    Image
    00:00
    <text x={30} y={30} paint-order="stroke" stroke="white" stroke-width="3" >{mouseoverValue?.x}</text>
    rendered svg showing effect of paint-order="stroke"
    user avatar
    Hamilton Ulmer
    @hamiltonulmer
    Mar 30, 2023
    I have a very overwrought and computationally expensive outline Svelte action I apply to chart labels (expensive at scale of a linked mouseover w/ lots of text). It turns out I can set paint-order=stroke and just stroke the text instead to get the same punch-out effect
    81K
  • user avatar
    Hamilton Ulmer
    @hamiltonulmer
    Jul 27, 2024
    Replying to @disconcision
    it's long, too ~ like 1800 pages? (1) no one actually implements it and (2) the spec is itself incomplete!
    4.3K
  • user avatar
    Hamilton Ulmer
    @hamiltonulmer
    Feb 14, 2024
    🥚We just released MotherDuck's first dataviz feature: the Column Explorer Never again will you need to write boilerplate SQL to find null %s, unique values, top n, histograms and basic time series! You can try it out now w/ your favorite datasets on MotherDuck dot com
    Image
    00:00
    33K
  • user avatar
    Hamilton Ulmer
    @hamiltonulmer
    Mar 12, 2025
    So thrilled the DuckDB UI is out to the world! A couple small design details we thought about in thread
    user avatar
    DuckDB
    @duckdb
    Mar 12, 2025
    DuckDB got a local UI. Thanks to our friends at MotherDuck, you can now interact with your DuckDB database through an interactive notebook, running on localhost. Read the announcement blog post at duckdb.org/2025/03/12/duc…
    Image
    18K
  • user avatar
    Hamilton Ulmer
    @hamiltonulmer
    May 28, 2024
    someone should write "Designing Data-Intensive UIs" sorry if I've tweeted this exact thought before
    user avatar
    Phil Eaton
    @eatonphil
    May 28, 2024
    If you're a developer and you haven't read Designing Data Intensive Applications, treat yourself. It is an excellent introduction to data and distributed systems thinking, and it's one of the best written and most fun books on software. For experienced developers, there is no
    Image
    25K
  • user avatar
    Hamilton Ulmer
    @hamiltonulmer
    Oct 20, 2022
    How many of you actively hate YAML?
  • user avatar
    Hamilton Ulmer
    @hamiltonulmer
    Sep 18, 2023
    Excited to share some job news ~ I'll be building DuckDB-powered interfaces with the brilliant folks at @motherduck! Feeling very lucky to get to collaborate with this talented, experienced, humble group of people. More to come very soon 🦆🚀
    17K
  • user avatar
    Hamilton Ulmer
    @hamiltonulmer
    Jul 22, 2022
    Can y'all think of any cases of “I am taking an internal tool we built at Company X and making a business around it” that have been successful?
  • user avatar
    Hamilton Ulmer
    @hamiltonulmer
    Jan 2, 2025
    🚀 New DuckDB instant SQL preview feature: decompose result sets in real time! Break apart any select list expression to triage unexpected NULL values and results Scales seamlessly to arbitrarily complex expressions
    Image
    00:00
    9.8K