[alfanick]

I'm trying to understand what am I looking at. MS Access like db+ui in browser, with homemade engine and no sql support? What are guarantees here, concurenncy, isolation, single user? Not much on the main page.

[mftb]

DB engine appears to be sqlite. It's in the tags on the main page and there's a file full of sql to create what looks like a sample db in the data/ dir.

[alfanick]

Sqlite is fine, could we call this product somehow differently? I don't feel it's database, it's database frontend or smth.

[nichenqin]

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

[alicemeow]

It seems more along the lines of a "headless CMS", which is basically just extensible CRUD often with API endpoints; compare it to Strapi. This one looks finished enough to play around with at least.

[naushit]

Would prefer mainline DB engine like Postgres or MySQL

[adr1an]

Check baserow.io then ;)

[aae42]

why?

[nichenqin]

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

[RadiozRadioz]

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.

[nichenqin]

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

[lopkeny12ko]

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

[nichenqin]

It supports, but just hard to write for people don't know sql

[titanomachy]

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

[kidfiji]

From what I can gather, it looks to be somewhat of a self-hosted alternative to Airtable