How to do an insert to sqlite


#1

Hi Glitch community. I’m looking for example code that illustrates how to pass client (HTML form) data to a Node/Express/sqlite back-end. (I want to insert a piece of text enterd by the user into a sqlite table.) Any suggestions/pointers would be gratefully appreciated. (Glitch newbie)


#2

Here’s an example project which does that using sqlite via sequelize: https://glitch.com/~sqlite3-db


#3

Thanks Gareth - I did see that example and while it does the job I was keen to use native SQL.
Here’s the project … https://glitch.com/edit/#!/join/99338a87-a051-46c2-96e4-50125ed7e72d