website/docs/integrations/phoenix.md
Phoenix is a full-stack web development framework for Elixir.
Electric is developed in Elixir, has a first-class Elixir client and a deep Phoenix framework integration in the form of the official Phoenix.Sync library.
<figure> <div style="aspect-ratio: 16/9" class="embed-container"> <YoutubeEmbed video-id="rlzL5wnWa9o" /> </div> </figure>Phoenix.Sync enables real-time sync for Postgres-backed Phoenix applications. You can use it to sync data into Elixir, LiveView and frontend web and mobile applications.
The library integrates with Plug and Phoenix.{Controller, LiveView, Router, Stream}. It uses ElectricSQL as the core sync engine, either as an embedded application dependency, or running as an external HTTP service.
The APIs map Ecto queries to Shapes.
Documentation is available at hexdocs.pm/phoenix_sync.
There are four key APIs:
Phoenix.Sync.Client.stream/2 for low level usage in ElixirPhoenix.Sync.LiveView.sync_stream/4 to sync into a LiveView streamPhoenix.Sync.Router.sync/2 macro to expose a statically defined shape in your RouterPhoenix.Sync.Controller.sync_render/3 to expose dynamically constructed shapes from a ControllerUse Phoenix.Sync.Client.stream/2 to convert an Ecto.Query into an Elixir Stream:
stream = Phoenix.Sync.Client.stream(Todos.Todo)
stream =
Ecto.Query.from(t in Todos.Todo, where: t.completed == false)
|> Phoenix.Sync.Client.stream()
Swap out Phoenix.LiveView.stream/3 for Phoenix.Sync.LiveView.sync_stream/4 to automatically keep a LiveView up-to-date with the state of your Postgres database:
defmodule MyWeb.MyLive do
use Phoenix.LiveView
import Phoenix.Sync.LiveView
def mount(_params, _session, socket) do
{:ok, sync_stream(socket, :todos, Todos.Todo)}
end
def handle_info({:sync, event}, socket) do
{:noreply, sync_stream_update(socket, event)}
end
end
LiveView takes care of automatically keeping the front-end up-to-date with the assigned stream. What Phoenix.Sync does is automatically keep the stream up-to-date with the state of the database.
This means you can build fully end-to-end real-time multi-user applications without writing Javascript and without worrying about message delivery, reconnections, cache invalidation or polling the database for changes.
Use the Phoenix.Sync.Router.sync/2 macro to expose statically (compile-time) defined shapes in your Router:
defmodule MyWeb.Router do
use Phoenix.Router
import Phoenix.Sync.Router
pipeline :sync do
plug :my_auth
end
scope "/shapes" do
pipe_through :sync
sync "/todos", Todos.Todo
end
end
Because the shapes are exposed through your Router, the client connects through your existing Plug middleware. This allows you to do real-time sync straight out of Postgres without having to translate your auth logic into complex/fragile database rules.
Sync shapes from any standard Controller using the Phoenix.Sync.Controller.sync_render/3 view function:
defmodule Phoenix.Sync.LiveViewTest.TodoController do
use Phoenix.Controller
import Phoenix.Sync.Controller
import Ecto.Query, only: [from: 2]
def show(conn, %{"done" => done} = params) do
sync_render(conn, params, from(t in Todos.Todo, where: t.done == ^done))
end
def show_mine(%{assigns: %{current_user: user_id}} = conn, params) do
sync_render(conn, params, from(t in Todos.Todo, where: t.owner_id == ^user_id))
end
end
This allows you to define and personalise the shape definition at runtime using the session and request.
You can sync into any client in any language that speaks HTTP and JSON. For example, using the Electric Typescript client:
import { Shape, ShapeStream } from '@electric-sql/client'
const stream = new ShapeStream({
url: `/shapes/todos`,
})
const shape = new Shape(stream)
// The callback runs every time the data changes.
shape.subscribe((data) => console.log(data))
Or binding a shape to a component using the React bindings:
import { useShape } from '@electric-sql/react'
const MyComponent = () => {
const { data } = useShape({
url: `shapes/todos`,
})
return <List todos={data} />
}
See the Electric demos and documentation for more client-side usage examples.
Phoenix.Sync can be used in two modes:
:embedded where Electric is included as an application dependency and Phoenix.Sync consumes data internally using Elixir APIs:http where Electric does not need to be included as an application dependency and Phoenix.Sync consumes data from an external Electric service using it's HTTP APIIn :embedded mode, Electric must be included an application dependency but does not expose an HTTP API (internally or externally). Messages are streamed internally between Electric and Phoenix.Sync using Elixir function APIs. The only HTTP API for sync is that exposed via your Phoenix Router using the sync/2 macro and sync_render/3 function.
Example config:
# mix.exs
defp deps do
[
{:electric, ">= 1.0.0-beta.20"},
{:phoenix_sync, "~> 0.3"}
]
end
# config/config.exs
config :phoenix_sync,
env: config_env(),
mode: :embedded,
repo: MyApp.Repo
# application.ex
children = [
MyApp.Repo,
# ...
{MyApp.Endpoint, phoenix_sync: Phoenix.Sync.plug_opts()}
]
In :http mode, Electric does not need to be included as an application dependency. Instead, Phoenix.Sync consumes data from an external Electric service over HTTP.
# mix.exs
defp deps do
[
{:phoenix_sync, "~> 0.3"}
]
end
# config/config.exs
config :phoenix_sync,
env: config_env(),
mode: :http,
url: "https://api.electric-sql.cloud",
credentials: [
secret: "...", # required
source_id: "..." # optional, required for Electric Cloud
]
# application.ex
children = [
MyApp.Repo,
# ...
{MyApp.Endpoint, phoenix_sync: Phoenix.Sync.plug_opts()}
]
It is also possible to include Electric as an application dependency and configure it to expose a local HTTP API that's consumed by Phoenix.Sync running in :http mode:
# mix.exs
defp deps do
[
{:electric, ">= 1.0.0-beta.20"},
{:phoenix_sync, "~> 0.3"}
]
end
# config/config.exs
config :phoenix_sync,
env: config_env(),
mode: :http,
http: [
port: 3000,
],
repo: MyApp.Repo,
url: "http://localhost:3000"
# application.ex
children = [
MyApp.Repo,
# ...
{MyApp.Endpoint, phoenix_sync: Phoenix.Sync.plug_opts()}
]
This is less efficient than running in :embedded mode but may be useful for testing or when needing to run an HTTP proxy in front of Electric as part of your development stack.
Apps using :http mode in certain environments can exclude :electric as a dependency for that environment. The following example shows how to configure:
:embedded mode in :dev:http mode with a local Electric service in :test:http mode with an external Electric service in :prodWith Electric only included and compiled as a dependency in :dev and :test.
# mix.exs
defp deps do
[
{:electric, "~> 1.0.0-beta.20", only: [:dev, :test]},
{:phoenix_sync, "~> 0.3"}
]
end
# config/dev.exs
config :phoenix_sync,
env: config_env(),
mode: :embedded,
repo: MyApp.Repo
# config/test.esx
config :phoenix_sync,
env: config_env(),
mode: :http,
http: [
port: 3000,
],
repo: MyApp.Repo,
url: "http://localhost:3000"
# config/prod.exs
config :phoenix_sync,
mode: :http,
url: "https://api.electric-sql.cloud",
credentials: [
secret: "...", # required
source_id: "..." # optional, required for Electric Cloud
]
# application.ex
children = [
MyApp.Repo,
# ...
{MyApp.Endpoint, phoenix_sync: Phoenix.Sync.plug_opts()}
]
The source code for Phoenix.Sync is maintained at electric-sql/phoenix_sync. You can see various usage examples in the test/support folder.
The main Electric monorepo has a Phoenix LiveView example. This is an example Phoenix LiveView application that uses Electric.Phoenix.LiveView.sync_stream/4 to sync data from Postgres into a LiveView using Phoenix Streams.
The Gatekeeper auth example also contains a Phoenix application that uses Plug to authorize shape access and issue shape-scoped access tokens.
There's also a conference demo app using Phoenix.Sync on GitHub at thruflo/conductor. This demonstrates using the LiveView, Router and Controller integrations.
There's an #elixir channel in the Electric Discord that's a good place to ask questions.