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

Julien Bayle's icon

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)

no more, no less.

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

any advices? ideas? experiences?

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

spectro's icon

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

Julien Bayle's icon

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

Andrew Benson's icon
Max Patch
Copy patch and select New From Clipboard in Max.

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