ExampleDescription
localUses libsql with a local SQLite file. Creates database, inserts data, and queries.
remoteConnects to a remote database. Requires environment variables for URL and auth token.
syncDemonstrates synchronization between local and remote databases.
batchExecutes multiple SQL statements in a single batch operation.
transactionsShows transaction usage: starting, performing operations, and committing/rolling back.
memoryUses an in-memory SQLite database for temporary storage or fast access.
vectorWorks with vector embeddings, storing and querying for similarity search.
encryptionCreates and uses an encrypted SQLite database, demonstrating setup and data operations.