Datasette-lite this...

[ross-spencer]

I have been working with Datasette-lite this week, and I would be exceptionally easy to convert this data to Datasette. (Actually it may simply just work from the CSV...) 🤔

[ross-spencer]

https://lite.datasette.io/?install=datasette-dateutil&install=datasette-copyable&csv=https%3A%2F%2Fraw.githubusercontent.com%2Fnasawakeupcalls%2Fnasawakeupcalls.data%2Fmain%2Fnasawakeupcalls.csv#/data?sql=select+*+from+nasawakeupcalls

[ross-spencer]

Related to: nasawakeupcalls/nasawakeupcalls.data#25

[ross-spencer]

CSV quoting code:

"""Simple script to force-quote an existing CSV file as Sheets, and
Excel doesn't already do this. LibreOffice I believe does.
"""
import csv

data = []
header = None

with open("nasawakeupcalls.csv", "r", encoding="utf8") as nasa_csv:
    csv_reader = csv.reader(nasa_csv, delimiter=",")
    header = next(csv_reader, None)
    # The remainder of the rows are data rows.
    for row in csv_reader:
        assert len(row) == len(
            header
        ), "Problem parsing rows, inequal lenghts: {} (header) vs. {} (row)".format(
            len(row), len(header)
        )
        data_dict = dict(zip(header, row))
        data.append(data_dict)

with open("quoted_nasawakeupcalls.csv", "wt", newline="") as new_csv:
    writer = csv.DictWriter(
        new_csv, fieldnames=header, quotechar='"', delimiter=",", quoting=csv.QUOTE_ALL
    )
    writer.writeheader()
    for idx, row in enumerate(data):
        if not row:
            continue
        writer.writerow(row)

[ross-spencer]

Useful tool from SimonW:

• https://pypi.org/project/csvs-to-sqlite/
  • Example command: csvs-to-sqlite nasawakeupcalls.csv --just-strings nasawakeupcalls.db

[ross-spencer]

Deployed to: https://nasawakeupcalls.github.io/datasette

[ross-spencer]

Linked to here as well: https://nasawakeupcalls.github.io/data/

Okay, I think this is done for now. We may look at datasette and think we can do more with the field types, and datasette may include more plugins as well. These can be registered as new issues.