#9 Add SQLite3 Support

closed-fixed
nobody
None
5
2009-09-16
2009-07-01
No

Now that PostgreSQL ist supported there is only support for SQLite3 missing, to support all major databases which bacula supports, too. As bweb also does not have support for SQLite3 I wonder if there is a specific reason for it.

SQLite3 support is primarly useful if bacula is used in an embedded environment, to have a web GUI for these types of installations would be very nice.

Discussion

  • Yuriy Timofeev

    Yuriy Timofeev - 2009-07-07

    I do not think that Zend Framework will be useful for embedded environments.

     
  • Carsten Menke

    Carsten Menke - 2009-07-07

    Actually I plan to get Bacula in FreeNAS so embedded comes here more of a software view, it is just overhelmed to install a complete MySQL Database just for that, so embedded in my case means space of installation (it has to fit onto a compact flash card). It is not RAM or Processing Power, I got plenty of this.

     
  • Carsten Menke

    Carsten Menke - 2009-08-27

    SQLite3 Patch

     
  • Carsten Menke

    Carsten Menke - 2009-08-27

    Differences between SQL Statements

     
  • Carsten Menke

    Carsten Menke - 2009-08-27

    I've added SQLite3 support (done with a checkout of 15th August. Please find the patch attached. However I would recommend to put all SQL Statements into a separate class instead of duplicating the whole SQL String and doing a case/switch statement everytime.

    I've put together the relevant differences between the SQL Statements in the File DbSqlStrings.php

    If you quer the Database Type on Startup and set the variables noted there, you then later write

    SELECT Job,Fied1,Field2,StartTime FROM Job WHERE StartTime > $DB_StartTime;

    for example

     
  • Yuriy Timofeev

    Yuriy Timofeev - 2009-09-16

    added in 3.1.rc1

     
  • Yuriy Timofeev

    Yuriy Timofeev - 2009-09-16
    • status: open --> closed-fixed
     

Log in to post a comment.