I would like to create a new table every day named with the daily date.

Is this possible to do so in max, with the java script sqlite.

Hi all,
I would like to create a new table every day named with the daily date.
Is this possible to do so in max, with the java script sqlite.
Thx
ad


date-as-new-table-in-sqlite-is-it-possible

Shouldn't be too difficult. You can either use the javascript Date object, or the Max Date object (and just send that to the js object) to get the date. Here is a basic tutorial for using SQLite in Max:

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

I might just have a patch running that is checking the output of the date object, then when the time output matches the point that that you would like the table to be made, trigger a function in your js object that creates a new table. Just one way to possibly tackle it.

Shouldn't be too difficult.  You can either use the javascript Date object, or the Max Date object (and just send that to the js object) to get the date.  Here is a basic tutorial for using SQLite in Max:

I might just have a patch running that is checking the output of the date object, then when the time output matches the point that that you would like the table to be made, trigger a function in your js object that creates a new table.  Just one way to possibly tackle it.

Better surely to have a single table, with a known name and add a date column.

I tried even with number named table and it doesn't seem to work (see the patch)

@big_pause:what would you suggest ? I have to recover from daily date the numbers of people for instance. Is this what foreign key made for ? would you have some example of such stuffs ?

@ben
I tried even with number named table and it doesn't seem to work (see the patch)

@big_pause:what would you suggest ? I have to recover from daily date the numbers of people for instance. Is this what foreign key made for ? would you have some example of such stuffs ?  

I'd suggest googling for some basic sql tutorials.

sqlite doesn't have a native date type, but in the past (not max related), I've always used integers for dates formatted as yyyymmdd eg 20120314 (natural ordering with this format, for instance if you use the BETWEEN operator in a clause). You could of course if you wanted store in a varchar.

exec "CREATE TABLE a(name VARCHAR(256), value VARCHAR(512), my_date INTEGER)"

your insert can then just change to for eg

exec "INSERT INTO a ('name', 'value', 'my_date') VALUES ('foo', '673', 20120314)

and crucially, you can add a clause to your select statement

exec "SELECT * FROM a WHERE my_date=20120314"

some db's won't like table or columns that start with numbers, you can force the issue though, you will need to search on this for sqlite specific behaviour.

let me know if this all makes some kind of sense to you.