CSV file is being uploaded (multipart/form-data) to my HTTP service. My task is to read content of that file and store it in PostgreSQL table. HTTP request body contains raw data (content of CSV file/files). How to parse & store it in the database table the most efficient way? julia> using HTTP jul…

You can use the write_table! function from https://github.com/lungben/TableIO.jl It implements the COPY FROM STDIN functionality using CSV.jl and LibPQ.jl. https://github.com/lungben/TableIO.jl/blob/ce1f205053cee0270ae2b53c0787d576f70e0c4e/src/postgresql.jl#L32

HTTP request body -> PostgreSQL

New to Julia

Jan_Dolinsky February 9, 2021, 2:54pm 4

This is also a useful read: Upload of DataFrame data to databases - #5 by mmiller

1 Like

Topic		Replies	Views
How to quickly bulk insert into postgres Data	14	21935	September 10, 2019
PostgreSQL in Julia: LibPQ.jl Data package , data	9	5887	July 5, 2018
Given a PostgresSQL.jl connection string, what's the easiest way to create a table in the database by copying a dataframe into it? Data	6	872	September 14, 2021
Upload of DataFrame data to databases Data	6	2421	October 19, 2020
How to quickly bulk insert into postgres 1 Data	3	630	August 29, 2019

HTTP request body -> PostgreSQL

Related topics