aarpmcgee (u/aarpmcgee)

aarpmcgee commented on Triplit: Open-source DB that syncs data between server and browser in real-time github.com/aspen-cloud/tr... · Posted by u/thunderbong

matlin · 2 years ago

Triplit is pretty opinionated about how things get stored so it doesn't work with existing SQLite schemas. We support basic `like` operators for searching but are definitely interested in supporting full text search. If you want to try that out, we use Sqlite in our server implementation so you can see an example there: https://github.com/aspen-cloud/triplit/blob/main/packages/se...

aarpmcgee · 2 years ago

Interesting! So with this configuration, would there be any sqlite instance running in the browser, or does triplit only sync with sqlite on the server?

aarpmcgee commented on Triplit: Open-source DB that syncs data between server and browser in real-time github.com/aspen-cloud/tr... · Posted by u/thunderbong

aarpmcgee · 2 years ago

This looks so cool and might use it for my project. Are there any examples showing how to use Sqlite? I dug around the docs for some time but only found mention of sqlite in passing. I'm developing a notes app and will be using sqlite's full text search extension a lot—wondering if anyone knows if the react bindings/hooks will properly update the UI if the UI is showing data from virtual tables.

aarpmcgee commented on Svelte 5: Runes svelte.dev/blog/runes... · Posted by u/benmccann

aarpmcgee · 2 years ago

For me, in both Firefox and Chrome (but not Safari), all the code samples look like this:

https://imgur.com/yGXHb1h

Anyone know what's going on here?

aarpmcgee commented on Launch HN: Tiptap (YC S23) – Toolkit for developing collaborative editors · Posted by u/philipisik

patrickbaber · 2 years ago

Thank you for your open source contributions and in-depth articles. We think that the field of collaboration is still new and evolving. Because of the pros and cons of the different implementations, we think it might be a good idea to have the choice between libraries like Yjs and Automerge. Would you use it?

aarpmcgee · 2 years ago

I wouldn't say no to first-party integration with crsqlite! [1]

[1] https://github.com/vlcn-io/cr-sqlite

aarpmcgee commented on Simone Weil’s Great Awakening newstatesman.com/ideas/20... · Posted by u/enskied

aarpmcgee · 2 years ago

Stanford Encyclopedia of Philosophy has an article on Simone Weil [1]. I haven't read it yet, but now I plan to.

[1] https://plato.stanford.edu/entries/simone-weil/

aarpmcgee commented on Next.js App Router Update nextjs.org/blog/june-2023... · Posted by u/feross

leerob · 2 years ago

Sorry about this. I work on the documentation (author of the post). Are you talking about searching through the docs or searching through GitHub? ARe there specific things you've searched for you couldn't find?

aarpmcgee · 2 years ago

It has been primarily related to web search and Github. It has been a month or two since I last tried the Next.js app router and I don't remember specifics, but I do recall that my workflow often involved searching for an issue, article, or guide related to how to accomplish something or fix something in relation to the router, but with the distinction between routing mechanisms being represented by these relatively generic nouns (app/pages), I found it difficult/cumbersome to identify if the information I was looking at was pertinent to the routing mechanism I was using. I wouldn't be surprised if the situation has improved by now.

I'd also like to mention that I regret my uncharitable phrasing in my original comment "…the most ungooglable and generic name they could have chosen…". While I do think more specific names might have helped in some ways, I can appreciate the difficulty in coming up with names for this kind of thing.

aarpmcgee commented on Next.js App Router Update nextjs.org/blog/june-2023... · Posted by u/feross

aarpmcgee · 2 years ago

I have found that it is pretty difficult to find what I'm looking for when searching for articles/issues that relate in any way to the Next router. "App router" and "pages router" were two of the most ungooglable and generic name they could have chosen. Suddenly it is much more difficult to find what I'm looking for in the ecosystem.

aarpmcgee commented on UnsuckJS: Progressively enhance HTML with lightweight JavaScript libraries unsuckjs.com/... · Posted by u/vmoore

aarpmcgee · 2 years ago

Perhaps Crank.js[1] would belong on this list

[1]: https://crank.js.org/

aarpmcgee commented on Why SQLite is so great for the edge blog.turso.tech/why-sqlit... · Posted by u/thunderbong

samwillis · 2 years ago

For a tenanted SAAS app SQLite at the edge is a really compelling architecture. You have a single DB per customer/company/group with all their users woking against that. It can operate at the edge, closest to where the majority of the customers users are.

SQLite could scale to even quite large customers with this.

Another really compelling architecture is a DB per user, with partial/selective sync between the nodes. If you then couple this with a "local first" design, the "edge" just becomes an other local deployment that the users db can sync against. Collaborative apps, where the users have their own documents but can also share/fork them would align well with this.

I believe starting with "local first" and using the edge for sync and "online only" modes is going to become the default for a significant number of apps moving forward. SQLite with CRDT based syncing and merge conflict resolution is the way to do this. There are a couple of exciting projects working on this:

https://electric-sql.com/

https://vlcn.io/

aarpmcgee · 2 years ago

more at https://localfirstweb.dev/

aarpmcgee commented on Speed running Monkey Island grumpygamer.com/speed_run... · Posted by u/mepian

soneca · 2 years ago

Just to have at least one counterpoint in this thread, but I loved the ending. Much, much better, IMO, than a non-meta epic fight with LeChuck, for example.

I took it as a very interesting and profound discussion about the role of games and fantasy in our lives as adults after playing it from a different perspective as kids. The dialogs during the ending are very well thought and thought-provoking. The role of Elaine in it is special.

I loved the whole game, but the ending brought it to a complete new level for me. It’s probably something that I’ll want to play again a few years from now.

aarpmcgee · 2 years ago

I loved the ending too. I found it very emotionally resonant and I teared up a bit.