As of 3.38 (or 3.45 if you meant a binary JSON structure specifically) https://sqlite.org/json1.html
We can use json type, but the dx around directly using that is not comparable to mongodb. Which is why I was looking for a similar abstraction.
Readit Newszareith commented on QueryLeaf: SQL for Mongo github.com/beekeeper-stud... · Posted by u/tilt
There is FerretDB v1, which provides MongoDB protocol for SQLite. See https://github.com/FerretDB/FerretDB/tree/main-v1
They seemed to have moved away from that.
From https://docs.ferretdb.io/migration/migrating-from-v1
> Unlike v1.x that provides options for PostgreSQL and SQLite as backend, FerretDB v2.x requires a PostgreSQL with DocumentDB extension as the backend
Would much rather have "Mongo" for SQL like this:
https://github.com/microsoft/documentdb
I am skeptical that SQL with Mongo backing it would be at all performant except in the most trivial cases. On the flip side, Postgres's jsonb indexing makes the inverse very doable.
Curious if there is something similar that works with sqlite.
zareith commented on Show HN: Aberdeen – An elegant approach to reactive UIs aberdeenjs.org/... · Posted by u/vanviegen
This looks cool, love the API.
I don't any support for lifecycle hooks (eg. something like onMount when the returned node will be attached to the document) in the component api. In absense of those, I imagine integrating with vanillajs libraries will be difficult (eg. codemirror, slickgrid etc.) Curious what your thoughts in the matter are.
I think an underappreciated library in this space is Logux [1]
It requires deeper (and more) integration work compared to solutions that sync your state for you, but is a lot more flexible wrt. the backend technology choices.
At its core, it is an action synchronizer. You manage both your local state and remote state through redux-style actions, and the library takes care of syncing and resequencing them (if needed) so that all clients converge at the same state.
zareith commented on Konva.js - Declarative 2D Canvas for React, Vue, and Svelte konvajs.org/... · Posted by u/lavrton
Don't know about the library but the spreadsheet project built on top is impressive https://www.rowsncolumns.app/
Unrelated tangent, but $300 for non-commercial use with limited features... wow!
zareith commented on Show HN: EnkiTask: Lightweight Project Management for Freelancers enkitask.com/... · Posted by u/booper
zareith commented on Show HN: EnkiTask: Lightweight Project Management for Freelancers enkitask.com/... · Posted by u/booper
The project looks cool, but I'd strongly recommend against the per-task pricing.
This makes budgeting & forecasting difficult to impossible for a lot of teams, and creates wrong incentives. It is better to have a per user pricing, and then allow them to use as much as they want.
zareith commented on Show HN: Nash, I made a standalone note with single HTML file keepworking.github.io/nas... · Posted by u/yevgenyhong
Love this. The proliferation of software that imposes artificial limitations and puts features that can be (and have been) easily performed locally, behind subscriptions is quite frustrating.
I have been working on a free markdown editor that works entirely in the browser and can edit local files through the new filesystem access api (available in chromium only browsers).
I have used and like HTMX. But I think Unpoly is more batteries included, in a good way:
It has more built-in functionality that most web applications are going to need.
Also: https://mizu.sh/
It embraces a more structured and composable approach and I love that it embraces web-components.