| 428 | | <application>SQLite</application> is supported but not documented for now. |
| | 428 | <application>SQLite</application> is an embeddable Relationnal DataBase |
| | 429 | distributed under a Free Software |
| | 430 | license from the |
| | 431 | <ulink url="http://www.sqlite.org">http://www.sqlite.org</ulink> |
| | 432 | web site. |
| | 433 | If is very easy to configure and use, offers a very small memory footprint, |
| | 434 | is very fast, but can only be used on the print server because it doesn't include |
| | 435 | a server daemon : the database is directly embedded in the application. |
| | 436 | </para> |
| | 437 | |
| | 438 | <para> |
| | 439 | To configure your database, you must have SQLite already working. |
| | 440 | The complete installation of <application>SQLite</application> is not covered by |
| | 441 | the present manual, please refer to your system's documentation or to |
| | 442 | <ulink url="http://www.sqlite.org">http://www.sqlite.org</ulink> for |
| | 443 | details. |
| | 444 | </para> |
| | 445 | |
| | 446 | <para> |
| | 447 | Once <application>SQLite</application> is installed, you have to decide where |
| | 448 | you'll put your database. A good idea is to store it into the <literal>pykota</literal> |
| | 449 | user's home directory. Then to create the database, just type : |
| | 450 | <screen> |
| | 451 | # sqlite3 ~pykota/pykota.db <pykota/initscripts/sqlite/pykota.sqlite |
| | 452 | # chown pykota.pykota ~pykota/pykota.db |
| | 453 | # chmod 660 ~pykota/pykota.db |
| | 454 | # chown pykota.pykota ~pykota |
| | 455 | </screen> |
| | 456 | </para> |
| | 457 | <para> |
| | 458 | If user <literal>pykota</literal> doesn't exist yet, then please |
| | 459 | follow the instructions a bit below which explain how to install PyKota on the print server. |
| | 460 | </para> |
| | 461 | |
| | 462 | <para> |
| | 463 | Once this is done, you'll want to set in <filename>~pykota/pykota.conf</filename> the |
| | 464 | following lines in the <literal>[global]</literal> section : |
| | 465 | <screen> |
| | 466 | storagebackend : sqlitestorage |
| | 467 | storagename : /etc/pykota/pykota.db |
| | 468 | </screen> |
| | 469 | </para> |
| | 470 | <para> |
| | 471 | Of course you'll want to replace the path on the <literal>storagename</literal> line |
| | 472 | with the full path to the newly created <application>SQLite</application> database. |
| | 473 | </para> |
| | 474 | <para> |
| | 475 | That's all ! For more details, please refer to <filename>pykota/initscripts/sqlite/README.sqlite</filename>. |
| 532 | | SQLite backend : Supported but not documented yet. |
| | 579 | SQLite backend : SQLite is not a database server, but an embeddable database, so |
| | 580 | if you want to use it you MUST install SQLite on your print server. With |
| | 581 | <application>PostgreSQL</application>, <application>MySQL</application> or |
| | 582 | <application>OpenLDAP</application> you can store your datas on a different |
| | 583 | machine than the print server, but this is not possible with <application>SQLite</application>. |
| | 584 | <itemizedlist> |
| | 585 | <listitem> |
| | 586 | <para> |
| | 587 | <application>SQLite</application> version 3.2.1 or higher and its library. |
| | 588 | You can download it from |
| | 589 | <ulink url="http://www.sqlite.org">http://www.sqlite.org</ulink> |
| | 590 | </para> |
| | 591 | </listitem> |
| | 592 | <listitem> |
| | 593 | <para> |
| | 594 | The <application>Python-SQLite</application> python module version 2.0.5 or higher. |
| | 595 | You can download it from |
| | 596 | <ulink url="http://www.pysqlite.org">http://www.pysqlite.org</ulink> |
| | 597 | </para> |
| | 598 | </listitem> |
| | 599 | </itemizedlist> |
