Member
All I found was an old thread that was 4 years old..
But I am wondering if there is any continued effort (or revisiting the effort) to run zenphoto with sqlite.
My server had a filesystem crash 2 days ago; and it's been a while between backups; and so now I will be spending the next few days "trying" to recover stuff out of mysql. The old HD is still intact, and if zenphoto was running sqlite, then I would have been able to just cp -p * and all would be well. Instead, I have to muck and try to get mysql to cough up some sort of backup.
So again, I'm hoping to generate renewed interest in sqlite.
But I am wondering if there is any continued effort (or revisiting the effort) to run zenphoto with sqlite.
My server had a filesystem crash 2 days ago; and it's been a while between backups; and so now I will be spending the next few days "trying" to recover stuff out of mysql. The old HD is still intact, and if zenphoto was running sqlite, then I would have been able to just cp -p * and all would be well. Instead, I have to muck and try to get mysql to cough up some sort of backup.
So again, I'm hoping to generate renewed interest in sqlite.
Administrator
Member
We have done some preparatory work in isolating out (as much as we have knowledge) the database dependent stuff so that Zenphoto can support multiple databases.
We would like to take this further. But it requires some knowledge that neither of the active developers possess. If you have knowledge of sqlliet vs. MySQL I would be glad to work with you in making this happen.
The quick overview is that there are two places changes are needed. First there needs to be made a functions-db-sqlite.php script. This is just a modification of the functions-db-MySql.php script changing it to comply with the sqlite api.
Second, there are areas of setup.php that are flagged as probably being MySQL specific that will need to be abstracted. So, if you are interested, create a ticket on track for the effort. We can converse on that ticket for the details.
[b]Notice[/b]: anyone interested in any other database support (or perhaps to help with this effort) please create/contribute to implementation tickets.
We would like to take this further. But it requires some knowledge that neither of the active developers possess. If you have knowledge of sqlliet vs. MySQL I would be glad to work with you in making this happen.
The quick overview is that there are two places changes are needed. First there needs to be made a functions-db-sqlite.php script. This is just a modification of the functions-db-MySql.php script changing it to comply with the sqlite api.
Second, there are areas of setup.php that are flagged as probably being MySQL specific that will need to be abstracted. So, if you are interested, create a ticket on track for the effort. We can converse on that ticket for the details.
[b]Notice[/b]: anyone interested in any other database support (or perhaps to help with this effort) please create/contribute to implementation tickets.