When I enter (command line) pihole -w ipinfo.io, two database entries are created, one in table domainlists and another in table domainlist_by_group. I expected this entry to go in the table whitelist, that is obviously NOT the case.
What are the different tables used for?
Is the whitelist table still used?
It appears to be possible to add adlists, whitelist, ... entries, using sqlite3 I'm using (example):
sudo sqlite3 /etc/pihole/gravity.db
insert into adlist (address) values ("https://dbl.oisd.nl");
.quit
The goal of course is to automate - add multiple entries, using a script (sudo sqlite3 /etc/pihole/gravity.db < /home/pi/tmp/adlists.sql), the script as follows:
CREATE TEMP TABLE i(txt);
.separator ~
.import /home/pi/tmp/adlists.list i
INSERT OR IGNORE INTO adlist (address) SELECT txt FROM i;
DROP TABLE i;
If these tables aren't used, they should be removed.
I don't think the developers would leave obsolete tables in the database, there are already 9 revisions to the database structure, see folder /etc/.pihole/advanced/Scripts/database_migration/gravity/, so this appears to be well maintained...
How can we be sure we're really running the latest beta version, apart from running pihole -up regularly. A sticky topic with the commands, required to get the latest and greatest would be an idea, this to keep the testers motivated...
Yes. When you follow the link to the PR you can see it hasn't been reviewed and merged yet.
There isn't anything you need to or really can do besides running pihole -up. I doubt we will add many more features. If everything is working well for you, you can happily use the beta now. If you have an issue, we will tell you when updating will make a difference
Maybe you can watch the Github repositories, that's the best source for information and also something that cannot be forgotten to update.
Yes. They are a convenient way to read only the enabled entries. Furthermore, for domains, they also do the filtering by domain type so you don't have to remember what type regex whitelist, etc. is.
