sqlc-database

sqlc Database example

This is a basic Hello World Encore application with a single API endpoint, that uses sqlc and a SQL database to keep track of how many times you've said hello.

Developing locally

When you have installed Encore, you can create a new Encore application and clone this example with this command.

encore app create my-app-name --example=sqlc-database

Generating store code

In order to generate code in store package you should have installed sqlc and create your SQL queries in store/queries directory. Then just run this command from root catalog.

sqlc generate

Running

To run the application, make sure you have Docker installed and running. This is required to locally run Encore applications with SQL databases.

encore run

Using the API

To see that your app is running, you can ping the API.

curl http://localhost:4000/hello/There

Open the developer dashboard

While encore run is running, open http://localhost:9400/ to view Encore's local developer dashboard.

Deployment

Deploy your application to a staging environment in Encore's free development cloud:

git add -A .
git commit -m 'Commit message'
git push encore

Then head over to the Cloud Dashboard to monitor your deployment and find your production URL.

From there you can also connect your own AWS or GCP account to use for deployment.

Now off you go into the clouds!

Testing

encore test ./...