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 theformat
option in yourrsql.toml
(see configuration).
Q: How do I set or change my locale?
- Use the
.locale
command (see locale command) or set thelocale
option in yourrsql.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?
- See Supported Locales for instructions.
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.