You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Is your feature request related to a problem? Please describe.
Currently, importing a database as an SQL script is possible, but it is not possible as a CSV or text file. An SQL script is not very lightweight and large scripts may cause the program go unresponsive. Importing CSV or TXT via LOAD DATA LOCAL INLINE is very inconvenient, in case a table has lots of columns.
Describe the solution you'd like
An import feature that allows to -
Select a plain text file from storage.
Select a table in which it is desired to be imported.
Select the desired delimiter/allows to enter one.
Select whether the CSV has a header.
Automatically create the columns, or allow to optionally drop ones which are already present and re-create.
Describe alternatives you've considered
I really loved the simplicity of Antares, but for importing CSV, I am currently using DBeaver or Dbgate. They have direct import options for plaintext.
Additional context
I know this may need really a lot of work, but it would be a good to have feature.
The text was updated successfully, but these errors were encountered:
Is your feature request related to a problem? Please describe.
Currently, importing a database as an SQL script is possible, but it is not possible as a CSV or text file. An SQL script is not very lightweight and large scripts may cause the program go unresponsive. Importing CSV or TXT via LOAD DATA LOCAL INLINE is very inconvenient, in case a table has lots of columns.
Describe the solution you'd like
An import feature that allows to -
Describe alternatives you've considered
I really loved the simplicity of Antares, but for importing CSV, I am currently using DBeaver or Dbgate. They have direct import options for plaintext.
Additional context
I know this may need really a lot of work, but it would be a good to have feature.
The text was updated successfully, but these errors were encountered: