Okay, did some more refactoring and caught some other errors / differences between MySQL and SQLite. Also added the SQLite option in the config setup.

Dec 8 2018, 7:06 PM · WriteFreely (v1.0)

GitHub <noreply@github.com> committed rWF18984c2410d7: Merge 17c816477b49747eca39856aa2c7564b37e2845a into… (authored by matt).

Merge 17c816477b49747eca39856aa2c7564b37e2845a into…

Dec 8 2018, 7:02 PM

matt committed rWF17c816477b49: Add SQLite option to config process (authored by matt).

Add SQLite option to config process

Dec 8 2018, 6:38 PM

matt committed rWFc6851fee5059: Fix duplicate key checks in SQLite (authored by matt).

Fix duplicate key checks in SQLite

Dec 8 2018, 6:38 PM

matt committed rWFba3d6ae64c10: Support custom SQLite database file name (authored by matt).

Support custom SQLite database file name

Dec 8 2018, 6:38 PM

matt committed rWF4b780361bfe9: Fix upsert queries on SQLite (authored by matt).

Fix upsert queries on SQLite

Dec 8 2018, 5:59 PM

matt committed rWF026604b3dd7a: Fix pinned post content truncation with SQLite (authored by matt).

Fix pinned post content truncation with SQLite

Dec 8 2018, 5:59 PM

matt committed rWFdaaa4564bbc6: Fix post `created` date in SQLite (authored by matt).

Fix post `created` date in SQLite

Dec 8 2018, 5:59 PM

matt committed rWF6f4c004e8c8b: Fix SQLite date format string (authored by matt).

Fix SQLite date format string

Dec 8 2018, 5:59 PM

matt committed rWFbc1b3fdfb7c5: Move NOW() calls to datastore.now() method (authored by matt).

Move NOW() calls to datastore.now() method

Dec 8 2018, 5:59 PM

matt committed rWF7fab11b3c83f: Move initial config loading to its own func (authored by matt).

Move initial config loading to its own func

Dec 8 2018, 5:59 PM

matt committed rWFafede80e8731: Merge branch 'master' into sqlite-support (authored by matt).

Merge branch 'master' into sqlite-support

Dec 8 2018, 5:59 PM

matt added a parent task for T553: User management: T538: Admin interface.

Dec 8 2018, 3:23 PM · WriteFreely

matt added a subtask for T538: Admin interface: T553: User management.

Dec 8 2018, 3:23 PM · WriteFreely

matt triaged T553: User management as Low priority.

Dec 8 2018, 3:21 PM · WriteFreely

GitHub <noreply@github.com> committed rWF7eb92b28e84d: Merge 5856e91f84673483dec5e83c5cbaa8c2da345cd7 into… (authored by Marcel van der Boom <marcel@hsdev.com>).

Merge 5856e91f84673483dec5e83c5cbaa8c2da345cd7 into…

Dec 8 2018, 2:41 AM

Dec 7 2018

matt added a comment to T372: Import posts from Blogger.

Nice! Good to know.

Dec 7 2018, 10:11 PM · Write.as Web, Import, WriteFreely, Restricted Project

matt committed rWF9e466a6d23d2: Locally host MathJax (authored by matt).

Locally host MathJax

Dec 7 2018, 9:54 PM

matt closed T551: Remove CloudFlare dependencies as Resolved by committing rWF9e466a6d23d2: Locally host MathJax.

Dec 7 2018, 9:54 PM · Refactor, Write.as Web, WriteFreely

matt committed rWF860e8c01208a: Locally host highlightjs (authored by matt).

Locally host highlightjs

Dec 7 2018, 9:54 PM

Dec 6 2018

matt triaged T551: Remove CloudFlare dependencies as High priority.

Dec 6 2018, 4:07 PM · Refactor, Write.as Web, WriteFreely

matt added a comment to T529: Support SQLite for storage.

Sounds great.

Dec 6 2018, 4:04 PM · WriteFreely (v1.0)

benovermyer added a comment to T529: Support SQLite for storage.

After this has been merged in, I'll work on the PostgreSQL support.

Dec 6 2018, 1:41 PM · WriteFreely (v1.0)

GitHub <noreply@github.com> committed rWFfaa25bafc466: Merge 5856e91f84673483dec5e83c5cbaa8c2da345cd7 into… (authored by Marcel van der Boom <marcel@hsdev.com>).

Merge 5856e91f84673483dec5e83c5cbaa8c2da345cd7 into…

Dec 6 2018, 3:08 AM

matt committed rWFdf4cd9ed0073: Add --create-admin option (authored by matt).

Add --create-admin option

Dec 6 2018, 2:46 AM

matt closed T544: Add ability to generate users from the command line as Resolved by committing rWFdf4cd9ed0073: Add --create-admin option.

Dec 6 2018, 2:46 AM · WriteFreely

matt committed rWFe06b3287855a: Merge branch 'master' of github.com:writeas/writefreely (authored by matt).

Merge branch 'master' of github.com:writeas/writefreely

Dec 6 2018, 2:46 AM

matt triaged T550: Image uploading as Wishlist priority.

Dec 6 2018, 1:39 AM · Restricted Project, SnapFreely, WriteFreely

matt triaged T549: Handle deleted AP actors as Low priority.

Dec 6 2018, 12:36 AM · Federation, WriteFreely

matt claimed T544: Add ability to generate users from the command line.

Could really use this, especially now that WriteFreely.host is up and running, so I'll get started on it.

Dec 6 2018, 12:12 AM · WriteFreely

matt awarded T544: Add ability to generate users from the command line a 100 token.

Dec 6 2018, 12:08 AM · WriteFreely

matt moved T544: Add ability to generate users from the command line from Backlog to Soon / v1.0 on the WriteFreely board.

Dec 6 2018, 12:06 AM · WriteFreely

Dec 5 2018

matt closed T541: Support changing config values via web, a subtask of T538: Admin interface, as Resolved.

Dec 5 2018, 11:59 PM · WriteFreely

matt closed T541: Support changing config values via web as Resolved.

Actually, I think this is good for now.

Dec 5 2018, 11:59 PM · WriteFreely

matt triaged T548: Move to go-fed v1.0 as Low priority.

Dec 5 2018, 3:51 PM · Refactor, WriteFreely

matt added a project to T547: Create AP actor keys with Go's built-in libraries: Refactor.

Dec 5 2018, 3:49 PM · WriteFreely, Refactor

matt triaged T547: Create AP actor keys with Go's built-in libraries as High priority.

Dec 5 2018, 3:49 PM · WriteFreely, Refactor

GitHub <noreply@github.com> committed rWFc2a3b4935cb7: Merge pull request #44 from TeDomum/master (authored by bkoehn).

Merge pull request #44 from TeDomum/master

Dec 5 2018, 1:07 PM

GitHub <noreply@github.com> committed rWF9b8f1023f3ca: Merge d01d2c80b6f0e0f7b8eb96589a3abf1cb716683b into… (authored by kaiyou <pierre@jaury.eu>).

Merge d01d2c80b6f0e0f7b8eb96589a3abf1cb716683b into…

Dec 5 2018, 12:53 PM

kaiyou <pierre@jaury.eu> committed rWFd01d2c80b6f0: Add openssl and root anchors for federation queries (authored by kaiyou <pierre@jaury.eu>).

Add openssl and root anchors for federation queries

Dec 5 2018, 12:48 PM

matt added a comment to T544: Add ability to generate users from the command line.

Yep that's perfect, thanks 👍 That way anyone can make changes if needed. I've also changed that default value in the "Create Task" form.

Dec 5 2018, 5:07 AM · WriteFreely

matt changed the join policy for Refactor.

Dec 5 2018, 5:04 AM

matt added a comment to T529: Support SQLite for storage.

Awesome. Plenty of people asking about that now, so that'll be good. If you want to take the charge on that one, please feel free!

Dec 5 2018, 5:03 AM · WriteFreely (v1.0)

matt committed rWFf04469beee41: Fix SQLite concurrency issues (authored by matt).

Fix SQLite concurrency issues

Dec 5 2018, 4:57 AM

Dec 4 2018

GitHub <noreply@github.com> committed rWF65ae8acc1a4c: Merge 5856e91f84673483dec5e83c5cbaa8c2da345cd7 into… (authored by Marcel van der Boom <marcel@hsdev.com>).

Merge 5856e91f84673483dec5e83c5cbaa8c2da345cd7 into…

Dec 4 2018, 5:27 PM

Marcel van der Boom <marcel@hsdev.com> committed rWF5856e91f8467: Allow beginning of line as begin of tag as well (authored by Marcel van der Boom <marcel@hsdev.com>).

Allow beginning of line as begin of tag as well

Dec 4 2018, 5:27 PM

GitHub <noreply@github.com> committed rWFf2d2c1708307: Merge 1b30ff93519f6eaf62269f82aa1179af23caa828 into… (authored by bkoehn).

Merge 1b30ff93519f6eaf62269f82aa1179af23caa828 into…

Dec 4 2018, 2:20 PM

GitHub <noreply@github.com> committed rWF66654d15ae7c: Merge 79a7ca750ee4c8839b8777413c232ff2fcb60836 into… (authored by Marcel van der Boom <marcel@hsdev.com>).

Merge 79a7ca750ee4c8839b8777413c232ff2fcb60836 into…

Dec 4 2018, 12:53 AM

Dec 3 2018

matt committed rWF8ceb1650204e: Bump version to 0.5 (authored by matt).

Bump version to 0.5

Dec 3 2018, 11:58 PM

matt committed rWFcb2b30b379a2: Show stats on About page if public_stats enabled (authored by matt).

Show stats on About page if public_stats enabled

Dec 3 2018, 11:58 PM

matt committed rWF8cbc02d7cf8b: Hide unneeded config values in single-user mode (authored by matt).

Hide unneeded config values in single-user mode

Dec 3 2018, 11:58 PM

matt committed rWF573ce0273978: Remove params from URL after loading admin panel (authored by matt).

Remove params from URL after loading admin panel

Dec 3 2018, 11:58 PM

matt committed rWFcbf6ff54dfa4: Add site_description config value (authored by matt).

Add site_description config value

Dec 3 2018, 11:58 PM

matt committed rWFd2f89c6360d9: Open pages linked from admin UI in new window (authored by matt).

Open pages linked from admin UI in new window

Dec 3 2018, 11:58 PM

matt committed rWF9fe4b09de50e: Support editing some config values in admin UI (authored by matt).

Support editing some config values in admin UI

Dec 3 2018, 11:58 PM

matt added a comment to T541: Support changing config values via web.

Still need to describe what each setting does, but this is nearly complete.

Dec 3 2018, 10:33 PM · WriteFreely

benovermyer added a comment to T544: Add ability to generate users from the command line.

I updated the task's tag and changed it to be editable by All Users. Is that the right group?

Dec 3 2018, 6:33 PM · WriteFreely

benovermyer edited projects for T544: Add ability to generate users from the command line, added: WriteFreely; removed Write.as CLI.

Dec 3 2018, 6:32 PM · WriteFreely

GitHub <noreply@github.com> committed rWF9bc310e5f0fd: Merge 79a7ca750ee4c8839b8777413c232ff2fcb60836 into… (authored by Marcel van der Boom <marcel@hsdev.com>).

Merge 79a7ca750ee4c8839b8777413c232ff2fcb60836 into…

Dec 3 2018, 5:26 PM

GitHub <noreply@github.com> committed rWF09a3fe09febe: Merge pull request #39 from mrvdb/codehighlight (authored by matt).

Merge pull request #39 from mrvdb/codehighlight

Dec 3 2018, 5:24 PM

GitHub <noreply@github.com> committed rWF889686fe67b9: Merge 5fc41687be6bca83dea563e0910e89016e0b0794 into… (authored by Marcel van der Boom <marcel@hsdev.com>).

Merge 5fc41687be6bca83dea563e0910e89016e0b0794 into…

Dec 3 2018, 5:19 PM

matt committed rWF5fc41687be6b: Fix whitespace (authored by matt).

Fix whitespace

Dec 3 2018, 5:19 PM

matt added a comment to T544: Add ability to generate users from the command line.

Great point. This should be relatively easy, so maybe we can get it into the next release.

Dec 3 2018, 5:04 PM · WriteFreely

matt triaged T546: Custom blog avatar as Wishlist priority.

Dec 3 2018, 4:51 PM · Write.as Web, Snap.as, Federation, User Customization

matt changed the visibility for C1: Launch WriteFreely 1.0.

Dec 3 2018, 4:19 PM · WriteFreely

matt triaged T545: Update post view counts in batches as Low priority.

Dec 3 2018, 4:16 PM · Refactor, Write.as Web

benovermyer changed the edit policy for T544: Add ability to generate users from the command line.

Dec 3 2018, 3:19 PM · WriteFreely

benovermyer closed T531: Write a Dockerfile as Resolved.

This is done. The relevant commits that resolved it:

Dec 3 2018, 2:57 PM · WriteFreely

benovermyer added a comment to T529: Support SQLite for storage.

Oh, and I believe that adding PostgreSQL support will be much easier than SQLite. It should be able to use schema.sql and all of the MySQL SQL commands unmodified. The only bit that it'll require is a new connection block in the initial setup.

Dec 3 2018, 2:54 PM · WriteFreely (v1.0)

benovermyer added a comment to T372: Import posts from Blogger.

Ooh. I look forward to seeing this implemented, since I currently have a Blogger blog.

Dec 3 2018, 2:49 PM · Write.as Web, Import, WriteFreely, Restricted Project

matt edited projects for T372: Import posts from Blogger, added: WriteFreely, Import, Write.as Web; removed Write.as Web (Jul - Sep 2018).

Dec 3 2018, 2:12 PM · Write.as Web, Import, WriteFreely, Restricted Project

matt added a subtask for T245: Import posts from other platforms: T543: Import posts from Ghost.

Dec 3 2018, 2:11 PM · Roadmap, Import, WriteFreely, Write.as Web

matt added a parent task for T543: Import posts from Ghost: T245: Import posts from other platforms.

Dec 3 2018, 2:11 PM · Import, WriteFreely

matt changed the visibility for T543: Import posts from Ghost.

Dec 3 2018, 2:11 PM · Import, WriteFreely

matt changed the visibility for Import.

Dec 3 2018, 2:01 PM

GitHub <noreply@github.com> committed rWF11d1a5137ee2: Merge 79a7ca750ee4c8839b8777413c232ff2fcb60836 into… (authored by Marcel van der Boom <marcel@hsdev.com>).

Merge 79a7ca750ee4c8839b8777413c232ff2fcb60836 into…

Dec 3 2018, 11:16 AM

Marcel van der Boom <marcel@hsdev.com> committed rWF79a7ca750ee4: Require hashtags to have a space before them (authored by Marcel van der Boom <marcel@hsdev.com>).

Require hashtags to have a space before them

Dec 3 2018, 11:16 AM

Dec 2 2018

matt committed rWF61de04338e1a: Extract out common DB connection logic (authored by matt).

Extract out common DB connection logic

Dec 2 2018, 10:29 PM

matt committed rWFc6d3ef7596b7: Include SQLite schema in releases (authored by matt).

Include SQLite schema in releases

Dec 2 2018, 10:29 PM

matt committed rWF31b802e44041: Add backticks on table names in sqlite.sql (authored by matt).

Add backticks on table names in sqlite.sql

Dec 2 2018, 10:29 PM

matt added a comment to T529: Support SQLite for storage.

Some feedback from my initial multi-user testing: so far almost everything looks solid, this is really good work! Only issue so far is something weird going on with scheduled posts. They correctly show as "scheduled" and don't show up for non-auth'd users. But once the published time has passed, the "scheduled" badge correctly drops for auth'd users, but the post doesn't show up for non-auth'd users like it should.

Dec 2 2018, 10:20 PM · WriteFreely (v1.0)

GitHub <noreply@github.com> committed rWF4aa5bb32bc40: Merge 3b4d14f19453f33644d398e538ff751862c3973c into… (authored by Marcel van der Boom <marcel@hsdev.com>).

Merge 3b4d14f19453f33644d398e538ff751862c3973c into…

Dec 2 2018, 7:45 PM

Dec 1 2018

matt committed rWFc60c61c5b852: Add link to AUR package (authored by matt).

Add link to AUR package

Dec 1 2018, 9:28 PM

matt committed rWFfc856e36eb78: Fix editing metadata on single-user instances (authored by matt).

Fix editing metadata on single-user instances

Dec 1 2018, 9:28 PM

matt added a comment to T529: Support SQLite for storage.

Awesome!! I'll give it a thorough testing this weekend in various configurations and let you know how it looks.

Dec 1 2018, 9:18 PM · WriteFreely (v1.0)

benovermyer committed rWF6cb86214d7a5: SQLite support added. (authored by benovermyer).

SQLite support added.

Dec 1 2018, 6:10 PM

benovermyer added a comment to T529: Support SQLite for storage.

@matt OK, with the latest commit on the sqlite-support branch, SQLite support is working.

Dec 1 2018, 6:09 PM · WriteFreely (v1.0)

Nov 29 2018

GitHub <noreply@github.com> committed rWFf5215feff905: Merge 3b4d14f19453f33644d398e538ff751862c3973c into… (authored by Marcel van der Boom <marcel@hsdev.com>).

Merge 3b4d14f19453f33644d398e538ff751862c3973c into…

Nov 29 2018, 4:37 PM

Marcel van der Boom <marcel@hsdev.com> committed rWF3b4d14f19453: Only push language uri once on load stack (authored by Marcel van der Boom <marcel@hsdev.com>).

Only push language uri once on load stack

Nov 29 2018, 4:37 PM

GitHub <noreply@github.com> committed rWFa811f937937b: Merge b034a08350cb6697075410e8f9af6a818d968e5e into… (authored by Marcel van der Boom <marcel@hsdev.com>).

Merge b034a08350cb6697075410e8f9af6a818d968e5e into…

Nov 29 2018, 3:41 PM

Marcel van der Boom <marcel@hsdev.com> committed rWFb034a08350cb: Merge remote-tracking branch 'upstream/master' into codehighlight (authored by Marcel van der Boom <marcel@hsdev.com>).

Merge remote-tracking branch 'upstream/master' into codehighlight

Nov 29 2018, 3:41 PM

Marcel van der Boom <marcel@hsdev.com> committed rWFc6e496772858: Add support for all languages (authored by Marcel van der Boom <marcel@hsdev.com>).

Add support for all languages

Nov 29 2018, 3:41 PM

GitHub <noreply@github.com> committed rWFc3779790a553: Merge 1b30ff93519f6eaf62269f82aa1179af23caa828 into… (authored by bkoehn).