Alec Larson
Alec Larson
To start out, we could rip the organization from https://jawj.github.io/zapatos/ 😄
Tusken plugin that adds `Array.prototype` methods to `Select` queries as shorthand for `.then(rows => rows.map(...))` etc. Possibly with subquery support too?
Write a plugin package that provides superuser functionality, like managing tables, indexes, triggers, roles, etc.
- Plugins found in `node_modules` are loaded automatically - Their name must match a pattern like Babel uses (https://babeljs.io/docs/en/options#name-normalization) but imagine those patterns with `tusken` instead of `babel` - Plugins...
If you're calling a Postgres function that accepts `t.json` or `t.jsonb` and you pass a JS array, it will be serialized as a Postgres array (not a JSON array). This...
```sql SELECT array_fill(1, ARRAY[3]); SELECT array_fill(1, ARRAY[2,3]); ```
```ts db.select( t.tweet(tweet => ({ // Many-to-one relation author: db.get(t.user, tweet.author), // Many-to-many relation hashtags: db.select(t.hashtag).where(hashtag => hashtag.id.in(tweet.hashtags)), // One-to-many relation likes: db.select(t.like).where(like => like.tweet.eq(tweet.id)), })) ) ``` That query...