Sam Willis

@samwillis.uk

1051 Followers 283 Following

Local First, TanStack DB, @pglite.dev and Sync Engines at @electric-sql.com. More at https://samwillis.uk

const graph = new D2({ initialFrontier: 0 }); const issuesInput = graph.newInput<[string, Issue]>(); const usersInput = graph.newInput<[string, User]>(); const commentsInput = graph.newInput<[string, Comment]>(); const commentCounts = commentsInput.pipe( map(([_key, comment]) => [comment.issue_id, 1]), concat(issuesInput.pipe(map(([_key, issue]) => [issue.id, 0]))), reduce((values) => { let count = 0; for (const [num, diff] of values) { count += num * diff; } return [[count, 1]]; }) ); issuesInput.pipe( map(([_key, issue]) => [issue.user_id, issue]), join(usersInput.pipe(map(([_key, user]) => [user.id, user]))), join(commentCounts), map(([_key, [[issue, user], commentCount]]) => [ issue.id, { ...issue, user_id: user.id, username: user.username, user_email: user.email, user_full_name: user.full_name, comment_count: commentCount || 0, }, ]), consolidate(), output((msgs) => { console.log(msgs); }) );
const graph = new D2({ initialFrontier: 0 }); const issuesInput = graph.newInput<[string, Issue]>(); const usersInput = graph.newInput<[string, User]>(); const commentsInput = graph.newInput<[string, Comment]>(); const commentCounts = commentsInput.pipe( map(([_key, comment]) => [comment.issue_id, 1]), concat(issuesInput.pipe(map(([_key, issue]) => [issue.id, 0]))), reduce((values) => { let count = 0; for (const [num, diff] of values) { count += num * diff; } return [[count, 1]]; }) ); issuesInput.pipe( map(([_key, issue]) => [issue.user_id, issue]), join(usersInput.pipe(map(([_key, user]) => [user.id, user]))), join(commentCounts), map(([_key, [[issue, user], commentCount]]) => [ issue.id, { ...issue, user_id: user.id, username: user.username, user_email: user.email, user_full_name: user.full_name, comment_count: commentCount || 0, }, ]), consolidate(), output((msgs) => { console.log(msgs); }) );
import { PGlite } from '@electric-sql/pglite' import { beforeAll, beforeEach, describe, it } from 'vitest' import { allMigrations } from './migrations' import { loadTestData } from './testData' describe('my tests', () => { let db: PGlite beforeAll(async () => { db = await PGlite.create() for (const migration of allMigrations) { await db.exec(migration) } await loadTestData(db) }) beforeEach(async () => { // Clone the database for each test const dbClone = db.clone() await setDatabaseMock(dbClone) }) it('foo', () => { // ... }) it('bar', () => { // ... }) })
Started making it. Had a breakdown and wrote a database. Bon appetite.
Screen shot of Amazon with Tib Street Ballroom on promo. -- How do you solve an unsolvable murder? Ask the victim... In January 1986, newly-engaged Marnie Driscoll is found dead in her parents' kitchen. With no witnesses, it seems as though the circumstances of her death will remain a mystery. Six months later, high-flying Detective Inspector Andrew Joyce’s career takes an unexpected detour when he finds himself unwillingly transferred to an obscure department within Greater Manchester Police, known as the Ballroom. The Ballroom team employs unorthodox methods to crack previously unsolved cases, and Joyce, a sceptic by nature, must find a way to work with Peggy Swan, a reclusive ex-socialite with a unique talent: she can communicate with the dead. Joyce soon discovers that Marnie’s death, initially dismissed as an opportunistic act of violence, actually seems to be a carefully orchestrated murder. It will take both Joyce’s skill as an investigator and Peggy’s connection to her new ghostly charge to navigate the web of secrets surrounding the case and bring closure to Marnie’s tragic story before the killer can strike again.
<script> // In your <head> (t=>{var r,i,a,d,l="",s={},u=document,b=1,n=e=>{(i=e.getAttribute?.(t))&&(d=s[i ]??=b,a=t+d,e.removeAttribute(e[t]),e.setAttribute(a,""),e[t]=a,d==b)&&( l+=`[${a}]{${i}}`,b++)};new MutationObserver(e=>{e.map(e=>{ "childList"==e.type?e.addedNodes.forEach(e=>{n(e),[...e.querySelectorAll?.( `[${t}]`)||[]].map(n)}):n(e.target)}),l&&((r=u.createElement("style") ).innerHTML=l,u.head.appendChild(r),l="")}).observe(u,{attributeFilter:[t], childList:!0,subtree:!0})})("x-style"); </script> <a href="/something-awsome" x-style=" color: red; font-size: 30px; &:hover { background-color: yellow; } & > span { color: green; &::after { display: inline; content: '!'; } } " > Click here for <span>Something Awsome</span> </a>
Prompt: Who was the first object store to offer S3 compatibility and when? ChatGPT 4o: Amazon Simple Storage Service (S3), introduced by Amazon Web Services (AWS) in March 2006, was the first object storage service to offer S3 compatibility.  This service established the S3 API as a de facto standard for object storage. Subsequently, other storage solutions adopted S3 compatibility to integrate seamlessly with applications designed for Amazon S3. For instance, MinIO, launched in March 2016, is a high-performance object storage system that is API compatible with Amazon S3.