SQLite set up

Wappler General Need Help
1

Hi all,

I’m trying to set up an app with a Sqlite database, but I get stuck at somepointt.

Following the @ben’s video (5. The databse) I set up a new projetc, with Docker as hosting and NodeJs as server type. Then, in targets, “none” in database. At this point, there’s not a orange nor red circle, but half a green one, at the bottom left.
Right after, I go to Globals, add a new database connection, as SQLite type.
So that, under database, I can create new tables an fields, I can acces the .sqlite3 file from Navicat for SQLite, I can make changes in Navicat and update them from wappler.

But: I can’t edit the fields from wappler, when I select any field, the Properties menu, just does not appear. And not reciving any data from querys, neither in the front end app nor directly in the Api action file. (if I select the debug flag, I get "status 500 in the browser)

I can see in the video, noy only that he can edit the fields, also at the min 4:11, he can choose as data type even date format, whwn SQLite is not supossed to manage it.

I’ve tried to choose MySQL in database target, then docker starts running a server and I get the full green circle, and then I’m able to edit fields and get query results, but I think this way we are mixing up things and runing a server when SQLite should be server less.

Any idea of what am I doing wrong?

Thank you!

2

SQLite is a lightweight database that is just contained in a single file. Used mostly during development only.

For real production sites you should choose a larger database types.

See for usage:

3

Hi, first of all, thank you very much for your reply.
For others having similar issue, and following step by step the guide, I found the mistake in the server type. I had it as “Docker” when it should be “custom”.

But I still wonder.
I know SQLite is a light enviroment, that’s why I intend to use it in my project, since it’s got very basic database with just a couple of tables and a few regsitres.
What would be the point of working over SQLite in local and then migrate everything to MySQL for remote?