Fullstack application go + sqlite + htmx

The most productive and efficient stack of the world!

Steps to generate the code

0. Install the required tools.

go install github.com/walterwanderley/sqlc-http@latest

1. Create a directory to store SQL scripts.

mkdir -p sql/migrations

2. Create migrations scripts using goose rules.

echo "-- +goose Up
CREATE TABLE IF NOT EXISTS authors (
    id         integer PRIMARY KEY AUTOINCREMENT,
    name       text    NOT NULL,
    bio        text,
    birth_date date
);

-- +goose Down
DROP TABLE IF EXISTS authors;
" > sql/migrations/001_authors.sql

3. Create SQL queries and use sqlc and sqlc-http comments syntax.

echo "/* name: GetAuthor :one */
/* http: GET /authors/{id}*/
SELECT * FROM authors
WHERE id = ? LIMIT 1;

/* name: ListAuthors :many */
/* http: GET /authors */
SELECT * FROM authors
ORDER BY name
LIMIT ? OFFSET ?;

/* name: CreateAuthor :execresult */
/* http: POST /authors */
INSERT INTO authors (
  name, bio, birth_date
) VALUES (
  ?, ?, ? 
);

/* name: UpdateAuthor :execresult */
/* http: PUT /authors/{id} */
UPDATE authors
SET name = ?, 
bio = ?,
birth_date = ?
WHERE id = ?;

/* name: UpdateAuthorBio :execresult */
/* http: PATCH /authors/{id}/bio */
UPDATE authors
SET bio = ?
WHERE id = ?;

/* name: DeleteAuthor :exec */
/* http: DELETE /authors/{id} */
DELETE FROM authors
WHERE id = ?;
" > sql/queries.sql

4. Create the sqlc.yaml configuration file

echo "
version: "2"
sql:
- schema: "./sql/migrations"
  queries: "./sql/queries.sql"
  engine: "sqlite"
  gen:
    go:
      out: "internal/authors"
" > sqlc.yaml

6. Execute sqlc-http

sqlc-http -m sqlite-htmx -migration-path sql/migrations -frontend

Running

go run . -db test.db

Go to http://localhost:5000

Hot reload

If you want to automatic refresh the browser after change html files, use the -dev parameter:

go run . -db test.db -dev

Database Relication

Starting 3 instances with database replication (using either an embedded or external NATS server) to achieve high availability and fault tolerance:

Instance 1

go run . -db "node1.db" -cdc-id example -nats-port 4222 -node n1 -port 5000 -leader-redirect

Instance 2

go run . -db "node2.db" -cdc-id example -nats-url nats://localhost:4222 -node n2 -port 5001 -leader-redirect

Instance 3

go run . -db "node3.db" -cdc-id example -nats-url nats://localhost:4222 -node n3 -port 5002 -leader-redirect

Go to http://localhost:5000 Go to http://localhost:5001 Go to http://localhost:5002

"Computers make art, artists make money" (Chico Science)