Hacker News Reader

Comment by emptyparadise | Hacker News Reader

I wish there was some sort of an Access-like form/app builder tool for quickly building GUIs around SQLite databases. That's the one thing I miss. I'd love to reach for SQLite instead of Excel or something.

View on HN

We're maintaining a rapid dev solution for building Apps for SQLite + other popular RDBMS's at: https://www.locode.dev

You just need to create your API definitions and you get APIs + Auto management UI for free, here's our most recent video showing how you can build a multi-user Bookings App in minutes [1].

[1] https://youtu.be/rSFiikDjGos

This is the thing about Access. For simple to moderate stuff you can't really bear it for easy of building and deployment due to the forms and reports being integrated with the tables and queries. I'm always surprised by how powerful it is and what you can accomplish with it. Nothing beats it for local, department type I formation management, libre/open office don't come close.

With that easy of use comes its reputation of being a nightmare to manage, mostly because it's easy enough for people with no knowledge of the relational model to use.

If there was a similar solution utilising sqlite as the backend I'd definitely be using it.

Ultorg is interesting [1][2].

[1] https://www.ultorg.com/

[2] https://www.hytradboi.com/2022/ultorg-a-user-interface-for-r...

I did some work several years ago using (I think) DB Browser for SQLite: https://sqlitebrowser.org/

Mostly just analysis, no app building. But it is a great tool

I believe that Libreoffice Base supports SQLite.

It does

https://wiki.documentfoundation.org/Documentation/HowTo/Base...

Although it could use some more Linux in that link.

I hope to play with Appsmith soon. It looks really cool. It doesn't seem to have an sqlite connector but I wonder how hard that would be to build. Note that I know nothing about Appsmith and almost nothing about sqlite, but I'm intrigued by the possibilities. https://www.appsmith.com/

Many db applications tack on a spreadsheet gui and a form input mode. See baserow, budibase, airtables, memento, etc. Some include fancier features like webhooks and ACLs.

My main rant is the lack of import/export standardization in this space.

Not too familiar with the space, how do all of these stack up? Are they mostly SaaS or are there local/offline options? Do any of these have personal plans?

Grist is another one for the list. It's not quite the same in terms of GUI building, but depending on the use case, it may be enough.

As so often before: https://www.lazarus-ide.org/

I can't recall for certain, but I feel at least 75% sure there is an included demo project that shows how to wire up a simple CRUD app in, like, seven mouse clicks.

Not SQLite, but try Retool with their new RetoolDB (which is an integrated version of Postgres).

This totally fills the Access gap for me, assuming that you are looking for / happy with a web interface and a SaaS model which is paid per user (but free for first 5)

If it's SaaS, it's entirely different from the excel use-case (which is unfortunately ubiquitous and offline). It's also different from the average SQLite use-case, which is also local.

For my use-cases it’s mostly replaced Access.

If your use case requires everything to be local and offline it won’t work, but if you can be online it’s a great replacement.

We're working on it! => https://www.airsequel.com/ =)

LibreOffice Base?

Reply on news.ycombinator.com