pelican: content: 1 row where category = "technology" and "published

1 row where category = "technology" and "published_date" is on date 2021-07-07

descending

slug ▼	author	category	content	published_date	summary	title	url
publishing-content-to-pelican-site	ryan	technology	There are a lot of different ways to get the content for your Pelican site onto the internet. The [Docs show](https://docs.getpelican.com/en/latest/publish.html) an example using `rsync`. For automation they talk about the use of either `Invoke` or `Make` (although you could also use [`Just`](https://github.com/casey/just) instead of `Make` which is my preferred command runner.) I didn't go with any of these options, instead opting to use GitHub Actions instead. I have [two GitHub Actions](https://github.com/ryancheley/ryancheley.com/tree/main/.github/workflows) that will publish updated content. One action publishes to a UAT version of the site, and the other to the Production version of the site. Why two actions you might ask? Right now it's so that I can work through making my own theme and deploying it without disrupting the content on my production site. Also, it's a workflow that I'm pretty used to: 1. Local Development 2. Push to Development Branch on GitHub 3. Pull Request into Main on GitHub It kind of complicates things right now, but I feel waaay more comfortable with having a UAT version of my site that I can just undo if I need to. Below is the code for the [Prod Deployment](https://raw.githubusercontent.com/ryancheley/ryancheley.com/main/.github/workflows/publish.yml) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 \| name: Pelican Publish on: push: branches: - main jobs: deploy: runs-on: ubuntu-18.04 steps: - name: deploy code uses: appleboy/ssh-action@v0.1.2 with: host: ${{ secrets.SSH_HOST }} key: ${{ secrets.SSH_KEY }} username: ${{ secrets.SSH_USERNAME }} script: \| rm -rf ryancheley.com git clone git@github.com:ryanch…	2021-07-07	There are a lot of different ways to get the content for your Pelican site onto the internet. The [Docs show](https://docs.getpelican.com/en/latest/publish.html) an example using `rsync`. For automation they talk about the use of either `Invoke` or `Make` (although you could also use [`Just`](https://github.com/casey/just) instead of `Make` which is my preferred …	Publishing content to Pelican site	https://www.ryancheley.com/2021/07/07/publishing-content-to-pelican-site/

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE [content] (
   [author] TEXT,
   [category] TEXT,
   [content] TEXT,
   [published_date] TEXT,
   [slug] TEXT PRIMARY KEY,
   [summary] TEXT,
   [title] TEXT,
   [url] TEXT
);