Examples

Practical examples are available in the official examples repository:

https://github.com/netlifeguru/examples/db

The repository contains standalone examples covering connection setup, connection configuration, connection pools, typed queries, pointer-based lookups, maps, scalar values, inserts, updates, deletes, dialect SQL, low-level operations, transactions, SQL files, Scylla batches, and lightweight transactions.

MySQL Examples

MySQL examples are available at:

https://github.com/netlifeguru/examples/db/mysql

These examples demonstrate the shared DB API with the MySQL driver, including ? placeholders, LastInsertId, dialect SQL, SQL transactions, connection pools, and multi-driver SQL files.

Getting Started and Connections

• Getting started
• Connection
• Connection config
• Connection pools

Select Helpers

• Select list
• Select get
• Select get pointer
• Select value
• Select map

Query Object Helpers

• Query list
• Query get
• Query get pointer
• Query value
• Query map

Dialect SQL Helpers

• Dialect list
• Dialect get
• Dialect get pointer
• Dialect map
• Dialect value

Mutations

• Insert result
• Insert
• Update
• Delete
• Insert dialect
• Update dialect
• Delete dialect

Low-Level Mutations

• Insert low-level
• Insert result low-level
• Update low-level
• Delete low-level

Transactions and SQL Files

• Transactions
• Low-level transactions
• SQL files
• Multi-driver SQL files

PostgreSQL Examples

PostgreSQL examples are available at:

https://github.com/netlifeguru/examples/db/postgresql

These examples demonstrate the shared DB API with the PostgreSQL driver, including numbered placeholders, INSERT ... RETURNING, dialect SQL, connection pools, SQL transactions, and multi-driver SQL files.

Getting Started and Connections

• Getting started
• Connection
• Connection config
• Connection pools

Select Helpers

• Select list
• Select get
• Select get pointer
• Select value
• Select map

Query Object Helpers

• Query list
• Query get
• Query get pointer
• Query value
• Query map

Dialect SQL Helpers

• Dialect list
• Dialect get
• Dialect get pointer
• Dialect value
• Dialect map

Mutations

• Insert
• Update
• Delete
• Insert returning dialect
• Update dialect
• Delete dialect

Low-Level Mutations

• Insert low-level
• Insert returning low-level
• Update low-level
• Delete low-level

Transactions and SQL Files

• Transactions
• Low-level transactions
• SQL files
• Multi-driver SQL files

Scylla Examples

Scylla examples are available at:

https://github.com/netlifeguru/examples/db/scylla

These examples demonstrate the shared DB API with the Scylla driver, including CQL placeholders, connection pools, query-driven tables, generated IDs, batches, lightweight transactions, and CQL model files.

Getting Started and Connections

• Getting started
• Connection
• Connection config
• Connection pools

Select Helpers

• Select list
• Select get
• Select get pointer
• Select value
• Select map

Query Object Helpers

• Query list
• Query get
• Query get pointer
• Query value
• Query map

Dialect SQL Helpers

• Dialect list
• Dialect get
• Dialect get pointer
• Dialect value
• Dialect map

Mutations

• Insert
• Update
• Delete
• Insert dialect
• Update dialect
• Delete dialect

Low-Level Mutations

• Insert low-level
• Update low-level
• Delete low-level

Batches

• Batch
• Low-level batch

Lightweight Transactions

• Lightweight transaction
• Lightweight transaction map
• Lightweight transaction low-level

SQL Files

• SQL files

Recommended Starting Points

Start with the getting-started example for your driver:

• MySQL getting started
• PostgreSQL getting started
• Scylla getting started

Continue with connection configuration and connection pools:

• 02_connection
• 03_connection_config
• 04_connection_pools

Then explore the shared select helpers:

• 05_select_list
• 06_select_get
• 07_select_get_ptr
• 08_select_value
• 09_select_map

For prepared db.Query values, continue with:

• 10_query_list
• 11_query-get
• 12_query-get_ptr
• 13_query_value
• 14_query_map

For SQL loaded through db.DialectSQL, continue with:

• 15_dialect_list
• 16_dialect_get
• 17_dialect_get_ptr
• 18_dialect_value or 18_dialect_map, depending on the driver
• 19_dialect_map or 19_dialect_value, depending on the driver

For mutation helpers, see the insert, update, delete, and dialect mutation examples for the selected driver.

For lower-level control, continue with the low-level mutation and transaction examples.