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

Mar 16, 2011 at 3:55pm

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

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!

#55548
Mar 16, 2011 at 4:30pm

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

#199809
Mar 16, 2011 at 4:38pm

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

#199810
Mar 16, 2011 at 10:32pm

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

– Pasted Max Patch, click to expand. –
#199811

You must be logged in to reply to this topic.