---
title: "💭 Sqlite-jiff"
description: "!https://simonwillison.net/2024/Jul/23/sqlite-jiff/"
date: 2024-07-24
published: true
tags:
  - sqlite
  - sql
  - thought
template: link
---


<div class="embed-card embed-card-external">
  <a href="https://simonwillison.net/2024/Jul/23/sqlite-jiff/" class="embed-card-link" target="_blank" rel="noopener noreferrer">
    <div class="embed-card-content">
      <div class="embed-card-title">sqlite-jiff</div>
      <div class="embed-card-description">I linked to the brand new Jiff datetime library yesterday. Alex Garcia has already used it for an experimental SQLite extension providing a timezone-aware jiff_duration() function - a useful new …</div>
      <div class="embed-card-meta">Simon Willison’s Weblog &middot; simonwillison.net</div>
    </div>
  </a>
</div>


Sqlite is getting rust extensions now, and datetimes make it totally worth if if they work well and and fast, two things that don't always go together in datetime libraries

!!! note

    This post is a <a href="/thoughts/" class="wikilink" data-title="Thoughts" data-description="These are generally my thoughts on a web page or some sort of url, except a rare few don&#39;t have a link. These are dual published off of my..." data-date="2024-04-01">thought</a>. It's a short note that I make
    about someone else's content online <a href="/tags/thoughts/" class="hashtag-tag" data-tag="thoughts" data-count=2 data-reading-time=3 data-reading-time-text="3 minutes">#thoughts</a>