Hi everyone,
I'm developing a new node.js web project with SqlLite.
I would like to insert texts for multi-language management into a table but I noticed that I can't insert HTML formatted values into a table field.
Currently the field type is set to Text
I think it's best you show some example. I'm guessing you just have to use a JSON encode formatter (it's not visible in Wappler's user interface, you probably have to search the forum)
Can you explain. Why not? HTML is just text and can be inserted.
Also, are you planning to.use sqlite in a oroduction environment? It really is not suitable for use in production.
The author of SQLite addresses this on the website:
SQLite works great as the database engine for most low to medium traffic websites (which is to say, most websites). The amount of web traffic that SQLite can handle depends on how heavily the website uses its database. Generally speaking, any site that gets fewer than 100K hits/day should work fine with SQLite. The 100K hits/day figure is a conservative estimate, not a hard upper bound. SQLite has been demonstrated to work with 10 times that amount of traffic.
The SQLite website (https://www.sqlite.org/) uses SQLite itself, of course, and as of this writing (2015), it handles about 400K to 500K HTTP requests per day, about 15-20% of which are dynamic pages touching the database. Dynamic content uses about 200 SQL statements per webpage. This setup runs on a single VM that shares a physical server with 23 others and yet still keeps the load average below 0.1 most of the time.