Can you open a local SQLite file as well as a server database?

Yes. For local SQLite, select the full path to a disposable file with made-up records and use read-only file protection where available. For a server, check the test host and database name and use a restricted reader login. Stay on paper if either destination is uncertain.

Table browsing and editing can be available in the same app. The server login must have only the permissions you intend to use.

How do you know whether the CSV contains just your results?

Choose the rows and columns for the question first. The app can export query results or a table view. A normal download can be limited to displayed results, while a full-result export can fetch more. Check your edition and open the file to confirm the row count and fields.

Keep important queries as text alongside the approved exports. Saved connections and queries can be stored locally by the app. Do not distribute a connection settings file as a report.

What does Community cover before you need a paid edition?

Community is free and includes common database connections, basic result exports and single-table export. Some database types and other features require paid editions. The pricing FAQ asks larger organizations to buy a paid license. Check the current edition for the database and operation you need.

An export is a portable file of the selected information. Keep a separate recovery plan for your database.

How would you catch a report that includes too many rows?

Draw a fictional orders table on paper. Do not open a connection or export real data.

Set the boundary
Use three pretend orders. Mark two as ready and one as cancelled.
Draw the intended file
Write the two ready order IDs and amounts as two rows. Leave out the cancelled row and contact column.
Check a failure
Draw a third exported row or an extra contact column. Either means you should recheck the selected result before sharing.