4 ms·

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 r

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.

nvrspyx 4y ago
I believe that Libreoffice Base supports SQLite.
- rascul 4y ago
  It does https://wiki.documentfoundation.org/Documentation/HowTo/Base/Connect_to_SQLite https://wiki.documentfoundation.org/Documentation/HowTo/Base... Although it could use some more Linux in that link.
Closi 4y ago
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)
- krageon 4y ago
  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.
  - Closi 4y ago
    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.
yellowapple 4y ago
LibreOffice Base?
mythz 4y ago
We're maintaining a rapid dev solution for building Apps for SQLite + other popular RDBMS's at: https://www.locode.dev 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 https://youtu.be/rSFiikDjGos
doctor_eval 4y ago
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/ https://www.appsmith.com/
lliamander 4y ago
I did some work several years ago using (I think) DB Browser for SQLite: https://sqlitebrowser.org/ https://sqlitebrowser.org/ Mostly just analysis, no app building. But it is a great tool
jhd3 4y ago
Ultorg is interesting [1][2]. [1] https://www.ultorg.com/ https://www.ultorg.com/ [2] https://www.hytradboi.com/2022/ultorg-a-user-interface-for-relational-databases https://www.hytradboi.com/2022/ultorg-a-user-interface-for-r...
viraptor 4y ago
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.
jiggunjer 4y ago
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.
- emptyparadise 4y ago
  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?
deleted 4y ago
[deleted]
account-5 4y ago
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.
adius 4y ago
We're working on it! => https://www.airsequel.com/ https://www.airsequel.com/ =)
CRConrad 4y ago
As so often before: https://www.lazarus-ide.org/ 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.

nvrspyx 4y ago

I believe that Libreoffice Base supports SQLite.

rascul 4y ago
It does https://wiki.documentfoundation.org/Documentation/HowTo/Base/Connect_to_SQLite https://wiki.documentfoundation.org/Documentation/HowTo/Base... Although it could use some more Linux in that link.

Closi 4y ago

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)

krageon 4y ago
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.
- Closi 4y ago
  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.

yellowapple 4y ago

LibreOffice Base?

mythz 4y ago

We're maintaining a rapid dev solution for building Apps for SQLite + other popular RDBMS's at: https://www.locode.dev 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 https://youtu.be/rSFiikDjGos

doctor_eval 4y ago

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/ https://www.appsmith.com/

lliamander 4y ago

I did some work several years ago using (I think) DB Browser for SQLite: https://sqlitebrowser.org/ https://sqlitebrowser.org/ Mostly just analysis, no app building. But it is a great tool

jhd3 4y ago

Ultorg is interesting [1][2]. [1] https://www.ultorg.com/ https://www.ultorg.com/ [2] https://www.hytradboi.com/2022/ultorg-a-user-interface-for-relational-databases https://www.hytradboi.com/2022/ultorg-a-user-interface-for-r...

viraptor 4y ago

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.

jiggunjer 4y ago

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.

emptyparadise 4y ago
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?

deleted 4y ago

[deleted]

account-5 4y ago

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.

adius 4y ago

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

CRConrad 4y ago

As so often before: https://www.lazarus-ide.org/ 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.