thenorthbay

5 ms·

1.
Ask HN: AI Agents for Automated Web E2E Testing
1 points by thenorthbay 2y ago|0 comments
2.
Ask HN: Is Serverless Overkill?
5 points by thenorthbay 2y ago|20 comments
3.
by thenorthbay 2y ago
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 analytics, download links, programatic re-rendering with webhooks
4.
by thenorthbay 2y ago
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 automatically creating and animating infographics, making backgrou
5.
by thenorthbay 2y ago
that's pretty cool! Would be great to have it for TS to configure my own backend
6.
Ask HN: Wouldn't it be cool to have a Supabase for SQLite?
26 points by thenorthbay 2y ago|26 comments
7.
by thenorthbay 3y ago
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 suggestions.
8.
by thenorthbay 3y ago
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 Database that allows people to pick which driver they want to
9.
by thenorthbay 3y ago
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 API and experience but without letting network req
10.
by thenorthbay 3y ago
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.
11.
by thenorthbay 3y ago
Just didn't find it quickly enough after some browsing. Also, using SQLite seemed so simple.
12.
by thenorthbay 3y ago
I'm using SQLites underlying Data Change Notification functionality. It's exposed by one of the libraries mine relies on.
13.
by thenorthbay 3y ago
Thank you!
14.
by thenorthbay 3y ago
If I understood you correctly, Documents in a database, and database as a file. If else please let me know.
15.
by thenorthbay 3y ago
Thank you for the feedback. Seems this is important.
16.
by thenorthbay 3y ago
Here's the source: https://github.com/thenorthbay/doculite
17.
by thenorthbay 3y ago
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 keeping sqlite and sqlite3 up to date, people might also
18.
by thenorthbay 3y ago
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 functionalities I care about. Skimming the do
19.
by thenorthbay 3y ago
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 transactions. Could be a cool feature to build for this, though.
20.
by thenorthbay 3y ago
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 which scenario would the current design cause you problems?
21.
by thenorthbay 3y ago
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
22.
Show HN: Doculite – Use SQLite as a Document Database(npmjs.com)
160 points by thenorthbay 3y ago|56 comments