Skip to main content
Loss of provenance

A previous release had provenance metadata, but this release does not. View details.

pelican-to-sqlite

PyPI GitHub changelog Tests License pre-commit.ci status

Create a SQLite database containing data posts from your local pelican files.

How to install

uv add pelican-to-sqlite

Using pip

pip install pelican-to-sqlite

Usage

Once the plugin has been installed you only need to run make html to create a SQLite database called pelican.db which will be created in the root of your pelican site.

You will need to add a form to your base.html template (or similar template depending on your theme). The form that needs to be added looks like this (assuming you use Tailwind):

<section class="relative h-8">
<section class="absolute inset-y-0 right-10 w-128">
<form
class = "pl-4"
<
action="your-action-link-here"
method="get">
        <label for="site-search">Search the site:</label>
        <input type="search" id="site-search" name="text"
                aria-label="Search through site content">
        <button class="rounded-full w-16 hover:bg-blue-300">Search</button>
</form>
</section>

In the above, your-action-link-here should be substituted for the link that you get from your Vercel hosted instance of datasette.

Deploy using Vercel

There are many options to deploy your SQLite database with datasette. Below describes using Vercel.

Note: The datasette-publish-vercel plugin may have limited maintenance. Consider alternative deployment methods like Datasette Cloud or manual Vercel deployment if you encounter issues.

First, install datasette using uv (or pip)

uv add datasette
# or: pip install datasette

Next, install the datasette plugin datasette-publish-vercel using uv (or pip)

uv add datasette-publish-vercel
# or: pip install datasette-publish-vercel

and the Vercel CLI

Once that's done, run vercel login to login to (or create) an account.

To publish your pelican.db to Vercel just run:

datasette publish vercel my-database.db

There are several options for outputting to Vercel. See the documentation for more details

Using with Datasette

The SQLite database produced by this tool is designed to be browsed using Datasette. See my post Adding Search to My Pelican Blog with Datasette for more details on how I implemented it.

Metadata

Release files for pelican-to-sqlite 0.7.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Loss of provenance

These files do not have provenance metadata, despite files in a prior release including this data.

We recommend further investigation before installing these files. View details.

Source distribution (sdist)

Source distribution for pelican-to-sqlite 0.7.0
File Size Uploaded Provenance Actions
pelican_to_sqlite-0.7.0.tar.gz 72.7 kB Without provenance Details for pelican_to_sqlite-0.7.0.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for pelican-to-sqlite 0.7.0
File Interpreter ABI Platform Actions
pelican_to_sqlite-0.7.0-py3-none-any.whl Python 3 none any Details for pelican_to_sqlite-0.7.0-py3-none-any.whl

Total release size: 81.7 kB

Release files / pelican_to_sqlite-0.7.0.tar.gz

Loss of provenance

This file belongs to a release without provenance metadata, despite a prior release including this data.

We recommend further investigation before installing this file. View details.

Download URL pelican_to_sqlite-0.7.0.tar.gz
Size 72.7 kB
Tags Source
SHA-256 checksum
How to use checksums
a21faba8072916d4669260928e07797422593b091fb6657f75264bd4d9f3d1e0
BLAKE2b-256 checksum
How to use checksums
733501b3e1d4dc2177e46d1bce607bdd77db847ea6846dcec510d7253ec963c9
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/6.1.0 CPython/3.13.0

Release files / pelican_to_sqlite-0.7.0-py3-none-any.whl

Loss of provenance

This file belongs to a release without provenance metadata, despite a prior release including this data.

We recommend further investigation before installing this file. View details.

Download URL pelican_to_sqlite-0.7.0-py3-none-any.whl
Size 9.0 kB
Tags Python 3
SHA-256 checksum
How to use checksums
889f0b2ae566e583291e764f0f4f80ac3ff72be0ef0b55c08fcd4139b048d891
BLAKE2b-256 checksum
How to use checksums
4da63755e33d80f7738bdb824d85d1a3f1d3b5c1c01dea1f130fc5ec9217ef4b
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/6.1.0 CPython/3.13.0

Security for pelican-to-sqlite 0.7.0

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

Loss of provenance

A previous release of these files had provenance metadata, but this release does not.

While this could reflect a routine change by the project maintainers, it may also indicate that the release files have been compromised.

Release comparison

  • Removed 0.6.3 2 files With provenance
  • Added 0.7.0 2 files Without provenance

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page