Appendix

FAQ & Tips & Tricks

Frequently Asked Questions

Q: rsql fails to connect to my database. What should I check?

  • Ensure your connection string (URL) is correct and credentials are valid.
  • Check that the database server is running and accessible from your machine.
  • Verify that the required driver is installed and supported (see drivers).
  • For cloud databases, ensure your IP is whitelisted and network/firewall rules allow access.

Q: How do I change the output format (CSV, JSON, etc.)?

  • Use the .format command or set the format option in your rsql.toml (see configuration).

Q: How do I set or change my locale?

  • Use the .locale command (see locale command) or set the locale option in your rsql.toml.

Q: Where is the configuration file stored?

  • On Unix-like systems: $HOME/.rsql/rsql.toml
  • On Windows: %APPDATA%\rsql\rsql.toml

Q: How do I contribute a new translation or improve an existing one?

Tips & Tricks

  • Use command history and smart completions to speed up repetitive tasks.
  • Use the .read command to execute SQL from a file.
  • Use the .output command to redirect results to a file.
  • For large result sets, use the limit option or .limit command to avoid overwhelming your terminal.
  • Use the .help command to see available commands and their usage.

For more troubleshooting and advanced usage, see the Configuration File and Commands sections.