Kobie Botha kobiebotha

SQLite Extension Loading for PowerSync

PowerSync requires the ability to load SQLite extensions. This document describes the requirements and approaches for enabling SQLite extension loading across different platforms.

Requirements

PowerSync has no special requirements other than requiring the ability for our SQLite extension to be loaded.

SQLite Documentation

Quickstart:

npx create-expo-app@latest my-app
cd my-app && npm run ios
Open a new terminal tab:
npm install @powersync/react-native @powersync/adapter-sql-js
Replace code in app/(tabs)/index.tsx:

import { SQLJSOpenFactory } from "@powersync/adapter-sql-js";

PowerSync Contributor License Agreement

In order to clarify the intellectual property license granted with Contributions (as defined below) from any person or entity, Journey Mobile, Inc. ("JourneyApps") must have a Contributor License Agreement ("CLA") on file that has been signed by each Contributor, indicating agreement to the license terms below. This license is for Your protection as a Contributor as well as the protection of the JourneyApps and its users; it does not change Your rights to use Your own Contributions for any other purpose.

You accept and agree to the following terms and conditions for Your present and future Contributions submitted to JourneyApps. Except for the license granted herein to JourneyApps and recipients of software distributed by JourneyApps, You reserve all right, title, and interest in and to Your Contributions.

Definitions. "You" (or "Your") shall mean the copyright owner or legal entity authorized by the copyright owner that is making this CLA wi

Keybase proof

I hereby claim:

I am kobiebotha on github.
I am kobie (https://keybase.io/kobie) on keybase.
I have a public key ASB5VtLXAYe6ePa9S8COAkV-dmYWX1dqVpTIHC8nQo6CjQo

To claim this, I am signing this object:

	PS C:\Users\journey\powersync\powersync.dart\demos\supabase-todolist> flutter run
	Downloading Web SDK... 6.2s
	Downloading windows-x64-debug/windows-x64-flutter tools... 6.1s
	Downloading windows-x64/flutter-cpp-client-wrapper tools... 82ms
	Downloading windows-x64-profile/windows-x64-flutter tools... 4.6s
	Downloading windows-x64-release/windows-x64-flutter tools... 5.8s
	Connected devices:
	Windows (desktop) • windows • windows-x64 • Microsoft Windows [Version 10.0.22631.3958]
	Chrome (web) • chrome • web-javascript • Google Chrome 127.0.6533.73
	Edge (web) • edge • web-javascript • Microsoft Edge 127.0.2651.74