Will fix the issues!

I like your idea!

Will find out the bug and fix it

I spent about two weeks to migrate from old code from react (nextjs) to sveltekit and I feel svelte is so easy to use and promising.

What drove you to migrate, and out of curiosity, what makes Svelte worth it to you?

I tried 60,000 records and 20 columns and display in fe on my Mac in 4 seconds, not a official benchmark but sqlite have impressive performance

I'm a big fan of Ms access!

thanks for you feedback, there is more feature on our roadmap and it will always be local friendly and easy to host. I'll consider to switch undb to MIT someday.

If you license APL you can always offer MIT (or even proprietary) for a fee.

Undb handles reference for you, which is always most hard/difficult part to handle in most lowcode system, so it's not just a database frontend. It's like MS access when you link reference in the access ui, but undb can also handle lookup & rollup in browser

GP didn't ask about references. They asked what the tool actually was, and asked about the types of guarantees it provides compared to a known RDBMS.

I got it. And in my opinion the most value undb provide is to handle the reference part which you always have to impl in code when you use traditional RDBMS. Also it provides typed api, real-time sub and user friendly views

...You're still not answering the question. What are the ACID properties? Why is SQL, a standard for database query languages, not supported?

By “reference” you mean like foreign key reference? Joins?

You are right, it's not a database, so I call it undb :P

sqlite is cheap when you sync the file in s3