Arch Linux User Repository

With the latest update this doesn't build for me anymore:

==> Starting build()...
* Getting build dependencies for wheel...

ERROR Missing dependencies:
        pytest-runner
==> ERROR: A failure occurred in build().
    Aborting...

Adding python-pytest-runner to makedepends fixes the build (since datasette 1.0a8 the responsible (deprecated) setup_requires=["pytest-runner"] in setup.py is removed).

Hi, could it be that the latest release requires click-default-group-wheel[0] instead of click-default-group to run?

[…]
    raise DistributionNotFound(req, requirers)
pkg_resources.DistributionNotFound: The 'click-default-group-wheel>=1.2.2' distribution was not found and is required by datasette

[0] https://github.com/simonw/click-default-group-wheel

@NBonaparte

Yes, python-setuptools is installed.

Do you have python-setuptools installed? It seems to build fine for me.

Hello, I think the package doesn't build anymore:

==> Starting build()...
Traceback (most recent call last):
  File "setup.py", line 1, in <module>
    from setuptools import setup, find_packages
ModuleNotFoundError: No module named 'setuptools'
==> ERROR: A failure occurred in build().
    Aborting...
 -> error making: datasette

I've created a csvs-to-sqlite package. Unfortunately it requires an out-of-date version of python-click (7.0, while the version in the repos is 8.0). I manually changed the requirements to click>=7.0 and it seems to work fine, let me know if it doesn't.

Thanks for your effort in providing these very active maintained and extremely usefull packages.

Datasette seems to be working properly now. Sqlite-utils also.

Hope that with enough votes and interest these can be made into official Arch packgaes.

csvs-to-sqlite also installs nicely with "pipx", to a users home dir. Because of it's dependencies on pandas and numpy it pulls 120 MB though to build a virtual env. That's a bit redundant, if one already has pandas in the system.

That's the reason I wanted to see a PKGBUILD also for csvs-to-sqlite

install_requires=[
        "click~=7.0",
        "dateparser>=1.0",
        "pandas>=1.0",
        "py-lru-cache~=0.1.4",
        "six",

I've updated the package to 0.57.1 which should fix this. I never got around to creating packages for those but I'll have a go at them now, thanks for the tip.

This isnt installing datasette properly.

I testetd

datasette --help

and got errors, apparently related to some problem ??? with "itsdangerous":

Traceback (most recent call last):
  File "/usr/lib/python3.9/site-packages/pkg_resources/__init__.py", line 568, in _build_master
    ws.require(__requires__)
  File "/usr/lib/python3.9/site-packages/pkg_resources/__init__.py", line 886, in require
    needed = self.resolve(parse_requirements(requirements))
  File "/usr/lib/python3.9/site-packages/pkg_resources/__init__.py", line 777, in resolve
    raise VersionConflict(dist, req).with_context(dependent_req)
pkg_resources.ContextualVersionConflict: (itsdangerous 2.0.1 (/usr/lib/python3.9/site-packages), Requirement.parse('itsdangerous~=1.1'), {'datasette'})

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/bin/datasette", line 33, in <module>
    sys.exit(load_entry_point('datasette==0.56', 'console_scripts', 'datasette')())
  File "/usr/bin/datasette", line 25, in importlib_load_entry_point
    return next(matches).load()
  File "/usr/lib/python3.9/importlib/metadata.py", line 77, in load
    module = import_module(match.group('module'))
  File "/usr/lib/python3.9/importlib/__init__.py", line 127, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
  File "<frozen importlib._bootstrap>", line 1030, in _gcd_import
  File "<frozen importlib._bootstrap>", line 1007, in _find_and_load
  File "<frozen importlib._bootstrap>", line 986, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 680, in _load_unlocked
  File "<frozen importlib._bootstrap_external>", line 855, in exec_module
  File "<frozen importlib._bootstrap>", line 228, in _call_with_frames_removed
  File "/usr/lib/python3.9/site-packages/datasette/cli.py", line 15, in <module>
    from .app import Datasette, DEFAULT_SETTINGS, SETTINGS, SQLITE_LIMIT_ATTACHED, pm
  File "/usr/lib/python3.9/site-packages/datasette/app.py", line 12, in <module>
    import pkg_resources
  File "/usr/lib/python3.9/site-packages/pkg_resources/__init__.py", line 3243, in <module>
    def _initialize_master_working_set():
  File "/usr/lib/python3.9/site-packages/pkg_resources/__init__.py", line 3226, in _call_aside
    f(*args, **kwargs)
  File "/usr/lib/python3.9/site-packages/pkg_resources/__init__.py", line 3255, in _initialize_master_working_set
    working_set = WorkingSet._build_master()
  File "/usr/lib/python3.9/site-packages/pkg_resources/__init__.py", line 570, in _build_master
    return cls._build_from_requirements(__requires__)
  File "/usr/lib/python3.9/site-packages/pkg_resources/__init__.py", line 583, in _build_from_requirements
    dists = ws.resolve(reqs, Environment())
  File "/usr/lib/python3.9/site-packages/pkg_resources/__init__.py", line 772, in resolve
    raise DistributionNotFound(req, requirers)
pkg_resources.DistributionNotFound: The 'itsdangerous~=1.1' distribution was not found and is required by datasette

I do have python-itsdangerous, the officiall arch package, in my system as a dependency from other package:

Name            : python-itsdangerous
Version         : 2.0.1-1
Description     : Various helpers to pass trusted data to untrusted environments
Architecture    : any
URL             : http://pypi.python.org/pypi/itsdangerous
Licenses        : BSD
Groups          : None
Provides        : None
Depends On      : python
Optional Deps   : None
Required By     : python-flask
Optional For    : None
Conflicts With  : None
Replaces        : None
Installed Size  : 133.05 KiB
Packager        : Sven-Hendrik Haase <svenstaro@gmail.com>
Build Date      : Wed 19 May 2021 09:04:08 AM WEST
Install Date    : Wed 19 May 2021 10:22:18 AM WEST
Install Reason  : Installed as a dependency for another package
Install Script  : No
Validated By    : Signature

I also tested an alternative way of installing datasette. I used pipx, and it worked. This is the expected output, running datasette --help

Usage: datasette [OPTIONS] COMMAND [ARGS]...

  Datasette!

Options:
  --version  Show the version and exit.
  --help     Show this message and exit.

Commands:
  serve*     Serve up specified SQLite database files with a web UI
  inspect
  install    Install Python packages - e.g.
  package    Package specified SQLite files into a new datasette Docker...
  plugins    List currently available plugins
  publish    Publish specified SQLite database files to the internet...
  uninstall  Uninstall Python packages (e.g.

PS:

Another two tools, from the same author, that are very usefull to work with datasette, and deserve a PKGBUILD are

• csvs-to-sqlite

https://github.com/simonw/csvs-to-sqlite https://pypi.org/project/csvs-to-sqlite/

• sqlite-utils

https://pypi.org/project/sqlite-utils/ https://github.com/simonw/sqlite-utils