go-svelte-sqlite-template

This is a template application I use frequently to spin simple applications up quickly. The stack is essentially:

• DB: Sqlite (schema managed by Atlas)
• Backend: Golang
• Frontend: Svelte (in Typescript)
• RPC API: Twirp

The golang backend implements the twirp API server and also serves static FE files (index.html, css, js, etc). The protocol buffer API definition generates both go code for the server implementation and the client-side typescript code the frontend to use. The sqlite db is replicated to S3 (in production) by litestream.

How to deploy

TODO

Things I'd like to improve

1. Serve static files via the go static file server without giving up Hot Module Replacement, so that you don't have to use the node webserver in development.

Steps

1. git clone https://github.com/cameront/go-svelte-sqlite-template [your_directory]
2. ./scripts/one_time_setup.sh
3. (source env_dev.sh && air)
4. pushd _ui && npm run dev

Optional Additional Steps

Rename ish

Rename the "count" service to the name of the service ([servicename]) you want to build.

1. replace rpc/count/countservice.proto package names with references to [servicename]
2. replace scripts/protogen.sh with references to [servicename]
3. mv rpc/count/countservice.proto rpc/[servicename]/[servicename]service.proto
4. mv rpc/count -> rpc/[servicename]
5. rm -rf rpc/count
6. ./scripts/protogen.sh
7. optionally replace the server port (5001) and the UI dev port (5000) with those of your liking