next »

[JustinJ]

I noticed with 1.7.1 sqlite was added as an experimental option.
Where can I find more information on how to use this with Windows?
I will provide feedback and bug reports.

[Courgette]

with sqlite, you can either have persistent or non-persistent database.

non persitent database will be erased and fresh new every time you start B3. This is great for test and trying out B3. To use that, just set the database part of your b3.xml as follow :

Code:

<set name="database">sqlite://:memory:</set>

If you want persistent database, then the database will be saved on a file on your hard drive. Let say you want to save the database file in the same folder as your b3.xml, under the name b3_database.sqlite, then use the following snippet :

Code:

<set name="database">sqlite://@conf/b3_database.sqlite</set>

Note that plugins requiring you to create new tables on the database won't work with sqlite (unless you translate their sql script to the sqlite syntax)

any feedback is appreciated. We'd like to know if you have instability issues, if it reacts well when your server is full, or if you lost your data at some point.

[JustinJ]

Amazing work, thank you.
I will start testing this out now.