arpan

arpan

CSV2SQL - Blazing fast csv to database loader!

Hi, I have been working on a side project for quite some time now. I had earlier posted about this project here, since then I have improved the codebase and I have added some additional features to this project.

Basically, Csv2Sql is a fast fully automated tool that can load huge CSV files into a MySQL or PostgreSQL database very easily.

It now comes with a dashboard web UI that runs using phoenix live view. So, now we can use the app easily using either the web interface or using the command line. I have separated out the core application and this new phoenix web app and created an umbrella project.

Heres a GIF of the application in action:

The web interface also much easy to use and configure and gives much detailed information about the progress of the app as it processes the CSV files one by one. Also, I have added support for Postgres now.

I have tested the app on by Ubuntu x86_64 system, Please create an issue with details of your OS distribution, architecture(for example, x86_64 or ARM) and ABI (for example, musl or gnu) if the app does not run on your system.

I would love any feedback or suggestions, please do give it a try, you can find all details on installation and usage here in this repository. If you face any issues feel free to create an issue.

Thanks, have a good day! :slight_smile:

Where Next? Top

Trending in Discussions Top

budgie
I love Elixir. It’s one of 2 programming languages I’ve ever fallen in love with. But I don’t use it anymore. Serverless was the promis...
New
AstonJ
As the title says, please share what you’ve been up to with Elixir. Whether that’s been learning it, looking into it, making stuff with i...
2977 94592 917
New
cblavier
Hey there, It’s been more than a year since we started using LiveView as our main UI library and building a whole library of UI componen...
New
mudasobwa
I am happy to introduce the very α version of the new programming language compiled to BEAM. Welcome Cure. It has literally three kille...
New
heathen
Quite interesting article Google brought me. Didn’t find any mentions about it here. What do you think in general? Would you use togethe...
New
mhanberg
Hi everyone! The first release candidate for the Expert language server project is now available! We’ve published a press release detai...
New
axelson
Hi there! :wave: @frigidcode and I (but mostly him) have been running an Elixir Book club, we’re almost done with Designing Elixir Syste...
New

Other Trending Topics Top

GenericJam
Edit: 2026 May 15 - This post is archived. Mob is alive!! Main docs: mob v0.7.11 — Documentation A bit of explanation for the slightly c...
New
JesseHerrick
Hey, I’m Jesse and I’m the main contributor behind Dexter, a full-featured, lightning-fast Elixir LSP optimized for large codebases. It s...
New
marciok
Hi there! We created Gust: A task orchestrator inspired by Airflow. For those who have never heard about Aiflow, it’s a Python-based wor...
New
jimsynz
Beam Bots (or just BB for short) is a framework for building fault-tolerant robotics applications in Elixir using familiar OTP patterns. ...
New
Dmk
Xamal is a deployment tool for Elixir apps that deploys native releases to bare metal servers over SSH. It’s a port of GitHub - basecamp/...
New
webofbits
With AI doing more of the implementation work, I’ve been wondering how much coding I should deliberately keep doing myself. My main conc...
#ai
New

We're in Beta

About us Mission Statement

Options

Thread Display Mode




Thread Preview

Skip Thread Previews