Skip to content

Instantly share code, notes, and snippets.

### Keybase proof
I hereby claim:
* I am gargol on github.
* I am gargol (https://keybase.io/gargol) on keybase.
* I have a public key whose fingerprint is A960 3CC4 7FA3 42A8 3B14 9664 E510 5675 04C1 465F
To claim this, I am signing this object:
@naz
naz / changelog-2.1.1.md
Created September 6, 2018 11:46
Changelog 2.1.1
@naz
naz / changelog-2.1.2.md
Created September 11, 2018 14:04
Changelog 2.1.2
@naz
naz / restore_script.sql
Created October 8, 2018 11:40
Ghost post restoration script (MySQL version)
-- show available versions for a post
SELECT `mr`.`id` 'version id', `p`.`id` 'post id', `p`.`title`, `mr`.`mobiledoc`
FROM `posts` `p`
JOIN `mobiledoc_revisions` `mr`
ON `p`.`id` = `mr`.`post_id`
WHERE `p`.`id` = '$POST_ID' \G
-- restore specific versions of the post
UPDATE `posts` `p`
JOIN `mobiledoc_revisions` `mr`
@naz
naz / changelog-2.2.1.md
Created October 9, 2018 15:07
Changelog 2.2.1
@naz
naz / relation_filtering.sql
Created November 8, 2018 11:01
Describes types of filtering that could be applied to related resources in M:M relations
​​--tag:-two
​​select p.title, html
​​from posts as p
​​where p.id
​​NOT in (
​​ select post_id
​​ from posts_tags as pt
​​ inner join tags as t
​​ on t.id = pt.tag_id
​​ where t.slug IN ('two')
@naz
naz / changelog-2.6.1.md
Created November 20, 2018 17:44
Changelog 2.6.1
  • fcf5d5f23 Version bump to 2.6.1 - Nazar Gargol
  • ec0a58b6f Version bump to 2.6.1 - Nazar Gargol
  • 142417934 Updated Ghost-Admin to 2.6.1 - Nazar Gargol
  • 0254202df Bump @tryghost/mobiledoc-kit version - Kevin Ansfield
  • 1beae3001 Fixing negative margins of Koenig embeds - Zimo
  • e2e5353ea Updated error message log and lastTriggeredError for webhook requests (TryGhost/Ghost#10147) - Rishabh Garg
  • db34297a7 Added string size comment to schema.js (TryGhost/Ghost#10179) - Fabien O'Carroll
  • 090a936e1 Moved raw order for author filtering to correct place (TryGhost/Ghost
@naz
naz / changelog-2.9.1.md
Created December 20, 2018 10:50
Changelog 2.9.1
  • af7daa08f Version bump to 2.9.1 - Nazar Gargol
  • aca3987ff Updated Ghost-Admin to 2.9.1 - Nazar Gargol
  • 28759ea14 Version bump to 2.9.1 - Nazar Gargol
  • 4a5a5acba 🐛 Fixed broken content import in Admin API v2 (TryGhost/Ghost#10299) - Kevin Kuang
  • fd91e3182 Fixed koenigDragDropHandler._resetDrag throwing errors - Kevin Ansfield
@naz
naz / changelog-2.10.0.md
Created January 8, 2019 13:28
Changelog 2.10.0
@naz
naz / changelog-2.13.2.md
Created February 5, 2019 12:33
Changelog 2.13.2