appsmithorg
[Feature]: Support for SQLite3
Is there an existing issue for this?
- [X] I have searched the existing issues
Summary
A user has requested for an SQLite3 DB integration
Why should this be worked on?
SQLite is a widely used SQL datasource and should be very similar to our exisiting datasources
I would like this as well. I just setup appsmith and was excited to test it but was very surprised to find SQLite3 wasn't a supported datasource.
I second this. SQLite is used for many micro/small projects and the biggest issue comes when one has to "throw" a quick UI over the DB. Is this on the roadmap for the future?
Hello! We don't currently have this on our roadmap since we haven't received too many requests for it yet. We'd be very open to a community contribution on this datasource!
There are a lot of developers that need this. Sqlite is a really used database
Agree, we'd love to have this for some of our internal tools for non-developers too
I'll throw in my vote too, after reviewing my options I decided to use appsmith for a work project, only to find out during setup that it doesn't support sqlite.
I too use sqlite for many of my projects and would love to see appsmith support it.
Idem... Quelle déception en voyant que SQLite n'est pas pris en charge... J'espère qu'il ne faudra pas des lustres pour que cela change. Je croise les doigts (20) :D
@FJEagle any reason you aren't ok with using the supabase.com free tier?
this was also one of the first things I was looking for but couldn't find.
+1 Please i really love appsmith and i have a lot of small projet with sqlite, i really want to mutulize all of my app with appsmith
SQLite is one of the most popular databases, on par with Postgres. Not supporting it is baffling.
Cloudflare D1 is based on SQLite - a supported integration would be amazing!
SQLite is one of the most popular databases, on par with Postgres. Not supporting it is baffling.
It would be great for users that self-host personal projects, but maybe that's not the intended audience.
Edit: I ended up going with NocoDB since it has sqlite support, and skipped appsmith altogether
@NilanshBansal Sqlite support is when appsmith hosted in local? or do we need to think taking leverage of web apps?
@shanid544 this functionality should work for both appsmith cloud as well as self hosted.
@NilanshBansal To integrate SQLite with Appsmith, I have explored several approaches and decided to leverage existing cloud solutions. During my research, I came across SQLiteCloud and am considering utilizing its WebLite service for seamless integration. I found the documentation for WebLite at SQLiteCloud WebLite Docs, which provides useful insights. Should I proceed with this approach, or would you have any other suggestions?
in this we can import the db files.