Re: [sqlite] Correct design to split sqlite db into month and year ?

2016-06-24 Thread Simon Slavin
On 24 Jun 2016, at 3:19am, mon siong wrote: > This is the correct design for sqlite to split database into > multiple sqlite file and access by multiple application? I also experience db > corrupt . This design cause the DB corrupt ? Your design is a good

[sqlite] Correct design to split sqlite db into month and year ?

2016-06-23 Thread mon siong
Hi    I use sqlite as database for my website develop using php and a c program  keep receiving data from socket in multithread environment, and insert the data into multiple sqlite database by month . For example if the data is January data , then insert into January sqlite db and