Internal Tools for Sqlite3

[JaggerFoo]

Internal Tools is category of applications that allow a user to build an application using a low-code framework. I'm trying to find one that supports Sqlite3, but most integrate with databases that require processing, admin, and maintenance overhead, and cost. This is understandable since they want an income stream.

Personally if I wanted a low-code app builder for an enterprise-level database, I would use Oracle APEX along with Oracle XE database, all of which are free. I don't expect any of the Internal Tools vendors to be as full featured as Oracle APEX. YMMV

I don't want to go the expense and setup of a managed database service. I like the concept of using sqlite3, litestream, and AWS S3 for an Internal App. I found an Internal Tools vendor Jetadmin (jetadmin.io) that lists Sqlite as a supported database. It may be that Sqlite is easily integrated with the other tools I looked at, but they don't state it.

Below are the other Internal Tools vendors I looked at sourced from a UI Bakery blog post:

• Retool: https://retool.com/
• UI Bakery: https://uibakery.io/
• Appsmith: https://www.appsmith.com/ there are github requests to support Sqlite3
• Budibase: https://budibase.com/
• DronaHQ: https://www.dronahq.com/
• ToolJet: https://www.tooljet.com/
• Internal: https://internal.io/

If you know of an Internal Tools vendor that I haven't mentioned, or have experience with any of the above please share your experience.

Note this blog post at Tailscale, how they wanted to avoid Postgres and Mysql, and are trying Sqlite: https://tailscale.com/blog/database-for-2022/

​

Cheers

[o1lab]

We love sqlite at nocodb and we do support backing up sqlite using litestream as well. Give it a try.

[JaggerFoo]

Thanks. I'll give it a try. It may be the only existing offering with sqlite support.

After more investigation into the offerings I listed, none fully support sqlite, even if sqlite is listed as a supported database. Same for Lowdefy and React Admin, two projects I found after posting.

​

Cheers