Forums > MaxMSP

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

March 16, 2011 | 3:55 pm

I read http://cycling74.com/2008/09/05/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)

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!


March 16, 2011 | 4:30 pm

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


March 16, 2011 | 4:38 pm

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


March 16, 2011 | 10:32 pm

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

– Pasted Max Patch, click to expand. –

Viewing 4 posts - 1 through 4 (of 4 total)