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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
1101
1102
1103
1104
1105
1106
1107
1108
1109
1110
1111
1112
1113
1114
1115
1116
1117
1118
1119
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129
1130
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
1150
1151
1152
1153
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
1186
1187
1188
1189
1190
1191
1192
1193
1194
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
1208
1209
1210
1211
1212
1213
1214
1215
1216
1217
1218
1219
1220
1221
1222
1223
1224
1225
1226
1227
1228
1229
1230
1231
1232
1233
1234
1235
1236
1237
1238
1239
1240
1241
1242
1243
1244
1245
1246
1247
1248
1249
1250
1251
1252
1253
1254
1255
# The "publish" half of the two-workflow release flow. Fires
# automatically when a Release PR (from `release-pr.yml`) merges —
# detects it via the `release: v<semver>` commit message on the
# merge commit. A `workflow_dispatch` fallback lets a human re-run
# the publish side manually when the auto-trigger needs a kick.
#
# Phase 6d: tag-all + publish-crate + publish-ffi + finalize.
# Phase 6e adds publish-desktop.
# Phase 6f adds build-python-wheels + publish-python.
# Phase 6g adds build-nodejs-binaries + publish-nodejs.
# Phase 6h adds publish-wasm.
# Phase 6i adds publish-go (no registry — git tag + GitHub Release
# with the FFI tarballs attached for users who want prebuilt
# libsqlrite_c alongside `go get`).
#
# Design doc: docs/release-plan.md.
# One-time registry / branch-protection setup: docs/release-secrets.md.
name: Release
on:
push:
branches:
workflow_dispatch:
inputs:
version:
description: 'Version to (re-)publish. Use only when the auto-trigger needs a manual kick.'
required: true
type: string
# `contents: write` — tag creation + GitHub Release uploads.
permissions:
contents: write
# Only one release at a time across the whole workflow. Back-to-back
# merges of two Release PRs (which should never happen, but still)
# run serially rather than racing on tag creation.
concurrency:
group: release
cancel-in-progress: false
jobs:
# ---------------------------------------------------------------------------
# Step 1: figure out whether this push commit is actually a release
# (and extract the version from the commit message), or just a
# regular push we should ignore. Runs on every push to main.
detect:
name: Detect release commit
runs-on: ubuntu-latest
outputs:
version: ${{ steps.parse.outputs.version }}
should_release: ${{ steps.parse.outputs.should_release }}
steps:
- uses: actions/checkout@v4
- id: parse
# On workflow_dispatch, trust the input verbatim (validated
# by the dispatcher).
# On push, parse the top line of the HEAD commit message.
# If it matches `release: vX.Y.Z`, extract and proceed.
# Anything else is a regular commit — exit silently.
run: |
if [ "${{ github.event_name }}" = "workflow_dispatch" ]; then
VERSION="${{ inputs.version }}"
echo "version=$VERSION" >> "$GITHUB_OUTPUT"
echo "should_release=true" >> "$GITHUB_OUTPUT"
echo "::notice::Manually dispatched release for v$VERSION"
exit 0
fi
# GitHub's default squash-merge title is `<PR title> (#N)` —
# e.g. `release: v0.1.2 (#18)`. Strip the trailing ` (#N)` so
# the regex matches both the squash-merge form and the
# stripped-title form (we still recommend editing to the
# latter, but should-just-work beats should-remember).
MSG=$(git log -1 --pretty=%s | sed -E 's/ \(#[0-9]+\)$//')
if [[ "$MSG" =~ ^release:\ v([0-9]+\.[0-9]+\.[0-9]+(-[0-9A-Za-z.-]+)?(\+[0-9A-Za-z.-]+)?)$ ]]; then
VERSION="${BASH_REMATCH[1]}"
echo "version=$VERSION" >> "$GITHUB_OUTPUT"
echo "should_release=true" >> "$GITHUB_OUTPUT"
echo "::notice::Release commit detected: v$VERSION"
else
echo "should_release=false" >> "$GITHUB_OUTPUT"
echo "::notice::Not a release commit — skipping"
fi
# ---------------------------------------------------------------------------
# Step 2: push per-product tags against the current commit. Runs
# BEFORE any publish step so a bad version number (e.g., tag
# already exists for some reason) aborts the whole release cleanly.
#
# As of Phase 6g, we tag:
# - sqlrite-v<V> (Rust engine)
# - sqlrite-ffi-v<V> (C FFI prebuilt binaries)
# - sqlrite-desktop-v<V> (Tauri desktop installers)
# - sqlrite-py-v<V> (Python wheels on PyPI)
# - sqlrite-node-v<V> (Node.js N-API bindings on npm)
# - v<V> (umbrella)
#
# Later phases add sqlrite-wasm-v<V>, sdk/go/v<V> as their
# publish jobs come online.
#
# Idempotent on re-run: if a tag already exists (partial-failure
# scenario where publish-crate succeeded but publish-ffi failed,
# say), we skip instead of failing. Lets "Re-run failed jobs" in
# the GitHub UI actually work.
tag-all:
name: Tag all products
needs: detect
if: needs.detect.outputs.should_release == 'true'
runs-on: ubuntu-latest
steps:
- uses: actions/checkout@v4
with:
# Need tag history to check existing tags.
fetch-depth: 0
- name: Configure git identity
run: |
git config user.name "github-actions[bot]"
git config user.email "41898282+github-actions[bot]@users.noreply.github.com"
- name: Create + push tags
run: |
V="${{ needs.detect.outputs.version }}"
TAGS=(
"sqlrite-v$V"
"sqlrite-ffi-v$V"
"sqlrite-desktop-v$V"
"sqlrite-py-v$V"
"sqlrite-node-v$V"
"sqlrite-wasm-v$V"
"sdk/go/v$V"
"v$V"
)
for tag in "${TAGS[@]}"; do
if git rev-parse "$tag" >/dev/null 2>&1; then
echo "::notice::Tag $tag already exists — skipping (re-run scenario)"
else
git tag "$tag"
echo "Created tag $tag"
fi
done
git push --tags
# ---------------------------------------------------------------------------
# Step 3a: publish the Rust engine crate to crates.io + create
# its per-product GitHub Release. Gated by the `release`
# environment's required-reviewer rule (a maintainer has to
# click Approve before this job actually runs).
publish-crate:
name: Publish sqlrite crate to crates.io
needs:
if: needs.detect.outputs.should_release == 'true'
runs-on: ubuntu-latest
environment: release
steps:
- uses: actions/checkout@v4
- uses: dtolnay/rust-toolchain@stable
- uses: Swatinem/rust-cache@v2
with:
shared-key: publish-crate
- name: cargo publish
env:
CARGO_REGISTRY_TOKEN: ${{ secrets.CRATES_IO_TOKEN }}
run: |
# `--no-verify` skips the rebuild+test that publish does
# by default — CI already ran on the same commit on the
# Release PR, so re-running here is duplicate work.
#
# Package name on crates.io is `sqlrite-engine`, not
# `sqlrite` — the latter was taken by an unrelated project
# (see root Cargo.toml for context). The [lib] name is
# still `sqlrite`, so downstream code writes `use sqlrite::…`.
cargo publish -p sqlrite-engine --no-verify
- name: GitHub Release
uses: softprops/action-gh-release@v2
with:
tag_name: sqlrite-v${{ needs.detect.outputs.version }}
name: Rust engine v${{ needs.detect.outputs.version }}
body: |
Published to crates.io: https://crates.io/crates/sqlrite-engine/${{ needs.detect.outputs.version }}
```toml
[dependencies]
sqlrite-engine = "${{ needs.detect.outputs.version }}"
```
```rust
// The [lib] name stays `sqlrite`, so the import alias is
// the short one even though the package name is longer.
use sqlrite::{Database, ExecutionResult};
```
See the umbrella release [v${{ needs.detect.outputs.version }}](../../releases/tag/v${{ needs.detect.outputs.version }}) for the full changelog.
generate_release_notes: true
# ---------------------------------------------------------------------------
# Step 3b: build `libsqlrite_c` for each supported platform and
# upload the tarballs to the `sqlrite-ffi-v<V>` GitHub Release.
#
# Matrix covers the platforms the Go / Python / Node SDKs' cgo /
# dlopen paths care about. Note: macos-latest is Apple Silicon
# (aarch64). A universal binary (x86_64 + aarch64 lipo'd
# together) is a follow-up — the MVP ships aarch64-only for
# macOS. Add `macos-13` to the matrix if x86_64 Mac support
# becomes a real ask.
publish-ffi:
name: Publish C FFI (${{ matrix.platform }})
needs:
if: needs.detect.outputs.should_release == 'true'
runs-on: ${{ matrix.os }}
environment: release
strategy:
fail-fast: false
matrix:
include:
- os: ubuntu-latest
platform: linux-x86_64
shared_lib: libsqlrite_c.so
static_lib: libsqlrite_c.a
- os: ubuntu-24.04-arm
platform: linux-aarch64
shared_lib: libsqlrite_c.so
static_lib: libsqlrite_c.a
- os: macos-latest
platform: macos-aarch64
shared_lib: libsqlrite_c.dylib
static_lib: libsqlrite_c.a
- os: windows-latest
platform: windows-x86_64
shared_lib: sqlrite_c.dll
static_lib: sqlrite_c.lib
steps:
- uses: actions/checkout@v4
- uses: dtolnay/rust-toolchain@stable
- uses: Swatinem/rust-cache@v2
with:
shared-key: publish-ffi-${{ matrix.platform }}
- name: Build libsqlrite_c
run: cargo build --release -p sqlrite-ffi
- name: Package tarball
shell: bash
run: |
V="${{ needs.detect.outputs.version }}"
STAGE="sqlrite-ffi-v$V-${{ matrix.platform }}"
mkdir -p "$STAGE/lib" "$STAGE/include"
cp "target/release/${{ matrix.shared_lib }}" "$STAGE/lib/"
cp "target/release/${{ matrix.static_lib }}" "$STAGE/lib/" 2>/dev/null || \
echo "::warning::static lib ${{ matrix.static_lib }} not found on ${{ matrix.platform }} — shipping shared lib only"
cp "sqlrite-ffi/include/sqlrite.h" "$STAGE/include/"
# README pointer so end users know what they're looking at
# when they untar the download.
cat > "$STAGE/README" <<EOF
SQLRite C FFI v$V — ${{ matrix.platform }}
Contents:
lib/ ${{ matrix.shared_lib }} — dynamic library to link against
lib/ ${{ matrix.static_lib }} — static library (if present)
include/ sqlrite.h — C header
Full docs: https://github.com/joaoh82/rust_sqlite/blob/main/sqlrite-ffi/README.md
EOF
tar czf "$STAGE.tar.gz" "$STAGE"
# Emit the path for the upload step below.
echo "ASSET=$STAGE.tar.gz" >> "$GITHUB_ENV"
- name: Upload to GitHub Release
uses: softprops/action-gh-release@v2
with:
tag_name: sqlrite-ffi-v${{ needs.detect.outputs.version }}
name: C FFI v${{ needs.detect.outputs.version }}
body: |
Prebuilt `libsqlrite_c` for every supported platform, plus the `sqlrite.h` header.
Download the tarball for your platform, extract, and link:
```
tar xzf sqlrite-ffi-v${{ needs.detect.outputs.version }}-<platform>.tar.gz
# lib/ — dynamic + static libraries
# include/sqlrite.h — header to #include
```
See the umbrella release [v${{ needs.detect.outputs.version }}](../../releases/tag/v${{ needs.detect.outputs.version }}) for the full changelog.
files: ${{ env.ASSET }}
generate_release_notes: true
# ---------------------------------------------------------------------------
# Step 3c: build the Tauri desktop app for each supported platform
# and upload the installers to the `sqlrite-desktop-v<V>` GitHub
# Release. (Phase 6e.)
#
# Matrix mirrors publish-ffi's — same three OS families, same
# "aarch64 on macOS, x86_64 elsewhere" choice. The actual installer
# formats per platform come from Tauri's bundler, not the matrix:
# - ubuntu-22.04 → AppImage + .deb (x86_64)
# - macos-latest → .dmg (aarch64)
# - windows-latest → .msi (x86_64)
#
# ubuntu-22.04 (not ubuntu-latest) is deliberate: AppImage links
# glibc at build time, so building on 22.04 (glibc 2.35) yields
# an AppImage that runs on any distro with glibc ≥ 2.35 — which
# covers everything shipped since 2022. Building on ubuntu-latest
# (24.04, glibc 2.39) would produce an AppImage that refuses to
# launch on Debian 12 / Ubuntu 22.04 and older.
#
# macOS universal (x86_64 + aarch64 lipo'd together) + Linux
# aarch64 desktop are follow-ups — same MVP-simplicity reasoning
# as publish-ffi. Apple Silicon is the majority of Mac downloads
# and x86_64 Linux is the majority of Linux downloads, so this
# covers 95%+ of users on day one.
#
# Installers ship **unsigned** — Phase 6.1 wires up Apple
# Developer ID + Windows code-signing cert. Unsigned installers
# trigger the expected "unidentified developer" / SmartScreen
# warnings; the release body explains how to bypass them.
publish-desktop:
name: Publish desktop (${{ matrix.platform }})
needs:
if: needs.detect.outputs.should_release == 'true'
runs-on: ${{ matrix.os }}
environment: release
strategy:
fail-fast: false
matrix:
include:
- os: ubuntu-22.04
platform: linux-x86_64
- os: macos-latest
platform: macos-aarch64
- os: windows-latest
platform: windows-x86_64
steps:
- uses: actions/checkout@v4
- uses: actions/setup-node@v4
with:
node-version: '20'
cache: 'npm'
cache-dependency-path: desktop/package-lock.json
- uses: dtolnay/rust-toolchain@stable
- uses: Swatinem/rust-cache@v2
with:
shared-key: publish-desktop-${{ matrix.platform }}
workspaces: './ -> target'
# Linux-only: Tauri's webview backend is webkit2gtk, which
# isn't preinstalled on GitHub runners. libayatana-appindicator
# / librsvg2 / patchelf are the rest of the standard Tauri
# Linux build kit. Matches the `desktop-build` job in ci.yml.
- name: Install Tauri Linux deps
if: matrix.os == 'ubuntu-22.04'
run: |
sudo apt-get update
sudo apt-get install -y \
libwebkit2gtk-4.1-dev \
libayatana-appindicator3-dev \
librsvg2-dev \
patchelf
- name: npm ci
working-directory: desktop
run: npm ci
# Icons (icon.ico, icon.icns, size-specific PNGs for Linux,
# mobile assets) are pre-generated in the repo via `npx tauri
# icon src-tauri/icons/icon.png` and committed to
# `desktop/src-tauri/icons/`. That keeps CI deterministic and
# saves ~10s per matrix cell; the tradeoff is that anyone
# changing `icon.png` needs to re-run `tauri icon` locally and
# commit the regenerated assets (PR review catches this).
# tauri-action does: frontend build (via beforeBuildCommand) →
# `cargo tauri build` → bundle installers per platform → upload
# each installer to the target GitHub Release. It reads
# tauri.conf.json for bundle config, so flipping `bundle.active`
# from `false` to `true` there is what actually causes installers
# to get produced. `tagName` is templated so the action doesn't
# create its own tag — we already did that in `tag-all`.
- name: Build + upload installers
uses: tauri-apps/tauri-action@v0
env:
GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}
with:
tagName: sqlrite-desktop-v${{ needs.detect.outputs.version }}
releaseName: Desktop v${{ needs.detect.outputs.version }}
releaseBody: |
SQLRite desktop app — unsigned installers. This release wave ships:
- **Linux**: `.AppImage` + `.deb` (Debian/Ubuntu) + `.rpm` (Fedora/RHEL), x86_64
- **macOS**: `.dmg` + raw `.app.tar.gz`, Apple Silicon (aarch64). Intel Macs not supported yet — tracked as a Phase 6e follow-up (universal dmg).
- **Windows**: `.msi` + `.exe` (NSIS installer), x86_64
### ⚠️ Unsigned installer warnings
Installers aren't code-signed yet (Phase 6.1 wires up Apple Developer ID + Windows code-signing). First-launch warnings to expect:
**macOS — "SQLRite is damaged and can't be opened" or "unidentified developer":**
```bash
xattr -cr /Applications/SQLRite.app
```
This strips the `com.apple.quarantine` attribute your browser attached on download. macOS Gatekeeper shows "damaged" (not the gentler "unidentified developer") because Tauri ad-hoc signs the binary — Apple Silicon *requires* a signature, even an ad-hoc one, but quarantined ad-hoc signatures trip a stricter Gatekeeper path. The app is fine; the signature just isn't from a registered Apple Developer ID.
**Windows — SmartScreen "Windows protected your PC":**
Click "More info" → "Run anyway".
**Linux — AppImage:**
```bash
chmod +x SQLRite_*_amd64.AppImage
./SQLRite_*_amd64.AppImage
```
See the umbrella release [v${{ needs.detect.outputs.version }}](../../releases/tag/v${{ needs.detect.outputs.version }}) for the full changelog.
releaseDraft: false
prerelease: false
projectPath: desktop
# tauri-action's default is to create the release if it
# doesn't exist. Since we want the release to aggregate
# artifacts across all three matrix jobs, the first job
# to finish creates it; the other two upload additional
# files to the same release. (action is idempotent on
# this — it uses `tagName` as the identity key.)
# ---------------------------------------------------------------------------
# Step 3d: build Python wheels for every supported platform.
# (Phase 6f — build half; publish half lives in the next job.)
#
# Why the split: PyPI expects wheels to be uploaded as one
# batch — if publish-python-wheels had publish logic inline,
# each matrix cell would race to upload its wheel independently,
# and a failure mid-matrix would leave PyPI with a partial wave.
# The two-job shape lets us aggregate every wheel (+ sdist) into
# one `dist/` directory and do the upload as a single atomic
# step in the `publish-python` job below.
#
# Matrix mirrors publish-ffi / publish-desktop — same four
# OS / arch combinations. abi3-py38 means each platform gets
# ONE wheel that works on every CPython ≥ 3.8, so we don't
# need a per-Python-version matrix axis.
build-python-wheels:
name: Build Python wheel (${{ matrix.platform }})
needs:
if: needs.detect.outputs.should_release == 'true'
runs-on: ${{ matrix.os }}
strategy:
fail-fast: false
matrix:
include:
- os: ubuntu-latest
target: x86_64
platform: linux-x86_64
manylinux: auto
- os: ubuntu-24.04-arm
target: aarch64
platform: linux-aarch64
manylinux: auto
- os: macos-latest
target: aarch64
platform: macos-aarch64
manylinux: ""
- os: windows-latest
target: x64
platform: windows-x86_64
manylinux: ""
steps:
- uses: actions/checkout@v4
- uses: actions/setup-python@v5
with:
# 3.10 is the build interpreter; abi3 means the wheel
# itself runs on every CPython ≥ 3.8. Any recent
# Python on the runner would work — 3.10 is just
# well-supported + cached on all runner images.
python-version: '3.10'
- uses: dtolnay/rust-toolchain@stable
- uses: Swatinem/rust-cache@v2
with:
shared-key: build-python-wheels-${{ matrix.platform }}
# `maturin-action` builds + packages the wheel. For Linux
# `manylinux: auto` means it runs inside a manylinux2014
# container so glibc gets baked at an old-enough version
# that the wheel runs on any distro shipped since ~2014.
# macOS / Windows don't use manylinux — the wheel tags
# reflect the specific OS version it was built on.
- name: Build wheel
uses: PyO3/maturin-action@v1
with:
working-directory: sdk/python
target: ${{ matrix.target }}
args: --release --out dist
manylinux: ${{ matrix.manylinux }}
- name: Upload wheel artifact
uses: actions/upload-artifact@v4
with:
name: python-wheel-${{ matrix.platform }}
path: sdk/python/dist/*.whl
if-no-files-found: error
retention-days: 1
# ---------------------------------------------------------------------------
# Step 3e: build the Python source distribution.
#
# Uploaded alongside the wheels so users on odd platforms not
# covered by our wheel matrix (FreeBSD, alpine aarch64, etc.)
# can still `pip install sqlrite` and get a source build
# (requires their local Rust toolchain, which is the standard
# fallback path for any PyO3 crate).
build-python-sdist:
name: Build Python sdist
needs:
if: needs.detect.outputs.should_release == 'true'
runs-on: ubuntu-latest
steps:
- uses: actions/checkout@v4
- uses: actions/setup-python@v5
with:
python-version: '3.10'
- name: Build sdist
uses: PyO3/maturin-action@v1
with:
working-directory: sdk/python
command: sdist
args: --out dist
- name: Upload sdist artifact
uses: actions/upload-artifact@v4
with:
name: python-sdist
path: sdk/python/dist/*.tar.gz
if-no-files-found: error
retention-days: 1
# ---------------------------------------------------------------------------
# Step 3f: aggregate every wheel + the sdist, upload to PyPI
# via OIDC trusted publishing, and cut the per-product
# `sqlrite-py-v<V>` GitHub Release.
#
# OIDC trusted publishing: no long-lived PyPI API token exists
# anywhere. The `permissions: id-token: write` block below
# lets `pypa/gh-action-pypi-publish` mint a short-lived OIDC
# token, exchange it at PyPI for a one-time upload token, and
# push every wheel. PyPI-side config lives on the `sqlrite`
# project's settings page — see docs/release-secrets.md for
# the one-time trusted-publisher registration.
publish-python:
name: Publish Python wheels to PyPI
needs:
if: needs.detect.outputs.should_release == 'true'
runs-on: ubuntu-latest
environment: release
permissions:
# OIDC: required for PyPI trusted-publisher token exchange.
id-token: write
# For the softprops/action-gh-release step at the end.
contents: write
steps:
- uses: actions/checkout@v4
# Pull every wheel artifact (one per matrix platform) +
# the sdist into a single `dist/` directory.
- name: Download wheel artifacts
uses: actions/download-artifact@v4
with:
pattern: python-wheel-*
path: dist
merge-multiple: true
- name: Download sdist artifact
uses: actions/download-artifact@v4
with:
name: python-sdist
path: dist
- name: List files about to be uploaded
run: ls -la dist/
# Single atomic upload of all wheels + sdist. If any file
# fails to upload, none are published — no partial wave
# on PyPI.
- name: Publish to PyPI
uses: pypa/gh-action-pypi-publish@release/v1
with:
packages-dir: dist
# Keep `skip-existing: false` so a re-run of this job
# (after a partial-failure scenario) fails loudly rather
# than silently ignoring already-uploaded files.
skip-existing: false
- name: GitHub Release
uses: softprops/action-gh-release@v2
with:
tag_name: sqlrite-py-v${{ needs.detect.outputs.version }}
name: Python v${{ needs.detect.outputs.version }}
body: |
Published to PyPI: https://pypi.org/project/sqlrite/${{ needs.detect.outputs.version }}/
```bash
pip install sqlrite==${{ needs.detect.outputs.version }}
```
```python
import sqlrite
conn = sqlrite.connect(":memory:")
conn.execute("CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT)")
conn.execute("INSERT INTO users (name) VALUES (?)", ("alice",))
for row in conn.execute("SELECT * FROM users"):
print(row)
```
**Wheels in this release:**
- Linux x86_64 (manylinux2014 or newer)
- Linux aarch64 (manylinux2014 or newer)
- macOS aarch64 (Apple Silicon)
- Windows x86_64
- Source distribution (`.tar.gz`) — builds from source on other platforms via a local Rust toolchain
All wheels are `abi3-py38`, so one wheel per platform works on every CPython ≥ 3.8.
See the umbrella release [v${{ needs.detect.outputs.version }}](../../releases/tag/v${{ needs.detect.outputs.version }}) for the full changelog.
files: dist/*
generate_release_notes: true
# ---------------------------------------------------------------------------
# Step 3g: build Node.js N-API binaries for every supported
# platform. (Phase 6g — build half; publish half lives in the
# next job.)
#
# Architecture: the "bundled binaries" approach, not napi-rs's
# newer optional-deps-per-platform pattern. The main `sqlrite`
# npm package ships every platform's `.node` binary inside one
# tarball; napi-rs's generated `index.js` dispatcher picks the
# right one at require time based on process.platform / arch.
# Simpler for MVP than maintaining N+1 npm packages; the cost
# is a ~15 MiB tarball instead of a ~4 MiB per-platform download,
# which is fine for a database driver people install once.
#
# Same build/publish split as publish-python for the same
# reason: npm expects one `npm publish` invocation per package
# version. If every matrix cell published independently, a
# partial-failure would put some-but-not-all binaries on npm
# with no clean rollback.
#
# Matrix mirrors publish-ffi / publish-desktop / publish-python.
# Naming convention for the `.node` file is napi-rs's own: the
# platform triple is baked into the filename, e.g.,
# `sqlrite.linux-x64-gnu.node` vs `sqlrite.darwin-arm64.node`.
# The `files` glob in sdk/nodejs/package.json matches on
# `sqlrite.*.node`, so whichever binaries land in the directory
# at publish time get included in the tarball.
build-nodejs-binaries:
name: Build Node.js binary (${{ matrix.platform }})
needs:
if: needs.detect.outputs.should_release == 'true'
runs-on: ${{ matrix.os }}
strategy:
fail-fast: false
matrix:
include:
- os: ubuntu-latest
platform: linux-x86_64
napi_triple: linux-x64-gnu
- os: ubuntu-24.04-arm
platform: linux-aarch64
napi_triple: linux-arm64-gnu
- os: macos-latest
platform: macos-aarch64
napi_triple: darwin-arm64
- os: windows-latest
platform: windows-x86_64
napi_triple: win32-x64-msvc
steps:
- uses: actions/checkout@v4
- uses: actions/setup-node@v4
with:
node-version: '20'
cache: 'npm'
cache-dependency-path: sdk/nodejs/package-lock.json
- uses: dtolnay/rust-toolchain@stable
- uses: Swatinem/rust-cache@v2
with:
shared-key: build-nodejs-${{ matrix.platform }}
- name: Install npm deps
working-directory: sdk/nodejs
run: npm ci
# `napi build --platform --release` produces:
# - sqlrite.<napi_triple>.node (the actual binary)
# - index.js (platform-dispatch loader)
# - index.d.ts (TypeScript types)
# We upload all three but only index.js/d.ts from the
# Linux x86_64 cell (they're identical across platforms
# since napi generates platform-agnostic dispatch code).
- name: Build native binary
working-directory: sdk/nodejs
run: npm run build
- name: Verify binary exists
working-directory: sdk/nodejs
shell: bash
run: |
ls -la sqlrite.*.node
# Fail early if napi produced an unexpected filename —
# otherwise the publish step would silently ship an
# incomplete tarball.
test -f "sqlrite.${{ matrix.napi_triple }}.node"
- name: Upload .node binary
uses: actions/upload-artifact@v4
with:
name: nodejs-binary-${{ matrix.platform }}
path: sdk/nodejs/sqlrite.${{ matrix.napi_triple }}.node
if-no-files-found: error
retention-days: 1
# Only Linux x86_64 uploads the shared dispatcher files.
# These are identical regardless of build platform (they're
# just require-the-right-.node glue), so we only need one
# copy in the final npm tarball.
- name: Upload JS dispatcher (linux-x86_64 only)
if: matrix.platform == 'linux-x86_64'
uses: actions/upload-artifact@v4
with:
name: nodejs-dispatcher
path: |
sdk/nodejs/index.js
sdk/nodejs/index.d.ts
if-no-files-found: error
retention-days: 1
# ---------------------------------------------------------------------------
# Step 3h: aggregate every platform's `.node` binary + the JS
# dispatcher into sdk/nodejs/, publish to npm via OIDC trusted
# publishing, and cut the per-product `sqlrite-node-v<V>`
# GitHub Release.
#
# OIDC trusted publishing: similar to the PyPI setup in
# publish-python. `permissions: id-token: write` lets npm mint
# a short-lived OIDC token, which `npm publish --provenance`
# exchanges for a one-time upload token. No NPM_TOKEN secret.
# One-time trusted-publisher config on npmjs.com — see
# docs/release-secrets.md.
#
# `--provenance` also attaches a signed attestation linking
# the package to this exact GitHub Actions workflow run (via
# sigstore, same mechanism as PyPI's PEP 740). Users who care
# about supply-chain can verify it with `npm audit signatures`.
publish-nodejs:
name: Publish Node.js package to npm
needs:
if: needs.detect.outputs.should_release == 'true'
runs-on: ubuntu-latest
environment: release
permissions:
# OIDC for npm trusted publisher + provenance signing.
id-token: write
# For softprops/action-gh-release step at the end.
contents: write
steps:
- uses: actions/checkout@v4
# NOTE: deliberately NO `registry-url:` here. setting that
# makes setup-node generate an `.npmrc` with
# `_authToken=${NODE_AUTH_TOKEN}`, which forces npm into
# token-based auth and *bypasses* the trusted-publisher
# OIDC pathway entirely. The v0.1.5 canary blew up on this
# exact issue: `404 Not Found - PUT ... is not in this
# registry` because npm sent an empty/missing
# NODE_AUTH_TOKEN instead of minting an OIDC token.
#
# With registry-url omitted, no `.npmrc` is generated, and
# npm CLI ≥ 11.5 auto-detects the GitHub Actions OIDC
# environment (via ACTIONS_ID_TOKEN_REQUEST_URL +
# permissions: id-token: write below), mints an OIDC token,
# and exchanges it at npm for a one-time publish token. The
# public default registry is fine — that's where
# registry.npmjs.org lives anyway.
- uses: actions/setup-node@v4
with:
node-version: '20'
# Node 20 LTS ships with npm 10.x, but trusted publishing
# auto-detection landed in npm 11.5. Force-upgrade so we
# don't depend on the runner image happening to ship a
# recent-enough npm.
- name: Upgrade npm to latest (need 11.5+ for trusted publishing)
run: npm install -g npm@latest
# Pull every platform's `.node` binary plus the JS
# dispatcher into sdk/nodejs/, overlaying them on top of
# the checked-out package.json / package-lock.json / etc.
- name: Download .node binaries
uses: actions/download-artifact@v4
with:
pattern: nodejs-binary-*
path: sdk/nodejs
merge-multiple: true
- name: Download JS dispatcher
uses: actions/download-artifact@v4
with:
name: nodejs-dispatcher
path: sdk/nodejs
- name: List publish payload + OIDC env diagnostics
working-directory: sdk/nodejs
run: |
ls -la
echo "---"
npm --version
echo "---"
# Confirm the OIDC env vars GitHub Actions auto-sets when
# `permissions: id-token: write` is granted. If either of
# these is empty, OIDC token exchange CAN'T happen and
# npm publish will fall back to "no auth available".
# Just print whether they're set, not their values
# (the URL has a trailing token-issuance path; treat as
# sensitive).
echo "ACTIONS_ID_TOKEN_REQUEST_URL is set: ${ACTIONS_ID_TOKEN_REQUEST_URL:+yes}${ACTIONS_ID_TOKEN_REQUEST_URL:-NO}"
echo "ACTIONS_ID_TOKEN_REQUEST_TOKEN is set: ${ACTIONS_ID_TOKEN_REQUEST_TOKEN:+yes}${ACTIONS_ID_TOKEN_REQUEST_TOKEN:-NO}"
echo "---"
# Dry-run the pack to see exactly what ends up in the
# published tarball. A missing .node file or a stray
# devDep pulled in by accident would be visible here.
npm pack --dry-run
# Single atomic publish via OIDC trusted publisher.
#
# The `--provenance` flag is what tells npm CLI to use the
# OIDC code path. Without it, npm only checks for `_authToken`
# config and gives up with ENEEDAUTH (this happened on the
# v0.1.6 canary attempt that ran without the flag — npm
# never even tried OIDC). With it, npm:
# 1. Reads ACTIONS_ID_TOKEN_REQUEST_URL +
# ACTIONS_ID_TOKEN_REQUEST_TOKEN from the GHA env
# 2. Mints an OIDC token bearing the workflow's identity
# claims (repo, environment, workflow filename, etc.)
# 3. Exchanges it at npm for a one-time publish token
# 4. Publishes the package + attaches a sigstore-signed
# provenance attestation linking the artifact to this
# exact workflow run
#
# The previous v0.1.5 failure with `--provenance` set was a
# different bug — `registry-url` on setup-node was generating
# an `.npmrc` that forced token-auth and bypassed OIDC. With
# registry-url removed (this file's previous fix) and
# `--provenance` restored, both bugs are addressed.
#
# `--access public` is REQUIRED because `@joaoh82/sqlrite`
# is a scoped package and scoped packages default to private;
# without the flag, npm rejects the upload for a free-tier
# account that can't host private packages.
#
# `--loglevel verbose` makes auth/transport errors
# diagnosable from the run log without re-running with
# debug-on. Cheap insurance against another silent failure.
- name: Publish to npm
working-directory: sdk/nodejs
run: npm publish --access public --provenance --loglevel verbose
- name: GitHub Release
uses: softprops/action-gh-release@v2
with:
tag_name: sqlrite-node-v${{ needs.detect.outputs.version }}
name: Node.js v${{ needs.detect.outputs.version }}
body: |
Published to npm: https://www.npmjs.com/package/@joaoh82/sqlrite/v/${{ needs.detect.outputs.version }}
```bash
npm install @joaoh82/sqlrite@${{ needs.detect.outputs.version }}
```
```javascript
const { Database } = require('@joaoh82/sqlrite');
const db = new Database(':memory:');
db.exec('CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT)');
const stmt = db.prepare('INSERT INTO users (name) VALUES (?)');
stmt.run('alice');
for (const row of db.prepare('SELECT * FROM users').iterate()) {
console.log(row);
}
```
**Binaries bundled in this release:**
- Linux x86_64 (`sqlrite.linux-x64-gnu.node`)
- Linux aarch64 (`sqlrite.linux-arm64-gnu.node`)
- macOS aarch64 (`sqlrite.darwin-arm64.node`)
- Windows x86_64 (`sqlrite.win32-x64-msvc.node`)
The package's `index.js` dispatcher auto-selects the right binary at require time — no platform-specific install step.
Verify package provenance:
```bash
npm audit signatures
```
See the umbrella release [v${{ needs.detect.outputs.version }}](../../releases/tag/v${{ needs.detect.outputs.version }}) for the full changelog.
generate_release_notes: true
# ---------------------------------------------------------------------------
# Step 3h: build the WASM package via wasm-pack and publish to
# npm as @joaoh82/sqlrite-wasm. (Phase 6h.)
#
# Single job — unlike the Python / Node SDKs there's no per-OS
# binary matrix, because WebAssembly is one universal artifact
# that runs on any wasm32-capable host (browsers, Deno, modern
# bundlers). One build, one upload.
#
# **Why scoped (`@joaoh82/sqlrite-wasm`) preemptively:** the
# unscoped `sqlrite-wasm` is currently free on npm but the
# similarity check that rejected `sqlrite` (vs `sqlite`) might
# also reject `sqlrite-wasm` (vs `sqlite-wasm` — distance 1).
# Going scoped from day one matches the Node SDK's
# `@joaoh82/sqlrite` decision and avoids the rename dance we
# did in PR #30. Free to revisit if the ecosystem demands an
# unscoped name.
#
# **Build target = `bundler`:** webpack/vite/rollup users get
# JS modules + .wasm without needing additional config. `web`
# / `nodejs` / `deno` targets can be added as siblings later
# if there's demand; one target per package is the simpler
# MVP shape.
#
# `--scope joaoh82` on `wasm-pack build` makes wasm-pack emit
# an auto-generated package.json with `name: "@joaoh82/sqlrite-wasm"`
# in the `pkg/` output directory — saves us from managing two
# package.json files (the auto-generated one and a hand-written
# override).
publish-wasm:
name: Publish WASM package to npm
needs:
if: needs.detect.outputs.should_release == 'true'
runs-on: ubuntu-latest
environment: release
permissions:
# OIDC: required for npm trusted-publisher token exchange.
# Same flow proven in publish-nodejs after the v0.1.5–0.1.7
# debugging adventure.
id-token: write
contents: write
steps:
- uses: actions/checkout@v4
- uses: dtolnay/rust-toolchain@stable
with:
targets: wasm32-unknown-unknown
- uses: Swatinem/rust-cache@v2
with:
shared-key: publish-wasm
workspaces: 'sdk/wasm -> target'
# Install wasm-pack — the canonical tool for building +
# packaging Rust crates as npm-publishable WASM modules.
# `cargo binstall` would be faster than `cargo install`
# (downloads a prebuilt binary) but binstall isn't
# preinstalled on `ubuntu-latest`; the curl|sh installer
# does the same thing in one step without bootstrapping
# binstall first.
- name: Install wasm-pack
run: |
curl https://rustwasm.github.io/wasm-pack/installer/init.sh -sSf | sh
# See publish-nodejs for the long-form rationale of this
# whole setup-node + npm-upgrade dance. Short version:
# NO `registry-url:` (would force token-auth via .npmrc),
# then explicitly upgrade npm to 11.5+ so trusted
# publishing is supported.
- uses: actions/setup-node@v4
with:
node-version: '20'
- name: Upgrade npm to latest (need 11.5+ for trusted publishing)
run: npm install -g npm@latest
# Build the WASM package. `--target bundler` produces
# ES modules + .wasm that webpack/vite/rollup can consume
# directly. `--scope joaoh82` makes the auto-generated
# package.json's name `@joaoh82/sqlrite-wasm`. `--release`
# picks up the size-optimized profile from sdk/wasm/
# Cargo.toml ([profile.release] opt-level = "z" + LTO).
- name: Build WASM package
working-directory: sdk/wasm
run: |
wasm-pack build --release --target bundler --scope joaoh82
echo "--- generated pkg/ contents ---"
ls -la pkg/
echo "--- generated package.json ---"
cat pkg/package.json
echo "--- WASM binary size ---"
ls -la pkg/*.wasm
# OIDC env diagnostics — same defensive logging that paid
# off when publish-nodejs hit the trusted-publisher subject
# mismatch in v0.1.7.
- name: OIDC env diagnostics
working-directory: sdk/wasm/pkg
run: |
npm --version
echo "ACTIONS_ID_TOKEN_REQUEST_URL is set: ${ACTIONS_ID_TOKEN_REQUEST_URL:+yes}${ACTIONS_ID_TOKEN_REQUEST_URL:-NO}"
echo "ACTIONS_ID_TOKEN_REQUEST_TOKEN is set: ${ACTIONS_ID_TOKEN_REQUEST_TOKEN:+yes}${ACTIONS_ID_TOKEN_REQUEST_TOKEN:-NO}"
npm pack --dry-run
# Atomic OIDC publish. Same flag combo proven in
# publish-nodejs: `--provenance` to trigger OIDC code path,
# `--access public` because scoped packages default to
# private, `--loglevel verbose` to keep error logs
# diagnosable.
- name: Publish to npm
working-directory: sdk/wasm/pkg
run: npm publish --access public --provenance --loglevel verbose
- name: GitHub Release
uses: softprops/action-gh-release@v2
with:
tag_name: sqlrite-wasm-v${{ needs.detect.outputs.version }}
name: WASM v${{ needs.detect.outputs.version }}
body: |
Published to npm: https://www.npmjs.com/package/@joaoh82/sqlrite-wasm/v/${{ needs.detect.outputs.version }}
```bash
npm install @joaoh82/sqlrite-wasm@${{ needs.detect.outputs.version }}
```
```javascript
// Bundler target — works with webpack, vite, rollup, parcel
import init, { Database } from '@joaoh82/sqlrite-wasm';
await init();
const db = new Database();
db.exec("CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT)");
db.exec("INSERT INTO users (name) VALUES ('alice')");
const rows = db.query("SELECT id, name FROM users");
// → [{ id: 1, name: 'alice' }]
```
**What's in the package:**
- `sqlrite_wasm_bg.wasm` — the WebAssembly engine binary
- `sqlrite_wasm.js` — auto-generated JS glue (wasm-bindgen)
- `sqlrite_wasm.d.ts` — TypeScript types
- `package.json` — bundler-target metadata
**Build target:** `bundler` (webpack/vite/rollup-friendly).
For `web` / `nodejs` / `deno` targets, build from source via `wasm-pack build sdk/wasm --target <target>`.
Verify package provenance:
```bash
npm audit signatures
```
See the umbrella release [v${{ needs.detect.outputs.version }}](../../releases/tag/v${{ needs.detect.outputs.version }}) for the full changelog.
files: sdk/wasm/pkg/*.wasm
generate_release_notes: true
# ---------------------------------------------------------------------------
# Step 3i: publish the Go SDK. (Phase 6i.)
#
# Go's distribution model is unique among our publish channels:
# there's NO central registry. Go modules pull straight from VCS
# via tag, and `go get github.com/joaoh82/rust_sqlite/sdk/go@v0.X.Y`
# works the moment a `sdk/go/v0.X.Y` tag is on the remote (modulo
# ~minutes of cache lag at proxy.golang.org). The tag is created
# by `tag-all` upstream of this job — there's nothing to upload.
#
# **What this job DOES do:** the binding uses cgo against
# `libsqlrite_c` (the C FFI from sqlrite-ffi), so end users
# need that shared library on their system to run anything.
# We pull the per-platform tarballs that publish-ffi already
# uploaded to its release and re-attach them to the Go release
# page so Go users have a one-stop-shop:
#
# `go get github.com/joaoh82/rust_sqlite/sdk/go@vX.Y.Z`
# download `libsqlrite_c-<platform>.tar.gz` from the same
# release page → set CGO_LDFLAGS / CGO_CFLAGS → `go build`.
#
# **Tag with slashes:** Go's submodule tag convention is
# `<subpath>/vX.Y.Z` — for our module path
# `github.com/joaoh82/rust_sqlite/sdk/go`, the canonical tag is
# `sdk/go/vX.Y.Z` (slashes intact). GitHub Releases handle
# slash-bearing tags fine; the URL just URL-encodes them.
publish-go:
name: Publish Go SDK GitHub Release
needs:
if: needs.detect.outputs.should_release == 'true'
runs-on: ubuntu-latest
permissions:
# For softprops/action-gh-release + gh CLI release-download.
contents: write
steps:
- uses: actions/checkout@v4
with:
# Need full tag history to verify tag-all's `sdk/go/v$V`
# is on the remote.
fetch-depth: 0
# Cheap consistency check that tag-all did its job. If this
# fires, something's wrong upstream and the human should
# know before we cut a confusingly-named GitHub Release.
- name: Verify Go module tag exists
run: |
V="${{ needs.detect.outputs.version }}"
TAG="sdk/go/v$V"
if ! git rev-parse "$TAG" >/dev/null 2>&1; then
echo "::error::Tag $TAG not found — tag-all should have created + pushed it"
exit 1
fi
echo "Tag $TAG exists at $(git rev-parse --short $TAG)"
# Pull the tarballs publish-ffi already attached to the
# sqlrite-ffi-v<V> release. The `gh release download` flow
# avoids re-running the whole publish-ffi build matrix just
# to get the artifacts here — it's a single API call with
# the workflow's auto-injected GITHUB_TOKEN.
- name: Download FFI tarballs from this release wave
env:
GH_TOKEN: ${{ secrets.GITHUB_TOKEN }}
run: |
V="${{ needs.detect.outputs.version }}"
mkdir -p ffi-tarballs
gh release download "sqlrite-ffi-v$V" \
--repo joaoh82/rust_sqlite \
--dir ffi-tarballs \
--pattern '*.tar.gz'
echo "--- FFI tarballs downloaded ---"
ls -la ffi-tarballs/
# Cut the Go release page. Tag has slashes — softprops handles
# that correctly (URL-encodes the slashes in the resulting
# release URL).
- name: GitHub Release
uses: softprops/action-gh-release@v2
with:
tag_name: sdk/go/v${{ needs.detect.outputs.version }}
name: Go SDK v${{ needs.detect.outputs.version }}
body: |
```bash
go get github.com/joaoh82/rust_sqlite/sdk/go@v${{ needs.detect.outputs.version }}
```
```go
package main
import (
"database/sql"
"fmt"
_ "github.com/joaoh82/rust_sqlite/sdk/go" // registers "sqlrite" driver
)
func main() {
db, _ := sql.Open("sqlrite", ":memory:")
defer db.Close()
_, _ = db.Exec("CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT)")
_, _ = db.Exec("INSERT INTO users (name) VALUES ('alice')")
rows, _ := db.Query("SELECT id, name FROM users")
defer rows.Close()
for rows.Next() {
var id int64
var name string
rows.Scan(&id, &name)
fmt.Printf("%d: %s\n", id, name)
}
}
```
## Prebuilt `libsqlrite_c` (cgo dependency)
The Go binding uses cgo against the `libsqlrite_c` shared library shipped by [`sqlrite-ffi`](https://github.com/joaoh82/rust_sqlite/tree/main/sqlrite-ffi). The tarballs attached below are the same ones from this release wave's [C FFI release](../../releases/tag/sqlrite-ffi-v${{ needs.detect.outputs.version }}) — provided here so Go users have a one-stop-shop:
- `sqlrite-ffi-v${{ needs.detect.outputs.version }}-linux-x86_64.tar.gz`
- `sqlrite-ffi-v${{ needs.detect.outputs.version }}-linux-aarch64.tar.gz`
- `sqlrite-ffi-v${{ needs.detect.outputs.version }}-macos-aarch64.tar.gz`
- `sqlrite-ffi-v${{ needs.detect.outputs.version }}-windows-x86_64.tar.gz`
Extract for your platform, then point cgo at it:
```bash
tar xzf sqlrite-ffi-v${{ needs.detect.outputs.version }}-<platform>.tar.gz
export CGO_CFLAGS="-I$(pwd)/sqlrite-ffi-v${{ needs.detect.outputs.version }}-<platform>/include"
export CGO_LDFLAGS="-L$(pwd)/sqlrite-ffi-v${{ needs.detect.outputs.version }}-<platform>/lib -lsqlrite_c"
export LD_LIBRARY_PATH="$(pwd)/sqlrite-ffi-v${{ needs.detect.outputs.version }}-<platform>/lib"
go build ./...
```
(On macOS use `DYLD_LIBRARY_PATH` instead of `LD_LIBRARY_PATH`. On Windows, place the `.dll` next to your binary or on `%PATH%`.)
See the umbrella release [v${{ needs.detect.outputs.version }}](../../releases/tag/v${{ needs.detect.outputs.version }}) for the full changelog.
files: ffi-tarballs/*.tar.gz
generate_release_notes: true
# ---------------------------------------------------------------------------
# Step 4: create the umbrella GitHub Release. Runs after all
# publish-* jobs succeed. Uses GitHub's native auto-generated
# release notes so the changelog is "everything between the
# previous v* tag and this one" — curated via .github/release.yml
# config if we add one later.
finalize:
name: Finalize umbrella release
needs:
if: needs.detect.outputs.should_release == 'true'
runs-on: ubuntu-latest
steps:
- uses: actions/checkout@v4
with:
fetch-depth: 0
- name: Umbrella GitHub Release
uses: softprops/action-gh-release@v2
with:
tag_name: v${{ needs.detect.outputs.version }}
name: v${{ needs.detect.outputs.version }}
body: |
**SQLRite v${{ needs.detect.outputs.version }}**
Per-product releases in this wave:
- 🦀 [Rust engine](../../releases/tag/sqlrite-v${{ needs.detect.outputs.version }}) → [crates.io](https://crates.io/crates/sqlrite-engine/${{ needs.detect.outputs.version }})
- 🔧 [C FFI](../../releases/tag/sqlrite-ffi-v${{ needs.detect.outputs.version }}) — prebuilt `libsqlrite_c` for Linux x86_64/aarch64, macOS aarch64, Windows x86_64
- 🖥️ [Desktop](../../releases/tag/sqlrite-desktop-v${{ needs.detect.outputs.version }}) — unsigned installers for Linux (AppImage + deb), macOS (dmg aarch64), Windows (msi)
- 🐍 [Python](../../releases/tag/sqlrite-py-v${{ needs.detect.outputs.version }}) → [PyPI](https://pypi.org/project/sqlrite/${{ needs.detect.outputs.version }}/) — abi3-py38 wheels for Linux x86_64/aarch64, macOS aarch64, Windows x86_64 + sdist
- 🟢 [Node.js](../../releases/tag/sqlrite-node-v${{ needs.detect.outputs.version }}) → [npm](https://www.npmjs.com/package/@joaoh82/sqlrite/v/${{ needs.detect.outputs.version }}) — N-API bindings with prebuilt `.node` binaries for Linux x86_64/aarch64, macOS aarch64, Windows x86_64
- 🌐 [WASM](../../releases/tag/sqlrite-wasm-v${{ needs.detect.outputs.version }}) → [npm](https://www.npmjs.com/package/@joaoh82/sqlrite-wasm/v/${{ needs.detect.outputs.version }}) — browser/bundler-target WebAssembly build via wasm-pack
- 🐹 [Go SDK](../../releases/tag/sdk%2Fgo%2Fv${{ needs.detect.outputs.version }}) → `go get github.com/joaoh82/rust_sqlite/sdk/go@v${{ needs.detect.outputs.version }}` — `database/sql` driver via cgo against `libsqlrite_c`
---
Auto-generated changelog below ↓
generate_release_notes: true