This is an example web application using ElectricSQL in the browser with wa-sqlite.
You need NodeJS >= 16.11 and Docker Compose v2.
Install the dependencies:
npm installStart Postgres and Electric using Docker (see running the examples for more options):
npm run backend:up
# Or `npm run backend:start` to foregroundNote that, if useful, you can connect to Postgres using:
npm run db:psqlSetup your database schema:
npm run db:migrateGenerate your type-safe client:
npm run client:generate
# or `yarn client:watch`` to re-generate whenever the DB schema changesStart your app:
npm run devOpen localhost:5173 in your web browser.
./src/Example.tsx has the main example code. For more information see the:
If you need help let us know on Discord.
I went with Fly Postgres... app called my-app-pg (in bx account) https://fly.io/docs/postgres/getting-started/what-you-should-know/
NOTE: You don't have a fly.toml (presumably because it could get mixed up with your actual app one..) so you have to explicitly specify the pg app name, e.g.:
flyctl <command> -a my-app-pg
Then, the "main app": named it electricsql-on-fly-test-app Pasted the fly.toml data as ElectricSQL suggests, then overwrote the value for DATABASE_URL with the "connection string" value that came back from creating my-app-pg and added the DATABASE_USE_IPV6 = 'true' and DATABASE_REQUIRE_SSL = 'false'
Allocated dedicated ipv4: 149.248.221.49 Allocated dedicated ipv6: 2a09:8280:1::38:65f8:0
IT FAILED. Raised a github issue with Electric, as the message told me to..