Home / Python / Database

Automatic import file (CSV, JSON) file to database (PostgreSQL | MySQL | SQLite | Oracle | Microsoft SQL Server)

A mini OS X app to simply upload a CSV/JSON/EXCEL file to a database (PostgreSQL | MySQL | SQLite | Oracle | Microsoft SQL Server). You don't need to create the table structure, the application extract it from analysing the content of the file.
Information
Category: Python / Database
Watchers: 2
Star: 6
Fork: 0
Last update: Jun 20, 2022
Resource links
https://github.com/BenderV/file2db

File2DB

A mini OS X app to simply upload a CSV/JSON/EXCEL file to a database (PostgreSQL | MySQL | SQLite | Oracle | Microsoft SQL Server). You don't need to create the table structure, the application extract it from analysing the content of the file.

App

Download

Go to Release to download the app.

How

Behind the scene, it's simply a wrapper on the awesome Pandas.to_sql function.

To make it an app, we use Pashua & Platypus.

Build it

  1. Download Pashua: curl https://www.bluem.net/files/Pashua.dmg
  2. Create a python virtual environment: virtualenv -p $(which python) venv
  3. Activate the environment: source venv/bin/activate
  4. Install dependancies: pip install -r requirements.txt
  5. Download Platypus and install it.
  6. Start platypus and create the app. See the configuration example

Contents

    oracle The Oracle Database Operator for Kubernetes (a.k.a. OraOperator) helps developers, DBAs, DevOps and GitOps teams reduce the time and complexity of deploying and managing Oracle Databases. It eliminates the dependency on a human operator or administrator for the majority of database operations.
    incredibleindishell This code is vulnerable to SQL Injection and having SQLite database. For SQLite database, SQL Injection payloads are different so it is for fun. Just enjoy it \m/
    simonw Convert CSV files into a SQLite database
    Microsoft Microsoft Drivers for PHP for SQL Server
    mattn Oracle driver for Go using database/sql
    Microsoft The Microsoft JDBC Driver for SQL Server is a Type 4 JDBC driver that provides database connectivity with SQL Server through the standard JDBC application program interfaces (APIs).
    thombashi A CLI tool to convert CSV / Excel / HTML / JSON / Jupyter Notebook / LDJSON / LTSV / Markdown / SQLite / SSV / TSV / Google-Sheets to a SQLite database file.
    auraphp Independent query builders for MySQL, PostgreSQL, SQLite, and Microsoft SQL Server.
    oracle R2DBC Driver for Oracle Database
    xo Command line tool to generate idiomatic Go code for SQL databases supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server
    rana An Oracle database driver for the Go programming language.
    plotly Free, open-source SQL client for Windows and Mac 🦅
    plotly Free, open-source SQL client for Windows and Mac 🦅
    brutella Fast and memory-efficient CSV library in Swift.
    simonw CLI tool for exporting tables or queries from any SQL database to a SQLite file
    mergestat Experimental implementation of a SQLite backend for go-mysql-server
    formulahendry MySQL management tool for Visual Studio Code
    sqlitebrowser Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at:
    diogob Simple PostgreSQL's COPY command support in ActiveRecord models
    tyler-smith A benchmarking shootout of various db/SQL utilities for Go
    super-csv A fast, programmer-friendly, free CSV library for Java
    Share this repo

    Related Repos


    Database
    137
    PostgreSQL replication monitoring and failover daemon
    aiven pglookout pglookout is a PostgreSQL replication monitoring and failover daemon. pglookout monitors PG database nodes and their replication status and
     
    Database
    957
    PostgreSQL configuration wizard
    gregs1104 Introduction pgtune takes the wimpy default postgresql.conf and expands the database server to be as powerful as the hardware it's being deployed on.
     
    Database
    1.2k
    Lanyrd's MySQL to PostgreSQL conversion script
    lanyrd MySQL to PostgreSQL Converter Lanyrd's MySQL to PostgreSQL conversion script. Use with care. This script was designed for our specific database and co
     
    Database
    90
    A command line client for the PostgreSQL Extension Network
    pgxn PGXN Client A command line tool to interact with the PostgreSQL Extension Network The PGXN Client is a command line tool designed to interact with the
     
    Database
    3
    A database scraper created with mechanical soup and sqlite
    MariyaSha WebscrapingDatabases a database scraper created with mechanical soup and sqlite author: Mariya Sha Watch on YouTube: This repository was created to su
     
    Database
    9
    create a database, insert data and easily select it with Sqlite
    MariyaSha sqliteBasics create a database, insert data and easily select it with Sqlite Watch on YouTube a step by step tutorial explaining this code: https://yo
     
    Database
    34
    Python async MongoDB Object Document Mapper
    aminalaee MongoX MongoX is an async python ODM (Object Document Mapper) for MongoDB which is built on top Motor and Pydantic. The main features include: Fully t
     
    Database
    9
    Galvanalyser is a system for automatically storing data generated by battery cycling machi...
    Battery-Intelligence-Lab Galvanalyser is a system for automatically storing data generated by battery cycling machines in a database, using a set of "harvesters", whose job it is to monitor the datafiles produced by the battery testers and upload it in a standard format to the server database.
     
    Database
    6
    A Randomizer Oracle
    asbjornenge Tezos Randomizer Tezod Randomizer "Oracle". It's a smart contract that you can call to get a random number between X and Y (for now). It uses entropy
     
    Database
    50
    A Python wheel containing PostgreSQL
    michelp A Python wheel for Linux containing a complete, self-contained, locally installable PostgreSQL database server.
     
    Database
    53
    An Entity Relationship diagram (ERD) visualization tool, with various filters and inputs t...
    azimuttapp An Entity Relationship diagram (ERD) visualization tool, with various filters and inputs to help understand your database schema
     
    Database
    17
    sqlite medicine database
    WSAyan medicinedb SQLite medicine database 💊 💊 💊 Please note that this database is almost 4 years old and mostly 🇧🇩 Bangladeshi brands related. Although
     
    Database
    104
    Python function to query SQLite files stored on S3
    michalc Python function to query a SQLite file stored on S3. It uses multiple HTTP range requests per query to avoid downloading the entire file, and so is suitable for large databases.
     
    Database
    13
    Write reproducible code for getting and processing ChEMBL
    cthoyt Don't worry about downloading/extracting ChEMBL or versioning - just use chembl_downloader to write code that knows how to download it and use it automatically.
     
    Database
    20
    A deployer and package manager for OceanBase open-source software.
    oceanbase A deployer and package manager for OceanBase open-source software.