electric
electric copied to clipboard
Sync little subsets of your Postgres data into local apps and services.
This pull request updates the dependencies and images used in the project. It includes the following changes: - Updated the PostgreSQL image from `postgres:14-alpine` to `postgres:16-alpine`. - Updated the Electric...
@justindotpub has shared their experience of running Electric alongside a Phoenix app [on Discord](https://discord.com/channels/933657521581858818/1206993245385662555). One pain point from it that we could improve is to let the Phoenix app drop...
Limitations of this POC: * The serevr translates the type `vector(N)` to `TEXT(N)` when building SQLite migrations from the Postgres schema. * It doesn't validate dimensions for incoming values. So...
A part of the tauri example. This is a WIP, more changes are needed. To load a dump of data into the db, download this https://www.dropbox.com/s/oqzy4igb89fi953/data.zip?dl=1 and extract it to...
Concurrent PostgreSQL and SQLite3 clients can trigger a deadlock: * error in electric.reorder_main_op pgSQL * error in Replication.Postgres.Writer genserver which terminates and restarts * replication transaction appears to not be...
Attempt to prevent / warn users to provide invalid URLs to the config. Discord source: https://discord.com/channels/933657521581858818/1110941752875028530/1194966674026270831 In this example, the user provides that URL by mistake, probably because of lack...
Hi! I fell a bit in love with your project to be honest. Thanks for the great work so far. Anyway. I'm trying to create a template to make project...
This PR modifies the generic DB adapter and the capacitor-sqlite DB adapter to use a priority-aware mutex such that UI queries have higher priority than Satellite queries.
https://github.com/electric-sql/electric/blob/d385d3cf7eb4c8822afefdd6173fad7feb71712a/clients/typescript/src/drivers/wa-sqlite/database.ts#L45 `prepare_v2` generates a new query plan every time it's called. Consider keeping a cache of prepared statements.
In certain cases we don't catch SQLite errors and propagate them as they arrive from the database driver. In this task we unify raw SQLite error messages to have a...