DbSchema for CSV Files Database
DbSchema is a powerful database management and design tool for CSV Files. It offers features such as
visual schema design, team collaboration with GIT, schema deployment and HTML schema documentation.
How to Connect to CSV Files Database
- Access the Connection Dialog
Choose "Connect to the database" or "New Model Connected to the Database" will let you select your database
and open the Connection Dialog.
DbSchema automatically downloads the
JDBC driver to connect to your database.
- Configure the Connection
In the Connection Dialog window, select the JDBC URL you want to connect with. If your database is running in the cloud,
choose Edit Manually and insert the JDBC URL from the cloud console.
Enter the host name, the authentication details, select your database as described in the Connection Dialog page.
- Troubleshoot Firewall Issues
If you encounter connection issues, it may be due to firewall settings. Read how to enable Firewall Connections.
Firewalls & anti-viruses may block database connections.
CSV Formats
| DEFAULT | Standard Comma Separated Value format, similar to RFC4180 but allows empty lines. |
| EXCEL | The Microsoft Excel CSV format. |
| INFORMIX_UNLOAD | Informix UNLOAD format used by the UNLOAD TO file_name operation. |
| INFORMIX_UNLOAD_CSV | Informix CSV UNLOAD format used by the UNLOAD TO file_name operation (escaping is disabled). |
| MONGO_CSV | MongoDB CSV format used by the mongoexport operation. |
| MONGO_TSV | MongoDB TSV format used by the mongoexport operation. |
| MYSQL | The MySQL CSV format. |
| ORACLE | Default Oracle format used by the SQL*Loader utility. |
| POSTGRESQL_CSV | Default PostgreSQL CSV format used by the COPY operation. |
| POSTGRESQL_TEXT | Default PostgreSQL text format used by the COPY operation. |
| RFC4180 | The RFC-4180 format defined by RFC-4180. |
| TDF | A tab-delimited format. |
Here with a more detailed description
| Format Name | Delimiter | Ignore Empty Lines | Quote Character | Comment Marker | Record Separator |
| DEFAULT | , | No | " | # | \r\n |
| EXCEL | , | No | " | None | \r\n |
| INFORMIX_UNLOAD | ` | ` | No | None | None |
| INFORMIX_UNLOAD_CSV | , | No | " | None | \n |
| MONGO_CSV | , | No | " | None | \r\n |
| MONGO_TSV | \t | No | " | None | \r\n |
| MYSQL | \t | No | " | None | \n |
| ORACLE | , | No | " | None | \n |
| POSTGRESQL_CSV | , | No | " | None | \n |
| POSTGRESQL_TEXT | \t | No | None | None | \n |
| RFC4180 | , | No | " | None | \r\n |
| TDF | \t | No | " | None | \n |
Save the Database Back to CSV
After connecting, DbSchema will load the data into a H2 local database.
You can edit the data, add new records, etc.
To save back the data to CSV file use the command:
save csv to 'path'
where the path is the folder where to save the data.
DbSchema Features for CSV Files
DbSchema is loading the CSV files to a temporary H2 database.
DbSchema will auto-detect the mandatory fields, primary keys and foreign keys.
Available are all DbSchema features, including the SQL Editor, Relational Data Explorer, Query Builder, etc.