From 2ab1e809e6de6c00a9c2fc46a048c005a9c38c27 Mon Sep 17 00:00:00 2001 From: Pieter Lexis Date: Wed, 27 May 2015 11:22:18 +0200 Subject: [PATCH] Remove everything sqlite2 related, closes #2544 --- .../markdown/authoritative/backend-gsqlite.md | 66 ++++++++++++------- docs/markdown/authoritative/index.md | 1 - 2 files changed, 42 insertions(+), 25 deletions(-) diff --git a/docs/markdown/authoritative/backend-gsqlite.md b/docs/markdown/authoritative/backend-gsqlite.md index d2dd0fdf19..a5e0f3126c 100644 --- a/docs/markdown/authoritative/backend-gsqlite.md +++ b/docs/markdown/authoritative/backend-gsqlite.md @@ -5,29 +5,30 @@ |Master|Yes| |Slave|Yes| |Superslave|Yes| -|DNSSEC|gsqlite3 only (set `gsqlite3-dnssec`)| -|Disabled data|gsqlite3 only| -|Comments|gsqlite3 only| -|Module name|gsqlite and gsqlite3| -Launch name|gsqlite and gsqlite3| +|DNSSEC|Yes| +|Disabled data|Yes| +|Comments|Yes| +|Module name|gsqlite3| +|Launch name|gsqlite3| -**Warning**: When importing large amounts of data, be sure to run 'analyze;' afterwards as SQLite3 has a tendency to use sub-optimal indexes otherwise. +**Warning**: When importing large amounts of data, be sure to run 'analyze;' +afterwards as SQLite3 has a tendency to use sub-optimal indexes otherwise. -This backend retrieves all data from a SQLite database, which is an RDBMS that's embedded into the application itself, so you won't need to be running a separate server process. It also reduces overhead, and simplifies installation. At [www.sqlite.org](http://www.sqlite.org) you can find more information about SQLite. +This backend retrieves all data from a SQLite database, which is an RDBMS that's +embedded into the application itself, so you won't need to be running a separate +server process. It also reduces overhead, and simplifies installation. At +[www.sqlite.org](http://www.sqlite.org) you can find more information about SQLite. -As this is a generic backend, built on top of the gSql framework, you can specify all queries as documented in [Generic MySQL and PostgreSQL backends](backend-generic-mypgsql.md#queries-and-settings). +As this is a generic backend, built on top of the gSql framework, you can +specify all queries as documented in +[Generic MySQL and PostgreSQL backends](backend-generic-mypgsql.md#queries-and-settings). -SQLite exists in two incompatible versions, PowerDNS only supports version 3. To launch the backend, put `launch=gsqlite3` in the configuration. - -## Compiling the SQLite backend -Before you can begin compiling PowerDNS with the SQLite backend you need to have the SQLite utility and library installed on your system. You can download these from , or you can use packages (if your distribution provides those). - -When you've installed the library you can use: `./configure --with-modules="gsqlite3"` to configure PowerDNS to use the SQLite backend. Compilation can then proceed as usual. - -SQLite is included in most PowerDNS binary releases. +SQLite exists in two incompatible versions, PowerDNS only supports version 3. To +launch the backend, put `launch=gsqlite3` in the configuration. ## Setting up the database -Before you can use this backend you first have to set it up and fill it with data. The default setup conforms to the following schema: +Before you can use this backend you first have to set it up and fill it with +data. The default setup conforms to the following schema: ``` !!include=../modules/gsqlite3backend/schema.sqlite3.sql @@ -35,23 +36,26 @@ Before you can use this backend you first have to set it up and fill it with dat This schema contains all elements needed for master, slave and superslave operation. -After you have created the database you probably want to fill it with data. If you have a BIND zone file it's as easy as: `zone2sql --zone=myzonefile --gsqlite | sqlite3 powerdns.sqlite3`, but you can also use AXFR (or insert data manually). +After you have created the database you probably want to fill it with data. If +you have a BIND zone file it's as easy as: +`zone2sql --zone=myzonefile --gsqlite | sqlite3 powerdns.sqlite3`, but you can +also use AXFR (or insert data manually). To communicate with a SQLite database, use the `sqlite3` program, and feed it SQL. ## Configuration Parameters These are the configuration file parameters that are available for the gsqlite3 backend. -### `(gsqlite3)-database` -Filename of the SQLite3 database. +### `gsqlite3-database` +Path to the SQLite3 database. -### `(gsqlite3)-pragma-synchronous` +### `gsqlite3-pragma-synchronous` Set this to 0 for blazing speed. -### `(gsqlite3)-pragma-foreign-keys` +### `gsqlite3-pragma-foreign-keys` Enable foreign key constraints. -### `(gsqlite3)-dnssec` +### `gsqlite3-dnssec` Enable DNSSEC processing. ## Using the SQLite backend @@ -63,4 +67,18 @@ launch=gsqlite3 gsqlite3-database= ``` -Then you can start PowerDNS and it should notify you that a connection to the database was made. +Then you can start PowerDNS and it should notify you that a connection to the +database was made. + +## Compiling the SQLite backend +Before you can begin compiling PowerDNS with the SQLite backend you need to have +the SQLite utility and library installed on your system. You can download these +from , or you can use packages +(if your distribution provides those). + +When you've installed the library you can use: +`./configure --with-modules="gsqlite3"` to configure PowerDNS to use the SQLite +backend. Compilation can then proceed as usual. + +SQLite is included in most PowerDNS binary releases. + diff --git a/docs/markdown/authoritative/index.md b/docs/markdown/authoritative/index.md index 8d9f08314d..2b3eeb2003 100644 --- a/docs/markdown/authoritative/index.md +++ b/docs/markdown/authoritative/index.md @@ -27,7 +27,6 @@ The following table describes the capabilities of the backends. | [PostgreSQL](backend-generic-mypgsql.md) | Supported | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | `gpgsql` | | [Random](backend-random.md) | Supported | Yes | No | No | No | No | Yes (no key storage) | No | No | `random` | | [Remote](backend-remote.md) | Supported | Yes | Yes\* | Yes\* | Yes\* | Yes\* | Yes\* | Unknown (No) | Unknown(No) | `remote` | -| [SQLite](backend-gsqlite.md) 2 | Supported (not recommended) | Yes | Yes | Yes | Yes | No | No | No | No | `gsqlite` | | [SQLite](backend-gsqlite.md) 3 | Supported | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | `gsqlite3` | | [TinyDNS](backend-tinydns.md) | Experimental | Yes | Yes | No | No | No | No | Unknown (No) | Unknown (No) | `tinydns` | -- 2.47.2