Hi! Does anyone know: is it possible to use SQLite in vvvv gamma? Or are there other databases?
we don’t have much on databases yet. but everything is possible, see: Databases | vvvv gamma documentation
Hey @slepoy_ali,
Last times I had to work with an SQL database, I found it way more convenient to run an external tool that creates a REST API on top of it so you don’t have to deal with database-specific nodes.
Been using Rest and was super happy with it :
You start this executable with the proper arguments to point it to your SQLite database, and it will spawn a REST API you can make queries to to add/edit/remove stuff from your DB.
Their documentation is available here.
For complex scenarios you could also try Directus which is a headless CMS that gives you a fancy user interface and a very granular permission system as well as a REST API on top of an SQL database. But that’s way more involved, for simple cases the first tool I linked above should work fine.
3 Likes