PostgreSQL

PostgreSQL 代码截图生成器

不必离开 Mac，就能把 PostgreSQL 代码片段变成值得分享的图片。

Postgres-specific syntax is worth screenshotting precisely because it is not portable SQL. The window functions and CTEs are the point.

Codeshot 会根据你粘贴的代码识别 PostgreSQL，不存在选错语言的问题。下面是同一段代码在内置 30 款主题中的三款下的效果，由应用自身的样式表渲染。

WITH recent AS (
    SELECT theme, created_at
    FROM snapshots
    WHERE created_at >= NOW() - INTERVAL '30 days'
)
SELECT theme,
       COUNT(*) AS total,
       RANK() OVER (ORDER BY COUNT(*) DESC) AS position
FROM recent
GROUP BY theme;

Edge · 深色

WITH recent AS (
    SELECT theme, created_at
    FROM snapshots
    WHERE created_at >= NOW() - INTERVAL '30 days'
)
SELECT theme,
       COUNT(*) AS total,
       RANK() OVER (ORDER BY COUNT(*) DESC) AS position
FROM recent
GROUP BY theme;

GitHub · 深色

WITH recent AS (
    SELECT theme, created_at
    FROM snapshots
    WHERE created_at >= NOW() - INTERVAL '30 days'
)
SELECT theme,
       COUNT(*) AS total,
       RANK() OVER (ORDER BY COUNT(*) DESC) AS position
FROM recent
GROUP BY theme;

Solarized · 深色

为 PostgreSQL 选择主题

Format the query before you capture it. A CTE that wraps mid-line is unreadable as an image, and unlike text nobody can reformat it themselves.

把尺寸定对

让图片随内容自适应，或锁定一个比例——1:1、4:3、3:2、16:9、9:16、2:3 或 3:4——然后以 1×、2× 或 3× 导出，在 Retina 屏上依然清晰。用 ⌘⇧C 直接复制到剪贴板，或用 ⌘S 保存。

查看全部 30 款主题对比，或阅读完整流程。

为 PostgreSQL 以及另外 59 种语言打造

一切都在你的 Mac 上完成，代码不会外传。

下载 macOS 版