Oracle Backend for Firebase

https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/
Admin
Oracle Backend for Firebase is a backend service that provides database, authentication, storage,...
Tokens:130,848
Snippets:1,483
Trust Score:9.1
Update:4 months ago
Show doc for...
Tokens:
Raw
### Basic Authentication Setup

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/setting-authentication.html

Configure basic email and password sign-in for development or testing. This setup also supports third-party sign-in methods.

```text
1. Open Authentication.
2. Select Authentication setup.
3. Choose Basic.
4. Save and apply the configuration.
```

--------------------------------

### Initiate Web Sign-In with Redirect (JS Namespace)

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/getting-started-authentication-sdk.html

Start the sign-in process using the redirect flow with the JS Namespace SDK. Includes logic to get the redirect result and handle errors.

```javascript
// Start sign in with redirect flow
auth.signInWithRedirect(provider);

// After the user completes sign-in and returns to the app, obtain sign-in result by calling getRedirectResult()
auth.getRedirectResult()
  .then((result) => {
    var credential = result.credential;

    // OAuth access and id tokens can also be retrieved:
    var accessToken = credential.accessToken;
    var idToken = credential.idToken;
  })
  .catch((error) => {
    // Handle error.
  });

```

--------------------------------

### Link CLI Project and Verify Installation

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/installing-and-configuring.html

If 'fusabase' is not found after installation, return to the CLI project directory, rerun this command, and then verify with 'fusabase --help'.

```bash
npm link
```

--------------------------------

### Install Modular JavaScript SDK

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/adding-oracle-backend-firebase-your-apps.html

Install the modular JavaScript SDK using npm. This approach is recommended for modern JavaScript build tools and frameworks.

```bash
npm install fusabase
```

--------------------------------

### Install Namespace-Style JavaScript SDK

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/adding-oracle-backend-firebase-your-apps.html

Install the older namespace-style JavaScript SDK using npm. Use this if your application is not using a module-based workflow.

```bash
npm install fusabase-ns
```

--------------------------------

### Start Auth UI Rendering

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/getting-started-authentication-sdk.html

This JavaScript snippet shows how to initiate the rendering of the authentication UI into a specified container.

```javascript
ui.start('#auth-container', {
  /* config */
});
```

--------------------------------

### Sign in with OIDC Provider using Java (Android)

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/setting-authentication.html

Initiate a sign-in flow with an OIDC provider on Android using the Java SDK. This example shows how to get the Firebase authentication instance, create an OAuthProvider, and start the sign-in activity. Handle the sign-in result in the OnSuccessListener.

```java
import com.oracle.mobile.fusabase.auth.FusabaseAuth;
import com.oracle.mobile.fusabase.auth.OAuthProvider;

FusabaseAuth auth = FusabaseAuth.getInstance();
OAuthProvider provider = OAuthProvider.newBuilder("oidc_example").build();

auth.startActivityForSignInWithProvider(activity, provider)
    .addOnSuccessListener(authResult -> {
        // Signed in
    });
```

--------------------------------

### Example fusabase-config.json

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/adding-oracle-backend-firebase-your-apps.html

This is an example of the configuration file generated by the Oracle Backend for Firebase Console. It contains essential details for initializing the SDK, such as schema, app ID, and ORDS host.

```json
{
    "schema": "your-schema",
    "app_name": "your-app-name",
    "app_type": "ANDROID",
    "app_id": "your-app-id",
    "objs_type": "dbfs",
    "project_id": "your-proj-id",
    "storage_bucket": "your-storage-bucket",
    "auth_type": "base",
    "auth_id": "your-auth-di",
    "ords_host": "https://your-ords.example.com/ords/"
}
```

--------------------------------

### String Split Function Example

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/security-rules-database.html

Shows the `split()` string function, which divides a string into a list of substrings based on a delimiter. This example splits a comma-separated string.

```cel
'A,B,C'.split(',') == ['A','B','C']
```

--------------------------------

### Get a Document using CLI

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/advanced-features.html

Use this command to retrieve a specific document from the database by providing its path.

```bash
fusabase database get <document path>
```

--------------------------------

### Install Oracle Backend for Firebase CLI

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/installing-and-configuring.html

Install the Oracle Backend for Firebase Command Line Interface (CLI) globally using npm. Ensure Node.js and npm are available on your system.

```shell
npm i -g fusabase-cli
```

--------------------------------

### List Size Function Example

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/security-rules-database.html

Shows the `size()` list function, which returns the number of elements in a list. This example checks if the list ['A','B'] has a size of 2.

```cel
['A','B'].size() == 2
```

--------------------------------

### Swift Package Manager Dependencies

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/adding-oracle-backend-firebase-your-apps.html

Example of how to add the Oracle Backend for Firebase iOS SDK dependencies in your `Package.swift` file.

```swift
dependencies: [
    .package(url: "https://github.com/oracle/fusabase-ios-sdk", from: "26.1.1")
]
.target(
    name: "YourTarget",
    dependencies: [
        "FusabaseAuth",
        "FusabaseCore",
        "FusabaseOracledb",
        "FusabaseStorage"
    ]
)
```

--------------------------------

### Get Provider Details

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/setting-authentication.html

Retrieves the details for a specified authentication provider.

```bash
fusabase auth get <provider>
```

--------------------------------

### Logical AND Operator Example

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/operators-and-functions.html

Ensures the user is authenticated and their UID matches the resource's owner UID. Use for strict access control.

```plaintext
request.auth != null && resource.data.uuid == request.auth.uid
```

--------------------------------

### Initialize Auth Instance (Java Android)

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/getting-started-authentication-sdk.html

Get the singleton instance of FusabaseAuth for Android applications using Java.

```java
import com.oracle.database.fusabase.auth.FusabaseAuth;

final FusabaseAuth mAuth = FusabaseAuth.getInstance();
```

--------------------------------

### Setup Storage Service using CLI

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/storage-configuration.html

Use this command to set up the object storage service for your current project. An optional path to a configuration file can be provided.

```bash
fusabase set-objs
```

```bash
fusabase set-objs --path=<path-to-objsConfig.json>
```

--------------------------------

### Get Download URL and Write to File in Flutter

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/using-storage-sdk.html

Provides examples of getting a download URL and writing a file to local storage using the Flutter SDK. Use getDownloadURL for public access and writeToFile for saving files to the device.

```flutter
final ref = FusabaseStorage.instance.ref('recipes/pasta.pdf');
final url = await ref.getDownloadURL();

print(url);

final ref_p = FusabaseStorage.instance.ref('recipes/pasta.pdf');
final file = File('${Directory.systemTemp.path}/pasta.pdf');

await ref_p.writeToFile(file);
```

--------------------------------

### Get Rule with Document Data Check

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/security-rules-database.html

Allows a get operation only if a specific project document exists and its 'status' field is 'active'. This demonstrates using the `get()` macro to retrieve and inspect document data.

```plaintext
allow get: if get(/projects/$(projectId)).data.status == "active";
```

--------------------------------

### Initialize Auth Instance (Swift iOS)

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/getting-started-authentication-sdk.html

Configure and obtain the Auth instance for iOS applications using Swift.

```swift
import FusabaseCore
import FusabaseAuth

FusabaseApp.configure()
let auth = FusabaseAuth.auth()
```

--------------------------------

### Simulate Folders Using Path Prefixes

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/object-storage-console-tasks.html

Organize files into logical folders by using '/' in file paths. The Console UI interprets these prefixes as folders.

```text
photos/2025/image1.jpg
photos/2025/image2.jpg
```

--------------------------------

### List Concat Function Example

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/security-rules-database.html

Illustrates the `concat()` list function, which merges two lists into a single list. This example concatenates ['A'] and ['B'].

```cel
['A'].concat(['B']) == ['A','B']
```

--------------------------------

### Initialize JS SDK (Modular)

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/getting-started-quick-start.html

Initialize the JavaScript SDK using the modular approach with provided configuration.

```javascript
import { initializeApp } from "fusabase/app";
import { getOracledb } from "fusabase/oracledb";

const app = initializeApp(config);
const db = getOracledb(app);

```

--------------------------------

### Configure Authentication

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/setting-authentication.html

Use this command to set up authentication for your current project by providing a path to your authentication configuration JSON file.

```bash
fusabase set-auth --path=<path-to-authConfig.json>
```

--------------------------------

### String Replace Function Example

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/security-rules-database.html

Demonstrates the `replace()` string function to substitute occurrences of a substring with another. This example replaces 'Chip' with 'Coco'.

```cel
'ChocolateChip'.replace("Chip","Coco") == 'ChocolateCoco'
```

--------------------------------

### Add a Document using CLI

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/advanced-features.html

Use this command to add a new document to the database by providing a configuration path.

```bash
fusabase database add --path=<config>
```

--------------------------------

### Math Power Function Example

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/security-rules-database.html

Demonstrates the `pow()` math function, which calculates the power of a number. This example calculates 2 raised to the power of 3.

```cel
pow(2,3) == 8
```

--------------------------------

### Manual Sign-In with Credentials (JS Modular)

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/getting-started-authentication-sdk.html

Demonstrates how to manually sign in a user using credentials obtained from various identity providers. This includes creating credential objects for Google, Facebook, GitHub, OIDC, and SAML, and handling the sign-in promise.

```javascript
import { OAuthProvider, GoogleAuthProvider, FacebookAuthProvider, GithubAuthProvider, SAMLAuthProvider, signInWithCredential } from "fusabase/auth";

// Get the id token or access token from the provider
// How you get the token, it can be using Native SDKs for the Auth Providers
// like Google, Facebook web SDKs

// Create a credential object 
// using Google ID token
const authCredential = GoogleAuthProvider.credential(idToken, null);

// using Facebook Access token
const authCredential = FacebookAuthProvider.credential(null, accessToken);

// using Github tokens
const authCredential = GithubAuthProvider.credential(null, accessToken);

// using OIDC Token
const authCredential = OAuthProvider.credential(idToken, null);

// using SAML Token
const authCredential = SAMLAuthProvider.credential(idToken);

signInWithCredential(auth, authCredential)
  .then((result) => {
    var credential = result.credential;

    // OAuth access and id tokens can also be retrieved:
    var accessToken = credential.accessToken;
    var idToken = credential.idToken;
  })
  .catch((error) => {
    // Handle error.
  });

```

--------------------------------

### String Trim Function Example

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/security-rules-database.html

Demonstrates the `trim()` string function, which removes leading and trailing whitespace from a string. This example trims spaces from ' A B '.

```cel
' A B '.trim() == 'AB'
```

--------------------------------

### Initialize Auth Instance (JavaScript Namespace)

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/getting-started-authentication-sdk.html

Initialize the Auth instance using the namespace-style JavaScript SDK. Ensure the app instance is correctly obtained.

```javascript
import fusabase from 'fusabase-ns';

const app = fusabase.app(); // Or use the instance returned from initializeApp.
const auth = fusabase.auth(app);
```

--------------------------------

### String Size Function Example

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/security-rules-database.html

Illustrates the `size()` string function, which returns the length of a string. This example checks if the string 'ChocolateChip' has a length of 13.

```cel
'ChocolateChip'.size() == 13
```

--------------------------------

### Initialize and Configure Auth UI (JS Modular)

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/getting-started-authentication-sdk.html

This snippet shows how to import necessary modules, create an AuthUI instance, and configure sign-in options and callbacks for the JS modular API.

```javascript
import { authUI } from 'fusabase/ui';
import {
  EmailAuthProvider,
  FacebookAuthProvider,
  GithubAuthProvider,
  GoogleAuthProvider,
} from 'fusabase/auth';

const ui = new authUI.AuthUI(auth);

// Mount into a container (selector or HTMLElement)
ui.start('#auth-container', {
  signInOptions: [
    GoogleAuthProvider.PROVIDER_ID, // 'google'
    FacebookAuthProvider.PROVIDER_ID, // 'facebook'
    GithubAuthProvider.PROVIDER_ID, // 'github'
    EmailAuthProvider.PROVIDER_ID, // 'password' (shows email/password login/register)
  ],
  callbacks: {
    // Return true to allow redirect; false to prevent it
    signInSuccessWithAuthResult: (authResult, redirectUrl) => {
      console.log(
        'Signed in:',
        authResult.user.uid,
        'redirect to:',
        redirectUrl
      );
      return true;
    },
  },
  // If provided and callback returns true, UI will navigate to this URL
  signInSuccessUrl: '/home',
});

```

--------------------------------

### Initialize and Configure Auth UI (JS Namespace)

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/getting-started-authentication-sdk.html

This snippet demonstrates initializing the AuthUI instance and setting up sign-in options using the JS namespace import style.

```javascript
import { authUI } from 'fusabase-ns/ui';
import { auth } from 'fusabase-ns/auth';

const ui = new authUI.AuthUI(auth);

// Mount into a container (selector or HTMLElement)
ui.start('#auth-container', {
  signInOptions: [
    auth.EmailAuthProvider.PROVIDER_ID,
    auth.GoogleAuthProvider.PROVIDER_ID,
    auth.FacebookAuthProvider.PROVIDER_ID,
    auth.GithubAuthProvider.PROVIDER_ID,
  ],
  signInSuccessUrl: '/home',
  callbacks: {
    // Return false to prevent automatic redirect
    signInSuccessWithAuthResult: (result, redirectUrl) => true,
  },
});

```

--------------------------------

### Timestamp Seconds Function Example

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/security-rules-database.html

Illustrates the `seconds()` timestamp function, which extracts the second from a timestamp. This example checks if the request time's second is 15.

```cel
request.time.seconds() == 15
```

--------------------------------

### Timestamp Minutes Function Example

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/security-rules-database.html

Demonstrates the `minutes()` timestamp function, which extracts the minute from a timestamp. This example checks if the request time's minute is 30.

```cel
request.time.minutes() == 30
```

--------------------------------

### Initialize JS SDK (Namespace)

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/getting-started-quick-start.html

Initialize the JavaScript SDK using the namespace approach with provided configuration.

```javascript
const app = fusabase.initializeApp(config);
const db = fusabase.oracledb(app);

```

--------------------------------

### Timestamp Hours Function Example

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/security-rules-database.html

Shows the `hours()` timestamp function, which extracts the hour from a timestamp. This example checks if the request time's hour is 14.

```cel
request.time.hours() == 14
```

--------------------------------

### Timestamp Month Function Example

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/security-rules-database.html

Illustrates the `month()` timestamp function, which extracts the month from a timestamp. This example checks if the request time's month is 11.

```cel
request.time.month() == 11
```

--------------------------------

### Initialize iOS SDK with Default Configuration

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/adding-oracle-backend-firebase-your-apps.html

Initialize the Oracle Backend for Firebase SDK using the default configuration loaded from `fusabase-config.json`. This example shows how to access core services like database, authentication, and storage.

```swift
import FusabaseCore
import FusabaseOracledb
import FusabaseAuth
import FusabaseStorage

FusabaseApp.configure()
let db = FusabaseOracledb.oracledb()
let auth = FusabaseAuth.auth()
let storage = Storage.storage()
```

--------------------------------

### Math Square Root Function Example

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/security-rules-database.html

Shows the `sqrt()` math function, which calculates the square root of a number. This example calculates the square root of 9.

```cel
sqrt(9) == 3
```

--------------------------------

### Sign In to the CLI

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/installing-and-configuring.html

Initialize the CLI by signing in with your ORDS OAuth Client ID and Client Secret. This step verifies credentials and establishes a connection.

```bash
fusabase init
```

--------------------------------

### List All Projects using CLI

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/managing-projects.html

Use this command to list all projects owned or managed by the current schema via the CLI.

```bash
fusabase list-projects
```

--------------------------------

### Math Round Function Example

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/security-rules-database.html

Illustrates the `round()` math function, which rounds a number to the nearest integer. This example shows `round(4.6)` equals 5.

```cel
round(4.6) == 5
```

--------------------------------

### Manage Sign-in Methods (Provider Config)

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/setting-authentication.html

Manages sign-in methods for a provider using a configuration file.

```bash
fusabase auth sign-in-method <provider> --path=<config>
```

--------------------------------

### Create CLI Configuration File

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/installing-and-configuring.html

Create a fusabase.config.js file to specify the ORDS host, port, and schema path. Ensure the URL includes a trailing slash.

```javascript
module.exports = {
  host: 'http://your-ords-host:port/ords/your-schema/'
}
```

--------------------------------

### Configure TDE and Manage Keystore

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/installing-and-configuring.html

Enable TDE configuration, create a keystore with a strong password, open it, and set the master encryption key. This is crucial for encrypting sensitive data.

```sql
ALTER SYSTEM SET tde_configuration='KEYSTORE_CONFIGURATION=FILE' SCOPE=BOTH;
ADMINISTER KEY MANAGEMENT CREATE KEYSTORE IDENTIFIED BY "<strong_keystore_password>";
ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY "<strong_keystore_password>" CONTAINER=ALL;
ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY "<strong_keystore_password>" WITH BACKUP CONTAINER=ALL;
SELECT WRL_TYPE, WRL_PARAMETER, STATUS FROM V$ENCRYPTION_WALLET;
```

--------------------------------

### Timestamp Nanos Function Example

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/security-rules-database.html

Shows the `nanos()` timestamp function, which extracts the nanosecond part from a timestamp. This example checks if the request time's nanoseconds are 0.

```cel
request.time.nanos() == 0
```

--------------------------------

### Timestamp Day Function Example

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/security-rules-database.html

Shows the `day()` timestamp function, which extracts the day of the month from a timestamp. This example checks if the request time's day is 8.

```cel
request.time.day() == 8
```

--------------------------------

### Initialize Swift iOS SDK

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/getting-started-quick-start.html

Initialize the Swift SDK for iOS applications.

```swift
import FusabaseCore
import FusabaseOracledb

_ = FusabaseApp.configure()
let db = FusabaseOracledb.oracledb()

```

--------------------------------

### Manual Sign-In with Credentials (JS Namespace)

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/getting-started-authentication-sdk.html

Shows how to sign in a user manually using credentials within the JS namespace. This example covers creating credential objects for different providers and handling the sign-in process with error management.

```javascript
// Get the id token or access token from the provider
// How you get the token, it can be using Native SDKs for the Auth Providers
// like Google, Facebook web SDKs

// Create a credential object 
// using Google ID token
const authCredential = auth.GoogleAuthProvider.credential(idToken, null);

// using Facebook Access token
const authCredential = auth.FacebookAuthProvider.credential(null, accessToken);

// using Github tokens
const authCredential = auth.GithubAuthProvider.credential(null, accessToken);

// using OIDC Token
const authCredential = auth.OAuthProvider.credential(idToken, null);

// using SAML Token
const authCredential = auth.SAMLAuthProvider.credential(idToken);
 

auth.signInWithCredential(authCredential)
  .then((result) => {
    var credential = result.credential;

    // OAuth access and id tokens can also be retrieved:
    var accessToken = credential.accessToken;
    var idToken = credential.idToken;
  })
  .catch((error) => {
    // Handle error.
  });

```

--------------------------------

### Math Absolute Value Function Example

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/security-rules-database.html

Demonstrates the `abs()` math function, which returns the absolute value of a number. This example shows `abs(-5)` equals 5.

```cel
abs(-5) == 5
```

--------------------------------

### Check CLI Configuration for Token Fetching

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/installing-and-configuring.html

Verify the 'host' value in 'fusabase.config.js', ensure the URL ends with '/', confirm ORDS reachability, and check OAuth credentials if 'fusabase init' fails to fetch a token.

```javascript
fusabase.config.js
```

--------------------------------

### List HasAll Function Example

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/security-rules-database.html

Shows the `hasAll()` list function, which checks if a list contains all elements from another specified list. This example checks if ['A','B'] contains ['A'].

```cel
['A','B'].hasAll(['A']) == true
```

--------------------------------

### Create TDE Wallet Directory and Set Permissions

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/installing-and-configuring.html

Use these commands to create the directory for the TDE wallet and set the appropriate ownership and permissions. This ensures the wallet is stored securely.

```bash
mkdir -p /opt/oracle/oradata/FREE/tde
chown -R oracle:oinstall /opt/oracle/oradata/FREE
chmod 700 /opt/oracle/oradata/FREE/tde
```

--------------------------------

### Math Floor Function Example

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/security-rules-database.html

Shows the `floor()` math function, which returns the largest integer less than or equal to a number. This example shows `floor(4.8)` equals 4.

```cel
floor(4.8) == 4
```

--------------------------------

### Math Ceiling Function Example

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/security-rules-database.html

Illustrates the `ceil()` math function, which returns the smallest integer greater than or equal to a number. This example shows `ceil(4.2)` equals 5.

```cel
ceil(4.2) == 5
```

--------------------------------

### Add a User

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/setting-authentication.html

Adds a new user to the authentication system using a configuration file.

```bash
fusabase auth add --path=<config>
```

--------------------------------

### SwiftUI App Initialization

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/adding-oracle-backend-firebase-your-apps.html

Example of initializing the Oracle Backend for Firebase SDK within the `init` method of a SwiftUI `App` struct. This ensures the SDK is configured early in the application lifecycle.

```swift
import SwiftUI
import FusabaseCore
import FusabaseAuth
import FusabaseOracledb
import FusabaseStorage

@main
struct ExampleApp: App {
    init() {
        FusabaseApp.configure()
    }

    var body: some Scene {
        WindowGroup {
            ContentView()
        }
    }
}
```

--------------------------------

### Create DBFS Filesystem SQL Script

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/storage-configuration.html

Use this SQL script to initialize the DBFS schema and prepare the database for storing binary files. Ensure the tablespace exists with sufficient space and the running user has the necessary privileges.

```sql
@?/rdbms/admin/dbfs_create_filesystem.sql tbs_3 fs12122
```

--------------------------------

### Install Oracle Backend for Firebase using ORDS CLI

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/installing-and-configuring.html

Run the ORDS command-line interface to install the Oracle Backend for Firebase feature. This command points to your ORDS configuration directory.

```bash
ords --config /opt/ords-config fusabase install
```

--------------------------------

### Auth Token Example

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/application-users.html

This JSON object represents an example of an Oracle Backend for Firebase Auth token. It includes user details, verification status, creation time, and token-specific claims.

```json
{
  "user_displayname": "Scott Scott",
  "user_id": "68AB1C234D9FA873E083F283695E41B0",
  "email_verified": "true",
  "creation_time": "2024-07-20T10:25:36.789123Z",
  "claim": null,
  "idp_type": "BASE",
  "sub": "scott@example.com",
  "iss": "baas_onprem#68AB1C2DE7C3D871E083F283695E54A2",
  "iat": 1721462736,
  "exp": 1721466337,
  "idp_name": "UserNamePassword",
  "scope": "database auth storage",
  "aud": "68AB1C2A90EF1872E083F283695E51D3",
  "uid": "68AB1C234D9FA873E083F283695E41B0",
  "token": {
    "email": "scott@example.com",
    "email_verified": "true",
    "sub": "scott@example.com",
    "name": "Scott Scott"
  }
}
```

--------------------------------

### Sign In User with Email and Password (JS Modular)

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/getting-started-authentication-sdk.html

Use this snippet to sign in an existing user with their email and password using the JS modular SDK. Ensure the 'auth' instance is properly initialized.

```javascript
import { signInWithEmailAndPassword } from 'fusabase/auth';

// Sign in user
signInWithEmailAndPassword(auth, email, password)
  .then((userCredential) => {
    console.log('User signed in:', userCredential.user.email);
  })
  .catch((error) => {
    console.error('Error:', error.message);
  });


```

--------------------------------

### Start ORDS Service

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/installing-and-configuring.html

Start the Oracle REST Data Services (ORDS) service using the specified configuration directory. Access the Oracle Backend for Firebase console via the provided URL.

```shell
ords --config /opt/ords-config serve
```

--------------------------------

### Object Field Access Operator Example

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/operators-and-functions.html

Accesses nested fields within objects. The first example checks the user's email in the token, and the second accesses a nested field in the resource data.

```plaintext
request.auth.token.email == "scott@example.com"
resource.data.content.step2 == "Add extra chocolate chips"
```

--------------------------------

### Initialize Flutter SDK

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/getting-started-quick-start.html

Initialize the Flutter SDK with provided options.

```dart
import 'package:fusabase/core.dart';
import 'package:fusabase/oracledb.dart';

final app = Fusabase.initializeApp(options: FusabaseOptions({
  // ords_host, project_id, app_id, schema, auth_type, storage_bucket, etc.
}));
final db = FusabaseOracledb.instance;

```

--------------------------------

### Get Download URL and Blob in JavaScript

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/using-storage-sdk.html

Demonstrates how to get a public download URL for a file and retrieve its content as a Blob in JavaScript. Use getDownloadURL for public access and getBlob for retrieving file content directly.

```javascript
const storage = getStorage();
const recipeRef = ref(storage, "recipes/pasta.pdf");

getDownloadURL(recipeRef)
  .then((url) => {
    // Open or download the recipe
    window.open(url);
  })
  .catch(console.error);

const recipeRef_b = ref(getStorage(), "recipes/pasta.pdf");

const blob = await getBlob(recipeRef_b);
console.log("Recipe blob:", blob);
```

--------------------------------

### Initiate Web Sign-In with Redirect (JS Modular)

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/getting-started-authentication-sdk.html

Initiate the sign-in flow using the redirect method with the JS Modular SDK. Retrieves sign-in results and handles potential errors.

```javascript
import { signInWithRedirect, getRedirectResult } from "fusabase/auth";

// Start sign in with redirect flow
signInWithRedirect(auth, provider);

// After the user completes sign-in and returns to the app, obtain sign-in result by calling getRedirectResult()
getRedirectResult(auth)
  .then((result) => {
    var credential = result.credential;

    // OAuth access and id tokens can also be retrieved:
    var accessToken = credential.accessToken;
    var idToken = credential.idToken;
  })
  .catch((error) => {
    // Handle error.
  });

```

--------------------------------

### List HasAny Function Example

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/security-rules-database.html

Demonstrates the `hasAny()` list function, which checks if a list contains at least one element from another specified list. This example checks if ['A','B'] contains any element from ['C','B'].

```cel
['A','B'].hasAny(['C','B']) == true
```

--------------------------------

### Initialize Facebook Login Button and Callback

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/getting-started-authentication-sdk.html

Integrate Facebook Login by initializing a `LoginButton` and registering a callback. Ensure you request `public_profile` and `email` permissions.

```java
// Initialize Facebook Login button
mCallbackManager = CallbackManager.Factory.create();
LoginButton loginButton = findViewById(R.id.button_sign_in);
loginButton.setReadPermissions("email", "public_profile");
loginButton.registerCallback(mCallbackManager, new FacebookCallback<LoginResult>() {
    @Override
    public void onSuccess(LoginResult loginResult) {

```

--------------------------------

### Join Query Result Example

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/document-operations.html

Example output of a join query, showing combined data from 'Cities' and 'Employees' collections. The 'ret' array contains objects with nested 'osons' data, including city details and employee information.

```json
{
  "ret": [
    {
      "osons": {
        "DOCUMENT": {
          "NAME": "NewYork",
          "COUNTRY": "USA",
          "POPULATION": 123455678,
          "EMPLOYEE": {
            "EmployeeID": "2",
            "FirstName": "John",
            "LastName": "Morrow",
            "Email": "Marston17@norton.net"
          }
        },
        "CREATED": "2025-01-24T08:03:27.014334",
        "LAST_MODIFIED": "2025-01-24T08:03:27.014334",
        "VERSION": 1,
        "OID": "2C6F2A7F590D231BE0631F965E6400A4"
      }
    }
  ]
}
```

--------------------------------

### List HasOnly Function Example

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/security-rules-database.html

Illustrates the `hasOnly()` list function, which checks if a list contains only elements from a specified list, ignoring duplicates or extra elements in the second list. This example checks if ['A','B'] contains only elements from ['A','B','C'].

```cel
['A','B'].hasOnly(['A','B','C']) == true
```

--------------------------------

### Create Social Sign-in Credentials

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/getting-started-authentication-sdk.html

Examples of creating credentials for social sign-in providers like Google, Facebook, and GitHub, as well as OIDC and SAML tokens.

```swift
import FusabaseAuth

// If your Auth Server is Oracle IDCS, the Social Sign-in flow is completed
// through the Oracle IDCS SSO page itself, and only IDCSAuthProvider is available.
// The Oracle IDCS SSO page allows choosing the Social Provider to login through.

// Using Google's Access Token
let googleCredential = GoogleAuthProvider.credential(withIDToken: idToken, accessToken: accessToken)
// Using Facebook Access token
let facebookCredential = FacebookAuthProvider.credential(withAccessToken: accessToken!)
// Using GitHub token
let githubCredential = GithubAuthProvider.credential(withToken: accessToken!)
// Using OIDC Token
let oidcCredential = OAuthProvider.credential(providerID: "oidc_example", idToken: idToken!)
// Using SAML Token
let samlCredential = SAMLAuthProvider.credential(providerID: "saml_example", idToken: idToken!)
```

--------------------------------

### Start Sign-In Flow with Provider

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/getting-started-authentication-sdk.html

Initiate the sign-in process using the selected authentication provider. This action will open a Custom Chrome Tab to complete the authentication.

```java
import com.oracle.mobile.fusabase.auth.FusabaseAuth;
import com.oracle.mobile.fusabase.auth.AuthResult;
import com.oracle.mobile.fusabase.auth.AuthProvider;
import com.oracle.mobile.fusabase.auth.GoogleAuthProvider;
import android.util.Log;
import androidx.annotation.NonNull;
import com.oracle.mobile.fusabase.task.OnSuccessListener;
import com.oracle.mobile.fusabase.task.OnFailureListener;

FusabaseAuth mAuth = FusabaseAuth.getInstance();

mAuth.startActivityForSignInWithProvider(/* activity= */ this, provider)
        .addOnSuccessListener(
                new OnSuccessListener<AuthResult>() {
                    @Override
                    public void onSuccess(AuthResult authResult) {
                        // User is signed in.
                    }
                })
        .addOnFailureListener(
                new OnFailureListener() {
                    @Override
                    public void onFailure(@NonNull Exception e) {
                        // Handle failure.
                    }
                });


```

--------------------------------

### Get Public Download URL (JS Modular)

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/using-storage-sdk.html

Use this snippet to get a time-stable, publicly accessible HTTPS URL for a Storage object. The URL is validated during generation and remains valid until the REST endpoint is removed from the schema. This method does not download the file; you must handle the download separately.

```javascript
import { ref } from "fusabase/storage";

const recipeRef = ref(getStorage(), "recipes/pasta.pdf");

const url = await getDownloadURL(recipeRef);
window.open(url);
```

--------------------------------

### Sign in with Popup (JS Namespace)

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/getting-started-authentication-sdk.html

Initiates sign-in via a popup window using the JS namespace. This example demonstrates handling the promise returned by the signInWithPopup function and extracting user credentials.

```javascript
auth.signInWithPopup(provider)
  .then((result) => {
    var credential = result.credential;

    // OAuth access and id tokens can also be retrieved:
    var accessToken = credential.accessToken;
    var idToken = credential.idToken;
  })
  .catch((error) => {
    // Handle error.
  });

```

--------------------------------

### Get Auth Instance (Flutter)

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/getting-started-authentication-sdk.html

Access the singleton instance of FusabaseAuth in a Flutter application.

```dart
final auth = FusabaseAuth.instance;
```

--------------------------------

### Read Document (Flutter)

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/getting-started-quick-start.html

Retrieve a document using `get()` in Dart for Flutter and print its data.

```dart
final snap = await docRef.get();
print(snap.data());

```

--------------------------------

### Manual Sign-In with Credentials (Flutter)

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/getting-started-authentication-sdk.html

Provides a Dart example for manual sign-in using credentials. It shows how to create an AuthCredential object from ID and access tokens and then use it to sign in the user.

```dart
// Get the id token or access token from the provider
AuthCredential credential = provider.credential({
    idToken: idToken,
	accessToken: accessToken
});

// use the AuthCredential to create the UserCredential
UserCredential credential = await auth.signInWithCredential(credential);

```

--------------------------------

### Register User with Email and Password (JS Namespace)

Source: https://docs.oracle.com/en/database/oracle/backend-for-firebase/26.1/fusab/getting-started-authentication-sdk.html

This snippet demonstrates user registration using the JS namespace-based SDK. It initializes the 'auth' instance and calls the createUserWithEmailAndPassword method.

```javascript
import fusabase from 'fusabase-ns';

// Register user
const auth = fusabase.auth();

auth
  .createUserWithEmailAndPassword(email, password)
  .then((userCredential) => {
    console.log('User registered:', userCredential.user.email);
  })
  .catch((error) => {
    console.error('Error:', error.message);
  });


```
Tokens:
Raw