Archive feature

[ryan876smith]

Any solutions for a archive feature since my DB is filling up quickly

[cornernote]

If you are using MySQL then try pt-archiver.

If you are using SQLite then rename the database each month.

Let me know if you have any other ideas or suggestions and I can add all this into the docs.

[dadinugroho]

Hi cornernote,

It's me again. I am really impressed with this yii-ext and your support to make this ext better.

Somehow, I am interested in this issue. Especially when we want to separate the data and the log. The capability to use mysql or sqlite is great. But, I am not sure. Can we implement that? I mean my data is as usual sored in mysql, but this extension will be using sqllite. This would be better if we have the automatic sqlite file for every month.

Thank you very much.

[cornernote]

Hi @dadinugroho,

You can simply put a cron script to move the sqlite database, then set 'autoCreateTables' => true in the config, which will create a new database.

The problem will be looking at the old data. You can use ATTACH DATABASE and UNION to query multiple sqlite databases in a single query. It may be possible to setup a yii connection to automatically do this, but I haven't looked into it.

If you find any useful resources to do this please link them to this issue and I'll look into them.