Question 1

How do I configure gorqlite to skip TLS certificate verification?

Accepted Answer

Pass a custom HTTP client with TLS configuration to OpenWithClient(), such as setting InsecureSkipVerify: true in the TLS config. This allows full control over HTTP settings, useful for testing or internal deployments with self-signed certs.

Question 2

What's the difference between gorqlite and the standard Go database/sql package?

Accepted Answer

gorqlite is specialized for rqlite, offering cluster awareness and rqlite features like queued writes, while database/sql is generic. However, gorqlite's driver has key limitations like no rollback, so it's best for rqlite-specific use cases rather than drop-in replacement.

Question 3

How can I handle large result sets with gorqlite without running out of memory?

Accepted Answer

Currently, gorqlite cannot fetch results iteratively due to rqlite's API. To manage large datasets, paginate queries or add filters to reduce result size, as all data is loaded into memory at once, which is a known constraint.

Question 4

Is gorqlite safe to use in concurrent Go applications?

Accepted Answer

The main gorqlite API connections are not thread-safe, so you need to manage synchronization with mutexes or similar. However, the database/sql driver via the stdlib package is thread-safe, but it comes with reduced functionality like no transaction support.

Question 5

How do I disable cluster discovery in gorqlite?

Accepted Answer

Add disableClusterDiscovery=true as a query parameter in the connection string, e.g., http://localhost:4001?disableClusterDiscovery=true. This is helpful when using external load balancers like Kubernetes to manage node communication instead.

Question 6

Can I use prepared statements with gorqlite?

Accepted Answer

No, gorqlite does not support prepared statements due to rqlite's API limitations. Use parameterized statements with WriteParameterized() or QueryParameterized() for safe SQL execution with placeholders, which is the recommended alternative.

go-rqlite

What is go-rqlite?

Overview

Use Cases

Best For

Related Projects

Found a gem we're missing?

Not Ideal For

Pros & Cons

Pros

Cons

Frequently Asked Questions