Selekta guides
Step by step guides for everyday database work on a Mac with Selekta: connecting, querying, editing, exporting and backing up.
- 23 OCTOBER 2026How to connect to PostgreSQL on a MacConnect to a local or remote PostgreSQL database on macOS, from Postgres.app or Homebrew defaults to SSL modes, with fixes for the common errors.
- 23 OCTOBER 2026Connect to PostgreSQL through OpenVPN on a MacReach a PostgreSQL database inside a private network using your .ovpn profile, without admin rights or changing your Mac's routes, and fix common VPN errors.
- 23 OCTOBER 2026Connect to Microsoft SQL Server from a MacConnect to SQL Server from macOS on port 1433 with a SQL login, pick the right encryption option, handle self-signed certificates and run GO batches.
- 23 OCTOBER 2026Connect to a database through an SSH tunnelReach a private PostgreSQL, MySQL or SQL Server database through a bastion host with an SSH key or password, verify the host key, and fix tunnel errors.
- 23 OCTOBER 2026Export a PostgreSQL or MySQL table to CSV or ExcelExport a PostgreSQL or MySQL table or query to CSV or XLSX on a Mac, with control over NULLs, dates and large tables, plus COPY and INTO OUTFILE options.
- 23 OCTOBER 2026How to open a SQLite file on a MacOpen a .db, .sqlite or .sqlite3 file on macOS, browse its tables, run SQL, open it read-only or create a new one, and export the data to CSV or Excel.
- 23 OCTOBER 2026How to run UPDATE and DELETE safely on productionA checklist for changing production data: SELECT the same WHERE first, use a transaction, limit batches per engine, and let the client confirm before it runs.