a_simple_php_sqlite_download_counter
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
a_simple_php_sqlite_download_counter [2020/06/27 21:09] – waxphilosophic | a_simple_php_sqlite_download_counter [2020/06/27 21:24] – waxphilosophic | ||
---|---|---|---|
Line 221: | Line 221: | ||
===== Database Management ===== | ===== Database Management ===== | ||
+ | |||
+ | The more downloads there are from your site, the more the download.sl3 file will grow. My assumptions have always been for a low volume of traffic and we're not storing a ton of information. My experience with tracking my own downloads is that I only need to prune one or two times a year. Most of that is removing ebook titles that I have removed. | ||
+ | |||
+ | There is no fancy PHP page for database pruning. It can be done with the '' | ||
+ | |||
+ | SQLite also has the advantage that it will assign each row an index number. This is normally hidden from queries, but can be seen with the statement, " | ||
+ | |||
+ | Even if you're not a SQL expert, you can prune by simply picking a rowid and delete everything before it. " | ||
+ | |||
+ | ===== Go Forth and Conquer ===== | ||
+ | |||
+ | Now that you know what people are downloading from your site, you'll have better insight into what's popular and what's not. | ||
+ | |||
+ | It's your call, but I like to let people know I'm tracking downloads. Even though I'm not gathering any personal information with it, I like to be transparent about it. I put it in a privacy statement on my site and even offer a link to the PHP query that shows what's been downloaded. | ||
a_simple_php_sqlite_download_counter.txt · Last modified: 2020/06/27 21:24 by waxphilosophic