Viewing profile — thenorthbay

Hey HN, together with a friend we realized in our engineering jobs that e2e testing is often broken and not worth the effort. But AI Agents could change this massively. There are a…

I just can't help observe that my developer friends increasingly build on the "low-end", serverful platforms instead of serverless. Many call serverless overkill for the (commercia…

Maybe not for editing per se. But for providing meta-functionalities to services built on top of revideo. Rendering, for instance, but maybe even reusable embeds, video watch analy…

Interesting stuff! Which use cases do you think developers will use you most for? There could be really interesting abstractions that people might build on top of this. Like automa…

that's pretty cool! Would be great to have it for TS to configure my own backend

Wouldn't it be cool to have a Supabase for SQLite? The core idea here is: let SQLite run next to your application on the server; but have all features a client-server database give…

I just did a quick search and struggled to find anything about the performance issues you referred to - can you link something so I can take another look? Thanks for the suggestion…

Hey! Thanks for the feedback. I'd just be worried people might not be using the correct libraries since I think they still provide different functionality. So exporting one Databas…

Yup! I doubt this project will naturally evolve into whatever you're describing. And that's ok! This project might help people who want to use SQLite like Firebase, with a similar …

Yeah interesting. I'm wondering what happens when I'm starting to introduce things from "outside" the system that need async operations, like processing webhooks.

Just didn't find it quickly enough after some browsing. Also, using SQLite seemed so simple.

I'm using SQLites underlying Data Change Notification functionality. It's exposed by one of the libraries mine relies on.

Thank you!

If I understood you correctly, Documents in a database, and database as a file. If else please let me know.

Thank you for the feedback. Seems this is important.

Here's the source: https://github.com/thenorthbay/doculite

Yup! I actually don't know about that. I figured this would be used for setting up newer, server-side Remix or Next projects rather than more dated ones. I could imagine that by ke…

If you use the library on a server in a node.js environment, wouldn't it be useful to fetch data (e.g. Remix / NextJS)? Besides, I'm not sure if better-sqlite3 offers the listener …

I guess it was sufficient to not have that kind of accuracy in most of the application to deliver user value. There probably were parts of the application where we used transaction…

Interesting. Updating values via incrementing them is a use case I barely had in Firebase. I mostly only dealt with 1-time updates to values, e.g. by the user or scheduled jobs. In…

Yes – I'm using JSON_extract and generated virtual columns https://www.sqlite.org/json1.html#jex Edit: the database is stored in a sqlite.db file in the cwd

Hi! As I was working on a side project, I noticed I wanted to use SQLite like a Document Database on the server. So I built Doculite. DocuLite lets you use SQLite like Firebase Fir…