FileFlow is a simple tool that allows you to insert data from a CSV file into a table in a database. It is designed to be simple to use and to require no privilege to insert the data. Build with Rust and the Tauri framework, it is a cross-platform application that can be used on Windows, MacOS and Linux.
See in the release section for the latest version of the application.
Insert data into a new tableInsert data into an existing table
Optimise the type of the columns (VARCHAR(MAX_LENGHT))
From CSV file
Don't require ANY privilege to insert the data
Generate LOAD DATA sql query to insert faster
- Rust
- Cargo
- pnpm
To install Rust and Cargo, you can follow the instructions on the Tauri website
- Clone the repository
git clone https://github.com/Maxime-Cllt/FileFlow.git- Install the dependencies
cd FileFlowpnpm install- Build the application
pnpm tauri build- Run the application
pnpm tauri dev- Insert Data
- Select the CSV file you want to insert into the database
- Select the database you want to insert the data into
- Click on the "Insert" button
- Wait for the data to be inserted
- Done!
- Generate Load data
- Select the CSV file you want to insert into the database
- Click on the "Load" button in the menu
- Copy the generated SQL query
- Run the query if your database support it
- Done!
There are two mode to insert the data into the database:
- Optimised mode: The data is inserted into a new table with the type of the columns optimised (VARCHAR(MAX_LENGHT))
- Fast mode: The data is inserted into an existing table with the type of the columns as they are in the CSV file
The optimised mode might take longer to insert the data but it will create a table with the type of the columns optimised.