Julien Bayle

https://cycling74.com/tutorials/data-collection-building-databases-using-sqlite/

I didn't understand where the database file is stored.

So I'm trying to know what would be the best compromise between reliability/safeness & simplicity.

I'll only have to store around 800 entries in the DB.

This number won't increase (it is a pool of rfid tags..)

this DB will be only requested with "SELECT".

a server will have the DB patch, and clients will send ID & the server will send language (through OSC over udp)

I'd need to load it at load time but I can do that easilty loadbang+my js

I just have to figure out how to manage (& backup) those files!

I read https://cycling74.com/tutorials/data-collection-building-databases-using-sqlite/

I didn't understand where the database file is stored.
So I'm trying to know what would be the best compromise between reliability/safeness & simplicity.

I'll only have to store around 800 entries in the DB.
This number won't increase (it is a pool of rfid tags..)
2 fields, id & language.
this DB will be only requested with "SELECT".
a server will have the DB patch, and clients will send ID & the server will send language (through OSC over udp)

I'd need to load it at load time but I can do that easilty loadbang+my js 

sqlite seems nice.
I just have to figure out how to manage (& backup) those files!


where-are-those-sqlite-database-file-im-using

From memory, the sqlite db files are written to the max application directory unless they are created with an explicit path in the filename.

I guess my filename/filepath isn't correct so I cannot "see" them :-(

thanks a lot spectro.
I guess my filename/filepath isn't correct so I cannot "see" them :-(


Try hooking this up. This should give you a database at a specified file location.

Try hooking this up.  This should give you a database at a specified file location.


where are those sqlite database file I'm using ....???