unofficial mirror of guix-patches@gnu.org 
 help / color / mirror / code / Atom feed
* [bug#60838] [PATCH 0/8] Add datasette and python-sqlite-utils.
@ 2023-01-15 21:47 Felix Gruber
  2023-01-15 21:50 ` [bug#60838] [PATCH 1/8] gnu: Add python-click-default-group-wheel Felix Gruber
                   ` (9 more replies)
  0 siblings, 10 replies; 38+ messages in thread
From: Felix Gruber @ 2023-01-15 21:47 UTC (permalink / raw)
  To: 60838; +Cc: Felix Gruber

This patchset adds new packages for the database exploration and
manipulation tools datasette and sqlite-utils, as well as some missing
dependencies of those two packages.

Since datasette and sqlite-utils do not contain any tests in their pypi
source archives, I've tested both on the global power plant database,
which can be downloaded as CSV file from
https://datasets.wri.org/dataset/globalpowerplantdatabase

First, I tested sqlite-utils by converting the power plants CSV file
to a sqlite database, using

  sqlite-utils insert powerplants.db powerplants \
    global_power_plant_database.csv --csv

Then I used datasette to explore the newly created database with

  datasette serve powerplants.db -o

(Note the -o option to automatically open the datasette instance in
your webbrowser.)

So far everything seems to work.

Felix Gruber (8):
  gnu: Add python-click-default-group-wheel.
  gnu: Add python-sqlite-fts4.
  gnu: Add python-sqlite-utils.
  gnu: python-janus: Update to 1.0.0.
  gnu: Add python-pluggy-next.
  gnu: Add python-asgi-lifespan.
  gnu: Add python-asgi-csrf.
  gnu: Add datasette.

 gnu/packages/databases.scm  | 104 ++++++++++++++++++++++++++++++++++++
 gnu/packages/python-web.scm |  50 ++++++++++++++++-
 gnu/packages/python-xyz.scm |  45 ++++++++++++++--
 3 files changed, 195 insertions(+), 4 deletions(-)

-- 
2.38.1





^ permalink raw reply	[flat|nested] 38+ messages in thread

end of thread, other threads:[~2023-03-29 19:39 UTC | newest]

Thread overview: 38+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2023-01-15 21:47 [bug#60838] [PATCH 0/8] Add datasette and python-sqlite-utils Felix Gruber
2023-01-15 21:50 ` [bug#60838] [PATCH 1/8] gnu: Add python-click-default-group-wheel Felix Gruber
2023-03-22  1:04   ` [bug#60838] [PATCH 0/8] Add datasette and python-sqlite-utils Maxim Cournoyer
2023-01-15 21:51 ` [bug#60838] [PATCH 2/8] gnu: Add python-sqlite-fts4 Felix Gruber
2023-03-22  1:05   ` [bug#60838] [PATCH 0/8] Add datasette and python-sqlite-utils Maxim Cournoyer
2023-01-15 21:51 ` [bug#60838] [PATCH 3/8] gnu: Add python-sqlite-utils Felix Gruber
2023-03-22  1:08   ` [bug#60838] [PATCH 0/8] Add datasette and python-sqlite-utils Maxim Cournoyer
2023-01-15 21:52 ` [bug#60838] [PATCH 4/8] gnu: python-janus: Update to 1.0.0 Felix Gruber
2023-01-15 21:52 ` [bug#60838] [PATCH 5/8] gnu: Add python-pluggy-next Felix Gruber
2023-01-15 21:53 ` [bug#60838] [PATCH 6/8] gnu: Add python-asgi-lifespan Felix Gruber
2023-01-15 21:53 ` [bug#60838] [PATCH 7/8] gnu: Add python-asgi-csrf Felix Gruber
2023-01-15 21:53 ` [bug#60838] [PATCH 8/8] gnu: Add datasette Felix Gruber
2023-03-17 19:19 ` [bug#60838] [PATCH v2 0/7] Add datasette and python-sqlite-utils Felix Gruber
2023-03-17 19:19   ` [bug#60838] [PATCH v2 1/7] gnu: Add python-click-default-group-wheel Felix Gruber
2023-03-17 19:19   ` [bug#60838] [PATCH v2 2/7] gnu: Add python-sqlite-fts4 Felix Gruber
2023-03-17 19:19   ` [bug#60838] [PATCH v2 3/7] gnu: Add python-sqlite-utils Felix Gruber
2023-03-17 19:19   ` [bug#60838] [PATCH v2 4/7] gnu: Add python-pluggy-next Felix Gruber
2023-03-22  1:13     ` [bug#60838] [PATCH 0/8] Add datasette and python-sqlite-utils Maxim Cournoyer
2023-03-17 19:19   ` [bug#60838] [PATCH v2 5/7] gnu: Add python-asgi-lifespan Felix Gruber
2023-03-22  1:17     ` [bug#60838] [PATCH 0/8] Add datasette and python-sqlite-utils Maxim Cournoyer
2023-03-17 19:19   ` [bug#60838] [PATCH v2 6/7] gnu: Add python-asgi-csrf Felix Gruber
2023-03-22  1:19     ` [bug#60838] [PATCH 0/8] Add datasette and python-sqlite-utils Maxim Cournoyer
2023-03-17 19:19   ` [bug#60838] [PATCH v2 7/7] gnu: Add datasette Felix Gruber
2023-03-22  1:26     ` [bug#60838] [PATCH 0/8] Add datasette and python-sqlite-utils Maxim Cournoyer
2023-03-18  8:13   ` [bug#60838] [PATCH v2 0/7] " Liliana Marie Prikler
2023-03-22  0:59 ` [bug#60838] [PATCH 0/8] " Maxim Cournoyer
2023-03-26 19:43   ` [bug#60838] [PATCH v3 0/9] " Felix Gruber
2023-03-26 19:43     ` [bug#60838] [PATCH v3 1/9] gnu: Add python-click-default-group-wheel Felix Gruber
2023-03-26 19:43     ` [bug#60838] [PATCH v3 2/9] gnu: Add python-sqlite-fts4 Felix Gruber
2023-03-26 19:43     ` [bug#60838] [PATCH v3 3/9] gnu: Add python-sqlite-utils Felix Gruber
2023-03-26 19:43     ` [bug#60838] [PATCH v3 4/9] gnu: Add python-asgi-lifespan Felix Gruber
2023-03-26 19:43     ` [bug#60838] [PATCH v3 5/9] gnu: Add python-asgi-csrf Felix Gruber
2023-03-26 19:43     ` [bug#60838] [PATCH v3 6/9] gnu: Add python-trustme-next Felix Gruber
2023-03-26 19:43     ` [bug#60838] [PATCH v3 7/9] gnu: Add python-cogapp Felix Gruber
2023-03-26 19:43     ` [bug#60838] [PATCH v3 8/9] gnu: python-pytest-7.1: Depend on python-pluggy-next Felix Gruber
2023-03-26 19:43     ` [bug#60838] [PATCH v3 9/9] gnu: Add datasette Felix Gruber
2023-03-29 17:22       ` bug#60838: [PATCH 0/8] Add datasette and python-sqlite-utils Maxim Cournoyer
2023-03-29 19:38         ` [bug#60838] " Felix Gruber

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/guix.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).