Arch Linux User Repository

Upstream URL is

https://code.google.com/archive/p/pacstats/

Source URL is

https://storage.googleapis.com/google-code-archive-downloads/v2/code.google.com/pacstats/pacstats-0.1.tar.gz

I've found a temporary fix for this issue.
In database.py, just replace

self._con.text_factory = sqlite.OptimizedUnicode

with

self._con.text_factory = str

You will also need to

ln -sf /usr/lib/python2.7/site-packages/matplotlib /usr/lib/python2.6/site-packages/

(there is a call somewhere to /usr/lib/python2.6/site-packages/matplotlib whereas it should be 2.7)

Don't forget to replace
#!/usr/bin/python
with
#!/usr/bin/python2

in /usr/bin/pacstats.

Then everything should work...but we still need a new release or at least a modified PKGBUILD ;)

After the transition to python 3.
Here is the runtime error :

...
Parsing the lib "/var/lib/pacman/local"
Traceback (most recent call last):
File "/usr/bin/pacstats", line 38, in <module>
app = app.Application(share_dir)
File "/usr/lib/python2.7/site-packages/PacStats/app.py", line 48, in __init__
self.main_win = main_win.Main_Window(self)
File "/usr/lib/python2.7/site-packages/PacStats/main_win.py", line 95, in __init__
self.check_update()
File "/usr/lib/python2.7/site-packages/PacStats/main_win.py", line 129, in check_update
self.on_update_db_activate(None)
File "/usr/lib/python2.7/site-packages/PacStats/main_win.py", line 221, in on_update_db_activate
self._libparser.parse()
File "/usr/lib/python2.7/site-packages/PacStats/libparser.py", line 128, in parse
self._packages.insert_many(tuples)
File "/usr/lib/python2.7/site-packages/PacStats/packages.py", line 79, in insert_many
self._database.execute_many(INSERT, tuples)
File "/usr/lib/python2.7/site-packages/PacStats/database.py", line 98, in execute_many
self._cur.executemany(string, tuples)
sqlite3.ProgrammingError: You must not use 8-bit bytestrings unless you use a text_factory that can interpret 8-bit bytestrings (like text_factory = str). It is highly recommended that you instead just switch your application to Unicode strings.

First stable release.